Tag: technology

Quizzes (307) Questions (36705)

Questions Related to technology

Multiple choice technology databases

Your database operates in ARCHIVELOGmode. User-managed consistent backups are performed every Sunday night. On Tuesday, client A drops a table at8:00 a.m.as follows: SQL> DROP TABLEcust_ordPURGE; Table dropped. Client B executes a query at9:00 a.m.on the same table as follows: SQL> SELECT * FROMcust_ord SELECT * FROMcust_ord * ERROR at line 1: ORA-00942: table or view does not exist Client B needs the dropped table and reports the problem to you. With reference to this scenario, which action should you take?

  1. retrieve the table by using the flashback feature

  2. restore all the data files from last Sunday's backup and then perform a time-based recovery

  3. restore all the data files from last Sunday's backup and then perform a log sequence recovery

  4. restore all the data files from last Sunday's backup and then perform a cancel-based recovery

  5. restore from last Sunday's backup only data files that belong to the tablespace in which the table was stored and then perform a complete recovery
Reveal answer Fill a bubble to check yourself
B Correct answer
Full explanation
Multiple choice technology databases

One of the tablespaces is read-only in your database. The loss of all control files forced you to re-create the control file. Which operation do you need to perform after re-creating the control file and opening the database?

  1. drop and re-create the read-only tablespaces

  2. rename the read-only data files to their correct file names

  3. change the tablespace status from read/write to read-only

  4. re-create the read-only tablespace because it is automatically removed

  5. none of the above
Reveal answer Fill a bubble to check yourself
B Correct answer
Full explanation