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

---

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

---

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

---

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

---

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

---

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

---