出自:Oracle认证

Which of the following identifies and creates an index to minimize the DB time for a particular SQL statement?（）
A:The SGA Tuning Advisor
B:The SQL Access Advisor
C:The SQL Tuning Advisor
D:The Memory Advisor
Which trigger property applies to Key triggers? （）
A:Hide Keys 
B:Show Menu Keys 
C:Hide Menu Keys 
D:Display in 'Keyboard Help' 
E:Hide Keys Description 
下列对于惟一码约束，说法错误的是（）。
A:定义了惟一码约束的字段不能有重复值
B:惟一码约束只能在表级定义
C:可以使用一个字段作为惟一码约束
D:定义惟一码约束的字段，可能出现空值
Given： What is the result？（）
A:test end
B:Compilation fails.
C:test runtime end
D:test exception end
E:A Throwable is thrown by main at runtime.
Which two options describe how MySQL Server allocates memory?（）
A:Thread memory is pre-allocated up to thread_cache_size for performance
B:Each connection may have its own per-thread memory allocations
C:Global memory resources are allocated at server startup
D:Each thread allocates memory from a global pool
Which files will you need to perform a full recovery of a database backed up in NOARCHIVELOG mode？（） 
A: Database datafiles
B: Control files
C: Archived redo logs
D: Online redo logs
E: Flashback logs
You must track all transactions that modify certain tables in the sales schema for at least three years. Automatic undo management is enabled for the database with a retention of one day. Which two must you do to track the transactions?（）
A:Enable supplemental logging for the database.
B:Specify undo retention guarantee for the database.
C:Create a Flashback Data Archive in the tablespace where the tables are stored.
D:Create a Flashback Data Archive in any suitable tablespace.
E:Enable Flashback Data Archiving for the tables that require tracking
Your database instance is functional for the past one month. The Automatic Workload Repository（AWR） snapshot retention is set to 7 and the STATISTICS_LEVEL initialization parameter is set to TYPICAL.  You receive a complaint about the poor performance of the database between 7 PM and 9 PM of theprevious day.  Choose two actions any of which can be referred to first to diagnose the problem. （）
A:Use the Active Session History report.
B:Use the AWR Compare Periods report.
C:Use an ADDM analysis between 7 PM and 9 PM of the previous day.
D:Use the AWR Compare Period report between 7 PM and 9 PM of the previous day.
You Execute the Following command to create a password file in the database server: $ orapwd file = ‘+DATA/PROD/orapwprod entries = 5 ignorecase = N format = 12’ Which two statements are true about the password file?（）
A:It records the usernames and passwords of users when granted the DBA role.
B:It contains the usernames and passwords of users for whom auditing is enabled.
C:Is used by Oracle to authenticate users for remote database administration.
D:It records the usernames and passwords of all users when they are added to the OSDBA or OSOPER operating system groups.
E:It supports the SYSBACKUP, SYSDG, and SYSKM system privileges.
The backup retention policy is configured as RECOVERY WINDOW 2. You executed the following command in Recovery Manager （RMAN） against your database： RMAN> REPORT OBSOLETE； What would you see in the output？（）
A: a list of all those files that have been deleted in the last two days
B: a list of all those files that have been recovered within the last two days
C: a list of all the expired backups and copies
D: a list of backups and copies that are outside the range covered by the current retention policy
在SQL*PLUS环境中可以利用DBMS_OUTPUT包中的PUT_LINE方法来回显服务器端变量的值，但在此之前要利用一个命令打开服务器的回显功能，这一命令是（）
A:set server on
B:set serverecho on
C:set servershow on
D:set serveroutput on
E:set serverdisplay on
Which two operations are NOT performed by the DUPLICATE command in Recovery Manager (RMAN)while duplicating a running database?（）
A:Creating the control file for the duplicate database
B:Restoring the target data files to the duplicate database
C:Performing complete recovery using all available backups
D:Generating a new, unique DBID for the duplicate database
E:Copying the online redo log files from the target database to the duplicate database
Because of a logical corruption in your production database， you wanted to perform Tablespace Point in Time Recovery （TSPITR）. But before you start the recovery，you queried the TS_PITR_OBJECTS_TO_BE_DROPPED view and realized that there are a large number of objects that would be dropped when you start the recovery by using this method. You want to preserve these objects.  Which option must you use to perform TSPITR and preserve the object？（）
A: Perform Export before TSPITR and Import after TSPITR
B: Move objects to another schema that has the same tablespace assigned
C: Perform Incomplete Recovery before TSPITR with the Log Sequence Number （LSN）
D: Perform Incomplete Recovery before TSPITR with the System Change Number （SCN）
The ORDERS table has these columns: The ORDERS table tracks the Order number, the order total, and the customer to whom the Order belongs. Which two statements retrieve orders with an inclusive total that ranges between 100.00 and 2000.00 dollars?（）
A:SELECT customer_id, order_id, order_total   FROM orders   RANGE ON order_total (100 AND 2000) INCLUSIVE;
B:SELECT customer_id, order_id, order_total   FROM orders   HAVING order_total BETWEEN 100 and 2000;
C:SELECT customer_id, order_id, order_total   FROM orders   WHERE order_total BETWEEN 100 and 2000;
D:SELECT customer_id, order_id, order_total   FROM orders   WHERE order_total >= 100 and <= 2000;
E:  SELECT customer_id, order_id, order_total   FROM orders   WHERE order_total >= 100 and order_total <= 2000;
Which background process sequentially writes Flashback Database data from the flashback buffer to the Flashback Database logs？（）
A: DBWn
B: RECO
C: RVWR
D: LGWR
假设需要删除Customer表中的LogoutTime列，可以使用如下（）方式。
A:ALTER TABLE CUSTOMER DROP column LOGOUTTIME
B:UPDATE TABLE DROP column LOGOUTTIME
C:ALTER TABLE CUSTOMER DROP LOGOUTTIME
D:UPDATE TABLE DROP LOGOUTTIME
After you have restored and recovered a database to a new host by using a previously performed Recovery Manager (RMAN) backup, which is the best option you would consider for the new database?（）
A:Opening the database in RESTRICTED mode
B:Opening the database with the RESETLOGS option
C:Setting a new DBID for the newly restored database
D:Restoring the server parameter file (SPFILE) to the new host
Click the Exhibit button. What is the result？（）
A:The code will deadlock.
B:The code may run with no output.
C:An exception is thrown at runtime.
D:The code may run with output "0 6".
E:The code may run with output "2 0 6 4".
F:The code may run with output "0 2 4 6".
如果希望更新表authors中的first_name列为非空，那么可以使用哪个语句？（）
A:alter table authors add first_name not null
B:alter table authors modify first_name not null
C:alter table authors alter first_name not null
D:alter table authors drop first_name not null
Which SQL statement displays the date March 19, 2001 in a format that appears as "Nineteenth of March 2001 12:00:00 AM"?（）
A:SELECT TO_CHAR(TO_DATE('19-Mar-2001', 'DD-Mon-YYYY'), 'fmDdspth "of" Month YYYY fmHH:MI:SS AM') NEW_DATE FROM dual;
B:SELECT TO_CHAR(TO_DATE('19-Mar-2001', 'DD-Mon-YYYY'), 'Ddspth "of" Month YYYY fmHH:MI:SS AM') NEW_DATE FROM dual;
C:SELECT TO_CHAR(TO_DATE('19-Mar-2001', 'DD-Mon-YYYY'), 'fmDdspth "of" Month YYYY HH:MI:SS AM') NEW_DATE FROM dual;
D:SELECT TO_CHAR(TO_DATE('19-Mar-2001', 'DD-Mon-YYYY'), 'fmtDdspth "of" Month YYYY fmtHH:MI:SS AM') NEW_DATE FROM dual;
You specified extent management as local for a tablespace. How will it affect space management in the tablespace？（）
A:All the extents will be of the same size.
B:Bitmap will be used to record free and allocated extents.
C:Free extents will be managed by the data dictionary tables.
D:The tablespace will be system managed and the users cannot specify the extent size.
Your database is open and users are connected using the LISTENER listener. The new DBA of the system stops the listener by using the following command： LSNRCTL> STOP  What would happen to the sessions that are presently connected to the database instance？（）
A:The sessions are able to perform only queries.
B:The sessions are not affected and continue to function normally.
C:The active transactions are rolled back and the sessions get terminated.
D:The sessions are not allowed to perform any operations till the listener is started.
Which two agent listeners are meant for Oracle eBusiness Suite only? （）(Choose two.)
A:Workflow Error
B:Workflow Deferred
C:Workflow Java Error
D:Workflow Java Deferred
E:Workflow Inbound Notification
F:Workflow Deferred Notification
You work as a database administrator for Certkiller .com. The UNDO_RETENTION parameter in your database is set to 1000 and undoretention is not guaranteed. Which statement regarding retention of undo data is correct？（）
A:Undo data becomes obsolete after 1，000 seconds.
B:Undo data gets refreshed after 1，000 seconds.
C:Undo data will be stored permanently after 1，000 seconds.
D:Committed undo data would be retained for 1，000 seconds if free undo space is available.
E:Undo data will be retained in the UNDOtablespacefor 1，000 seconds， then it gets movedmovedto the TEMPORARYtablespaceto provide read consistency.
A constraint in a table is defined with the INITIALLY IMMEDIATE clause. You executed the ALTER TABLEcommand with the ENABLE VALIDATE option to enable the constraint that was disabled.  What are the twoeffects of this command（）
A:It fails if any existing row violates the constraint.
B:It does not validate the existing data in the table.
C:It enables the constraint to be enforced at the end of each transaction.
D:It prevents insert， update， and delete operations on the table while the constraint is in the process of beingenabled
在IBatis框架中，利用（）来定义需要持久化的对象。
A:映射文件
B:配置文件
C:初始化文件
D:参数文件
Which of the following roles provides the privileges to maintain and query the recovery catalog schema？（）
A:EXECUTE_CATALOG_ROLE
B:CONNECT
C:RESOURCE
D:RECOVERY_CATALOG_OWNER
E:RECOVERY_CATALOG_USER
Which one of the following RMAN commands is used to register the database files with repository that were backed up using O/S commands？（）
A:CHANGE
B:CATALOG
C:CROSSCHECK
D:SWITCH
You are trying to alter the initial segment size given to a table in a dictionary-managed tablespace. Which of the following keywords would be used as part of this process?（）
A:DROP TABLE 
B:ALTER TABLE 
C:RESIZE 
D:COALESCE
In the parameter file of your production database， the FAST_START_MTTR_TARGET parameter is set to 300 to optimize instance recovery. While observing the performance of the database during instance recovery， you find that the redo log files are not sized properly to support this activity. Which two sources could you use to determine the optimal size of the redo log files？（）
A:the V$LOG view
B:the V$DBFILE view
C:the V$LOGFILE view
D:the V$INSTANCE_RECOVERY view
E:Oracle Enterprise Manager Database Control
首页 <上一页 136 137 138 139 140 下一页> 尾页