出自:Oracle认证

You issue the following RMAN command to set a retention policy on a database: RMAN>CONFIGURE RETENTION POLICY TO REDUNDANCY 2; What will be the outcome of issuing this command? （）
A:After two days, a backup will be marked obsolete
B:After two days, a backup will be deleted from the media
C:If the RMAN repository has records of two or more recent backups of a file, then older backups will be deleted from the media.
D:If the RMAN repository has records of two or more recent backups of a file, then older backups will be marked obsolete.
At the request of a user， you issue the following command to restore a dropped table： flashback table "BIN$F2JFfMq8Q5unbC0ceE9eJg==$0" to before drop； Later， the user notifies you that the data in the table seems to be very old and out of date.  What might be the problem？（）  
A: Because a proper range of SCNs was not specified， the wrong data was restored.
B: A proper range of timestamps was not specified， so the wrong data was restored.
C: A previous Flashback Drop operation had been performed， resulting in multiple versions of the table being stored in the Recycle Bin.
D: Either option A or B could be correct. Not enough information was provided to determine which.
E: None of the above.
Which two statements are true about Shared SQL Area and Private SQL Areas（）
A:Shared SQL Area will be allocated in the shared pool.
B:Shared SQL Area will be allocated when a session starts.
C:Shared SQL Area will be allocated in the large pool always.
D:The whole of Private SQL Area will be allocated in the Program Global Area （PGA） always.
E:Shared SQL Area and Private SQL Area will be allocated in the PGA or large pool.
F:The number of Private SQL Area allocations is dependent on the OPEN_CURSORS parameter.
You observe that database performance has degraded over a period of time. While investigating the reason， you find that the size of the database buffer cache is not large enough to cache all the needed data blocks.  Which advisory component would you refer to， in order to determine the required size of the database buffer cache？（）
A:Memory Advisor
B:Segment Advisor
C:SQL Tuning Advisor
D:SQL Access Advisor
E:Automatic Database Diagnostic Monitor （ADDM）
有关游标的论述，正确的是（）。
A:隐式游标属性%FOUND代表操作成功
B:显式游标的名称为SQL
C:隐式游标也能返回多行查询结果
D:可以为UPDATE语句定义一个显式游标
Given classes defined in two different files： What is required at line 5 in class SomeApp to use the process method of BitUtils？（）
A:process（bytes）；
B:BitUtils.process（bytes）；
C:util.BitUtils.process（bytes）；
D:SomeApp cannot use methods in BitUtils.
E:import util.BitUtils.*； process（bytes）；
Evaluate the following statement：   Which statement is true regarding the evaluation of rows returned by the subquery in the INSERT statement？（）
A: They are evaluated by all the three WHEN clauses regardless of the results of the evaluation of any other WHEN clause.
B: They are evaluated by the first WHEN clause. If the condition is true， then the row would be evaluated by the subsequent WHEN clauses.
C: They are evaluated by the first WHEN clause. If the condition is false， then the row would be evaluated by the subsequent WHEN clauses.
D: The INSERT statement would give an error because the ELSE clause is not present for support in case none of the WHEN clauses are true.
You are managing an Oracle Database 11g database. You want to take the backup of MULT_DATA, a big filetablespace of size 100 TB on tape drive, but you have tapedrives of only 10 GB each.Which method would accomplish the task quickly and efficiently?（）
A:parallel image copy backup
B:backup with MAXPIECESIZE configured for the channel
C:parallel backup with MAXPIECESIZE configured for the channel
D:intrafile parallel backup
Which three are direct benefits of the multiprocess, multithreaded architecture of Oracle Database 12cwhen it is enabled?（）
A:Reduced logical I/O
B:Reduced virtual memory utilization
C:Improved parallel Execution performance
D:Improved Serial Execution performance
E:Reduced physical I/O
F:Reduced CPU utilization
The rows inside three Oracle tables supporting a customer order entry system are frequently accessed together by means of a table join. Because data is always being added to the tables, you leave a lot of extra space inside each block to accommodate growth. Which of the following types of tables would be useful for storing the data in this context?（）
A:Temporary tables 
B:Index-organized tables 
C:Cluster tables 
D:Standard Oracle tables 
Examine the following ALTER command: SQL> ALTER DISKGROUP dgroup1 UNDROP DISKS; What is the purpose of the command?（）
A:It cancels all pending disk drops within the disk group.
B:It restores disks that are being dropped as the result of a DROP DISKGROUP operation
C:It mounts disks in the disk group for which the drop-disk operation has already been co pleted
D:It restores all the dropped disks in the disk group for which the drop-disk operation has already been completed
E:It adds previously dropped disks back into the disk group
Which two statements are true regarding the ORDER BY clause?（）
A:The sort is in ascending by order by default.
B:The sort is in descending order by default.
C:The ORDER BY clause must precede the WHERE clause.
D:The ORDER BY clause is executed on the client side.
E:The ORDER BY clause comes last in the SELECT statement.
F:The ORDER BY clause is executed first in the query execution.
Automatic PGA Memory Management eliminates the need to manually configure which of the following initialization parameters？（） 
A: SORT_AREA_SIZE
B: HASH_AREA_SIZE
C: BITMAP_MERGE_AREA_SIZE
D: CREATE_BITMAP_AREA_SIZE
E: PGA_AGGREGATE_TARGET
 You are creating tablespaces in Oracle. Which of the following keywords or clauses permits the datafiles of a database to grow automatically in order to accommodate data growth?（）
