DATABASE MANAGEMENT SYSTEMS
1.) Which type of file is part of the Oracle database?
A.) Control file
B.) Password file
C.) Parameter files
D.) Archived log files
Answer: Option A
2.) Which statements are use to UNLOCK the user?
A.) Alter user Scott account lock;
B.) Modified user Scott account unlock;
C.) Alter user Scott account unlock;
D.) Alter user Scott unlock
Answer: Option C
3.) For which two constraints are indexes created when the constraint is added?
A.) Check
B.) Unique
C.) Not null
D.) Primary key
E.) Foreign key
Answer: Option B, D
4.) What type of failure occurs when Oracle fails due to an operating system or computer hardware failure?
A.) Application failure
B.) Instance Failure
C.) Media Failure
D.) Rollback failure
Answer: Option B
5.) What Oracle backup and recovery file contains user and system data?
A.) Control file
B.) Datafile
C.) OnLine ReDo file
D.) Offline ReDo file
Answer: Option B
6.) When is the SGA created in an Oracle database environment?
A.) When the database is created
B.) When a user process is started
C.) When the database is mounted
D.) When the instance is started
E.) When a server process is started
Answer: Option D