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 is the UNDO tablespace used for?
Recognizes a user as logged into the OS and waives the password requirement.
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.
This process runs the job given to it by the CJQ0 process
This tablespace stores the rollback or undo segments used for transaction recovery

2. What does parameter MEMORY_TARGET do?
This parameter is used to automatically size and manage the SGA - PGA - and all memory used by them.
Allows you to group privileges for ease of management
This is a collection of information about you and the database's objects.
This contains information used for private or session-related information that individual users need

3. When is the redo log buffer flushed?
These files contain information about how your running database is configured.
Commit - every three seconds - redo log buffer is 1/3 full - just before dirty block is written to disk.
These use which pool? Oracle Recovery Manager - Oracle Shared Server - Parallel processing - I/O-related server processes.
AUDIT - NOAUDIT

4. What SQL gives a user the ability to grant object privileges to another user?
This contains the information used for backup and recovery - free space - file status details.
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.
Grant SELECT on <table> to <user> WITH GRANT OPTION;
This process copies filled redo logs to the archived redo storage area. If you aren't in archive mode - this process shuts down.

5. What view lets you look at audits of objects?
Users - Objects - System Privileges - Combination are things you can?
LGWR starts writing to the next group - A Database checkpoint occurs - The DBWR writes dirty blocks our of the buffer cascade
This tablespace stored objects that are auxiliary and not specifically tied to the core features of the database
DBA_OBJ_AUDIT_OPTS is a view that does what?

6. How does updating use Database Buffer Cache
This logical structure organizes one or more data files.
DBA_OBJ_AUDIT_OPTS is a view that does what?
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.
Database shutdown - full or partial checkpoint - recovery time threshold - free block is needed - some DDL commands - every three seconds

7. What does the server process do?
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.
Data requested by user is found in the database buffer cache. No need to read from disk.
Alter user HR profile report_writer;
The first extent is created when?

8. What is a system privilege?
This is the logical structure that makes up segments.
This process can be dedicated or shared
This controls what a user can do in the database. Primarily applies to adding or changing structures in the database.
This file should be named spfile<dbname>.ora

9. What is stored in the library cache
Grant create session to <user> with admin option;
Parsed SQL - syntax - objects are checked - Oracle permissions - p-code - optimum path or plan.
Create user OPS$REPORTS identified externally;
Free - Pinned - Dirty are what?

10. What is dynamic privilege management?
Whenever successful - whenever not successful - by access - by session
Background processes - Server Processes - User Processes are part of what?
This is the concept that adding and removing privileges from a role immediately affect all users who have the role.
This process resolves deadlock situations

11. What view lets you look at audits of system privileges
DBA_STMT_AUDIT_OPTS is a view that does what?
This process runs the job given to it by the CJQ0 process
Show parameter audit_file_dest;
SELECT statement information are not stored in these files?

12. What are the names of the parameter files?
Commit - every three seconds - redo log buffer is 1/3 full - just before dirty block is written to disk.
These are the PFILE and the SPFILE
Audit create table;
This pool does not use LRU and will fill up.

13. What is the library cache?
CREATE PROFILE xxxxx LIMIT FAILED_LOGIN_ATTEMPTS 3;
This is a library of ready to go SQL Statements.
SYSTEM - SYSAUX - UNDO - TEMP
These files store information from the log buffer.

14. What is the Redo Log Buffer
When are connections with SYSDBA privilege audited?
This records every SQL statement that changes data. The redo entry is in the redo log buffer before written to redo log.
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 first part of a data file.

15. What does process CJQ0 do?
This process checks for scheduled tasks within the database.
This records every SQL statement that changes data. The redo entry is in the redo log buffer before written to redo log.
If you have a full backup and copies of these you can recover from almost any type of failure.
The logwriter (LGWR) writes to these files.

16. How often should you switch log files
This can only mount to one database
You should switch these every 15-30 minutes
Row level security is this kind of database.
Large Pool - Java Pool - Streams Pool

17. What is the SQL to grant an object privilege?
Grant SELECT on <table> to <user>;
Oracle background processes and server processes share this.
This contains information used for private or session-related information that individual users need
This controls what a user can do in the database. Primarily applies to adding or changing structures in the database.

18. What is an OS Block?
This physical structure is the formatted size of the minimum unit of storage on the device
DBA_STMT_AUDIT_OPTS is a view that does what?
The tablespace is what level of logical organization?
Recognizes a user as logged into the OS and waives the password requirement.

19. What SQL allows you to create role and grant privileges to a user
The logwriter (LGWR) writes to these files.
Data Files - Control Files - Redo Log Files - Archive Log Files - Server and initialization parameter files
Create role <role>; grant <privilege> on <table> to <role>; grant <role> to <user>;
Memory used by sessions connecting to the database are not controlled by this parameter.

20. What are redo log files?
This is a logical structure that represents objects in the database that require physical storage
These files store information from the log buffer.
If you have a full backup and copies of these you can recover from almost any type of failure.
This parameter is used to automatically size and manage the SGA - PGA - and all memory used by them.

21. What is the first level of logical organization of your physical storage?
If you have a full backup and copies of these you can recover from almost any type of failure.
When are connections with SYSDBA privilege audited?
You must have at least 2 of the log file groups.
The tablespace is what level of logical organization?

22. What is a change vector?
Oracle background processes and server processes share this.
This is a modification applied to something; executing DML generates these applied to data.
This is a logical structure that represents objects in the database that require physical storage
Tables - Indexes - Materialized Views - Partitions

23. 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.
CREATE PROFILE xxxxx LIMIT FAILED_LOGIN_ATTEMPTS 3;
Data Files - Control Files - Redo Log Files - Archive Log Files - Server and initialization parameter files
This stores the results of a computation.

