ITPub博客

300.The following databases are registered in the base recovery catalog: PROD1, PROD2, and PROD3.The database user CATOWNER owns the base recovery catalog. You want a new user VPC1 to haveaccess to only the PROD1 database and create a virtual private catalog.Given below are some of the commands r...

522.The NLS_LANGUAGE parameter specifies the default conventions to be used for which of thefollowing globalization elements?A. Languages for server messagesB. Day and month names and abbreviationsC. Symbols to represent a.m., p.m., AD, and BCD. Affirmative and negative response strings (YES, N...

470.Which NLS parameter can be used to change the default Oracle sort method from binary to linguisticfor the SQL SELECT statement?A. NLS_LANGB. NLS_COMPC. NLS_SORTD. None of the aboveAnswer: D

396.Which of the following are not fundamental tasks of the Support Workbench? (Choose all that apply.)A. View long-running SQL workloadsB. View problem detailsC. Gather additional diagnostic informationD. Create a Service RequestE. Clean up incident data after upload to Oracle SupportAnswer: ...

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