Tag: databases

Quizzes (243) Questions (4862)

Questions Related to databases

Multiple choice technology databases

A user is running a long update batch file. Many tables are updated and all the statements are in one transaction. Before the process is finished, the user machine lost power. When the user calls you, what should you do as DBA?

  1. Do nothing, the PMON process handles everything.

  2. Shut down the database and restore all the tables the user was updating.

  3. Log in as DBA, clean up the partial updates in those tables, and do another manual backup.

  4. Use LogMiner to find out which records are changed based on the user’s ID, then roll back all those changes.
Reveal answer Fill a bubble to check yourself
A Correct answer
Full explanation
Multiple choice technology databases

SQL> CREATE TABLESPACE user_data EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO; Which twp assumptions must be true for this statement to execute successfully ? (Choose two)

  1. Oracle Managed Files used for this instance.
  2. The USER_DATA tablespace in managed using FET$/UET$ tables.

  3. The COMPATIBLE intialization paramter must be 9.0.0 or higer.

  4. Space within segments is the USER_DATA tablespace is managed with freelists.
Reveal answer Fill a bubble to check yourself
A,C Correct answer
Full explanation