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 a password verify function

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

2. What view lets you look at audits of system privileges
DBA_PRIV_AUDIT_OPTS is a view that does what?
This processs provides a time reference within the database.
This is the logical structure that makes up segments.
DBA_STMT_AUDIT_OPTS is a view that does what?

3. What SQL allows a user access to the database?
Each concurrent database request gets a server process.
Grant create session to <user>;
Allows a user to grant a system privilege to another user.
This process runs the job given to it by the CJQ0 process

4. Where are the PFILE and SPFILE stored?
This is a small - short-term staging area for change vectors before they are written to redo logs on disk.
These files are stored in ORACLE_HOME: $ORACLE_HOME/dbs - %ORACLE_HOMEdatabase
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.
The logwriter (LGWR) writes to these files.

5. What view lets you look at audits of privileges
This is the logical structure that makes up segments.
If you have a full backup and copies of these you can recover from almost any type of failure.
Grant create session to <user> with admin option;
DBA_PRIV_AUDIT_OPTS is a view that does what?

6. What is the Database Buffer Cache

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

7. What does parameter MEMORY_TARGET not control?
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 is a logical structure that represents objects in the database that require physical storage
What goes into the table SYS.AUD$
Memory used by sessions connecting to the database are not controlled by this parameter.

8. 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$
Commit - every three seconds - redo log buffer is 1/3 full - just before dirty block is written to disk.
This process flushes the redo log buffer. Writes redo entries to disk and signals a completion.

9. What actions are always audited
This stores the results of a computation.
When are connections with SYSDBA privilege audited?
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.
V$TEMPFILE and V$DATAFILE contain this information?

10. What is an Oracle Block?
This cleans up failed processes by releasing resources and rolling back uncomitted data.
This logical structure is the minimum unit that Oracle will read or write at any given time.
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.

11. How often should you switch log files
This is a library of ready to go SQL Statements.
SYSTEM - SYSAUX - UNDO - TEMP
You should switch these every 15-30 minutes
This relieves the shared pool of sometimes-transient memory requirements.

12. What does process DIA0 do?
This process resolves deadlock situations
Free - Pinned - Dirty are what?
Grant SELECT on <table> to <user>;
This process flushes the redo log buffer. Writes redo entries to disk and signals a completion.

13. What SQL gives a user the ability to grant system privileges to another user?
Database Buffer Cache - Log Buffer - Shared Pool
Revoke create session from <user>;
This file should be named spfile<dbname>.ora
Grant create session to <user> with admin option;

14. How should log files be configured?
These use which pool? Oracle Recovery Manager - Oracle Shared Server - Parallel processing - I/O-related server processes.
These are usually configured 3 groups with 2 mirrored members in each.
Grant SELECT on <table> to <user>;
This process can be dedicated or shared

15. What does the CREATE SESSION privilege do?
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.
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 grants users access to the database.

16. What does parameter MEMORY_TARGET do?
DBA_PRIV_AUDIT_OPTS is a view that does what?
When are connections with SYSDBA privilege audited?
This parameter is used to automatically size and manage the SGA - PGA - and all memory used by them.
This is a combination of memory and processes that are part of a running installation

17. When is the redo log buffer flushed?
Commit - every three seconds - redo log buffer is 1/3 full - just before dirty block is written to disk.
This logical structure organizes one or more data files.
What goes into the table SYS.AUD$
Whenever successful - whenever not successful - by access - by session

18. What view lets you look at audits of objects?
DB Block -- minimum size read into database buffer cache - OS Block - physical block determined when you format hard drive.
These are usually configured 3 groups with 2 mirrored members in each.
DBA_OBJ_AUDIT_OPTS is a view that does what?
This is the concept that adding and removing privileges from a role immediately affect all users who have the role.

19. What views contain information about your DB Files?
V$TEMPFILE and V$DATAFILE contain this information?
DB Block -- minimum size read into database buffer cache - OS Block - physical block determined when you format hard drive.
Create user OPS$REPORTS identified externally;
This processs provides a time reference within the database.

20. What does process CJQ0 do?
This process checks for scheduled tasks within the database.
DBA_PRIV_AUDIT_OPTS is a view that does what?
These files are stored in ORACLE_HOME: $ORACLE_HOME/dbs - %ORACLE_HOMEdatabase
This file should be named spfile<dbname>.ora

21. What is an object privilege?
Data requested by user is found in the database buffer cache. No need to read from disk.
Create user OPS$REPORTS identified externally;
Create role <role>; grant <privilege> on <table> to <role>; grant <role> to <user>;
This controls how a user can access actual data in the database. Primarily applies to rows in a table or a view.

22. What is the SYSAUX tablespace used for?
This tablespace stored objects that are auxiliary and not specifically tied to the core features of the database
This is a small - short-term staging area for change vectors before they are written to redo logs on disk.
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.
The first extent is created when?

23. Which SGA Structures are required
This is written in PL/SQL and examines passwords when they're chosen and accepts or rejects them based on criteria.
This is the first part of a data file.
Database Buffer Cache - Log Buffer - Shared Pool
This process takes dirty blocks from dirty list and writes them to disk.

24. 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.
This tablespace is used for temporary storage.
Oracle background processes and server processes share this.
These all start with 'ora_'

25. Where does auditing data go by default
Users - Objects - System Privileges - Combination are things you can?
This is written in PL/SQL and examines passwords when they're chosen and accepts or rejects them based on criteria.
What goes into the table SYS.AUD$
This tablespace stores the rollback or undo segments used for transaction recovery

