Home › Quizzes › Oracle Database Administration Fundamentals

Oracle Database Administration Fundamentals

Covers Oracle database recovery, backup, redo log management, and basic SQL operations.

20 Questions Published
Play Quiz Practise this topic out loud

Questions

Question 1 Multiple Choice (Single Answer)
  1. With SQL, how can you return the number of records in the "Persons" table?
  1. SELECT COLUMNS() FROM Persons
  2. SELECT COUNT(*) FROM Persons
  3. SELECT COUNT() FROM Persons
  4. SELECT COLUMNS(*) FROM Persons
Question 2 Multiple Choice (Single Answer)
  1. Which SQL statement is used to return only different values?
  1. SELECT UNIQUE
  2. SELECT DISTINCT
  3. SELECT DIFFERENT
  4. None
Question 3 True/False

The OR operator displays a record if ANY conditions listed are true. The AND operator displays a record if ALL of the conditions listed are true

  1. True
  2. False
Question 4 Multiple Choice (Multiple Answers)

How can you change "Hansen" into "Nilsen" in the "LastName" column in the Persons table?

  1. UPDATE Persons SET LastName='Hansen' INTO LastName='Nilsen'
  2. MODIFY Persons SET LastName='Nilsen' WHERE LastName='Hansen
  3. UPDATE Persons SET LastName='Nilsen' WHERE LastName='Hansen'
  4. MODIFY Persons SET LastName='Hansen' INTO LastName='Nilsen
Question 5 Multiple Choice (Multiple Answers)

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
Question 6 Multiple Choice (Multiple Answers)

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
Question 7 Multiple Choice (Multiple Answers)

The data file belonging to theSYSTEMtablespaceis corrupted and no backup of the file is available. How do you recover the data file?

  1. The data file cannot be recovered.
  2. The date file can be restored from the SYSTEM auto backup.
  3. Take thetablespaceoffline,drop,kand re-create it.
  4. Recovery Manager (RMAN) is used to recover the data file.
  5. The ALTER DATABSE CREATE DATAFILE
Question 8 Multiple Choice (Multiple Answers)

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
Question 9 Multiple Choice (Multiple Answers)

You work as a database administrator for TCS .com. In your production database, the size of Database Buffer Cache needs to be increased immediately for the current as well as future instances of the database. The Oracle instance has been configured to accommodate any changes in the size of the memory structures. At this is production database, you want to accomplish this task with no impact on the user's connections. Which activity must you have completed before accomplishing this task?

  1. You must have started the database instance in restricted mode.
  2. You must have started the database instance in NORMALmode.
  3. You must have started the database instance with server parameter file.
  4. You must have started the database instance but must not have mounted.
  5. You must have started the database instance but must not have opened.
Question 10 Multiple Choice (Multiple Answers)

Your TCS .com database is in ARCHIVELOG mode. The data file that belongs to the SYSTEMtablespacehas become corrupted. Up to what point can you recover the database?

  1. Until last commit
  2. Until the time you perform recovery
  3. Until the time the date file got corrupted
  4. Until the point where the last transaction begun
  5. You cannot recover the SYSTEM tablespaceand must re-create the database.
Question 11 Multiple Choice (Multiple Answers)

You work as a database administrator for TCS .com. The UNDO_RETENTION parameter in your database is set to 1000 and undoretention is not guaranteed. Which statement regarding retention of undo data is correct?

  1. Undo data becomes obsolete after 1,000 seconds.
  2. Undo data gets refreshed after 1,000 seconds.
  3. Undo data will be stored permanently after 1,000 seconds.
  4. Committed undo data would be retained for 1,000 seconds if free undo space is available.
  5. Undo data will be retained in the UNDOtablespacefor 1,000 seconds, then it gets movedmovedto the TEMPORARY tablespace to provide read consistency.
Question 12 Multiple Choice (Multiple Answers)

You work as a database administrator for TCS .com. On a Monday morning, you find the database instance aborted. After inspecting the alert log file, you execute the STARTUP command in SQL*Plus to bring the instance up. What statement is true?

  1. PMON coordinates media recovery.
  2. SMON coordinates instance recovery.
  3. PMON coordinates instance recovery.
  4. Undo Advisor would roll back all uncommitted transactions.
  5. SQL*PLUS reports an error with the message asking you to perform instance recovery.
Question 13 Multiple Choice (Multiple Answers)

You work as a database administrator for TCS .com. The database is open. A media failure has occurred, resulting in loss of all the control files in your database. Which statement regarding the database instance is true in this scenario?

  1. The instance would hang.
  2. The instance needs to be shut down.
  3. The instance would be in the open state.
  4. The instance would abort in such cases.
  5. The instance would be in the open and invalid state.
  6. The instance would in the open state, but all the background processes will be restarted.
Question 14 Multiple Choice (Multiple Answers)

You are working on the TCS database. What is the default name of the alert log file in this database?

  1. alert_TCS.log
  2. alertlog_TCS.log
  3. TCS _alert_log.log
  4. log_alert_TCS.log
  5. trace_alert_TCS.log
Question 15 Multiple Choice (Single Answer)

In your DB -multiplexed online redo log files,one of the members in a group is lost due to media failure? You wud..

  1. import the database from the last export
  2. restore all the members in the group from the last backup
  3. drop the lost member from the database and then add a new member to the group
  4. restore all the database files from the backup and then perform a complete recovery
  5. restore all the database files from the backup and then perform an incomplete recovery
Question 16 Multiple Choice (Single Answer)

Which statement regarding an incomplete recovery is true?(Oracle 10g)

  1. You do not need to restore all the data files.
  2. You do not need to open the database with the RESETLOGS operation
  3. You do not need to perform a full backup after the RESETLOGS operation.
  4. You do not need to recover all the data files to the same system change number (SCN).
Question 17 Multiple Choice (Single Answer)

In which scenarios would you rebuild an index?

  1. when you need to disable the index usage
  2. when you need to move the index to another tablespace
  3. when you need to enable index monitoring
  4. none of the above
Question 18 Multiple Choice (Single Answer)

A redo log file is corrupted while the database is open;You would ..

  1. clear the redo log group
  2. perform redo log file import
  3. perform an incomplete recovery
  4. perform a redo log recovery using Recovery Manager (RMAN)
  5. shut down the database and open the database in the NOARCHIVELOGmode
Question 19 Multiple Choice (Single Answer)

Which statement regarding an incomplete recovery is true(10g)?

  1. You do not need to restore all the data files.
  2. You do not need to open the database with the RESETLOGS operation
  3. You do not need to perform a full backup after the RESETLOGS operation.
  4. You do not need to recover all the data files to the same system change number (SCN).
Question 20 Multiple Choice (Single Answer)

Which file is not supported with RMANBACKUP command?

  1. data file
  2. password file
  3. archivelog file
  4. temporary file
  5. online redo log file
← Back to Quizzes