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 view lets you look at audits of system privileges
This stores the results of a computation.
This tablespace stores the core database objects that are used for running the database itself
DBA_STMT_AUDIT_OPTS is a view that does what?
This relieves the shared pool of sometimes-transient memory requirements.

2. What are the 3 buffer cache states?
Data blocks copied into database buffer cache - relevant rows copied into user session PGA - blocks stay in cache until buffer needed for something else.
Free - Pinned - Dirty are what?
This is a logical structure that represents objects in the database that require physical storage
This is written in PL/SQL and examines passwords when they're chosen and accepts or rejects them based on criteria.

3. What does parameter MEMORY_TARGET not control?
Memory used by sessions connecting to the database are not controlled by this parameter.
DBA_OBJ_AUDIT_OPTS is a view that does what?
When are connections with SYSDBA privilege audited?
Recognizes a user as logged into the OS and waives the password requirement.

4. When is database buffer cache allocated?
You must have at least 2 of the log file groups.
With this server process each user process gets its own server process. Server process waits on you. Most responsive.
This is a library of ready to go SQL Statements.
This cache is allocated at instance startup

5. What is the highest privileged role?
These use which pool? Oracle Recovery Manager - Oracle Shared Server - Parallel processing - I/O-related server processes.
Large Pool - Java Pool - Streams Pool
SYSDBA is this kind of role.
This file should be named spfile<dbname>.ora

6. What view lets you look at audits of privileges
Audit create table;
This grants users access to the database.
V$MEMORY_TARGET_ADVICE
DBA_PRIV_AUDIT_OPTS is a view that does what?

7. What kind of server process does a DBA connection get?
Create role <role>; grant <privilege> on <table> to <role>; grant <role> to <user>;
DBA_OBJ_AUDIT_OPTS is a view that does what?
These connections always get a dedicated server process.
This is the concept that adding and removing privileges from a role immediately affect all users who have the role.

8. What is a password verify function

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

9. How does updating use Database Buffer Cache
SELECT - INSERT - UPDATE - DELETE - REFERENCES - INDEX - ALTER - EXECUTE
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 Buffer Cache - Log Buffer - Shared Pool
This relieves the shared pool of sometimes-transient memory requirements.

10. 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
This is the first part of a data file.
These are the PFILE and the SPFILE
The first extent is created when?

11. Which SGA Structures are required
DB Block -- minimum size read into database buffer cache - OS Block - physical block determined when you format hard drive.
Show parameter audit_file_dest;
Audit create table;
Database Buffer Cache - Log Buffer - Shared Pool

12. What does process SMON do
Allows you to group privileges for ease of management
Views - Procedures - Synonyms - Sequences
Free - Pinned - Dirty are what?
This process is primarily responsible for instance recovery. Applies redo information. Cleans and releases temporary space

13. What SQL allows a user access to the database?
Grant create session to <user>;
This controls what a user can do in the database. Primarily applies to adding or changing structures in the database.
This is the first part of a data file.
V$MEMORY_TARGET_ADVICE

14. What views contain information about your DB Files?
This records every SQL statement that changes data. The redo entry is in the redo log buffer before written to redo log.
Data blocks copied into database buffer cache - relevant rows copied into user session PGA - blocks stay in cache until buffer needed for something else.
V$TEMPFILE and V$DATAFILE contain this information?
This contains the information used for backup and recovery - free space - file status details.

15. This logical structure gets created when you first create an object such as a table?
Create user OPS$REPORTS identified externally;
These use which pool? Oracle Recovery Manager - Oracle Shared Server - Parallel processing - I/O-related server processes.
The first extent is created when?
Commit - every three seconds - redo log buffer is 1/3 full - just before dirty block is written to disk.

16. What is an Oracle Block?
This pool does not use LRU and will fill up.
This processs provides a time reference within the database.
This is the physical component or the files
This logical structure is the minimum unit that Oracle will read or write at any given time.

17. Where does auditing data go by default
This is a collection of information about you and the database's objects.
These files contain information about how your running database is configured.
This records every SQL statement that changes data. The redo entry is in the redo log buffer before written to redo log.
What goes into the table SYS.AUD$

18. What is the dictionary cache?

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

19. What does process PMON do?
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>;
This cleans up failed processes by releasing resources and rolling back uncomitted data.
Grant SELECT on <table> to <user> WITH GRANT OPTION;

20. What view lets you look at audits of objects?
Commit - every three seconds - redo log buffer is 1/3 full - just before dirty block is written to disk.
DBA_OBJ_AUDIT_OPTS is a view that does what?
This tablespace stores the rollback or undo segments used for transaction recovery
This grants users access to the database.

21. The SGA is shared by what processes?
You must have at least 2 of the log file groups.
This logical structure organizes one or more data files.
This contains the information used for backup and recovery - free space - file status details.
Oracle background processes and server processes share this.

22. What is a database block?
These are copies of redo log files
This is the minimum amount of storage that Oracle reads or writes.
This controls how a user can access actual data in the database. Primarily applies to rows in a table or a view.
This parameter is used to automatically size and manage the SGA - PGA - and all memory used by them.

23. When does the large pool get cleaned out?
This contains information used for private or session-related information that individual users need
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 pool does not use LRU and will fill up.
SYSDBA is this kind of role.

24. 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.
This is the first part of a data file.
Recognizes a user as logged into the OS and waives the password requirement.
This controls how a user can access actual data in the database. Primarily applies to rows in a table or a view.

