<dl id="qdsea"></dl>

OCP 11G認證考試單項選擇題每日一練(2019.01.21)

單項選擇題
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';
單項選擇題
You perform a backup using the following BACKUP command: RMAN> BACKUP AS COMPRESSED BACKUPSET DATABASE,Which statement is true of this command?（）
A.A different procedure is required to restore a database from compressed backups
B.The AS COMPRESSED clause of the BACKUP command provided by RMAN is used to create compressed backup sets and image copies.
C.Using this command to create backups minimizes the bandwidth consumed.
D.Using this command to create backups improves the performance of the backup process
單項選擇題
You are using Recovery Manager (RMAN) with a recovery catalog to back up your production database. The backups and the archived redo log files are copied to a tape drive on a daily basis. Because of media failure, you lost your production database completely along with the recovery catalog database. You want to recover the target database and make it functional. You consider performing the following steps to accomplish the task:Which option illustrates the correct sequence that you must use?（）
A. 8, 1, 3, 2, 4, 5, 7, 6
B. 1, 8, 3, 4, 2, 5, 7, 6
C. 1, 3, 4, 2, 8, 5, 6, 7
D. 1, 3, 2, 4, 6, 5, 7, 8
單項選擇題
You are currently located in Singapore and have connected to a remote database in Chicago. You issue the following command:SQL> SELECT ROUND (SYSDATE-promo_begin_date, 0) FROM promotions WHERE (SYSDATE-promo_begin_date)/365 >2;PROMOTIONS is the public synonym for the public database link for the PROMOTIONS table. What is the outcome?（）
A.an error because the ROUND function specified is invalid
B.an error because the WHERE condition specified is invalid
C.number of days since the promo started based on the current Chicago date and time
D.number of days since the promo started based on the current Singapore date and time
單項選擇題
Which is the source used by Automatic SQL Tuning that runs as part of the AUTOTASK framework? （）
A.SQL statements that are part of the AWR baseline only
B.SQL statements based on the AWR top SQL identification
C.SQL statements that are part of the available SQL Tuning Set (STS) only
D.SQL statements that are available in the cursor cache and executed by a user other than SYS

<delect id="i68tf"></delect>