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. When is the redo log buffer flushed?
These all start with 'ora_'
Commit - every three seconds - redo log buffer is 1/3 full - just before dirty block is written to disk.
This tablespace stores the core database objects that are used for running the database itself
This is a small - short-term staging area for change vectors before they are written to redo logs on disk.

2. What are Archive log files?
These are copies of redo log files
Background processes - Server Processes - User Processes are part of what?
Large Pool - Java Pool - Streams Pool
This process copies filled redo logs to the archived redo storage area. If you aren't in archive mode - this process shuts down.

3. What does a database role do?
This process is primarily responsible for instance recovery. Applies redo information. Cleans and releases temporary space
Create role <role>; grant <privilege> on <table> to <role>; grant <role> to <user>;
Revoke create session from <user>;
Allows you to group privileges for ease of management

4. What is an Oracle Block?
This logical structure is the minimum unit that Oracle will read or write at any given time.
What goes into the table SYS.AUD$
Tables - Indexes - Materialized Views - Partitions
Allows a user to grant a system privilege to another user.

5. What kinds of blocks do data files have?
Each concurrent database request gets a server process.
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
DB Block -- minimum size read into database buffer cache - OS Block - physical block determined when you format hard drive.
SELECT - INSERT - UPDATE - DELETE - REFERENCES - INDEX - ALTER - EXECUTE

6. Is Auditing turned on by default?
Recognizes a user as logged into the OS and waives the password requirement.
This contains information used for private or session-related information that individual users need
Users - Objects - System Privileges - Combination are things you can?
AUDIT_TRAIL is set to DB

7. How do you assign a password profile to a user
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.
Alter user HR profile report_writer;
Create role <role>; grant <privilege> on <table> to <role>; grant <role> to <user>;
This is written in PL/SQL and examines passwords when they're chosen and accepts or rejects them based on criteria.

8. What SQL lets you see where SYSDBA connections audits are stored?
AUDIT_TRAIL is set to DB
Large Pool - Java Pool - Streams Pool
This tablespace stores the rollback or undo segments used for transaction recovery
Show parameter audit_file_dest;

9. What naming convention should you use for your PFILE
This file should be named init<dbname>.ora
Revoke create session from <user>;
This physical structure is the formatted size of the minimum unit of storage on the device
This is the physical component or the files

10. What does parameter MEMORY_TARGET not control?
If you have a full backup and copies of these you can recover from almost any type of failure.
Memory used by sessions connecting to the database are not controlled by this parameter.
This process resolves deadlock situations
These files are stored in ORACLE_HOME: $ORACLE_HOME/dbs - %ORACLE_HOMEdatabase

11. What does process SMON do
This tablespace stored objects that are auxiliary and not specifically tied to the core features of the database
This process is primarily responsible for instance recovery. Applies redo information. Cleans and releases temporary space
These are the PFILE and the SPFILE
This process copies filled redo logs to the archived redo storage area. If you aren't in archive mode - this process shuts down.

12. When is database buffer cache allocated?
This cache is allocated at instance startup
Grant create session to <user>;
SYSTEM - SYSAUX - UNDO - TEMP
This is the concept that adding and removing privileges from a role immediately affect all users who have the role.

13. What is Operating System Authentication?
Grant SELECT on <table> to <user> WITH GRANT OPTION;
This process can be dedicated or shared
This is the first part of a data file.
Recognizes a user as logged into the OS and waives the password requirement.

14. What is Advanced Security Option
Tables - Indexes - Materialized Views - Partitions
The first extent is created when?
This lets you encrypt data in your database files
Grant create session to <user> with admin option;

15. How does select use Database Buffer Cache
Data blocks copied into database buffer cache - relevant rows copied into user session PGA - blocks stay in cache until buffer needed for something else.
Allows a user to grant an object privilege to another user.
This controls what a user can do in the database. Primarily applies to adding or changing structures in the database.
Grant create session to <user>;

16. What is a segment
This is a logical structure that represents objects in the database that require physical storage
What goes into the table SYS.AUD$
You should switch these every 15-30 minutes
These all start with 'ora_'

17. What is a system privilege?
Allows a user to grant a system privilege to another user.
This is a modification applied to something; executing DML generates these applied to data.
This controls what a user can do in the database. Primarily applies to adding or changing structures in the database.
What logical structure do data files correspond to?

18. What SQL Would let you audit people creating tables?
These are the PFILE and the SPFILE
Audit create table;
This is a library of ready to go SQL Statements.
Revoke create session from <user>;

19. Which SGA Structures are optional
Large Pool - Java Pool - Streams Pool
Allows a user to grant a system privilege to another user.
This is a combination of memory and processes that are part of a running installation
This process runs the job given to it by the CJQ0 process

20. What is the first file read when a database starts?
This is a combination of memory and processes that are part of a running installation
This logical structure is the minimum unit that Oracle will read or write at any given time.
Recognizes a user as logged into the OS and waives the password requirement.
The parameter file is read at what point during database startup?

21. What view lets you look at audits of system privileges
This controls what a user can do in the database. Primarily applies to adding or changing structures in the database.
DBA_STMT_AUDIT_OPTS is a view that does what?
This tablespace stores the rollback or undo segments used for transaction recovery
LGWR starts writing to the next group - A Database checkpoint occurs - The DBWR writes dirty blocks our of the buffer cascade

22. What is an instance?
Users - Objects - System Privileges - Combination are things you can?
This is a combination of memory and processes that are part of a running installation
Audit create table;
This parameter is used to automatically size and manage the SGA - PGA - and all memory used by them.

