ITPub博客

484.Which steps are mandatory to enable Direct NFS?1. Mount all required file systems using the kernel NFS driver.2. Create an oranfstab file containing the attributes for each NFS server to be accessed using Direct NFS.3. Replace the ODM library libodm11.so_stub with libodm11.so.A. 2 and 3B. 1...

57.Which background process of a database instance, using Automatic Storage Management (ASM),connects as a foreground process into the ASM instance?A. ASMBB. PMONC. RBALD. SMONAnswer: AASM Background ProcessesThe following background processes are an integral part of Automatic Storage ...

116.Which two are the uses of the ASM metadata backup and restore (AMBR) feature? (Choose two.)A. It can be used to back up all data on ASM disks.B. It can be used to recover the damaged ASM disk group along with the data.C. It can be used to gather information about a preexisting ASM disk group ...

635.While Monitoring the space usage in your database that is in ARCHIVELOG mode you observed thatthe flash recovery area does not have enough free space to accommodate any more files and you do nothave necessary permissions to add more space to it.Identify the two events that can occur in the ev...

671.Examine the following RMAN command:RMAN> CONFIGURE ENCRYPTION FOR DATABASE ON;RMAN> BACKUP DATABASE PLUS ARCHIVELOG;Which prerequisite must be met before accomplishing the backup?A. Provide a password for the encryptionB. Set up an Oracle wallet for the encryptionC. No setup is required as...

571.Which files are required for a full recovery of the database in ARCHIVELOG mode? (Choose three.)A. Database datafilesB. Online redo logsC. Archived redo logsD. Backup control fileE. Control file from a backupAnswer: ACD

450.Which of the following are valid program types for a lightweight job? (Choose all that apply.)A. PLSQL_BLOCKB. EXECUTABLEC. JAVA_STORED_PROCEDURED. STORED_PROCEDUREE. EXTERNALAnswer: AD参考：https://docs.oracle.com/cd/B28359_01/server.111/b28310/schedover004.htm#BGBJGHBHA lightweight ...

80.Which two statements regarding a SQL profile are true? (Choose two.)A. It is built by Automatic Tuning Optimizer.B. It cannot be stored persistently in the data dictionary.C. It can be used by the query optimizer automatically.D. It can be created manually by using the CREATE PROFILE command....

53.You want to use RMAN to create compressed backups.Which statement is true about the compression algorithms that RMAN can use?A. The BZIP2 compression algorithm consumes more CPU resources than the ZLIB compressionalgorithm.B. The ZLIB compression algorithm consumes more CPU resources than the...

512.Which two statements correctly describe the relationship among the Scheduler components: job,program, and schedule? (Choose two)A. A job is specified as part of a program definitionB. A program can be used in the definition of multiple jobsC. A program and job can be specified as part of a s...

686. You execute the following FLASHBACK TABLE command:Which two statements are correct?(Choose two.)A.The EMP table that was dropped by mistake earlier is restored.B.The FLASHBACK TABLE statement is executed as a single transaction.C.The FLASHBACK TABLE statement does not maintain existing ind...

20.View the Exhibit and examine the resource consumption details for the current plan in use by thedatabase instance.Which two statements are true based on the output? (Choose two.)Exhibit:A. An attempt to start a new session by the user belonging to DSS_QUERIES fails with an errorB. A user be...

206.Which statements are true regarding the Query Result Cache? (Choose all that apply.)A. It can be set at the system, session, or table level.B. It is used only across statements in the same session.C. It can store the results from normal as well as flashback queries.D. It can store the resu...

531.When starting up your ASM instance, you receive the following error:What is the cause of the error?A. The ASM_DISKGROUPS parameter is configured for three disk groups: DGROUP1, DGROUP2, andDGROUP3.The underlying disks for these disk groups have apparently been lost.B. The format of the ASM...

326.Which of the following does the recover command not do?A. Restore archived redo logs.B. Apply archived redo logs.C. Restore incremental backups.D. Apply incremental backups.E. Restore datafile images.Answer: E

577.What methods are available to recover lost control files? (Choose all that apply.)A. Backup control file.B. Emergency control file.C. The create controlfile command.D. The restore controlfile SQL*Plus command.E. No backup is required. The database will re-create the control file when it is ...

360.When performing a full database disaster recovery with RMAN, in what order would you executethese steps?A. Restore the control file from autobackups.B. Run the RMAN restore and recover command.C. Restore the database spfile from autobackups.D. Make the RMAN backup set pieces available.E. O...

698. In your production database, you:-Are using Recovery Manager (RMAN) with a recovery catalog to perform the backup operation at regularintervals-Set the control file autobackup to “on”-Are maintaining image copies of the database filesYou have lost the server parameter file (SPFILE) and t...

99.View the Exhibit and examine the steps that you executed to create a database resource plan.Subsequently, you execute the following procedure which results in an error:SQL> EXECUTE dbms_resources_manager.validate_pending_area ( );What could be the reason?Exhibit:A. The pending area is autom...

85.You executed the following command to drop a user:DROP USER scott CASCADE;Which two statements regarding the above command are correct? (Choose two.)A. All the objects of scott are moved to the Recycle Bin.B. Any objects in the Recycle Bin belonging to scott are purged.C. All the objects own...