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. What does process J000 do?
Background processes - Server Processes - User Processes are part of what?
Allows a user to grant an object privilege to another user.
The first extent is created when?
This process runs the job given to it by the CJQ0 process

2. What is audited by default in Oracle 11g?
This file should be named spfile<dbname>.ora
These use which pool? Oracle Recovery Manager - Oracle Shared Server - Parallel processing - I/O-related server processes.
...
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.

3. What can you configure in the parameter files?
Memory Size - Database and Instance Name - Archiving parameters - Processes - Over 1900 other parameters
You must have at least 2 of the log file groups.
If you have a full backup and copies of these you can recover from almost any type of failure.
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.

4. What is the minimum number of redo log groups you must have?
You must have at least 2 of the log file groups.
This relieves the shared pool of sometimes-transient memory requirements.
What logical structure do data files correspond to?
Views - Procedures - Synonyms - Sequences

5. What are the 3 processes that are part of an instance?
You cannot restore a database with a complete collection of these from your last full backup.
This controls how a user can access actual data in the database. Primarily applies to rows in a table or a view.
Create role <role>; grant <privilege> on <table> to <role>; grant <role> to <user>;
Background processes - Server Processes - User Processes are part of what?

6. What does process DBWn do?
This process runs the job given to it by the CJQ0 process
Data requested by user is found in the database buffer cache. No need to read from disk.
This process takes dirty blocks from dirty list and writes them to disk.
This tablespace stores the rollback or undo segments used for transaction recovery

7. What is the Program Global Area -- PGA?
This tablespace is used for temporary storage.
This is the logical structure that makes up segments.
This controls what a user can do in the database. Primarily applies to adding or changing structures in the database.
This contains information used for private or session-related information that individual users need

8. What is the SQL to grant an object privilege?
This process can be dedicated or shared
V$MEMORY_TARGET_ADVICE
Grant SELECT on <table> to <user>;
The tablespace is what level of logical organization?

9. How often should you switch log files
This controls how a user can access actual data in the database. Primarily applies to rows in a table or a view.
These files store information from the log buffer.
This is the concept that adding and removing privileges from a role immediately affect all users who have the role.
You should switch these every 15-30 minutes

10. Which SGA Structures are required
Data Files - Control Files - Redo Log Files - Archive Log Files - Server and initialization parameter files
This is the concept that adding and removing privileges from a role immediately affect all users who have the role.
This tablespace is used for temporary storage.
Database Buffer Cache - Log Buffer - Shared Pool

11. What kind of server process does a DBA connection get?
Tables - Indexes - Materialized Views - Partitions
This logical structure is the minimum unit that Oracle will read or write at any given time.
This tablespace stores the core database objects that are used for running the database itself
These connections always get a dedicated server process.

12. What does a database role do?
This physical structure is the formatted size of the minimum unit of storage on the device
Allows you to group privileges for ease of management
When are connections with SYSDBA privilege audited?
Memory Size - Database and Instance Name - Archiving parameters - Processes - Over 1900 other parameters

13. What is a dirty buffer?
Large Pool - Java Pool - Streams Pool
Block in the database buffer cache does not match what is on disk.
ORACLE's work area for executing SQL
Database Buffer Cache - Log Buffer - Shared Pool

14. What SQL allows you to create role and grant privileges to a user
Create role <role>; grant <privilege> on <table> to <role>; grant <role> to <user>;
This process does anything the user requests of it. It is responsible for reading blocks into the buffer cache. It changes the blocks if requested. It can create objects.
Show parameter audit_file_dest;
SYSTEM - SYSAUX - UNDO - TEMP

15. What is a change vector?
With this server process each user process gets its own server process. Server process waits on you. Most responsive.
This is a modification applied to something; executing DML generates these applied to data.
This contains information used for private or session-related information that individual users need
This logical structure is the minimum unit that Oracle will read or write at any given time.

16. How do you assign a password profile to a user
Data requested by user is found in the database buffer cache. No need to read from disk.
Alter user HR profile report_writer;
This process resolves deadlock situations
Background process that write database buffer cache to disk

