A. a job
B. a program
C. a schedule
D. a PL/SQL procedure
您可能感兴趣的试卷
你可能感兴趣的试题
Your database is in ARCHIVELOG mode. You have two online redo log groups, each of which contains one redo member. When you attempt to start the database, you receive the following errors:
Which statement should you use to resolve this issue?()
A. ALTER DATABASE DROP LOGFILE GROUP 1;
B.ALTER DATABASE CLEAR LOGFILE GROUP 1;
C. ALTER DATABASE CLEAR UNARCHIVED LOGFILE GROUP 1;
D. ALTER DATABASE DROP LOGFILE MEMBER 'D:\REDO01.LOG';
A. The collection level for the AWR should be set to BASIC
B. The moving window size must be less than Undo Retention
C. The moving window size should be greater than the Automatic Workload Repository (AWR) retention period
D. The moving window size should be equal to or less than the Automatic Workload Repository (AWR) retention period
A. The plan baselines can be evolved over time to produce better performance.
B. The newly generated plans are directly placed into the SQL plan baseline without being verified.
C. The new SQL statements initially run with the plans that are known to produce good performance under standard test configuration.
D. The optimizer does not generate new plans for the SQL statements for which the SQL plan baseline has been imported.
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 have access to only the PROD1 database and create a virtual private catalog.
Given below are some of the commands required to achieve this:
1.SQL> GRANT recovery_catalog_owner TO vpc1;
2.RMAN> CONNECT CATALOG vpc1/password@catdb;
3.RMAN> GRANT CATALOG FOR DATABASE prod1 TO vpc1;
4.RMAN> CONNECT CATALOG catowner/password@catdb;
5.RMAN> CREATE VIRTUAL CATALOG;
What is the correct sequence in which the commands have to be executed?()
A. 1, 4, 5, 2, 3
B. 1, 4, 3, 2, 5
C. 4, 5, 2, 3, 1
D. 2, 3, 4, 5, 1
E. 1, 4, 2, 3, 5
In your database, the LDAP_DIRECTORY_SYSAUTH initialization parameter has been set to YES and the users who need to access the database as DBAs have been granted SYSDBA enterprise role in Oracle Internet Directory (OID). SSL and the password file have been configured. A user SCOTT with the SYSDBA privilege tries to connect to the database instance from a remote machine using the command:
Which authentication method would be used first?()
A. authentication by password file
B. authentication by using certificates over SSL
C. authentication by using the Oracle Internet Directory
D. authentication by using the local OS of the database server
A. It updates the existing SQL profiles with current statistics
B. It makes the statistics information available to GATHER_STATS_JOB
C. It initiates the statistics collection process by running GATHER_STATS_JOB
D. It logs a warning message in the alert log so that the DBA can perform statistics collection manually
View the Exhibit for some of the parameter settings. You start a session and issue the following command:
SQL>CREATE INDEX emp_ename ON emp(ename) TABLESPACE users INVISIBLE;
What is the outcome of the above command?()
A. The index is not used by the optimizer but is maintained during DML operations.
B. The index is not used by the optimizer and is not maintained during DML operations.
C. The index is used by the optimizer only if a hint is specified in the query statement and is maintained during DML operations.
D. The index is used by the optimizer only if a hint is specified in the query statement but is not maintained during DML operations.
You perform the following activities during the database upgrade from Oracle Database 10g to Oracle Database 11g:
1. Capture plans for a SQL workload into a SQL Tuning Set (STS) before upgrade.
2. Load these plans from the STS into the SQL plan baseline immediately after the upgrade.
What is the reason for performing these activities? ()
A. to minimize plan regression due to the use of a new optimizer version
B. to completely avoid the use of new plans generated by a new optimizer version
C. to prevent plan capturing when the SQL statement is executed after the database upgrade
D. to keep the plan in the plan history so that it can be used when the older version of the optimizer is used
A. To create and execute an RMAN stored script, you must use a recovery catalog.
B. When executing a stored script and a command fails, the remainder of the script is executed, and a message is written to the alert log file.
C. RMAN stored scripts can always be executed against any target database that is registered in the recovery catalog.
D. When you execute a stored script, it always executes using the persistent channel settings previously set with the CONFIGURE command.
A. Segment Advisor
B. SQL Access Advisor
C. Undo Advisor
D. SQL Tuning Advisor
![](https://static.ppkao.com/ppmg/img/appqrcode.png)
最新试题
View the exhibit and examine the TRANS table's storage information.After a massive delete operation, you executed the following statement to shrink the TRANS table:SQL> ALTER TABLE trans SHRINK SPACE CASCADE;Which statement describes the outcome of the command?()
You want to enable automatic PGA memory management in your database. Which setting is required to achieve this?()
Which two statements are true about a job chain?()
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?()
Which three statements are true about windows?()
While Monitoring the space usage in your database that is in ARCHIVELOG mode you observed that the flash recovery area does not have enough free space to accommodate any more files and you do not have necessary permissions to add more space to it.Identify the two events that can occur in the event of a log switch?()
In your production database, users report that they are unable to generate reports on an important table because it does not contain any data. While investigating the reason, you realize that another user executed the TRUNCATE TABLE command, which accidentally caused the data to be lost. Now you want to recover the lost data of the table without affecting objects in other schemas.Which method must you use to recover the lost data?()
Which three tasks can be performed using a duplicate database?()
Examine the following RMAN script:Which statement describes the purpose of the script?()
Which two operations are NOT performed by the DUPLICATE command in Recovery Manager (RMAN)while duplicating a running database?()