ITPub博客

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...

473.How many different calendars does Oracle 11g support?A. 22B. 7C. 6D. 15E. 2Answer: Bhttp://docs.oracle.com/cd/E11882_01/server.112/e10729/ch3globenv.htm#NLSPG215http://blog.csdn.net/rlhua/article/details/19572505

279.Identify the activities performed as part of the Automatic SQL Tuning process in the maintenancewindow? (Choose all that apply.)A. generating the SQL profileB. testing and accepting the SQL profileC. generating a list of candidate SQLs for tuningD. adding tuned SQL plans into the SQL plan b...

499.Which statement is true regarding the retention policy for the incidents accumulated in the AutomaticDiagnostic Repository (ADR)?A. The incident metadata is purged when the problem is resolved and the DBA closes the SR.B. The incident files and dumps are not retained in the ADR for the manual...

349.What is the result of this command? RMAN> Report need backup days 3;A. Lists all datafiles created in the last three days that are not backed up.B. Lists all datafiles not recoverable based on the current retention criteria.C. Lists all datafiles not backed up in the last three days. The data...

672.You are in the process of creating a Virtual Private Catalog (VPC) in your Oracle Database 11gdatabase. The Prod1, Prod2 and Prod3 Oracle Database 10g databases are registered in the recoverycatalog. The database user who owns the base recovery catalog is CATOWNER. CATOWNER executesthe follow...

 542.You are an Oracle DBA responsible for an ASM instance. The disk controller on your system fails.You suspect that the disk itself is okay. You know it will take 24 hours to replace the controller and youdon't want to have to rebuild the disks from scratch. What do you do?A. Take ...

574.A user sends you an email with the following error message: create table idtable(id number) *ERROR at line 1: ORA- 01110: data file 4: ,,/oracle01/oradata/orcl/users01.dbf ORA-27041:01116: error in opening database file 4 ORA-unable to open file Linux Error: 2: No such file or directoryAdditi...

561.If you issue the command shutdown abort prior to trying to put the database in ARCHIVELOG mode,what will be the result when you issue the command alter database archivelog?A. The alter database archivelog command will fail.B. The alter database archivelog inconsistent command must be used to ...

455.When a job exceeds the date specified in its END_DATE attribute, which of the following will happen?(Choose all that apply.)A. The job will be dropped automatically if the value of the     attribute is TRUE. B. The job will only be disabled if the value of the AUTO_DR...

https://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:1794009000346753857In a nutshell - the tuning advisor o suggests sql profiles o gathering more or stale statistics o indexes that might be VERY useful o query rewrites the access advisor o ...

 Examine the following statement that is used to modify the primary key constraint on the SALEStable:SQL> ALTER TABLE SALES MODIFY CONSTRAINT pk DISABLE VALIDATE;Which three statements are true regarding the above command? (Choose three.)A.The constraint remains valid.B.The index on the c...

185.A shoot-out has erupted between your MS development teams using .NET and your Linux development teams using Java. Knowing that your database is in danger, which command would you use to back up your NOARCHIVELOG mode database using RMAN with compression? A. backup database all B. backup comp...