17. What is Advanced Security Option
Views - Procedures - Synonyms - Sequences
This is a library of ready to go SQL Statements.
This lets you encrypt data in your database files
What logical structure do data files correspond to?

18. What is a buffer cache hit?
Recognizes a user as logged into the OS and waives the password requirement.
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.
If you have a full backup and copies of these you can recover from almost any type of failure.

19. Is Auditing turned on by default?
This pool does not use LRU and will fill up.
This is a library of ready to go SQL Statements.
SELECT - INSERT - UPDATE - DELETE - REFERENCES - INDEX - ALTER - EXECUTE
AUDIT_TRAIL is set to DB

20. What does process CKPT do?
Recognizes a user as logged into the OS and waives the password requirement.
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.
CREATE PROFILE xxxxx LIMIT FAILED_LOGIN_ATTEMPTS 3;
This process flushes the redo log buffer. Writes redo entries to disk and signals a completion.

21. What is the large pool?
Block in the database buffer cache does not match what is on disk.
This relieves the shared pool of sometimes-transient memory requirements.
Recognizes a user as logged into the OS and waives the password requirement.
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.

22. What is stored in the block header
Alter user HR profile report_writer;
Database shutdown - full or partial checkpoint - recovery time threshold - free block is needed - some DDL commands - every three seconds
This contains the information used for backup and recovery - free space - file status details.
This parameter is used to automatically size and manage the SGA - PGA - and all memory used by them.

23. What is a database block?
This is a logical structure that represents objects in the database that require physical storage
This tablespace stores the rollback or undo segments used for transaction recovery
This contains information used for private or session-related information that individual users need
This is the minimum amount of storage that Oracle reads or writes.

24. What happens during a log switch operation? What causes the following: LGWR finishes writing to the current group
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.
DB Block -- minimum size read into database buffer cache - OS Block - physical block determined when you format hard drive.
This process runs the job given to it by the CJQ0 process
LGWR starts writing to the next group - A Database checkpoint occurs - The DBWR writes dirty blocks our of the buffer cascade

25. What is an instance?
Commit - every three seconds - redo log buffer is 1/3 full - just before dirty block is written to disk.
This process resolves deadlock situations
When are connections with SYSDBA privilege audited?
This is a combination of memory and processes that are part of a running installation

26. What are the names of the parameter files?
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.
What is OPS$
These are the PFILE and the SPFILE
Commit - every three seconds - redo log buffer is 1/3 full - just before dirty block is written to disk.

27. What physical structure does a tablespace correspond to?
Data requested by user is found in the database buffer cache. No need to read from disk.
This process resolves deadlock situations
AUDIT_TRAIL is set to DB
What logical structure do data files correspond to?

28. Where are the PFILE and SPFILE stored?
These are the PFILE and the SPFILE
Grant create session to <user>;
The parameter file is read at what point during database startup?
These files are stored in ORACLE_HOME: $ORACLE_HOME/dbs - %ORACLE_HOMEdatabase

29. What happens if you are missing an archive log?
SELECT - INSERT - UPDATE - DELETE - REFERENCES - INDEX - ALTER - EXECUTE
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 physical structure is the formatted size of the minimum unit of storage on the device
You cannot restore a database with a complete collection of these from your last full backup.

30. What tablespaces should every database have?
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.
SYSTEM - SYSAUX - UNDO - TEMP
This process resolves deadlock situations
This is a logical structure that represents objects in the database that require physical storage

31. What does parameter MEMORY_TARGET not control?
This records every SQL statement that changes data. The redo entry is in the redo log buffer before written to redo log.
Memory used by sessions connecting to the database are not controlled by this parameter.
This process flushes the redo log buffer. Writes redo entries to disk and signals a completion.
With this server process each user process gets its own server process. Server process waits on you. Most responsive.

32. What does process SMON do
This process is primarily responsible for instance recovery. Applies redo information. Cleans and releases temporary space
Data requested by user is found in the database buffer cache. No need to read from disk.
The tablespace is what level of logical organization?
Allows you to group privileges for ease of management

