Tag: databases

Quizzes (243) Questions (4862)

Questions Related to databases

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
Multiple choice technology databases

You work as a database administrator for TCS .com. You decided to manage client and server connections using Local Naming method in TCS .com. When you try to connect to the database you get the following error: ERROR: ORA-12154:TNS:couldnot resolve service name Which network configuration files would you look into to resolve this error?

  1. snmp.ora

  2. names.ora

  3. spfile.ora

  4. sqlnet.ora

  5. listener.ora

  6. tnsnames.ora
Reveal answer Fill a bubble to check yourself
D,F Correct answer
Full explanation