出自:Oracle认证

In your database， all the tablespaces are locally managed. You started Recovery Manager （RMAN） using recovery catalog. The following commands are used in the process of recovering the database by using the backup control file：  In what sequence would you use this process to perform the recovery？（）
A:7， 2， 3， 1， 4， 6， 5
B:7， 1， 3， 2， 6， 5， 4
C:2， 1， 7， 6， 3， 5， 4
D:2， 7， 3， 5， 1， 6， 4
The BACKUP_TAPE_IO_SLAVES parameter is set to FALSE for the database instance. Which statement istrue while performing a tape backup in an RMAN session?（）
A:The tape I/O performed is asynchronous
B:The tape buffer is allocated from the System Global Area (SGA)
C:The tape buffer is allocated from the Program Global Area (PGA)
D:Oracle I/O uses an interrupt mechanism to determine when each I/O completes
Given: What is the result?（）
A:collie
B:harrier
C:Compilation fails.
D:collie harrier
E:An exception is thrown at runtime.
You issue the following command on the RMAN prompt.   REPORT NEED BACKUP DAYS 5；   Which statement is true about executing this command？（）  
A: It will display a list of files that need incremental backup
B: It will display a list of files that need backup after five days
C: It will display a list of files that were backed up in the last five days
D: It will display a list of files that have not been backed up in the last five days
E: It will apply the current retention policy to determine the files that need to be backed up
You are using Recovery Manager (RMAN) to perform backups. In which three situations would you perform a compressed backup?（）
A:You are backing up to tape and your tape device performs its own compression.
B:You are making image copies, and you have not enabled tablespace compression.
C:You are using disk-based backups and disk space in your Flash Recovery Area, or other disk-based backup destinations are limited.
D:You are performing your backups to some device over a network where reduced network bandwidth is more important than CPU usage.
E:You are using some archival backup media, such as CD or DVD, where reducing backup sizes saves  media costs and archival storage.
Click the Exhibit button.   What is the output of the program shown in the exhibit？ （）
A: 300-300-100-100-100
B: 300-300-300-100-100
C: 300-300-300-300-100
D: 300-100-100-100-100
You are maintaining an OLTP database in Oracle10g. You have configured the Flash Recovery Area in your database. The Flash Recovery Area is full because you have set the retention policy to NONE. What will you do to resolve the problem？（）
A: Increase the value of the FAST_START_MTTR_TARGET initialization parameter.
B: Increase the value of the DB_RECOVERY_FILE_DEST_SIZE parameter.
C: Increase the value of the PGA_AGGREGATE_TARGET initialization parameter.
D: Increase the value of the SGA_TARGET initialization parameter.
Examine the data in the EMPLOYEES table: LAST_NAME DEPARTMENT_ID SALARY Getz 10 3000 Davis 20 1500 Bill 20 2200 Davis 30 5000 ... Which three subqueries work? （）
A:SELECT * FROM employees where salary > (SELECT MIN(salary) FROM employees GROUP BY department _ id);
B:SELECT * FROM employees WHERE salary = (SELECT AVG(salary) FROM employees GROUP BY department _ id);
C:SELECT distinct department_id FROM employees Where salary > ANY (SELECT AVG(salary) FROM employees GROUP BY department _ id);
D:SELECT department_id FROM employees WHERE SALARY > ALL (SELECT AVG(salary) FROM employees GROUP BY department _ id);
E:SELECT last_name FROM employees Where salary > ANY (SELECT MAX(salary) FROM employees GROUP BY department _ id);
F:SELECT department_id FROM employees WHERE salary > ALL (SELECT AVG(salary) FROM employees GROUP BY ANG (SALARY));
Which two are true concerning a multitenant container database with three pluggable database?（）
A:All administration tasks must be done to a specific pluggable database.
B:The pluggable databases increase patching time.
C:The pluggable databases reduce administration effort.
D:The pluggable databases are patched together.
E:Pluggable databases are only used for database consolidation.
Where do you find information about a missing redo log file？（）
A:trace file
B:audit trail
C:control file
D:alert log file
E:event viewer
Which of the following objects can be directly referenced by a window object? （）
A:Schedule object
B:Program object
C:Job object
D:Resource plan
E:Resource consumer group
Identify the two tablespaces whose data files are so critical that only a closed recovery is possible.（）
A:SYSAUX
B:TOOLS
C:UNDO
D:INDEX
E:SYSTEM
F:USERS
G:TEMP
You are using a recovery catalog to maintain Recovery Manager （RMAN） backup information for your production database. You have registered your production database and are performing regular backups. Because of a new requirement you have added a few new tablespaces to your production database and you want them to be included in backups.  Identify two options for completing this task.（）
A: Reregistering the target database in recovery catalog
B: Transporting the new tablespaces to the recovery catalog database
C: Syncronizing the recovery catalog with the target database control file
D: Performing a fresh backup of the target database to include the new data files in the catalog database
What recommendations does the SQL Access Advisor provide for optimizing SQL queries?（） (Choose all that apply.)
A:selection of SQL plan baselines
B:partitioning of tables and indexes
C:creation of index-organized tables
D:creation of bitmap, function-based, and B-tree indexes
E:optimization of materialized views for maximum query usage and fast refresh
View the Exhibit.You executed the following command to perform a backup of the USERS tablespace： RMAN> BACKUP TABLESPACE USERS；  Which three types of files are backed up？ （）
A: all the data files belonging to the USERS tablespace
B: password file
C: online redo log files
D: the current control file
E: archived redo log files
F: the current server parameter file
G: data files belonging to the USERS tablespace and all the default tablespaces
Which two statements are true about setting the FAST_START_MTTR_TARGET initializationparameter to a nonzero value（）
A:The MTTR advisor will be disabled.
B:Automatic checkpoint tuning will be enabled.
C:The value for the LOG_CHECKPOINT_INTERVAL initialization parameter will be override the value forFAST_START_MTTR_TARGET.
D:The time taken to recover the instance after the crash is always exactly the same as the value given forthe FAST_START_MTTR_TARGET initialization parameter.
You require the Oracle server to manage the undo segments and space among various active sessions automatically. You created an undo tablespace， UNDO_TBS1， in your database. Which two additional steps would you perform to achieve this？（）
A:Set the UNDO_RETENTION parameter to 900 or more.
B:Create an initial undo segment in the undo tablespace.
C:Enable the retention guarantee for the undo tablespace.
D:Set the UNDO_TABLESPACE parameter to UNDO_TBS1.
E:Set the UNDO_MANAGEMENT initialization parameter to AUTO.
The NLS_SORT parameter sets the default sort method for which of the following operations?（）
A:WHERE clause WHERE
B:ORDER BY clause
C:BETWEEN clause
D:NLSSORT function
E:NLS_SORT function
You opened the encryption wallet and then issued the following command: Then you closed the wallet. Later, you issued the following command to create the EMPLOYEES table in the SECURESPACE tablespace and you use the NO SALT option for the EMPID column. What is the outcome?（）
A:It creates the table and encrypts the data in it.
B:It generates an error because the wallet is closed.
C:It creates the table but does not encrypt the data in it.
D:It generates an error because the NO SALT option cannot be used with the ENCRYPT option.
You executed the following SQL statement to shrink the EMPLOYEES table segment stored in the EXAMPLE tablespace: ALTER TABLE employees SHRINK SPACE CASCADE; Which statement is correct in this scenario?（）
A:The data in the segment will be compacted but the high water mark will not be adjusted 
B:The EMPLOYEES table will be changed to read-only mode during the shrink operation 
C:The indexes created on the EMPLOYEES table will need to be rebuilt after the shrink operation is over
D:The shrink behavior will be cascaded to all dependent segments of the table that support a shrink operation 
E:Data manipulation language (DML) operations will not be possible on the EMPLOYEES table during the COMPACTION phase of the shrink operation
What are three actions performed by the mysql_secure_installation tool?（）
A:It prompts you to set the root user account password
B:It checks whether file permissions are appropriate within datadir
C:It asks to remove the test database, which is generated at installation time
D:It can delete any anonymous accounts
E:It verifies that all users are configuration with the longer password hash
You are developing an inventory report to list the item number, description price and picture of all inventory items. The layout of each item is a repeating frame that contains three fixed fields and a image. When possible you want all objects in the repeating frame to appear on the same logical page without creating blank pages between instances. Which pagination property would you alter to achieve these results?（）
A:Page break before. 
B:Page break after. 
C:Page protect. 
D:Keep with anchoring object.
Identify the true statement regarding Temporary Coherence cluster members（）
A: it should have "localstorage" set to TRUE
B: it should be configured so as to not trigger re-partitioning 
C: both A and B are TRUE
D: Neither A and B are TRUE
以下关于数据库过程和函数叙述正确的是（）
A:过程和函数都是命名的PL/SQL块，但执行效率要比普通PL/SQL块高
B:过程和函数都是命名的子程序，每次执行前由数据库进行编译
C:过程是没有返回参数的，而函数是有返回参数的
D:过程不带输入参数，而函数是要带输入参数的
Your database is using shared server configuration. Which optional memory structure would you configure to store the User Global Area （UGA） information and improve the shared pool performance？（）
A:large pool
B:streams pool
C:keep buffer cache
D:recycle buffer cache
Orcacle提供了（），用于支持采用向导方式创建数据库。
A:SQL*Plus
B:Oracle Net
C:Oracle Listner
D:Oracle Database Configuration Assistant
假设需要更改表名“CUSTOMER”为“CUSTOMER_CHANGE”，可以使用（）语句。
A:ALTER TABLE CUSTOMER RENAME CUSTOMER_CHANGE
B:ALTER TABLE CUSTOMER RENAME TO CUSTOMER_CHANGE
C:RENAME TABLE CUSTOMER TO CUSTOMER_CHANGE
D:RENAME TABLE CUSTOMER CUSTOMER_CHANGE
You have been recently hired as a database administrator. Your senior manager asks you to study the production database server and submit a report on the settings done by the previous DBA.  While observing the server settings， you find that the following parameter has been set in the parameter file of the database：  REMOTE_OS_AUTHENT = TRUE  What could have been the reason to set this parameter as TRUE？（）
A:to enable operating system authentication for a remote client
B:to restrict the scope of administration to identical operating systems
C:to allow the start up and shut down of the database from a remote client
D:to enable the administration of the operating system from a remote client
E:to disable the administration of the operating system from a remote client
Which two statements about creating constraints are true?（）
A:Constraint names must start with SYS_C
B:All constraints must be defines at the column level
C:Constraints can be created after the table is created
D:Constraints can be created at the same time the table is created
E:Information about constraints is found in the VIEW_CONSTRAINTS dictionary view
You need to restore your database back to 9/30/2008 at 18：00. In what order would you run the following commands to compete this task？（）   a. restore controlfile until time `09/30/2008：18：00：00’ b. restore database until time `09/30/2008：18：00：00’  c. restore spfile until time `09/30/2008：18：00：00’ d. recover database until time `09/30/2008：18：00：00’ e. alter database open resetlogs f. alter database open
A: b， d， e
B: b， d， f
C: c， a， b， d， e
D: c， a， b， d， f
E: a， b， d， e
首页 <上一页 96 97 98 99 100 下一页> 尾页