ITPub博客

530.When an ASM instance receives a SHUTDOWN NORMAL command, what command does it passon to all database instances that rely on the ASM instances disk groups?A. TRANSACTIONALB. IMMEDIATEC. ABORTD. NORMALAnswer: NONEhttp://blog.csdn.net/rlhua/article/details/13008005注：有连接的RDBMS 实例...

660.You want to configure the Flashback Database feature and retain flashback logs for three days.Presently the database is open and configured in ARCHIVELOG mode.The following steps must be performed in the correct sequence to do this:1. Set the retention target:SQL> ALTER SYSTEM SET DB_FLASHBA...

477.Which of the following is not a valid linguistic sort element?A. Accent expansionB. Canonical equivalenceC. Reverse secondary sortingD. Ignorable charactersE. Character rearrangementAnswer: Ahttp://docs.oracle.com/cd/E11882_01/server.112/e10729/ch5lingsort.htm#NLSPG276Linguistic Sort...

477.Which of the following is not a valid linguistic sort element?A. Accent expansionB. Canonical equivalenceC. Reverse secondary sortingD. Ignorable charactersE. Character rearrangementAnswer: Ahttp://docs.oracle.com/cd/E11882_01/server.112/e10729/ch5lingsort.htm#NLSPG276Linguistic Sort...

46.What happens when you run the SQL Tuning Advisor with limited scope?A. Access path analysis is not performed for SQL statements.B. SQL structure analysis is not performed for SQL statements.C. SQL Profile recommendations are not generated for SQL statements.D. Staleness and absence of statist...

319.What is the end result of these commands if they are successful?RMAN> show retention policy;RMAN configuration parameters for database with db_unique_nameORCL are: CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # defaultBackup database tag=gold_copy plus archivelog tag=gold_copy delete input; B...

604.You realize that the control file is damaged in your production database. After restoring the control filefrom autobackup, what is the next step that you must do to proceed with the database recovery?A. Mount the databaseB. Open the database in NORMAL modeC. Open the database in RESTRICTED m...

687. Users are connected to a database instance that is using Automatic Storage Management (ASM).The DBA executes the command as follows to shut down the ASM instance:SQL> SHUTDOWN IMMEDIATE;What happens to the database instance?A.It shuts down long with the ASM instance.B.It is aborted and the...

694. As part of archiving the historical data, you want to transfer data from one database to anotherdatabase, which is on another server. All tablespaces in the source database are read/write and online.The source and target databases use the same compatibility level and character sets.View the ...

277.The BOOKINGS table contains online booking information. When a booking is confirmed, the detailsare transferred to an archival table BOOKINGS_HIST and deleted from the BOOKINGS table. There is nofixed time interval between each online booking and its confirmation. Because sufficient space is n...

482.USER_DATA is a nonencrypted tablespace that contains a set of tables with data. You want toconvert all existing data in the USER_DATA tablespace and the new data into the encrypted format.Which methods would you use to achieve this? (Choose all that apply.)A. Use Data Pump to transfer the exi...

452.Which of the following Scheduler elements encourage object reuse? (Choose all that apply.)A. Schedule objectsB. Program argumentsC. Job classesD. Job argumentsE. All of the aboveAnswer: ABD

400.Which of the following methods can be used to detect block corruption?A. ANALYZE operationsB. dbvC. SQL queries that access the potentially corrupt blockD. RMANE. All of the aboveAnswer: Ehttp://blog.csdn.net/rlhua/article/details/20620053另dbv工具例子：[oracle@db01 log]$ dbv file=/...

157.The DB_BLOCK_CHECKING initialization parameter is set to OFF. Which block checking would beperformed?A. The Oracle database will perform block checking for the index blocks onlyB. The Oracle database will not perform block checking for any of the data blocksC. The Oracle database will perfor...

651.The user SYS creates a job by using the following command:Which two statements are true about the job that was created by the preceding command? (Choose two.)A. The job is enabled by default after creationB. The job is automatically dropped after the end dateC. The job executes with the pri...

336.You want to make sure that your database backup does not exceed 10 hours in length. Whatcommand would you issue that would meet this condition?A. backup database plus archivelog;ivlog until time 10:00;B. backup database plus archC. backup database plus archivelog timeout 10:00;D. backup da...

575.You have lost all your database control files. To recover them, you are going to use the results of thealter database backup controlfile to trace command. Your datafiles and your online redo logs are all intact.Which of the following is true regarding your recovery?A. You will need to open th...

545.When performing an online backup, what is the proper order of the following steps?A. Issue the alter database end backup command.B. Back up the archived redo logs.C. Issue the alter database begin backup command.D. Back up the database files.E. Determine the beginning log sequence number.F...

699. Your database is using a default temporary tablespace that contains the temp01.tmp temporary file.All the users on the database use the default temporary tablspace. A user issues a query on the ORDERStable and receives the following error:What would be the most efficient way to rectify this ...

242.You want to create the Recovery Manager (RMAN) Virtual Private Catalog (VPC) to maintain aseparation of responsibilities along with a consolidation of RMAN repository. Which condition must be metbefore you create the VPC?A. A base catalog existsB. The recovery catalog is emptyC. The base re...