ITPub博客

217.Your organization decided to upgrade the existing Oracle 10g database to Oracle 11g database in amultiprocessor environment. At the end of the upgrade, you observe that the DBA executes the followingscript:SQL> @utlrp.sqlWhat is the significance of executing this script?A. It performs paral...

259.Which setting enables the baselines by default in Oracle Database 11g?A. setting the STATISTICS_LEVEL parameter to TYPICALB. adding filters to the Automatic Database Diagnostic Monitor (ADDM)C. enabling Automated Maintenance Task using Oracle Enterprise ManagerD. setting the OPTIMIZER_USE_PE...

384.Which of the following statements is true regarding the VERSIONS BETWEEN clause?A. The VERSIONS BETWEEN clause may be used in DML statements.B. The VERSIONS BETWEEN clause may be used in DDL statements.C. The VERSIONS BETWEEN clause may not be used to query past DDL changes to tables.D. The ...

252.Which three are the valid statements in relation to SQL plan baselines? (Choose three.)A. The plans can be manually loaded to the SQL plan baseline.B. The plans in the SQL plan baseline are verified and accepted plans.C. The plans generated for every SQL statement are stored in the SQL plan b...

566.You have lost all your SYSTEM tablespace datafiles (system_01.dbf and system_02.dbf) nd thedatabase has crashed.What would be the appropriate order of operations to correct the situation?A. Mount the database with the startup mount command.B. Take the SYSTEM datafile offline with the alter d...

445.To set the history retention period for either window logging or job logging individually, whichparameters of the SET_SCHEDULER_ATTRIBUTE procedure need to be used? (Choose all that apply.)A. LOG_HISTORYB. JOB_LOG_RETENTIONC. WINDOW_LOG_RETENTIOND. WHICH_LOGE. LOG_NAMEAnswer: AD

307.You have created a script in the recovery catalog called backup_database. Which of the followingcommands would successfully execute that script?A. run { open script backup_database; run script backup_database }B. run { engage script backup_database; }C. run { run script backup_database; }D....

6.You are working on a CATDB database that contains an Oracle Database version 11.1 catalog schemaowned by the user RCO11. The INST1 database contains an Oracle Database version 10.1 catalogschema owned by the user RCAT10.You want the RMAN to import metadata for database IDs 1423241 and 1423242, ...

115.What are the advantages of variable extent size support for large ASM files? (Choose two.)A. It improves resync operations when the disk comes online after being taken offline for maintenancepurposes.B. It improves performance in the extended cluster configuration by reading from a local copy...

510.You executed the following command in Recovery Manager (RMAN):RMAN> REPORT NEED BACKUP days 3;What is the output of this command?A. a list of files that require a backup within three daysB. a list of files requiring more than 3 days of archive logs to applyC. a list of files that RMAN recom...

137.Your company wants to upgrade the current production database to the RAC environment. Toperform testing before migrating to the RAC environment, you performed the workload capture on theproduction database to record the peak workload. You set up the test RAC database and want to replaythe rec...

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