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 Program Global Area -- PGA?
Row level security is this kind of database.
This contains information used for private or session-related information that individual users need
DBA_PRIV_AUDIT_OPTS is a view that does what?
Background processes - Server Processes - User Processes are part of what?

2. How does select use Database Buffer Cache
The parameter file is read at what point during database startup?
LGWR starts writing to the next group - A Database checkpoint occurs - The DBWR writes dirty blocks our of the buffer cascade
This process can be dedicated or shared
Data blocks copied into database buffer cache - relevant rows copied into user session PGA - blocks stay in cache until buffer needed for something else.

3. What does process CJQ0 do?
Large Pool - Java Pool - Streams Pool
This process checks for scheduled tasks within the database.
This parameter is used to automatically size and manage the SGA - PGA - and all memory used by them.
This is the concept that adding and removing privileges from a role immediately affect all users who have the role.

4. How many datafiles does a tablespace organize?
What goes into the table SYS.AUD$
Allows a user to grant a system privilege to another user.
This logical structure organizes one or more data files.
DB Block -- minimum size read into database buffer cache - OS Block - physical block determined when you format hard drive.

5. What can you configure in the parameter files?
Create role <role>; grant <privilege> on <table> to <role>; grant <role> to <user>;
Allows a user to grant an object privilege to another user.
DBA_PRIV_AUDIT_OPTS is a view that does what?
Memory Size - Database and Instance Name - Archiving parameters - Processes - Over 1900 other parameters

6. What is dynamic privilege management?
This tablespace stores the core database objects that are used for running the database itself
This is the concept that adding and removing privileges from a role immediately affect all users who have the role.
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.
These files are stored in ORACLE_HOME: $ORACLE_HOME/dbs - %ORACLE_HOMEdatabase

7. What are Archive log files?
These are copies of redo log files
The parameter file is read at what point during database startup?
...
This is the first part of a data file.

8. What SQL gives a user the ability to grant system privileges to another user?
The tablespace is what level of logical organization?
Data blocks copied into database buffer cache - relevant rows copied into user session PGA - blocks stay in cache until buffer needed for something else.
Grant create session to <user> with admin option;
What logical structure do data files correspond to?

9. What happens during a log switch operation? What causes the following: LGWR finishes writing to the current group
LGWR starts writing to the next group - A Database checkpoint occurs - The DBWR writes dirty blocks our of the buffer cascade
This pool does not use LRU and will fill up.
This is a logical structure that represents objects in the database that require physical storage
The parameter file is read at what point during database startup?

10. 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 logical structure is the minimum unit that Oracle will read or write at any given time.
This parameter is used to automatically size and manage the SGA - PGA - and all memory used by them.
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.

11. What does the server process do?
These use which pool? Oracle Recovery Manager - Oracle Shared Server - Parallel processing - I/O-related server processes.
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.
ORACLE's work area for executing SQL

12. 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
These files are stored in ORACLE_HOME: $ORACLE_HOME/dbs - %ORACLE_HOMEdatabase
Oracle background processes and server processes share this.
Database Buffer Cache - Log Buffer - Shared Pool

13. What does process PMON do?
This process checks for scheduled tasks within the database.
If you have a full backup and copies of these you can recover from almost any type of failure.
With this server process each user process gets its own server process. Server process waits on you. Most responsive.
This cleans up failed processes by releasing resources and rolling back uncomitted data.

14. What kinds of blocks do data files have?
This physical structure is the formatted size of the minimum unit of storage on the device
DB Block -- minimum size read into database buffer cache - OS Block - physical block determined when you format hard drive.
This is the first part of a data file.
This can only mount to one database

15. What are the 3 processes that are part of an instance?
Background processes - Server Processes - User Processes are part of what?
Allows a user to grant an object privilege to another user.
This is a modification applied to something; executing DML generates these applied to data.
Grant create session to <user>;

16. What naming convention should you use for your PFILE
Commit - every three seconds - redo log buffer is 1/3 full - just before dirty block is written to disk.
This file should be named init<dbname>.ora
These files store information from the log buffer.
Whenever successful - whenever not successful - by access - by session

