ITPub博客

160.Which two statements are true about the duplexing of the backups taken by RMAN? (Choose two.)A. It's only supported for the backups performed on the tapeB. It is not supported for backup operations that produce image copiesC. Duplex backups need a parallelism for the device to be equal to num...

632.Note the following parameter settings: Which setting is NOT allowed?A. ALTER SYSTEM SET DB_CACHE_SIZE=50M;B. ALTER SYSTEM SET DB_8K_CACHE_SIZE=10M;C. ALTER SYSTEM SET DB_4K_CACHE_SIZE=10M;D. ALTER SYSTEMAnswer: B验证：SQL> show parameter dbNAME           &n...

630.Which two statements are true about encrypting RMAN backup? (Choose two.)A. The transparent encryption of backups uses the encryption walletB. The database uses the same encryption key for every encrypted backupC. The password encryption of backups only uses the password while creating and re...

271.Examine the output of the query that you executed to list the objects in the recycle bin:You verified that no table named SALES_TAB exists in the schema. Then you executed the followingcommand to purge the objects in the recycle bin:SQL> PURGE TABLE sales_tab;What would be the outcome of th...

245.Which statements are true regarding system-partitioned tables? (Choose all that apply.)A. Only a single partitioning key column can be specified.B. All DML statements must use partition-extended syntax.C. The same physical attributes must be specified for each partition.D. Unique local index...

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

1. 查看用户允许最大进程数  /usr/sbin/lsattr -E -l sys0 | grep maxuproc2. 修改用户允许最大进程数 /usr/sbin/chdev -l sys0 -a maxuproc=1000进程数过小，可能导致监听处理不了客户端连接请求  TNS-12518: TNS:listener could not hand off client connection TNS-12536: TNS:op...

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

实验的时候碰到一个错误：SQL> create table t1 as select rownum rn from dual connect by rownum <= 10000;create table t1 as select rownum rn from dual connect by rownum <= 10000                                  &nb...

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