Test your basic knowledge |

Oracle 11g

Instructions:

Answer 50 questions in 15 minutes.
If you are not ready to take this test, you can study here.
Match each statement with the correct term.
Don't refresh. All questions and answers are randomly picked and ordered every time you load a test.

This is a study tool. The 3 wrong answers for each question are randomly chosen from answers to other questions. So, you might find at times the answers obvious, but you will see it re-enforces your understanding as you take the test each time.

1. Which process writes to the Redo Log Files?
The logwriter (LGWR) writes to these files.
Each concurrent database request gets a server process.
Create user OPS$REPORTS identified externally;
Limit number of times a password can be reused - limit amount of time before a password can be reused - limit failed login attempts - password lock time - passwords a life time - password grace time - check password complexity.

2. Where does auditing data go by default
What goes into the table SYS.AUD$
This tablespace stored objects that are auxiliary and not specifically tied to the core features of the database
This processs provides a time reference within the database.
AUDIT_TRAIL is set to DB

3. List the kinds of files used to run an Oracle Instance?
Memory used by sessions connecting to the database are not controlled by this parameter.
AUDIT - NOAUDIT
These all start with 'ora_'
Data Files - Control Files - Redo Log Files - Archive Log Files - Server and initialization parameter files

4. Where are the PFILE and SPFILE stored?
This physical structure is the formatted size of the minimum unit of storage on the device
This process initiates check points -- dumps all dirty buffers to disk. Also updates the data file headers and the control files with the checkpoint information so SMON knows where to start recovery if system crashes.
These files are stored in ORACLE_HOME: $ORACLE_HOME/dbs - %ORACLE_HOMEdatabase
This is the concept that adding and removing privileges from a role immediately affect all users who have the role.

5. What options does a password profile allow you to have?
Limit number of times a password can be reused - limit amount of time before a password can be reused - limit failed login attempts - password lock time - passwords a life time - password grace time - check password complexity.
Data requested by user is found in the database buffer cache. No need to read from disk.
Oracle background processes and server processes share this.
This is a logical structure that represents objects in the database that require physical storage

6. What actions are always audited
This can only mount to one database
Data Files - Control Files - Redo Log Files - Archive Log Files - Server and initialization parameter files
Database Buffer Cache - Log Buffer - Shared Pool
When are connections with SYSDBA privilege audited?

7. What does process PMON do?
What logical structure do data files correspond to?
This cleans up failed processes by releasing resources and rolling back uncomitted data.
This controls how a user can access actual data in the database. Primarily applies to rows in a table or a view.
This is a special type of database file holding only information for sorts or temporary tables.

8. What are Archive log files?
This contains the information used for backup and recovery - free space - file status details.
AUDIT_TRAIL is set to DB
These are copies of redo log files
You should switch these every 15-30 minutes

9. What is a password profile
Data Files - Control Files - Redo Log Files - Archive Log Files - Server and initialization parameter files
This pool does not use LRU and will fill up.
This forces a user to follow guidelines when creating or changing passwords.
Memory used by sessions connecting to the database are not controlled by this parameter.

10. What does process DBWn do?
This process takes dirty blocks from dirty list and writes them to disk.
Parsed SQL - syntax - objects are checked - Oracle permissions - p-code - optimum path or plan.
These connections always get a dedicated server process.
Database shutdown - full or partial checkpoint - recovery time threshold - free block is needed - some DDL commands - every three seconds

11. What is the TEMP tablespace used for?
These files store information from the log buffer.
Show parameter audit_file_dest;
This tablespace is used for temporary storage.
DB Block -- minimum size read into database buffer cache - OS Block - physical block determined when you format hard drive.

12. What is an Oracle Block?
This logical structure is the minimum unit that Oracle will read or write at any given time.
This relieves the shared pool of sometimes-transient memory requirements.
DBA_OBJ_AUDIT_OPTS is a view that does what?
This contains information used for private or session-related information that individual users need

13. What is Operating System Authentication?
Recognizes a user as logged into the OS and waives the password requirement.
DB Block -- minimum size read into database buffer cache - OS Block - physical block determined when you format hard drive.
Database shutdown - full or partial checkpoint - recovery time threshold - free block is needed - some DDL commands - every three seconds
Show parameter audit_file_dest;

14. What is a change vector?
This lets you encrypt data in your database files
This tablespace stores the rollback or undo segments used for transaction recovery
This controls how a user can access actual data in the database. Primarily applies to rows in a table or a view.
This is a modification applied to something; executing DML generates these applied to data.