17. 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.
Free - Pinned - Dirty are 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 tablespace stores the core database objects that are used for running the database itself

18. What is a dirty buffer?
These all start with 'ora_'
Parsed SQL - syntax - objects are checked - Oracle permissions - p-code - optimum path or plan.
Block in the database buffer cache does not match what is on disk.
DBA_OBJ_AUDIT_OPTS is a view that does what?

19. What uses the large pool?
You cannot restore a database with a complete collection of these from your last full backup.
This controls what a user can do in the database. Primarily applies to adding or changing structures in the database.
These use which pool? Oracle Recovery Manager - Oracle Shared Server - Parallel processing - I/O-related server processes.
These files contain information about how your running database is configured.

20. The SGA is shared by what processes?
This is the first part of a data file.
Oracle background processes and server processes share this.
This is a small - short-term staging area for change vectors before they are written to redo logs on disk.
This file should be named init<dbname>.ora

21. What does process J000 do?
This is written in PL/SQL and examines passwords when they're chosen and accepts or rejects them based on criteria.
SELECT - INSERT - UPDATE - DELETE - REFERENCES - INDEX - ALTER - EXECUTE
This process runs the job given to it by the CJQ0 process
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.

22. What is the library cache?
This is a library of ready to go SQL Statements.
The parameter file is read at what point during database startup?
CREATE PROFILE xxxxx LIMIT FAILED_LOGIN_ATTEMPTS 3;
This relieves the shared pool of sometimes-transient memory requirements.

23. What SQL allows you to create role and grant privileges to a user
Data requested by user is found in the database buffer cache. No need to read from disk.
Create role <role>; grant <privilege> on <table> to <role>; grant <role> to <user>;
Block in the database buffer cache does not match what is on disk.
Data blocks copied into database buffer cache - relevant rows copied into user session PGA - blocks stay in cache until buffer needed for something else.

24. What is an Oracle Block?
Allows you to group privileges for ease of management
This logical structure is the minimum unit that Oracle will read or write at any given time.
DB Block -- minimum size read into database buffer cache - OS Block - physical block determined when you format hard drive.
This process copies filled redo logs to the archived redo storage area. If you aren't in archive mode - this process shuts down.

25. What does the WITH GRANT OPTION do?
The first extent is created when?
...
Audit create table;
Allows a user to grant an object privilege to another user.

26. What does process VKTM do?
This tablespace is used for temporary storage.
Grant create session to <user>;
This processs provides a time reference within the database.
Alter user HR profile report_writer;

27. What does process SMON do
This process is primarily responsible for instance recovery. Applies redo information. Cleans and releases temporary space
This controls what a user can do in the database. Primarily applies to adding or changing structures in the database.
This is a logical structure that represents objects in the database that require physical storage
This is the concept that adding and removing privileges from a role immediately affect all users who have the role.

28. What is the first file read when a database starts?
Allows a user to grant an object privilege to another user.
The parameter file is read at what point during database startup?
This is written in PL/SQL and examines passwords when they're chosen and accepts or rejects them based on criteria.
This process is primarily responsible for instance recovery. Applies redo information. Cleans and releases temporary space

29. What is the SYSTEM tablespace used for?
Oracle background processes and server processes share this.
This tablespace stores the core database objects that are used for running the database itself
CREATE PROFILE xxxxx LIMIT FAILED_LOGIN_ATTEMPTS 3;
Database shutdown - full or partial checkpoint - recovery time threshold - free block is needed - some DDL commands - every three seconds

30. What kinds of server processes are there?
This process is primarily responsible for instance recovery. Applies redo information. Cleans and releases temporary space
DBA_STMT_AUDIT_OPTS is a view that does what?
This process can be dedicated or shared
ORACLE's work area for executing SQL

31. What triggers a block write and therefore a dirty block?
Database shutdown - full or partial checkpoint - recovery time threshold - free block is needed - some DDL commands - every three seconds
You must have at least 2 of the log file groups.
When are connections with SYSDBA privilege audited?
This controls how a user can access actual data in the database. Primarily applies to rows in a table or a view.

