出自:Oracle认证

Which two statements about Flashback Query are true？（）
A:It is generated by using the redo log files. 
B:It helps in row-level recovery from user errors.
C:It can be performed to recover ALTER TABLE statements 
D:It fails when undo data pertaining to the transaction is overwritten.
E:The database has to be opened with the resetlogs option after performing Flashback Query.
Indentify two advantages of using recovery catalog instead of the control file of the database in Recovery Manager (RMAN)？（）
A:You can use RMAN stored scripts
B:Recovery is faster if data is stored in catalog in addition to the control file
C:You can store backup information of all registered databases in one place
D:Database backups are automatically deleted when they are older than the specified time period
You are maintaining your database in Oracle10g. You are not using the recovery catalog to maintain the backup information of your database. Which file can be used as a repository to store information regarding the RMAN backup？（）
A: online redo log files
B: alert log files
C: control file
D: datafiles associated with the SYSTEM tablespace
You execute the following command to audit the database activities：  SQL> AUDIT DROP ANY TABLE BY scott BY SESSION WHENEVER SUCCESSFUL；  What is the effect of this command？（）
A:One audit record is created for the whole session if user SCOTT successfully drops one or more tables in his session.
B:One audit record is created for every session when any user successfully drops a table owned by SCOTT.
C:One audit record is created for each successful DROP TABLE command executed by any user to drop tables owned by SCOTT.
D:One audit record is generated for the session when SCOTT grants the DROP ANY TABLE privilege to other users in his session.
E:One audit record is created for each successful DROP TABLE command executed in the session of SCOTT.
You are managing an Oracle Database 11g database with the ASM storage. The database is having big file tablespaces. You want files to open faster and less memory to be used in the shared pool to manage the extent maps.  What configuration would you effect to achieve your objective？（）  
A: Set the ASM compatibility attribute for the ASM disk group to 11.1.0.
B: Set the RDBMS compatibility attribute for the ASM disk group to 11.1.0.
C: Set the COMPATIBLE initialization parameter for the ASM instance to 11.1.0.
D: Set the COMPATIBLE initialization parameter for the database instance to 11.1.0.
Which two statements are true regarding the use of UTF-16 encoding？ （）
A:Enables easier loading of multinational data. 
B:Uses a fixed-width Multibyte encoding sequence.
C:Asian characters are represented in three characters. 
D:Used a variable-width Multibyte encoding sequence. 
E:European characters are represented on one or two bytes. 
Your boss at Supportcenter.cn wants you to clarify Oracle 10g. Which statement regarding the usage of redo log files during instance recovery is true？ （）
A:Transactions are rolled back using redo log files.
B:Transactions are rolled forward using redo log files.
C:Transactions are rolled back using redo log files and archived log files.
D:Transactions are rolled forward using redo log files and rolled back using redo log files.
Examine the following command; ALTER SYSTEM SET enable_ddl_logging = TRUE; Which statement is true?（）
A:Only the data definition language (DDL) commands that resulted in errors are logged in the alert log file.
B:All DDL commands are logged in the alert log file.
C:All DDL commands are logged in a different log file that contains DDL statements and their execution dates.
D:Only DDL commands that resulted in the creation of new segments are logged.
E:All DDL commands are logged in XML format in the alert directory under the Automatic Diagnostic Repository (ADR) home.
Examine the details of the Top 5 Timed Events in the following Automatic Workloads Repository (AWR)report:What are three possible causes for the latch-related wait events?（）
A:The size of the shared pool is too small.
B:Cursors are not being shared.
C:A large number COMMITS are being performed.
D:There are frequent logons and logoffs.
E:The buffers are being read into the buffer cache, but some other session is changing the buffers.
Consider the following command to create a tablespace in your production database （which is using an Automatic Storage Management [ASM] instance to manage the database files）： CREATE TABLESPACE user_tbsp DATAFILE ’+dgroup3 （usder_temp） /user_files/user_tbsp’ SIZE 200M； What would be the result of this command？（）
A: It would result in an error because the template cannot be used along with the disk group.
B: It would result in an error because the path cannot be specified while creating a tablespace in a disk group.
C: It would create a tablespace with a data file that has an alias， and its attributes are set by the user-defined template.
D: It would create a tablespace with a data file that does not have an alias， and its attributes are set by the user-defined template.
Given：
Which two statements are true about a Work Item with "Open" Notification? （）(Choose two.)
A:The Work Item is not eligible for Purge.
B:The Work Item is eligible for a Permanent purge.
C:The Work Item is eligible for a Temporary purge.
D:The Work Item is not complete because it still has "Open" Notification.
E:The Work Item is eligible for both Temporary and Permanent purge.
在ORACLE客户端网络配置文件中"HOST"参数值为（）
A:客户机的IP或客户机的机器名
B:服务器的IP或服务器的机器名
C:客户机的IP和客户机的机器名
D:服务器的IP和服务器的机器名
E:以上所述都不正确
Given： Which four code fragments， inserted independently at line 7， will compile？（）
A:public void m1（） { }
B:protected void m1（） { }
C:private void m1（） { }
D:void m2（） { }
E:public void m2（） { }
F:protected void m2（） { }
Which setting enables the baselines by default in Oracle Database 11g?（）
A:setting the STATISTICS_LEVEL parameter to TYPICAL
B:adding filters to the Automatic Database Diagnostic Monitor (ADDM)
C:enabling Automated Maintenance Task using Oracle Enterprise Manager
D:setting the OPTIMIZER_USE_PENDING_STATISTICS parameter to TRUE
You need to modify the STUDENTS table to add a primary key on the STUDENT_ID column. The table is currently empty.Which statement accomplishes this task?（）
A:ALTER TABLE students   ADD PRIMARY KEY student_id;
B:ALTER TABLE students   ADD CONSTRAINT PRIMARY KEY (student_id);
C:ALTER TABLE students   ADD CONSTRAINT stud_id_pk PRIMARY KEY student_id;
D:ALTER TABLE students   ADD CONSTRAINT stud_id_pk PRIMARY KEY (student_id);
E:ALTER TABLE students   MODIFY CONSTRAINT stud_id_pk PRIMARY KEY (student_id);
You want to enable archiving on your database. Presently， the database is running in NOARCHIVELOG mode.Given below are the steps to accomplish the task in random order： 1. Shut down the instance. 2. Execute the ALTER DATABASE ARCHIVELOG command. 3. Start up the instance and mount the database. 4. Set the DB_RECOVERY_FILE_DEST initialization parameter to $ORACLE_HOME/dest_1. 5. Open the database. Which is the correct sequence of steps for accomplishing the task（）
A:4， 1， 3， 2， 5
B:1， 3， 4， 5， 2
C:1， 3， 2， 5； 4 not required
D:4， 1， 5， 2； 3 not required
E:1， 3， 4， 5； 2 not required
The production database has been functional for the last seven days. Because of application requirements， some of the initialization parameters were changed during run time without any comments. You have asked to find out the value of the parameters when the instance was started.Which source would you use to locate this information？（）
A: Fixed views
B: The alert log file
C: The parameter file
D: The server parameter file
E: Dynamic performance views
You issued the following RMAN command to back up the database: Which two statements are true regarding the backup performed?（）
A:Archived redo log files are backed up along with data files.
B:Only data files are backed up and a restore point named FY06Q4 is created.
C:Archived log files are backed up along with data files, and the archived log files are deleted.
D:The command creates a restore point named FY06Q4 to match the SCN at which this backup is consistent.
Which statement about Automatic Memory Management with Oracle 11g is true?（）
A:You cannot specify MEMORY_TARGET if you explicitly specify SGA_TARGET or PGA_AGGREGATE_TARGET values that are greater than zero in your parameter file.
B:Oracle can reallocate memory between the SGA and PGA automatically as needed.
C:To use Automatic Memory Management, you must explicitly set both the MEMORY_TARGET and MEMORY_MAX_TARGET parameters in your parameter file.
D:You can set the MEMORY_TARGET parameter to a maximum value of the current SGA size plus the current PGA size.
在Oracle中，数据库中的触发器是一个对关联表发出insert、update或（）语句时触发的存储过程。
A:delete
B:drop
C:create
D:truncate
You administer an Oracle Database 10g and a third-party database. You use Recovery Manager （RMAN） to perform backup and recovery operations. You have configured a recovery catalog to act as an RMAN repository. To which of the following databases can you NOT connect using the RMAN CONNECT command？（）
A: target database
B: auxiliary database
C: third-party database
D: recovery catalog database
You decided to use Direct NFS configuration in a non-RAC Oracle installation and created the oranfstab file in /etc. Which two statements are true regarding this oranfstab file? （）
A:Its entries are specific to a single database.
B:It contains file systems that have been mounted by Direct NFS.
C:It is globally available to all Oracle 11g databases on the machine.
D:It contains file systems that have been mounted by the kernel NFS system.
Which background process coordinates the rebalance activity for disk groups？（）
A: ORBn
B: OSMB
C: RBAL
D: ASMn
对于一个名为v_arr的类型为PL/SQL表类型的变量，以下对它进行引用形式正确的是（）
A:v_arr[1]
B:v_arr（1）
C:v_arr<1>
D:v_arr{1}
The database is configured in ARCHIVELOG mode and regular complete database backups are taken. The loss of which two types of files may require a recovery with the RESETLOGS option？（）
A: Control files
B: Password files
C: Inactive online redo log file
D: Archived log files required to perform recovery
E: Newly created tablespace which is not backed up
You are connected to Recovery Manager （RMAN） without a recovery catalog. There is no copy of the control file available. You want to restore the control file from an autobackup. To retrieve the autobackup， you need the database ID （DBID）. In which two sources would you find the DBID？ （）
A: the alert log file
B: the server parameter file
C: the formatted name of a control file autobackup
D: an RMAN session log file
E: the trace file
You are using an Automatic Storage Management （ASM） instance to manage the files of your production database. You have two disk groups， DG1 and DG2， with one device each.  In the parameter file of the production database， the following parameters have been specified：  DB_CREATE_ONLINE_LOG_DEST_1 = ’+dg1’  DB_CREATE_ONLINE_LOG_DEST_2 = ’+dg2’  What would be the impact of this setting？（）
A:When a new log group is added， it would have one member in each disk group.
B:When a new log group is added， it would have two members in each disk group.
C:When a new tablespace is added， it would have one data file in each disk group.
D:When a new log file is added， it would have one member spread across the disk groups.
Your database is running in the ARCHIVELOG mode. You have configured RMAN for backup and recovery operations. You execute the following command from the RMAN prompt：   RMAN> CONFIGURE CONTROLFILE AUTOBACKUP ON；   After executing this command， in which of the following cases will RMAN make an auto-backup of the control file？ （）
A: when you change the name of a datafile
B: when you drop a table from the database
C: when you take an export of the database
D: when you back up the database using OS utilities
E: when you issue an ALTER SYSTEM SWITCH LOGFILE statement
F: when you issue a BACKUP command from inside the RMAN run block
Last night， a media failure caused the loss of a temporary file that belongs to your database. Which two things may happen this morning when you try to open your database？（）
A: The database writer writes to a trace file， indicating that the temporary file is not found.
B: The database prompts for a database recovery.
C: The database opens normally.
D: The database gets mounted and throws an error indicating that the temporary file requires recovery.
首页 <上一页 97 98 99 100 101 下一页> 尾页