出自:Oracle认证

ORACLE数据库启动后，有哪五个必要的后台进程（mandatory background processes）（）
A:CKPT  DBWn  LGWR  PMON  SMON
B:ARCn  CKPT  DBWn  LGWR  SMON
C:CJQ0  CKPT  DBWn  LGWR  SMON
D:DBWn  LGWR  PMON  RECO  SMON
E:CKPT  DBWn  LMON  PMON  SMON
Which two statements are true regarding Oracle Data Pump（）
A:EXPDP and IMPDP are the client components of Oracle Data Pump.
B:DBMS_DATAPUMP PL/SQL packages can be used independently of the Data Pump clients.
C:Oracle Data Pump export and import operations can be performed only by users with the SYSDBA privilege.
D:Oracle Data Pump imports can be done from the export files generated in the export utility of previous versions.
E:EXPDP and IMPDP use the procedures provided by DBMS_METADATA to execute export and import commands.
The EMPLOYEES table contains these columns: EMPLOYEE_ID NUMBER(4) LAST_NAME VARCHAR2 (25) JOB_ID VARCHAR2(10) You want to search for strings that contain 'SA_' in the JOB_ID column. Which SQL statement do you use?（）
A:SELECT employee_id, last_name, job_id FROM employees WHERE job_id LIKE '%SA/_%' ESCAPE '/';
B:SELECT employee_id, last_name, job_id FROM employees WHERE job_id LIKE '%SA_';
C:SELECT employee_id, last_name, job_id FROM employees WHERE job_id LIKE '%SA_' ESCAPE "/";
D:SELECT employee_id, last_name, job_id FROM employees WHERE job_id = '%SA_';
Which of the following architectures is used to support the agent or the application tier？（）
A:Simple
B:Two-tier
C:N-tier
D:Client-server
下列关于序列的使用场景说法正确的是（）。
A:使用序列代替多个字段的主键标识记录，以简化子表对于父表的引用关系
B:需要产生诸如此类的单据流水号，可以借助序列来完成
C:如果有多个用户同时向序列提出申请，可能会生成两个相同的整数
Which of the following advisors is run in every maintenance window by the auto-task system?（）
A:The Memory Advisor
B:The SQL Tuning Advisor
C:The Undo Advisor
D:The SQL Access Advisor
Examine the following scenario：   -Database is running in ARCHIVELOG mode.  -Complete consistent backup is taken every Sunday.  -On Tuesday the instance terminates abnormally because the disk on which control files are located gets corruptedThe disk having active online redo log files is also corrupted.  The hardware is repaired and the paths for online redo log files and control files are still valid.  Which option would you use to perform the recovery of database till the point of failure？（）  
A: Restore the latest whole backup，perform complete recovery，and open the database normally 
B: Restore the latest whole backup，perform incomplete recovery，and open the database with the  RESETLOGS option.
C: Restore the latest backups control file，perform complete recovery，and open the database with the RESETLOGS option.
D: Restore the latest backup control file，perform incomplete recovery using backup control file，and open the database with the RESETLOG option.
Which package provides API’s for the SQL Tuning Advisor？（）
A: DBMS_MONITOR
B: DBMS_STATS
C: DBMS_SQLTUNE
D: DBMS_ADVISOR
Evaluate the following command: Which statement is true regarding the above command?（）
A:The LOB matically compressed.
B:The LOB values are cached bvalues are autoy default in the buffer cache.
C:The LOB values are automatically stored in encrypted mode.
D:All LOB data that is identical in two or more rows in a LOB column share the same data blocks.
Given: Which exception or error will be thrown when a programmer attempts to run this code?（）
A:java.lang.StackOverflowError
B:java.lang.IllegalStateException
C:java.lang.ExceptionInInitializerError
D:java.lang.ArrayIndexOutOfBoundsException
View the Exhibit and examine the parameters. User A executes the following command to update the TRANStable： SQL> UPDATE B.trans SET tr_amt=tr_amt+500 WHERE c_code=’C005’； Before user A issues a COMMIT orROLLBACK command， user B executes the following command on the TRANS table： SQL> ALTER TABLE trans MODIFY （tr_type VARCHAR2（3））；  What would happen in this scenario（）
A:The ALTER TABLE command modifies the column successfully.
B:The DDL operation gets higher priority and transaction for user A is rolled back.
C:The ALTER TABLE command waits indefinitely until user A ends the transaction.
D:The ALTER TABLE command fails after waiting for 60 seconds due to the resource being busy
You are an Enterprise Architect in a large IT organization. Your organization has deployed applications on a variety of containers such as WLS， WebSphere， and JBoss.  Why would you consider consolidating on a single type of container （instead of mix） ？ （）
A: Guarantee of higher application performance and reliability if the transactions are flowing between instances of the same container type.
B:Easier to build a Shared Services infrastructure that can provide best practices， tools and expertise around HA/Management.... with a single type of container than a mix of multiple types
C: You’ll save on hardware costs with a homogenous environment
D: It’s a necessary step in our move toward adopting SOA
You executed the following command to perform a backup of the USERS tablespace：  SQL> ALTER TABLESPACE users BEGIN BACKUP； ALTER TABLESPACE users BEGIN BACKUP *  ERROR at line 1：  ORA-01123： cannot start online backup； media recovery not enabled  What could be the reason for this error（）
A:The MTTR Advisor is disabled.
B:The database is in NOARCHIVELOG mode.
C:The tablespace is already in backup mode.
D:The Flash Recovery Area is not configured.
You want to access employee details contained in flat files as part of the EMPLOYEE table. You plan to add anew column to the EMPLOYEE table to achieve this.  Which data type would you use for the new column（）
A:CLOB
B:BLOB
C:BFILE
D:LONG RAW
If you issue the command shutdown abort prior to trying to put the database in ARCHIVELOG mode， what will be the result when you issue the command alter database archivelog？（）  
A: The alter database archivelog command will fail
B: The alter database archivelog inconsistent command must be used to put the database in ARCHIVELOG mode
C: The alter database archivelog command will succeed
D: The alter database archivelog command will ask if you want to make the database consistent first
E: There is no alter database archivelog command. The correct command is alter database alterlogging
Which statement is true regarding synonyms?（）
A:Synonyms can be created only for a table 
B:Synonyms are used to reference only those tables that are owned by another user 
C:A public synonym and a private synonym can exist with the same name for the same table 
D:The DROP SYNONYM statement removes the synonym, and the table on which the synonym has been created becomes invalid
Which options must you configure while performing an automated Tablespace Point-in-Time Recovery （TSPITR） by using Recovery Manager （RMAN）？（）  
A: New channels for restore and recovery tasks
B: New name for the data files of the tablespace
C: Auxiliary name for the data files of the tablespace
D: Auxiliary destinations for an auxiliary set of data files
What is true about sequences? （）
A:Once created, a sequence belongs to a specific schema.
B:Once created, a sequence is linked to a specific table.
C:Once created, a sequence is automatically available to all users.
D:Only the DBA can control which sequence is used by a certain table.
E:Once created, a sequence is automatically used in all INSERT and UPDATE statements.
Which statement is true about XpauseTarget in Oracle JRockit JVM ？ （）
A: This option is supported by all type of Garbage collection modes.
B: This option is only supported by Generational Garbage Collection mode.
C: This option is only supported by Mark and Sweep Garbage Collection mode.
D: This option is only supported by Dynamic Garbage Collection mode.
You execute the following command in your Certkiller .com production database to change the width of the CUST_NAME column of the CUSTOMERS table： ALTER TABLE customers  MODIFY （cust_nameVARCHAR2 （40）） /  When you execute the command， it displays the following error message：  ERROR at line 1：  ORA-00054： resource busy and acquire with NOWAIT specified  What could be the reason for the error message？（）
A:The database instance is not available.
B:The ALTER TABLE command does not have WAIT option
C:The table or a row in the table is currently locked by another user session.
D:The database instance is busy processing other user sessions commands.
E:The CUSTOMERS table has no long running query active at the time when this request is made.
F:The server process executing the ALTER TABLE command is busy with another command execution
What happens when you run the SQL Tuning Advisor with limited scope？（）  
A: Access path analysis is not performed for SQL statements.
B: SQL structure analysis is not performed for SQL statements.
C: SQL Profile recommendations are not generated for SQL statements.
D: Staleness and absence of statistics are not checked for the objects in the SQL Tuning Advisor.
PL/SQL和数据库之间是通过（）进行数据交换。
A:函数
B:过程
C:常量
D:变量
You want to flash back a test database by five hours.You issue this command:SQL > FLASHBACK DATABASE TO TIMESTAMP (SYSDATE - 5/24);Which two statements are true about this flashback scenario?（）
A:The database must have multiplexed redo logs for the flashback to succeed.
B:The database must be MOUNTED for the flashback to succeed.
C:The database must use block change tracking for the flashback to succeed.
D:The database must be opened in restricted mode for the flashback to succeed.
E:The database must be opened with the RESETLOGS option after the flashback is complete.
F:The database must be opened in read-only mode to check if the database has been flashed back to the correct SCN.
Given： What is the result？（）
A:null
B:finally
C:null finally
D:Compilation fails.
E:finally exception
Evaluate the following statements: What are the two consequences of the above statements?（）
A:Partitions of PURCHASE_ORDER_ITEMS have system-generated names.
B:Both PURCHASE_ORDERS and PURCHASE_ORDER_ITEMS tables are created with four partitions each.
C:Partitions of the PURCHASE_ORDER_ITEMS table exist in the same tablespaces as the partitions of the PURCHASE_ORDERS table.
D:The PURCHASE_ORDER_ITEMS table inherits the partitioning key from the parent table by automatically duplicating the key columns.
E:Partition maintenance operations performed on the PURCHASE_ORDER_ITEMS table are automatically reflected in the PURCHASE_ORDERS table.
The CUSTOMERS table has these columns: CUSTOMER_ID NUMBER(4) NOT NULL CUSTOMER_NAME VARCHAR2(100) NOT NULL STREET_ADDRESS VARCHAR2(150) CITY_ADDRESS VARCHAR2(50) STATE_ADDRESS VARCHAR2(50) PROVINCE_ADDRESS VARCHAR2(50) COUNTRY_ADDRESS VARCHAR2(50) POSTAL_CODE VARCHAR2(12) CUSTOMER_PHONE VARCHAR2(20) Which statement finds the rows in the CUSTOMERS table that do not have a postal code? （）
A:SELECT customer_id, customer_name FROM customers WHERE postal_code CONTAINS NULL;
B:SELECT customer_id, customer_name FROM customers WHER postal_code = ' ___________';
C:SELECT customer_id, customer_name FROM customers WHERE postal _ code IS NULL;
D:SELECT customer_id, customer_name FROM customers WHERE postal code IS NVL;
E:SELECT customer_id, customer_name FROM customers WHERE postal_code = NULL;
Exhibit， Viewing the Exhibit and examine the Flashback Database architecture. Identify the missing component （shown with a "？`"= in the Flashback Database architecture.（）
A: DBWn
B: RVWR
C: ARCH
D: RECO
E: TRWR
Your developers have created table to store some of their program's data. After examining the slow Query Log, you see that they are using the LIKE operator and SUBSTER （　） functions against a VARCHAR (10000) column quite often. An example of the start of one row of data: 'GREEN01020495888331993-12-10/2…' What should you do to improve the overall performance?（）
A:Convert the column to TEXT and add a fulltext index to the table
B:Create multiple prefix indexes of differing lengths
C:Convert their column to BINARY
D:Redesign the table so that the most commonly searched for string patterns are in their own columns
Which statement is true regarding checkpoints and recovery？（）
A:A checkpoint defines the highest system change number （SCN）.
B:All redo entries higher or at the SCN are known to be written to the data files.
C:Only the redo records containing SCNs higher then the checkpoint need to be applied during recovery.
D:The LOG_CHECKPOINT_INTERVAL initialization parameter specifies the amount of time between incremental checkpoints.
The EMP table has some discrepancy in data entry with a particular employee ID. You execute the query as shown in the Exhibit to retrieve all versions of the row that exist between two SCNs. View the Exhibit. Which two statements about the results of the query shown in the Exhibit are correct?（）
A:The LAST_SCN value in the first row is NULL, which means that the versions of the row still exist at SCN 6636300. LAST_SCN
B:The LAST_SCN value in the second row in NULL, which means that the version of the row still exists at SCN 6636300.
C:The LAST_SCN value in the third row is 6636280, which means that the version of row exists above SCN 6636280.
D:The LAST_SCN value in the second row is NULL, which means that the version of the row no longer exists because it was deleted. LAST_SCN
首页 <上一页 72 73 74 75 76 下一页> 尾页