24. What does the Program Global Area (PGA) contain?
Show parameter audit_file_dest;
This cache is allocated at instance startup
With this server process each user process gets its own server process. Server process waits on you. Most responsive.
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

25. What does a database role do?
Data requested by user is found in the database buffer cache. No need to read from disk.
This process runs the job given to it by the CJQ0 process
Allows you to group privileges for ease of management
This process takes dirty blocks from dirty list and writes them to disk.

26. What is Virtual Private Database?
Background processes - Server Processes - User Processes are part of what?
Row level security is this kind of 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.
Background process that write database buffer cache to disk

27. how do you turn on or off auditing?
This is a logical structure that represents objects in the database that require physical storage
AUDIT - NOAUDIT
Row level security is this kind of database.
These connections always get a dedicated server process.

28. Is Auditing turned on by default?
These files store information from the log buffer.
AUDIT_TRAIL is set to DB
You should switch these every 15-30 minutes
This processs provides a time reference within the database.

29. What does the WITH GRANT OPTION do?
Allows a user to grant an object privilege to another user.
AUDIT - NOAUDIT
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
This cleans up failed processes by releasing resources and rolling back uncomitted data.

30. What are Archive log files?
These are copies of redo log files
The first extent is created when?
This cache is allocated at instance startup
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.

31. What naming convention should you use for your SPFILE?
This file should be named spfile<dbname>.ora
Revoke create session from <user>;
This tablespace stores the rollback or undo segments used for transaction recovery
This tablespace is used for temporary storage.

32. What is a database
The tablespace is what level of logical organization?
This is the physical component or the files
These files store information from the log buffer.
Row level security is this kind of database.

33. What is a password verify function

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

34. How should log files be configured?
This relieves the shared pool of sometimes-transient memory requirements.
Whenever successful - whenever not successful - by access - by session
The parameter file is read at what point during database startup?
These are usually configured 3 groups with 2 mirrored members in each.

35. What does process ARCn do?

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

36. How many databases can an instance mount to?
This can only mount to one database
SELECT - INSERT - UPDATE - DELETE - REFERENCES - INDEX - ALTER - EXECUTE
SELECT statement information are not stored in these files?
Create user OPS$REPORTS identified externally;

37. What actions are always audited
When are connections with SYSDBA privilege audited?
DBA_OBJ_AUDIT_OPTS is a view that does what?
The logwriter (LGWR) writes to these files.
Recognizes a user as logged into the OS and waives the password requirement.

38. What kind of objects can be in a segment
These files store information from the log buffer.
Tables - Indexes - Materialized Views - Partitions
This forces a user to follow guidelines when creating or changing passwords.
Memory Size - Database and Instance Name - Archiving parameters - Processes - Over 1900 other parameters

39. What does parameter MEMORY_TARGET not control?
Audit create table;
Memory used by sessions connecting to the database are not controlled by this parameter.
Allows you to group privileges for ease of management
This cleans up failed processes by releasing resources and rolling back uncomitted data.

40. What is the database writer process?
Background process that write database buffer cache to disk
Free - Pinned - Dirty are what?
Row level security is this kind of database.
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.

41. What are the 3 processes that are part of an instance?
Background processes - Server Processes - User Processes are part of what?
AUDIT - NOAUDIT
SYSDBA is this kind of role.
This is a small - short-term staging area for change vectors before they are written to redo logs on disk.

42. What is the block header?
Row level security is this kind of database.
Grant SELECT on <table> to <user> WITH GRANT OPTION;
This is the first part of a data file.
SELECT statement information are not stored in these files?

43. When does the large pool get cleaned out?
This parameter is used to automatically size and manage the SGA - PGA - and all memory used by them.
This is a library of ready to go SQL Statements.
This pool does not use LRU and will fill up.
This forces a user to follow guidelines when creating or changing passwords.

44. What is the TEMP tablespace used for?
Data requested by user is found in the database buffer cache. No need to read from disk.
Memory used by sessions connecting to the database are not controlled by this parameter.
This tablespace is used for temporary storage.
This process runs the job given to it by the CJQ0 process

45. What tablespaces should every database have?
You should switch these every 15-30 minutes
The first extent is created when?
SYSTEM - SYSAUX - UNDO - TEMP
This process is primarily responsible for instance recovery. Applies redo information. Cleans and releases temporary space

46. What kinds of server processes are there?
Grant create session to <user>;
This process can be dedicated or shared
Background process that write database buffer cache to disk
DBA_OBJ_AUDIT_OPTS is a view that does what?

47. What does the WITH ADMIN OPTION do?
This grants users access to the database.
What goes into the table SYS.AUD$
Allows a user to grant a system privilege to another user.
Data requested by user is found in the database buffer cache. No need to read from disk.

48. What does process LGWR do?
This is a library of ready to go SQL Statements.
V$MEMORY_TARGET_ADVICE
This process flushes the redo log buffer. Writes redo entries to disk and signals a completion.
This controls what a user can do in the database. Primarily applies to adding or changing structures in the database.

49. What SQL revokes user access to the database?
Background process that write database buffer cache to disk
This process flushes the redo log buffer. Writes redo entries to disk and signals a completion.
Revoke create session from <user>;
Create user OPS$REPORTS identified externally;

50. What happens during a log switch operation? What causes the following: LGWR finishes writing to the current group
Parsed SQL - syntax - objects are checked - Oracle permissions - p-code - optimum path or plan.
This stores the results of a computation.
This is the logical structure that makes up segments.
LGWR starts writing to the next group - A Database checkpoint occurs - The DBWR writes dirty blocks our of the buffer cascade