A:DEFAULT STORAGE 
B:EXTENT MANAGEMENT 
C:AUTOEXTEND 
D:DATAFILE
Which RMAN command do you use to verify that the RMAN repository information is synchronized with the actual files that exist on disk？（）
A:LIST
B:CHANGE
C:CATALOG
D:CROSSCHECK
Your database is open and running in ARCHIVELOG mode. You take RMAN full backups every Sunday night. On Monday morning， while querying the user1.employees table， you receive the following error message：  01578： ORACLE data block corrupted （file # 5， block # 51） ORA/x7f01110： data file 5： ’/u01/app/oracle/oradata/orcl/example01.dbf’  You need to rectify the corruption while ensuring the following： The data file should remain online.  The mean time to recover （MTTR） should be minimal.  You are not using a backup control file， and all the archived logs are accessible. Which option would you choose？（）
A:flash back the corrupted blocks
B:use the DBMS_REPAIR package
C:use the RMAN TSPITR command
D:use the RMAN BLOCKRECOVER command
E:use the RESTORE DATABASE and RECOVER DATABASE commands
F:investigate the time at which the corruption occurred and perform a point­in­time recovery
In your production database there is a job， CALC_STAT， which has been scheduled to run every Friday at 5：00 p.m. CALC_STAT updates the optimizer statistics for the objects owned by the APPS schema. You want the task to be generic， thereby allowing users to modify the attributes of the task at run time without affecting the original task. Which component of Oracle Scheduler must you define to achieve this？（）
A:Window
B:Program
C:Job class
D:Window group
Given： Which two changes， taken together， would guarantee the output： 1， 2， 3， 4， 5， ？（）
A:move the line 12 print statement into the foo（） method
B:change line 7 to public synchronized void go（） {
C:change the variable declaration on line 2 to private volatile int x；
D:wrap the code inside the foo（） method with a synchronized（ this ） block
Which statement is true regarding the VALIDATE DATABASE command？（）
A: It checks the database for intrablock corruptions only.
B: It checks for block corruption in the valid backups of the database.
C: It checks the database for both intrablock and interblock corruptions.
D: It checks for only those corrupted blocks that are associated with data files.
Which syntax turns an existing constraint on?（）
A:ALTER TABLE table_name   ENABLE constraint_name;
B:ALTER TABLE table_name   STATUS = ENABLE CONSTRAINT constraint_name;
C:ALTER TABLE table_name   ENABLE CONSTRAINT constraint_name;
D:ALTER TABLE table_name   STATUS ENABLE CONSTRAINT constraint_name;
E:ALTER TABLE table_name   TURN ON CONSTRAINT constraint_name;
Oracle的分区表可以包括多个分区，每个分区都是一个独立的（），可以存放到不同的表空间中。
A:段
B:盘区
C:物化视图
D:数据文件
Which three statements about subqueries are true? （）
A:A main query can have more than one subquery.
B:A subquery can have more than one main query.
C:The subquery and main query must retrieve data from the same table.
D:The subquery and main query can retrieve data from different tables.
E:Only one column or expression can be compared between the subquery and main query.
F:Multiple columns or expression can be compared between the subquery and main query.
Click the Exhibit button. What is the result?（）
A:go in Goban go in Goban
B:go in Sente go in Goban
C:go in Goban go in Sente
D:go in Sente go in Sente
E:Compilation fails because of an error in line 17.
Which two are prerequisites for performing a flashback transaction?（）
A:Flashback Database must be enabled.
B:Undo retention guarantee for the database must be configured.
C:EXECUTE privilege on the DBMS_FLASHBACK package must be granted to the user flashing back transaction.
D:Supplemental logging must be enabled.
E:Recycle bin must be enabled for the database.
F:Block change tracking must be enabled tor the database.
Which background process of a database instance, using Automatic Storage Management (ASM), connects asa foreground process into the ASM instance?（）
A:ASMB
B:PMON
C:RBAL
D:SMON
You want to enable resumable space allocation at the instance level.Which two actions would enable resumable space allocation at the instance level? （）(Choose two.)
A:issuing the ALTER SYSTEM ENABLE RESUMABLE; statement
B:issuing the ALTER SESSION ENABLE RESUMABLE; statement
C:modifying the RESUMABLE_TIMEOUT initialization parameter to a nonzero value
D:issuing the ALTER SYSTEM SET RESUMABLE_TIMEOUT=; statement
You want to create an RMAN recovery catalog in the RC01 database to help you manage the databases named DB01 and DB02. You need to create a recovery catalog owner in which of your databases？（）
A:RCO1 only.
B:DB01 only.
C:DB02 only.
D:DB01 and DB02 only.
E:DB01，DB02，and RC01.
Mary has a view called EMP_DEPT_LOC_VU that was created based on the EMPLOYEES, DEPARTMENTS, and LOCATIONS tables. She granted SELECT privilege to Scott on this view. Which option enables Scott to eliminate the need to qualify the view with the name MARY.EMP_DEPT_LOC_VU each time the view is referenced?（）
A:Scott can create a synonym for the EMP_DEPT_LOC_VU by using the command CREATE PRIVATE SYNONYM EDL_VU FOR mary.EMP_DEPT_LOC_VU; then he can prefix the columns with this synonym.
B:Scott can create a synonym for the EMP_DEPT_LOC_VU by using the command CREATE SYNONYM EDL_VU FOR mary.EMP_DEPT_LOC_VU; then he can prefix the columns with this synonym.
C:Scott can create a synonym for the EMP_DEPT_LOC_VU by using the command CREATE LOCAL SYNONYM EDL_VU FOR mary.EMP_DEPT_LOC_VU; then he can prefix the columns with this synonym.
D:Scott can create a synonym for the EMP_DEPT_LOC_VU by using the command CREATE SYNONYM EDL_VU ON mary(EMP_DEPT_LOC_VU); then he can prefix the columns with this synonym.
E:Scott cannot create a synonym because synonyms can be created only for tables.
F:Scott cannot create any synonym for Mary's view. Mary should create a private synonym for the view and grant SELECT privilege on that synonym to Scott.
You work with a newly created database. Presently， there is no application load on the database instance. You want to create a baseline for tuning the application， so you decide to collect recommendations that can be implemented to improve application performance.  What action must you take to achieve this？（）  
A: Run Segment Advisor
B: Run the SQL Tuning Advisor （STA）
C: Run the Automatic Workload Repository （AWR） report
D: Run the SQL Access Advisor with a hypothetical workload
在Oracle中，下列（）语句不能用于控制游标。
A:Open
B:Create
C:Fetch
D:Close
首页 <上一页 49 50 51 52 53 下一页> 尾页