出自:Oracle认证

To enable faster incremental backups, you enabled block change tracking for the database.Which two statements are true about the block change tracking file?（）
A:Multiple change tracking files can be created for a database.
B:The change tracking file must be created after the first level 0 backup.
C:RMAN does not support backup and recovery of the change tracking file.
D:The database clears the change tracking file and starts tracking changes again, after whole database restore and recovery operations.
安装ORACLE数据库并建立数据库实例之后，预使用OMS应该做什么操作？
Which pseudocolumn could you use to identify a unique row in a Flashback Versions Query？（）
A: XID
B: VERSIONS_PK
C: VERSIONS_XID
D: VERSIONS_UNIQUE
You configured automatic archive logging for the database. On the next startup the database runs for a while， but then hangs. After checking the alert log， you determine that all the online redo logs need archiving.  Which step was skipped when you set up automatic archive log？（）
A:LOG_ARCHIVE_DEST was not set in the parameter file.
B:LOG_ARCHIVE_START was not set in the parameter file.
C:alter database archivelog； was not executed in MOUNT mode.
D:LOG_ARCHIVE_MAX processes were not set in the parameter file.
在Oracle中，当用户要执行SELECT语句时，下列哪个进程从磁盘获得用户需要的数据（）。
A:用户进程
B:服务器进程
C:日志写入进程（LGWR）
D:检查点进程（CKPT）
Given： What is the result？（）
A:2
B:3
C:4
D:6
E:7
While performing the backup of the flash recovery area， you notice that one of the archived redo log files is missing. You have multiple destinations for archived redo log files.  What implications does it have on the backup of the flash recovery area？（）  
A: The backup fails because one of the archived redo log files is missing.
B: The backup succeeds but it would be without the missing archived log.
C: During backup，you are prompted for the alternative destination for the missing archived redo log file.
D: The backup succeeds because it fails over to one of the alternative archived redo log destinations.
You work as a database administrator for Certkiller .com. You added atablespaceto your database. Because of the changes to the physical structure of your database， you performed a backup of the control file to trace. After this， you lost only the control files and the instance aborted due to a hardware failure.  How would you proceed to recover the database？（）
A:Start the instance and open the database, instance recovery automatically recovers control files 
B:Create a file based on the contents of the trace file and save it to the control file locations and start the database 
C:Re-create the database (The recovery of the control file is not possible because you have lost all the control files.) 
D:Start the instance, in the NOMOUNTstate,re-create the control file using the CREATE CONTROLFILE command stored in the trace file. 
E:Start the instance and MOUNT the database, then re-create the control file using the CREATE CONTROLFILE command stored in the trace file.
Identify the logical structure that will never have more than one data segment created for it.（）
A:external table
B:partitioned table
C:partitioned index
D:nonclustered table
E:global temporary table
You are working on a new Oracle Database 11g server， where only the software is installed and no database iscreated. You plan to create a database on this server using the Database Configuration Assistant （DBCA）.Some of the requirements set for your database creation task are： 1.Configure the database to operate in shared server mode. 2.Disable automatic maintenance tasks such as optimizer statistics collection. 3.Configure a naming method to help the remote user connect to the database instance. 4.Use Automatic Storage Management （ASM） for storing the database files. 5.Configure daily database backup to flash recovery area. 6.Configure Enterprise Manager Database Control to manage the database.  Which of these requirements can be met while creating the database（）
A:4 and 6
B:2，3，4，and 6
C:1，2，4，5，and 6
D:1，2，3，4，5，and 6
Which two built-ins would you use to remove the HOUR_ALARM timer using the timer_id parameter?（）
A:FIND_TIMER 
B:CREATE_TIMER 
C:SET_TIMER 
D:DELETE_TIMER 
E:GET_APPLICATION_PROPERTY
以下关于数据库例程（INSTANCE）和数据库关系的叙述正确是的（）
A:一个例程只能打开一个数据库，一个数据库也只能由一个例程打开
B:一个例程可以打开多个数据库，但一个数据库可以由多个例程打开
C:一个例程只能打开一个数据库，但一个数据库可以由多个例程打开
D:一个例程可以打开多个数据库，一个数据库也只能由一个例程打开
Which operator can be used with a multiple-row subquery?（）
A:=
B:LIKE
C:BETWEEN
D:NOT IN
E:IS
F:<>
Which two statements are true regarding hot patching? （）
A:It requires relinking of the Oracle binary.
B:It does not require database instance shutdown.
C:It can detect conflicts between two online patches.
D:It is available for installing all patches on all platforms.
E:It works only in a single database instance environment.
Given： What is the result？（）
A:0，0，0
B:150，60，0
C:Compilation fails.
D:150，150，150
在Oracle中创建用户时，若未提及DEFAULT TABLESPACE关键字，则Oracle就将（）表空间分配给用户作为默认表空间。
A:USER
B:SYSTEM
C:SYS
D:DEFAULT
如何显示今天是星期几（周一到周日，分别用1~7表示）（）
A:select to_char(sysdate,'D') from dual;
B:select to_char(sysdate,'W') from dual;
C:select to_char(sysdate,'D')-1 from dual;
D:select to_char(sysdate-1,'D') from dual;
E:select to_char(sysdate-1,'W') from dual;
Click the Exhibit button. What is the output if the main（） method is run？（）
A:4
B:5
C:8
D:9
Your database is having two control files， three redo log file groups with two members in each group. Failure of which file would cause an instance to shut down？（）
A:any control file
B:any archive log file
C:one of the redo log members
D:loss of the initialization parameter file
E:any data file belonging to the default permanent tablespac
By setting the value of MEMORY_TARGET to zero and setting the value of SGA_TARGET to a nonzero value， you will enable which of the following memory-management options？（）  
A: Automatic PGA Memory Management
B: Automatic SGA Memory Management
C: Automatic Shared Memory Management
D: Automatic Memory Management
E: Manual SGA Memory Management
F: None of the above
In your database， online redo log files are multiplexed and one of the members in a group is lost due to media failure？ How would you recover the lost redo log member？（）
A: import the database from the last export
B: restore all the members in the group from the last backup
C: drop the lost member from the database and then add a new member to the group
D: restore all the database files from the backup and then perform a complete recovery
E: restore all the database files from the backup and then perform an incomplete recovery
You need to maintain a record of all transactions on some tables for at least three years. Automatic undo management is enabled for the database. What must you do accomplish this task？（）
A: Enable supplemental logging for the database.
B: Specify undo retention guarantee for the database
C: Create Flashback Data Archive in the tablespace where the tables are stored.
D: Create Flashback Data Archive and enable Flashback Data Archive for specific tables
You are managing the APPPROD database as a DBA which is not using the Oracle-managed files. You plan to duplicate this database in the same system with the name DUPDB.You want to create the same directory structure for duplicate database files as of the target database. You executed the following RMAN commands：   RMAN> CONNECT TARGET sys/sys@APPPROD RMAN> CONNECT AUXILIARY sys/sys@DUPDB RMAN> DUPLICATE TARGET DATABASE TO dupdb  FROM ACTIVE DATABASE PASSWORD FILE SPILE  NOFILENAMECHECK；   What are the implications of this command？（）
A: It creates database files for the duplicate database under the Oracle base with a different directory for the duplicate database.
B: It overwrites data files of the target database because a different location for data files is not mentioned for the duplicate database.
C: It creates database files for the duplicate database under the same Oracle home as that of the target database with the same directory structure.
D: It creates database files for the duplicate database under the same Oracle home as that of the target but with a different directory for the duplicate database.
You noticed that large memory allocations for the Oracle backup and restore operations are causing a performance overhead on the shared pool. Which memory structure would you configure to avoid this performance overhead？（）
A: recycle buffer cache
B: large pool
C: streams pool
D: keep buffer cache
E: redo log buffer
Your database is running in ARCHIVELOG mode. One of the data files， USERDATA01.dbf， in the USERS tablespace is damaged and you need to recover the file until the point of failure. The backup for the datafile is available.  Which three files would be used in the user-managed recovery process performed by the database administrator （DBA）？（） 
A: Redo logs 
B: Control file
C: The latest backup of only the damaged data file
D: The latest backup of all the data file in the USERS tablespace
E: Temporary files of temporary tablespace
F: Archive Logs since the latest backup to point of failure
说明数据库表空间的种类，以及不同类型表空间的作用。
Which statement is true about a whole consistent database backup on a database running in ARCHIVELOGmode（）
A:The backup will consist of used data blocks only.
B:The database must be shut down to accomplish the backup.
C:The backup can be accomplished without shutting down the database.
D:The backup will contain all database files that have never been backed up
You define a multiple-row subquery in the WHERE clause of an SQL query with a comparison operator "=".What happens when the main query is executed?（）
A:The main query executes with the first value returned by the subquery.
B:The main query executes with the last value returned by the subquery.
C:The main query executes with all the values returned by the subquery.
D:The main query fails because the multiple-row subquery cannot be used with the comparison operator.
E:You cannot define a multiple-row subquery in the WHERE clause of a SQL query.
简单介绍表空间，并写出一种建立表空间的方法。
Given：   11. // insert code here   12. private N min， max；   13. public N getMin（） { return min； }   14. public N getMax（） { return max； }   15. public void add（N added） {   16. if （min == null || added.doubleValue（） < min.doubleValue（））  17. min = added；   18. if （max == null || added.doubleValue（） > max.doubleValue（））  19. max = added；   20. }   21. }   Which two， inserted at line 11， will allow the code to compile？（）
A:A
B:B
C:C
D:D
E:E
F:F
首页 <上一页 18 19 20 21 22 下一页> 尾页