Practice Questions

Which Oracle memory component stores parsed SQL statements and execution plans?

A. Database Buffer Cache B. Redo Log Buffer C. Shared Pool D. Large Pool

Which command is used to start an Oracle database instance?

A. START DATABASE B. STARTUP C. OPEN DATABASE D. INIT DATABASE

What is the primary purpose of redo log files in Oracle Database?

A. Store user data B. Improve query performance C. Recover committed transactions D. Manage temporary segments

Which tablespace is created by default during Oracle database installation?

A. USERS B. TEMP C. SYSTEM D. UNDO

Which privilege allows a user to create tables in their own schema?

A. CREATE ANY TABLE B. CREATE TABLE C. ALTER TABLE D. INSERT ANY TABLE

Which view provides information about database data files?

A. DBA_USERS B. DBA_TABLES C. DBA_DATA_FILES D. V$INSTANCE