25. What are redo log files?
V$MEMORY_TARGET_ADVICE
Allows you to group privileges for ease of management
Data Files - Control Files - Redo Log Files - Archive Log Files - Server and initialization parameter files
These files store information from the log buffer.

26. What is an instance?
Tables - Indexes - Materialized Views - Partitions
This relieves the shared pool of sometimes-transient memory requirements.
This is a combination of memory and processes that are part of a running installation
Views - Procedures - Synonyms - Sequences

27. What is the SQL for creating a password profile
CREATE PROFILE xxxxx LIMIT FAILED_LOGIN_ATTEMPTS 3;
This stores the results of a computation.
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.
You must have at least 2 of the log file groups.

28. What characters do all background processes start with?

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

29. What happens if you are missing an archive log?
Grant SELECT on <table> to <user>;
These connections always get a dedicated server process.
AUDIT - NOAUDIT
You cannot restore a database with a complete collection of these from your last full backup.

30. How does select use Database Buffer Cache
This is written in PL/SQL and examines passwords when they're chosen and accepts or rejects them based on criteria.
Oracle background processes and server processes share this.
This tablespace is used for temporary storage.
Data blocks copied into database buffer cache - relevant rows copied into user session PGA - blocks stay in cache until buffer needed for something else.

31. What SQL gives a user the ability to grant object privileges to another user?
Grant SELECT on <table> to <user> WITH GRANT OPTION;
...
This logical structure organizes one or more data files.
This file should be named init<dbname>.ora

32. What are the names of the parameter files?
Oracle background processes and server processes share this.
V$MEMORY_TARGET_ADVICE
These are the PFILE and the SPFILE
Each concurrent database request gets a server process.

33. What is the first level of logical organization of your physical storage?
The tablespace is what level of logical organization?
Data requested by user is found in the database buffer cache. No need to read from disk.
This is a small - short-term staging area for change vectors before they are written to redo logs on disk.
Memory used by sessions connecting to the database are not controlled by this parameter.

34. What is an OS Block?
This process can be dedicated or shared
This physical structure is the formatted size of the minimum unit of storage on the device
This file should be named spfile<dbname>.ora
Large Pool - Java Pool - Streams Pool

35. What is stored in the library cache
...
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.
Parsed SQL - syntax - objects are checked - Oracle permissions - p-code - optimum path or plan.
SELECT statement information are not stored in these files?

36. What is the minimum number of redo log groups you must have?
AUDIT - NOAUDIT
You must have at least 2 of the log file groups.
Commit - every three seconds - redo log buffer is 1/3 full - just before dirty block is written to disk.
SYSDBA is this kind of role.

37. What is the first file read when a database starts?
The parameter file is read at what point during database startup?
These files contain information about how your running database is configured.
These are the PFILE and the SPFILE
Memory Size - Database and Instance Name - Archiving parameters - Processes - Over 1900 other parameters

38. What does a database role do?
These are copies of redo log files
SELECT - INSERT - UPDATE - DELETE - REFERENCES - INDEX - ALTER - EXECUTE
These are usually configured 3 groups with 2 mirrored members in each.
Allows you to group privileges for ease of management

39. What does process CJQ0 do?
This process copies filled redo logs to the archived redo storage area. If you aren't in archive mode - this process shuts down.
These files contain information about how your running database is configured.
This process checks for scheduled tasks within the database.
This process flushes the redo log buffer. Writes redo entries to disk and signals a completion.

40. What is stored in the block header
Memory used by sessions connecting to the database are not controlled by this parameter.
Oracle background processes and server processes share this.
ORACLE's work area for executing SQL
This contains the information used for backup and recovery - free space - file status details.

41. What is a database
These files store information from the log buffer.
This is the physical component or the files
Data requested by user is found in the database buffer cache. No need to read from disk.
Audit create table;

42. What information is NOT stored in redo logs
This is the concept that adding and removing privileges from a role immediately affect all users who have the role.
This logical structure is the minimum unit that Oracle will read or write at any given time.
V$MEMORY_TARGET_ADVICE
SELECT statement information are not stored in these files?

43. What do control files contain?
Free - Pinned - Dirty are what?
DB Block -- minimum size read into database buffer cache - OS Block - physical block determined when you format hard drive.
Tables - Indexes - Materialized Views - Partitions
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.

44. What does process DIA0 do?
This forces a user to follow guidelines when creating or changing passwords.
This process can be dedicated or shared
This process resolves deadlock situations
This is a collection of information about you and the database's objects.

45. What naming convention should you use for your PFILE
This file should be named init<dbname>.ora
The first extent is created when?
What is OPS$
This is the logical structure that makes up segments.

46. 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.
What is OPS$
What goes into the table SYS.AUD$
Database shutdown - full or partial checkpoint - recovery time threshold - free block is needed - some DDL commands - every three seconds

47. What is the library cache?
This is a library of ready to go SQL Statements.
AUDIT_TRAIL is set to DB
This tablespace stores the rollback or undo segments used for transaction recovery
This lets you encrypt data in your database files

48. What is the Database Buffer Cache

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

49. What tablespaces should every database have?
This is a special type of database file holding only information for sorts or temporary tables.
Whenever successful - whenever not successful - by access - by session
SYSTEM - SYSAUX - UNDO - TEMP
Data blocks copied into database buffer cache - relevant rows copied into user session PGA - blocks stay in cache until buffer needed for something else.

50. What is a tempfile?
Grant SELECT on <table> to <user>;
This is a special type of database file holding only information for sorts or temporary tables.
Oracle background processes and server processes share this.
Memory Size - Database and Instance Name - Archiving parameters - Processes - Over 1900 other parameters