问题:多选题For which two SQL statements can you use the Flashback Table feature to revert a table to its previous state?()AUPDATE TABLEBCREATE CLUSTERCTRUNCATE TABLEDALTER TABLE MOVEEINSERT INTO···VALUESFALTER TABLE···DROP COLUMNGALTER TABLE···DROP PARTITION...
查看答案
问题:In which of the following scenarios is a tablespace recovery...
问题:单选题You are part of the DBA team working for a multinational bank. The team is responsible for performing administrative tasks on the database server located at the home office. The database server at the home office has a production database and a test da...
问题:In which scenario will you issue the following command?() ...
问题:单选题Your database is in ARCHIVELOG mode. You lost an index tablespace due to a disk failure while the database was open. You have neither a backup of the lost index tablespace nor the scripts containing the CREATE INDEX statements to recreate the indexes. ...
问题:You are maintaining the PROD database of NetFx Corporation. ...
问题:单选题You defined the Recovery Manager (RMAN) retention policy to recovery window of 7 days by executing the following command: RMAN CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 7 DAYS; When a backup is performed, what would be the status of this backu...
问题:What will be the result of using the SQL> DROP USER SCOTT CA...
问题:单选题You are working in an online transaction processing (OLTP) environment. You used the FLASHBACK TABLE command to flash back the CUSTOMERS table. Before executing the FLASHBACK TABLE command, the System Change Number (SCN) was 663571. After flashing back...
问题:单选题Using Oracle Scheduler you have scheduled two jobs, JOB_A and JOB_B, to run at 9:00 p.m. every Friday. You want both the jobs to use a single resource plan, WEEKEND_PLAN. Which task must have already been performed to enable you to achieve this objecti...
问题:单选题A junior level Database Administrator erroneously deleted the database alert log while users were accessing the database. Which action should you take to recover the alert log?()A Do nothing.B Restart the database.C Perform recovery on the database....
问题:You observe that database performance has degraded over a pe...
问题:You are connected to Recovery Manager (RMAN) without a recov...
问题:单选题In which scenario will you issue the following command?() SQL RECOVER DATABASE UNTIL TIME ’2005-10-04 : 12:09:08’ USING BACKUP CONTROLFILE;A when all the control files are missing and only a binary backup of the current control file exists...
问题:While creating a job class using the DBMS_SCHEDULER package,...
问题:单选题You receive the following error: ORA-19804: cannot reclaim nnnnn bytes disk space from mmmmm limit Identify the reason for receiving the above error message?()A The sort area is very small.B There is no more space in the Undo tablespace.C The fl...
问题:You have created a job class, CUST_JOB_1, with two jobs, CUS...
问题:You are performing a block media recovery on the tools01.dbf...
问题:In Recovery Manager (RMAN), you set the retention policy to ...
问题:In your database, all the tablespaces are locally managed. Y...