23. 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.
DBA_STMT_AUDIT_OPTS is a view that does what?
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 lets you encrypt data in your database files

24. Which SGA Structures are required
LGWR starts writing to the next group - A Database checkpoint occurs - The DBWR writes dirty blocks our of the buffer cascade
Database Buffer Cache - Log Buffer - Shared Pool
Create user OPS$REPORTS identified externally;
Block in the database buffer cache does not match what is on disk.

25. What is Virtual Private Database?
What logical structure do data files correspond to?
This is a library of ready to go SQL Statements.
Row level security is this kind of database.
Memory Size - Database and Instance Name - Archiving parameters - Processes - Over 1900 other parameters

26. What does process CKPT do?
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
Views - Procedures - Synonyms - Sequences
This process copies filled redo logs to the archived redo storage area. If you aren't in archive mode - this process shuts down.
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.

27. What kind of server process does a DBA connection get?
Show parameter audit_file_dest;
These connections always get a dedicated server process.
Grant create session to <user>;
This logical structure is the minimum unit that Oracle will read or write at any given time.

28. What is a change vector?
Block in the database buffer cache does not match what is on disk.
This is a modification applied to something; executing DML generates these applied to data.
SELECT statement information are not stored in these files?
This tablespace is used for temporary storage.

29. What is the SYSAUX tablespace used for?
This process runs the job given to it by the CJQ0 process
This tablespace stored objects that are auxiliary and not specifically tied to the core features of the database
V$MEMORY_TARGET_ADVICE
You cannot restore a database with a complete collection of these from your last full backup.

30. What are the 3 processes that are part of an instance?
Background processes - Server Processes - User Processes are part of what?
Allows you to group privileges for ease of management
SYSTEM - SYSAUX - UNDO - TEMP
Alter user HR profile report_writer;

31. What tablespaces should every database have?
You should switch these every 15-30 minutes
Commit - every three seconds - redo log buffer is 1/3 full - just before dirty block is written to disk.
SYSTEM - SYSAUX - UNDO - TEMP
These are copies of redo log files

32. What is a database block?
This is the minimum amount of storage that Oracle reads or writes.
Memory used by sessions connecting to the database are not controlled by this parameter.
With this server process each user process gets its own server process. Server process waits on you. Most responsive.
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.

33. What does process LGWR do?
AUDIT_TRAIL is set to DB
Background processes - Server Processes - User Processes are part of what?
DBA_OBJ_AUDIT_OPTS is a view that does what?
This process flushes the redo log buffer. Writes redo entries to disk and signals a completion.

34. Where does auditing data go by default
If you have a full backup and copies of these you can recover from almost any type of failure.
These are usually configured 3 groups with 2 mirrored members in each.
What goes into the table SYS.AUD$
These files contain information about how your running database is configured.

35. What is the PL/SQL function result cache?
Each concurrent database request gets a server process.
This stores the results of a computation.
What goes into the table SYS.AUD$
Data requested by user is found in the database buffer cache. No need to read from disk.

36. What is the Database Buffer Cache

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

37. What does process ARCn do?

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

38. What is the UNDO tablespace used for?
Large Pool - Java Pool - Streams Pool
This tablespace stores the rollback or undo segments used for transaction recovery
Users - Objects - System Privileges - Combination are things you can?
This is a library of ready to go SQL Statements.

39. What triggers a block write and therefore a dirty block?
This can only mount to one database
This is a modification applied to something; executing DML generates these applied to data.
Database shutdown - full or partial checkpoint - recovery time threshold - free block is needed - some DDL commands - every three seconds
AUDIT - NOAUDIT

40. What is an Extent?
This is the logical structure that makes up segments.
DBA_OBJ_AUDIT_OPTS is a view that does what?
This is the physical component or the files
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 does the Program Global Area (PGA) contain?
LGWR starts writing to the next group - A Database checkpoint occurs - The DBWR writes dirty blocks our of the buffer cascade
This process checks for scheduled tasks within the database.
Views - Procedures - Synonyms - Sequences
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

42. What does process DIA0 do?
This process resolves deadlock situations
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
Alter user HR profile report_writer;
Parsed SQL - syntax - objects are checked - Oracle permissions - p-code - optimum path or plan.

43. What does process DBWn do?
This logical structure organizes one or more data files.
SYSDBA is this kind of role.
This process takes dirty blocks from dirty list and writes them to disk.
V$MEMORY_TARGET_ADVICE

44. What is the first level of logical organization of your physical storage?
DBA_STMT_AUDIT_OPTS is a view that does what?
This process is primarily responsible for instance recovery. Applies redo information. Cleans and releases temporary space
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.
The tablespace is what level of logical organization?

45. What options can you add to audits?
The logwriter (LGWR) writes to these files.
Whenever successful - whenever not successful - by access - by session
Allows you to group privileges for ease of management
...

46. What is the dictionary cache?

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

47. What does the WITH GRANT OPTION do?
Database Buffer Cache - Log Buffer - Shared Pool
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.
Allows a user to grant an object privilege to another user.

48. What is a buffer cache hit?
This relieves the shared pool of sometimes-transient memory requirements.
This process can be dedicated or shared
Data requested by user is found in the database buffer cache. No need to read from disk.
AUDIT - NOAUDIT

49. What is a dirty buffer?
This is the first part of a data file.
DBA_PRIV_AUDIT_OPTS is a view that does what?
Block in the database buffer cache does not match what is on disk.
This is a collection of information about you and the database's objects.

50. What is audited by default in Oracle 11g?
...
Views - Procedures - Synonyms - Sequences
SYSTEM - SYSAUX - UNDO - TEMP
This processs provides a time reference within the database.