ITPub博客

159.Which package provides API's for the SQL Tuning Advisor?A. DBMS_MONITORB. DBMS_STATSC. DBMS_SQLTUNED. DBMS_ADVISORAnswer: C 哪个包提供SQL调优顾问的API？A. DBMS_MONITORB. DBMS_STATS        收集统计信息C. DBMS_SQLTUNE   &...

138.You are working on the APPDB database as a DB A. The database has a default Flashback Data Archive DFLA1 created on it. You issued the following command to drop theFlashback Archive FLA1:DROP FLASHBACK ARCHIVE fla1;What is the effect of this command?A. The Flashback Archive FLA1 is dropped on...

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

498.The database Is configured in ARCHIVELOG mode. The database needs to be up 24 X 7. You want to perform user managed backup for the data files of the HR_DATA tablespace. To accomplish the task, you issued the following command:SQL> ALTER TABLESPACE hi_data BEGIN BACKUP;Which two statements are ...

680.Which two operations are NOT performed by the DUPLICATE command in Recovery Manager(RMAN) while duplicating a running database? (Choose Two)A.Creating the control file for the duplicate databaseB.Restoring the target data files to the duplicate databaseC.Performing complete recovery using all...

641.Which three functions are performed by the SQL Tuning Advisor? (Choose three.)A. Building the SQL profileB. Recommending optimization of materialized viewsC. Checking query objects for missing and stale statisticsD. Recommending bitmap, function-based, and B-tree indexesE. Recommending rest...

628.The database is running in the ARCHIVELOG mode. It has three redo log groups with one member each. One of the redo log groups has become corrupted. You have issued the following command during the recovery of a damaged redo log file:ALTER DATABASE CLEAR UNARCHIVED LOGFILE GROUP 3;Which action ...

91.Your database interface is running. A user SCOTT starts a SQL *Plus session, and issues the following query:SQL> SELECT * FROM sales;Which process would retrieve the result from the database and return it to the client program?A. User processB. Server processC. System Monitor (SMON)D. Proce...

76.Identify three key features of ASM. (Choose three.)A. file stripingB. allocation unit mirroringC. automatic disk rebalancingD. automatic file size incrementE. automatic undo managementAnswer: ABC在ASM 中，条带化主要具有两种用途：? 在磁盘组的所有磁盘中执行I/O 负载平衡。? 改善I/...

360.When performing a full database disaster recovery with RMAN, in what order would you execute these 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...

356.Which of the following commands will perform an active database duplication of the ORCL database to the ORCL2 database?A. Set oracle_sid=orclrman target=sys/robert auxname=sys/Robert@orcl2 create duplicate target database to neworcl from active database nofilenamecheckspfile set control_file...

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

347.What does the output on this report indicate? RMAN> report need backup;RMAN retention policy will be applied to the commandRMAN retention policy is set to redundancy 1Report of files with less than 1 redundant backupsFile #bkps Name5 0 C:\ORACLE\ORADATA\ORCL\MY_DATA_01.DBF...

346.What is the impact of the results of the output of the following command? RMAN> report unrecoverable database;Report of files that need backup due to unrecoverable operationsFile Type of Backup Required Name4 full or incremental C:\ORACLE\ORADATA\ORCL\USERS01.DBFA. There are n...

344.In what view are you likely to see the following output? SID SERIAL# EVENT SECONDS_IN_WAIT121 269 RMAN backup & recovery I/O 2129 415 SQL*Net message from client 63 130 270 SQL*Net message from clientA. V$SESSION_EVENTB. V$SESSIONC. V$WAITSD. V$WAITSTATE. V$SYSSTAT...

343.What is the impact of the following backup if it exceeds the duration allowance? (Choose all that apply.)Backup as compressed backupset duration 2:00 partial minimize load database ;A. The entire backup will fail. It will not be usable for recovery.B. The entire backup will fail, but any data...

310.The RVPC user can do which of the following? (Choose all that apply.)A. Register databases if granted the register database privilegeB. See all databases in the recovery-catalogT sMchemaC. See all database-related metadata in the recovery catalog if they are granted access to that databaseD....

304.What privileges must be granted to allow an account to create the recovery catalog? (Choose all that apply.)A. RECOVERY_CATALOG_OWNERB. DBAC. RESOURCED. SELECT ANY DICTIONARYE. CONNECTAnswer: AC允许帐户创建恢复目录时必须授予什么权限？

303.What is the purpose of the RMAN recovery catalog? (Choose all that apply.)A. It must be used because all RMAN-related backup and recovery metadata information is contained in it.B. It provides a convenient, optional, repository of backup- and recovery-related metadata.C. It provides the abili...

600.Which of the following statements are true about the BACKUP command? (Choose all that apply.)A. The BACKUP command can not be used to make image copies of a datafile.B. The BACKUP command can improve performance by multiplexing backup files.C. The BACKUP can take advantage of the block-change...