32. How does updating use Database Buffer Cache
Whenever successful - whenever not successful - by access - by session
This is a small - short-term staging area for change vectors before they are written to redo logs on disk.
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.
This is a modification applied to something; executing DML generates these applied to data.

33. What SQL allows a user access to the database?
You cannot restore a database with a complete collection of these from your last full backup.
Grant create session to <user>;
Grant create session to <user> with admin option;
This lets you encrypt data in your database files

34. What is the dictionary cache?

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

35. What is Operating System Authentication?
This is the logical structure that makes up segments.
Recognizes a user as logged into the OS and waives the password requirement.
You should switch these every 15-30 minutes
AUDIT - NOAUDIT

36. What is audited by default in Oracle 11g?
This logical structure organizes one or more data files.
SYSTEM - SYSAUX - UNDO - TEMP
These are copies of redo log files
...

37. What is the first level of logical organization of your physical storage?
This is a collection of information about you and the database's objects.
The tablespace is what level of logical organization?
If you have a full backup and copies of these you can recover from almost any type of failure.
Whenever successful - whenever not successful - by access - by session

38. What is stored in the library cache
Background process that write database buffer cache to disk
Each concurrent database request gets a server process.
This contains the information used for backup and recovery - free space - file status details.
Parsed SQL - syntax - objects are checked - Oracle permissions - p-code - optimum path or plan.

39. What happens if you are missing an archive log?
These are copies of redo log files
This logical structure organizes one or more data files.
You cannot restore a database with a complete collection of these from your last full backup.
What goes into the table SYS.AUD$

40. What does the Program Global Area (PGA) contain?
These files store information from the log buffer.
This is the logical structure that makes up segments.
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
Allows you to group privileges for ease of management

41. What are the names of the parameter files?
AUDIT_TRAIL is set to DB
These are the PFILE and the SPFILE
Data requested by user is found in the database buffer cache. No need to read from disk.
This stores the results of a computation.

42. What is Advanced Security Option
Show parameter audit_file_dest;
Background process that write database buffer cache to disk
This lets you encrypt data in your database files
This logical structure organizes one or more data files.

43. What prefix must precede the OS username for an OS-Authenticated user?
Grant create session to <user>;
This parameter is used to automatically size and manage the SGA - PGA - and all memory used by them.
What is OPS$
AUDIT - NOAUDIT

44. What is a tempfile?
This process takes dirty blocks from dirty list and writes them to disk.
This controls what a user can do in the database. Primarily applies to adding or changing structures in the database.
Database Buffer Cache - Log Buffer - Shared Pool
This is a special type of database file holding only information for sorts or temporary tables.

45. What is the UNDO tablespace used for?
Database shutdown - full or partial checkpoint - recovery time threshold - free block is needed - some DDL commands - every three seconds
What logical structure do data files correspond to?
This tablespace stores the rollback or undo segments used for transaction recovery
These files contain information about how your running database is configured.

46. 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 process checks for scheduled tasks within the database.
This process can be dedicated or shared
These connections always get a dedicated server process.

47. What is the SQL for creating a password profile
CREATE PROFILE xxxxx LIMIT FAILED_LOGIN_ATTEMPTS 3;
The parameter file is read at what point during database startup?
If you have a full backup and copies of these you can recover from almost any type of failure.
You cannot restore a database with a complete collection of these from your last full backup.

48. Which view helps you size memory properly
Users - Objects - System Privileges - Combination are things you can?
SELECT statement information are not stored in these files?
V$MEMORY_TARGET_ADVICE
This contains the information used for backup and recovery - free space - file status details.

49. Where does auditing data go by default
Audit create table;
V$TEMPFILE and V$DATAFILE contain this information?
What goes into the table SYS.AUD$
The tablespace is what level of logical organization?

50. Which process writes to the Redo Log Files?
Recognizes a user as logged into the OS and waives the password requirement.
The logwriter (LGWR) writes to these files.
These are the PFILE and the SPFILE
...