15. What is the SQL to grant an object privilege?
Grant create session to <user> with admin option;
LGWR starts writing to the next group - A Database checkpoint occurs - The DBWR writes dirty blocks our of the buffer cascade
This is a combination of memory and processes that are part of a running installation
Grant SELECT on <table> to <user>;

16. What prefix must precede the OS username for an OS-Authenticated user?
What is OPS$
Database Buffer Cache - Log Buffer - Shared Pool
This is a combination of memory and processes that are part of a running installation
Each concurrent database request gets a server process.

17. What does process VKTM do?
Grant SELECT on <table> to <user> WITH GRANT OPTION;
What is OPS$
Parsed SQL - syntax - objects are checked - Oracle permissions - p-code - optimum path or plan.
This processs provides a time reference within the database.

18. What does a database role do?
Allows you to group privileges for ease of management
This is the first part of a data file.
Each concurrent database request gets a server process.
This logical structure organizes one or more data files.

19. What is a database
Background processes - Server Processes - User Processes are part of what?
Alter user HR profile report_writer;
This is a small - short-term staging area for change vectors before they are written to redo logs on disk.
This is the physical component or the files

20. What SQL gives a user the ability to grant object privileges to another user?
This grants users access to the database.
Allows a user to grant an object privilege to another user.
This is the concept that adding and removing privileges from a role immediately affect all users who have the role.
Grant SELECT on <table> to <user> WITH GRANT OPTION;

21. What are the names of the parameter files?
These are the PFILE and the SPFILE
Alter user HR profile report_writer;
SELECT statement information are not stored in these files?
This pool does not use LRU and will fill up.

22. What is a segment
Database Buffer Cache - Log Buffer - Shared Pool
This is a logical structure that represents objects in the database that require physical storage
When are connections with SYSDBA privilege audited?
This process checks for scheduled tasks within the database.

23. What is the minimum number of redo log groups you must have?
You must have at least 2 of the log file groups.
What is OPS$
This process resolves deadlock situations
These files contain information about how your running database is configured.

24. What is stored in the library cache
This cache is allocated at instance startup
Parsed SQL - syntax - objects are checked - Oracle permissions - p-code - optimum path or plan.
This process flushes the redo log buffer. Writes redo entries to disk and signals a completion.
DBA_PRIV_AUDIT_OPTS is a view that does what?

25. What characters do all background processes start with?

26. What is stored in the block header
This contains the information used for backup and recovery - free space - file status details.
This controls how a user can access actual data in the database. Primarily applies to rows in a table or a view.
This stores the results of a computation.
This grants users access to the database.

27. What do archive log and redo logs allow you to do?
If you have a full backup and copies of these you can recover from almost any type of failure.
Limit number of times a password can be reused - limit amount of time before a password can be reused - limit failed login attempts - password lock time - passwords a life time - password grace time - check password complexity.
Background processes - Server Processes - User Processes are part of what?
This process can be dedicated or shared

28. What kinds of server processes are there?
This tablespace is used for temporary storage.
This is the first part of a data file.
This process can be dedicated or shared
This is the minimum amount of storage that Oracle reads or writes.

29. What SQL allows you to create role and grant privileges to a user
SELECT - INSERT - UPDATE - DELETE - REFERENCES - INDEX - ALTER - EXECUTE
This is a small - short-term staging area for change vectors before they are written to redo logs on disk.
Grant SELECT on <table> to <user> WITH GRANT OPTION;
Create role <role>; grant <privilege> on <table> to <role>; grant <role> to <user>;

30. What does parameter MEMORY_TARGET not control?
Recognizes a user as logged into the OS and waives the password requirement.
Memory used by sessions connecting to the database are not controlled by this parameter.
DBA_PRIV_AUDIT_OPTS is a view that does what?
This contains the information used for backup and recovery - free space - file status details.

31. What happens during a log switch operation? What causes the following: LGWR finishes writing to the current group
LGWR starts writing to the next group - A Database checkpoint occurs - The DBWR writes dirty blocks our of the buffer cascade
Create user OPS$REPORTS identified externally;
This processs provides a time reference within the database.
V$TEMPFILE and V$DATAFILE contain this information?

32. What options do you have for auditing?
This tablespace stores the core database objects that are used for running the database itself
This process resolves deadlock situations
AUDIT_TRAIL is set to DB
Users - Objects - System Privileges - Combination are things you can?