26. 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.
Recognizes a user as logged into the OS and waives the password requirement.
This file should be named spfile<dbname>.ora

27. What is a buffer cache hit?
This tablespace stores the core database objects that are used for running the database itself
Recognizes a user as logged into the OS and waives the password requirement.
Data blocks copied into database buffer cache - relevant rows copied into user session PGA - blocks stay in cache until buffer needed for something else.
Data requested by user is found in the database buffer cache. No need to read from disk.

28. What does process PMON do?
Create user OPS$REPORTS identified externally;
V$TEMPFILE and V$DATAFILE contain this information?
What goes into the table SYS.AUD$
This cleans up failed processes by releasing resources and rolling back uncomitted data.

29. What are Archive log files?
These are copies of redo log files
This contains the information used for backup and recovery - free space - file status details.
Background process that write database buffer cache to disk
Each concurrent database request gets a server process.

30. What is the Redo Log Buffer
This grants users access to the database.
This stores the results of a computation.
This records every SQL statement that changes data. The redo entry is in the redo log buffer before written to redo log.
This is the minimum amount of storage that Oracle reads or writes.

31. How does a dedicated server process work?
These connections always get a dedicated server process.
With this server process each user process gets its own server process. Server process waits on you. Most responsive.
SELECT - INSERT - UPDATE - DELETE - REFERENCES - INDEX - ALTER - EXECUTE
This logical structure is the minimum unit that Oracle will read or write at any given time.

32. What is the database writer process?
AUDIT - NOAUDIT
This is written in PL/SQL and examines passwords when they're chosen and accepts or rejects them based on criteria.
This cache is allocated at instance startup
Background process that write database buffer cache to disk

33. What is a system privilege?
V$TEMPFILE and V$DATAFILE contain this information?
This controls what a user can do in the database. Primarily applies to adding or changing structures in the database.
This tablespace stores the core database objects that are used for running the database itself
Views - Procedures - Synonyms - Sequences

34. What are the 3 processes that are part of an instance?
...
When are connections with SYSDBA privilege audited?
Background processes - Server Processes - User Processes are part of 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

35. What is an instance?
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 blocks copied into database buffer cache - relevant rows copied into user session PGA - blocks stay in cache until buffer needed for something else.
This is a combination of memory and processes that are part of a running installation
This tablespace stores the core database objects that are used for running the database itself

36. What does the Program Global Area (PGA) contain?
The logwriter (LGWR) writes to these files.
Data Files - Control Files - Redo Log Files - Archive Log Files - Server and initialization parameter files
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 stores the results of a computation.

37. What does process CKPT do?
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 process checks for scheduled tasks within the database.
SELECT statement information are not stored in these files?
Grant create session to <user>;

38. What does process SMON do
This is a special type of database file holding only information for sorts or temporary tables.
This process is primarily responsible for instance recovery. Applies redo information. Cleans and releases temporary space
ORACLE's work area for executing SQL
DBA_STMT_AUDIT_OPTS is a view that does what?

39. 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>;
ORACLE's work area for executing SQL
These are usually configured 3 groups with 2 mirrored members in each.
This parameter is used to automatically size and manage the SGA - PGA - and all memory used by them.

40. What is the SQL for creating a password profile
DBA_OBJ_AUDIT_OPTS is a view that does what?
The parameter file is read at what point during database startup?
CREATE PROFILE xxxxx LIMIT FAILED_LOGIN_ATTEMPTS 3;
This is the minimum amount of storage that Oracle reads or writes.

41. What is the library cache?
This is a library of ready to go SQL Statements.
DBA_PRIV_AUDIT_OPTS is a view that does what?
This is the physical component or the files
These all start with 'ora_'

42. What is an Extent?
This records every SQL statement that changes data. The redo entry is in the redo log buffer before written to redo log.
This file should be named init<dbname>.ora
This is the logical structure that makes up segments.
Allows a user to grant a system privilege to another user.

43. What is dynamic privilege management?
This controls what a user can do in the database. Primarily applies to adding or changing structures in the database.
This is the concept that adding and removing privileges from a role immediately affect all users who have the role.
What logical structure do data files correspond to?
Grant SELECT on <table> to <user>;

44. When does the large pool get cleaned out?
This can only mount to one database
These all start with 'ora_'
This pool does not use LRU and will fill up.
This tablespace is used for temporary storage.

45. What naming convention should you use for your PFILE
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 file should be named init<dbname>.ora
This tablespace is used for temporary storage.
This lets you encrypt data in your database files

46. What are the PFILE and SPFILE?
This is the physical component or the files
Parsed SQL - syntax - objects are checked - Oracle permissions - p-code - optimum path or plan.
Database shutdown - full or partial checkpoint - recovery time threshold - free block is needed - some DDL commands - every three seconds
These files contain information about how your running database is configured.

47. What does process LGWR do?
This process is primarily responsible for instance recovery. Applies redo information. Cleans and releases temporary space
This tablespace stores the rollback or undo segments used for transaction recovery
Free - Pinned - Dirty are what?
This process flushes the redo log buffer. Writes redo entries to disk and signals a completion.

48. List the kinds of files used to run an Oracle Instance?
These are copies of redo log files
This tablespace stored objects that are auxiliary and not specifically tied to the core features of the database
Data Files - Control Files - Redo Log Files - Archive Log Files - Server and initialization parameter files
Recognizes a user as logged into the OS and waives the password requirement.

49. What do control files contain?
The first extent is created when?
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.
DBA_STMT_AUDIT_OPTS is a view that does what?
AUDIT - NOAUDIT

50. What does process ARCn do?

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