33. What view lets you look at audits of system privileges
This is the first part of a data file.
DBA_STMT_AUDIT_OPTS is a view that does what?
This pool does not use LRU and will fill up.
This is the concept that adding and removing privileges from a role immediately affect all users who have the role.

34. How does a dedicated server process work?
With this server process each user process gets its own server process. Server process waits on you. Most responsive.
This pool does not use LRU and will fill up.
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.
This can only mount to one database

35. What is the library cache?
This logical structure organizes one or more data files.
This is a library of ready to go SQL Statements.
This is the first part of a data file.
This is written in PL/SQL and examines passwords when they're chosen and accepts or rejects them based on criteria.

36. What does process CJQ0 do?
Background processes - Server Processes - User Processes are part of what?
These all start with 'ora_'
This process runs the job given to it by the CJQ0 process
This process checks for scheduled tasks within the database.

37. What information is NOT stored in redo logs
This is a library of ready to go SQL Statements.
Memory used by sessions connecting to the database are not controlled by this parameter.
SELECT statement information are not stored in these files?
This process does anything the user requests of it. It is responsible for reading blocks into the buffer cache. It changes the blocks if requested. It can create objects.

38. What is dynamic privilege management?
This is the concept that adding and removing privileges from a role immediately affect all users who have the role.
The parameter file is read at what point during database startup?
This processs provides a time reference within the database.
These files contain information about how your running database is configured.

39. What are the 8 object priviliges?
Create user OPS$REPORTS identified externally;
SELECT - INSERT - UPDATE - DELETE - REFERENCES - INDEX - ALTER - EXECUTE
These all start with 'ora_'
Revoke create session from <user>;

40. What are Archive log files?
Large Pool - Java Pool - Streams Pool
These are copies of redo log files
Grant SELECT on <table> to <user>;
This pool does not use LRU and will fill up.

41. What views contain information about your DB Files?
This process copies filled redo logs to the archived redo storage area. If you aren't in archive mode - this process shuts down.
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.
V$TEMPFILE and V$DATAFILE contain this information?
You should switch these every 15-30 minutes

42. What prefix must precede the OS username for an OS-Authenticated user?
The parameter file is read at what point during database startup?
What is OPS$
This contains information used for private or session-related information that individual users need
You should switch these every 15-30 minutes

43. What is stored in the library cache
This is written in PL/SQL and examines passwords when they're chosen and accepts or rejects them based on criteria.
This is the concept that adding and removing privileges from a role immediately affect all users who have the role.
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.
Parsed SQL - syntax - objects are checked - Oracle permissions - p-code - optimum path or plan.

44. What is the Database Buffer Cache

Warning: Invalid argument supplied for foreach() in /var/www/html/basicversity.com/show_quiz.php on line 183

45. What are the PFILE and SPFILE?
Block in the database buffer cache does not match what is on disk.
Grant SELECT on <table> to <user>;
These files contain information about how your running database is configured.
ORACLE's work area for executing SQL

46. What is the Log Buffer
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.
...
This is a small - short-term staging area for change vectors before they are written to redo logs on disk.

47. Which view helps you size memory properly
V$MEMORY_TARGET_ADVICE
Commit - every three seconds - redo log buffer is 1/3 full - just before dirty block is written to disk.
These are copies of redo log files
This tablespace is used for temporary storage.

48. What does process DIA0 do?
Create role <role>; grant <privilege> on <table> to <role>; grant <role> to <user>;
This process is primarily responsible for instance recovery. Applies redo information. Cleans and releases temporary space
This process resolves deadlock situations
Grant create session to <user> with admin option;

49. What does the Program Global Area (PGA) contain?
These are contained where? Session Memory - login information - session specific information - Private SQL area - Variables that get values during SQL Execution - Work areas for SQL Sort - Hash - bitmap - Cursors
...
Revoke create session from <user>;
You cannot restore a database with a complete collection of these from your last full backup.

50. What is the Redo Log Buffer
This records every SQL statement that changes data. The redo entry is in the redo log buffer before written to redo log.
These are usually configured 3 groups with 2 mirrored members in each.
Grant SELECT on <table> to <user>;
Database Buffer Cache - Log Buffer - Shared Pool