Your database supports a DSS workload that involves the execution of complex queries: Curr

第1题

You are working on a 24X7 database. You want to design a backup strategy for your database

that uses user managed backups. You want to be able to perform all backups while the database remains online.Which statement about performing user-managed backups in a 24x7 environment is true？（）

A. You must have change tracking enabled in your database

B. Your database must be running in NOARCHIVELOG mode

C. To back up a tablespace, it must be in backup mode

D. To back up a tablespace, it must first be taken offline

点击查看答案

第2题

In your multitenant container database （CDB) containing pluggable databases （PDB), users c

In your multitenant container database (CDB) containing pluggable databases (PDB), users complain about performance degradation.How does real-time Automatic database Diagnostic Monitor (ADDM) check performance degradation and provide solutions？（）

A. It collects data from SGA and compares it with a preserved snapshot.

B. It collects data from SGA, analyzes it, and provides a report.

C. It collects data from SGA and compares it with the latest snapshot.

D. It collects data from both SGA and PGA, analyzes it, and provides a report

点击查看答案

第3题

A.90 MB

B. 272 MB

C. 362 MB

D. 1,440 MB

点击查看答案

第4题

Why we use index in database？ How many indexes is the maximum in onetable as your sugg

Why we use index in database？ How many indexes is the maximum in one

table as your suggestion？

点击查看答案

第5题

You realize that the control file is damaged in your production database.After restoring t

he control file from autobackup, what is the next step that you must do to proceed with the database recovery？（）

A. Mount the database

B. Open the database in NORMAL mode

C. Open the database in RESTRICTED mode

D. Open the database with the RESETLOGS option

点击查看答案

第6题

The best title of the passage is likely to be“ _________”. A． The Internet An

The best title of the passage is likely to be“ _________”.

A． The Internet An Organized Database

B． Tools for Internet Information

C． How to Use Web Directories

D． How to Update Your Database

点击查看答案

第7题

Your database supports an online transaction processing （OLTP) application.The application

Your database supports an online transaction processing (OLTP) application.The application is undergoing some major schema changes, such as addition of new indexes and materialized views.You want to check the impact of these changes on workload performance.What should you use to achieve this？（）

A. Database replay

B. SQL Tuning Advisor

C. SQL Access Advisor

D. SQL Performance Analyzer

E. Automatic Workload Repository compare reports

点击查看答案

第8题

Your database instance is running.You are not able to access Oracle Enterprise Manager Database Control because the listener is not started.Which tool or utility would you use to start the listener？（）

A. Oracle Net Manager

B. Listener Control utility

C. Database Configuration Assistant

D. Oracle Net Configuration Assistant

点击查看答案

第9题

Your multitenant container database （CDB) contains a pluggable database, HR_PDB. The defau

Your multitenant container database (CDB) contains a pluggable database, HR_PDB. The default permanent tablespace in HR_PDB is USERDATA. The container database (CDB) is open and you connect RMAN.You want to issue the following RMAN command:RMAN ＞ BACKUP TABLESPACE hr_pdb:userdata;Which task should you perform before issuing the command？（）

A. Place the root container in ARHCHIVELOG mode.

B. Take the user data tablespace offline.

C. Place the root container in the nomount stage.

D. Ensure that HR_PDB is open.

点击查看答案

第10题

In your multitenant container database （CDB) containing pluggable database （PDBs), you gra

In your multitenant container database (CDB) containing pluggable database (PDBs), you granted theCREATE TABLE privilege to the common user C A_ADMIN in root and all PDBs. You execute thefollowing command from the root container:SQL >REVOKE create table FROM C A_ADMIN;What is the result？（）

A. It executes successfully and the CREATE TABLE privilege is revoked from C # # A_ADMIN in root only.

B. It fails and reports an error because the CONTAINER=ALL clause is not used.

C. It excludes successfully and the CREATE TABLE privilege is revoked from C # # A_ADMIN in root and all PDBs.

D. It fails and reports an error because the CONTAINER=CURRENT clause is not used.

E.It executes successfully and the CREATE TABLE privilege is revoked from C # # A_ADMIN in all PDBs.

点击查看答案

第11题

You are using recovery Manager （RMAN) with a recovery catalog to backup up your production

You are using recovery Manager (RMAN) with a recovery catalog to backup up your production database. The backups and the archived redo log files are copied to a tape drive on a daily basis. The database was open and transactions were recorded in the redo logs. Because of fire in the building you lost your servers having the production database and the recovery catalog database.The archive log files generated after the last backup are intact on one of the remote locations. While performing a disaster recovery of the production database what is the next step that you must perform after restoring the data files and applying archived redo logs？（）

A. Open the database in NORMAL mode

B. Open the database in read-only mode

C. Open the database in RESTRICTED mode

D. Open the database with the RESETLOGS option

点击查看答案