Managing Databases with Oracle - Database MCQ Questions and answers- Technical Aptitude

A. Using the Oracle Database Configuration Assistant.

B. Using the Oracle-supplied database creation procedures.

C. Using the SQL CREATE DATABASE command.

D. None of the above is correct.

A. Control file

B. Datafile

C. OnLine ReDo file

D. Offline ReDo file

A. are case insensitive.

B. are case sensitive.

C. must always be in lower case.

D. must always be in upper case.

A. ON DELETE CASCADE

B. ON UPDATE CASCADE

C. CREATE SEQUENCE [SequenceName]

D. DROP SEQUENCE [SequenceName]

A. Full backup

B. Consistent backup

C. Inconsistent backup

D. Differential backup

A. Open [FileName]

B. Show [FileName]

C. Alter [FileName]

D. Edit [FileName]

A. .txt

B. .pls

C. .ora

D. .sql

A. is a value that is incremented whenever a dirty read occurs.

B. is incremented whenever a deadlock occurs.

C. is a value that keeps track of explicit locks.

D. is a value that is incremented whenever database changes are made.

A. STRUCTURE [TableName].

B. DESCRIBE [TableName].

C. DESCRIBE STRUCTURE [TableName].

D. DESC TABLE [TableName].

A. CONTENTS

B. BUFFER

C. CURRENT

D. LIST