33. What is Advanced Security Option
This lets you encrypt data in your database files
Create role <role>; grant <privilege> on <table> to <role>; grant <role> to <user>;
Data blocks copied into database buffer cache - changes applied to the copy in the DBBC - Blocks remain in cache until buffer is needed for something else.
DBA_PRIV_AUDIT_OPTS is a view that does what?

34. What does process CKPT do?
This is a library of ready to go SQL Statements.
The tablespace is what level of logical organization?
This process initiates check points -- dumps all dirty buffers to disk. Also updates the data file headers and the control files with the checkpoint information so SMON knows where to start recovery if system crashes.
This processs provides a time reference within the database.

35. What is a tempfile?
This process resolves deadlock situations
This is a special type of database file holding only information for sorts or temporary tables.
You cannot restore a database with a complete collection of these from your last full backup.
This logical structure is the minimum unit that Oracle will read or write at any given time.

36. What SQL lets you see where SYSDBA connections audits are stored?
Show parameter audit_file_dest;
SELECT - INSERT - UPDATE - DELETE - REFERENCES - INDEX - ALTER - EXECUTE
Create role <role>; grant <privilege> on <table> to <role>; grant <role> to <user>;
You cannot restore a database with a complete collection of these from your last full backup.

37. What is the Database Buffer Cache

38. What is a database block?
Limit number of times a password can be reused - limit amount of time before a password can be reused - limit failed login attempts - password lock time - passwords a life time - password grace time - check password complexity.
This is the minimum amount of storage that Oracle reads or writes.
This records every SQL statement that changes data. The redo entry is in the redo log buffer before written to redo log.
This process resolves deadlock situations

39. What can you configure in the parameter files?
This logical structure organizes one or more data files.
These connections always get a dedicated server process.
This is a small - short-term staging area for change vectors before they are written to redo logs on disk.
Memory Size - Database and Instance Name - Archiving parameters - Processes - Over 1900 other parameters

40. What is the highest privileged role?
This file should be named spfile<dbname>.ora
Data Files - Control Files - Redo Log Files - Archive Log Files - Server and initialization parameter files
Background processes - Server Processes - User Processes are part of what?
SYSDBA is this kind of role.

41. What SQL Would let you audit people creating tables?
Audit create table;
This is the first part of a data file.
DB Block -- minimum size read into database buffer cache - OS Block - physical block determined when you format hard drive.
Background process that write database buffer cache to disk

42. What does the CREATE SESSION privilege do?
Audit create table;
This file should be named init<dbname>.ora
This grants users access to the database.
Oracle background processes and server processes share this.

43. Which SGA Structures are required
Database Buffer Cache - Log Buffer - Shared Pool
Block in the database buffer cache does not match what is on disk.
You cannot restore a database with a complete collection of these from your last full backup.
Whenever successful - whenever not successful - by access - by session

44. What SQL allows a user access to the database?
Grant create session to <user>;
This lets you encrypt data in your database files
This is a combination of memory and processes that are part of a running installation
When are connections with SYSDBA privilege audited?

45. How many databases can an instance mount to?
This tablespace stores the rollback or undo segments used for transaction recovery
This can only mount to one database
This is a library of ready to go SQL Statements.
DBA_STMT_AUDIT_OPTS is a view that does what?

46. What is the dictionary cache?

47. What is the large pool?
This relieves the shared pool of sometimes-transient memory requirements.
What is OPS$
Database Buffer Cache - Log Buffer - Shared Pool
Recognizes a user as logged into the OS and waives the password requirement.

48. how do you turn on or off auditing?
This tablespace stored objects that are auxiliary and not specifically tied to the core features of the database
Names and locations of data files and redo log files - Recovery and backup information - Checkpoint - Archive information - Database name - Log history and current logging information.
AUDIT - NOAUDIT
What logical structure do data files correspond to?

49. What is the Redo Log Buffer
V$TEMPFILE and V$DATAFILE contain this information?
Row level security is this kind of database.
This records every SQL statement that changes data. The redo entry is in the redo log buffer before written to redo log.
Grant SELECT on <table> to <user>;

50. What is Virtual Private Database?
Commit - every three seconds - redo log buffer is 1/3 full - just before dirty block is written to disk.
Row level security is this kind of database.
If you have a full backup and copies of these you can recover from almost any type of failure.
Background process that write database buffer cache to disk