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 stored in the library cache
This process resolves deadlock situations
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.
This physical structure is the formatted size of the minimum unit of storage on the device

2. What kind of server process does a DBA connection get?
This logical structure organizes one or more data files.
These connections always get a dedicated server process.
Tables - Indexes - Materialized Views - Partitions
Database shutdown - full or partial checkpoint - recovery time threshold - free block is needed - some DDL commands - every three seconds

3. What do control files contain?
Parsed SQL - syntax - objects are checked - Oracle permissions - p-code - optimum path or plan.
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.
Create role <role>; grant <privilege> on <table> to <role>; grant <role> to <user>;
This tablespace is used for temporary storage.

4. What is a database
These files store information from the log buffer.
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 the physical component or the files
This records every SQL statement that changes data. The redo entry is in the redo log buffer before written to redo log.

5. How does a shared server architecture work?
This forces a user to follow guidelines when creating or changing passwords.
Each concurrent database request gets a server process.
This can only mount to one database
This process is primarily responsible for instance recovery. Applies redo information. Cleans and releases temporary space

6. What is an OS Block?
Allows you to group privileges for ease of management
...
This forces a user to follow guidelines when creating or changing passwords.
This physical structure is the formatted size of the minimum unit of storage on the device

7. How do you create an OS-Authenticated user?
Grant create session to <user>;
Create user OPS$REPORTS identified externally;
This stores the results of a computation.
Grant SELECT on <table> to <user> WITH GRANT OPTION;

8. What is a tempfile?
This forces a user to follow guidelines when creating or changing passwords.
This is a collection of information about you and the database's objects.
This is a special type of database file holding only information for sorts or temporary tables.
Data requested by user is found in the database buffer cache. No need to read from disk.

9. What prefix must precede the OS username for an OS-Authenticated user?
V$MEMORY_TARGET_ADVICE
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$
This is the minimum amount of storage that Oracle reads or writes.

10. What is the Program Global Area -- PGA?
This contains the information used for backup and recovery - free space - file status details.
The parameter file is read at what point during database startup?
Views - Procedures - Synonyms - Sequences
This contains information used for private or session-related information that individual users need

11. What physical structure does a tablespace correspond to?
Create role <role>; grant <privilege> on <table> to <role>; grant <role> to <user>;
What logical structure do data files correspond to?
This contains the information used for backup and recovery - free space - file status details.
Memory used by sessions connecting to the database are not controlled by this parameter.

12. What happens if you are missing an archive log?
You cannot restore a database with a complete collection of these from your last full backup.
This cleans up failed processes by releasing resources and rolling back uncomitted data.
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 logical structure organizes one or more data files.

13. What is the Redo Log Buffer
The logwriter (LGWR) writes to these files.
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 records every SQL statement that changes data. The redo entry is in the redo log buffer before written to redo log.
This cleans up failed processes by releasing resources and rolling back uncomitted data.

14. What uses the large pool?
These use which pool? Oracle Recovery Manager - Oracle Shared Server - Parallel processing - I/O-related server processes.
This cache is allocated at instance startup
This is a collection of information about you and the database's objects.
DBA_STMT_AUDIT_OPTS is a view that does what?

15. What view lets you look at audits of objects?
This processs provides a time reference within the database.
This controls what a user can do in the database. Primarily applies to adding or changing structures in the database.
This logical structure organizes one or more data files.
DBA_OBJ_AUDIT_OPTS is a view that does what?

16. What is a change vector?
The logwriter (LGWR) writes to these files.
This is a modification applied to something; executing DML generates these applied to data.
The first extent is created when?
Allows a user to grant an object privilege to another user.

17. What are redo log files?
These files store information from the log buffer.
Background processes - Server Processes - User Processes are part of what?
Users - Objects - System Privileges - Combination are things you can?
This contains information used for private or session-related information that individual users need

18. What does the CREATE SESSION privilege do?
These files contain information about how your running database is configured.
You must have at least 2 of the log file groups.
What logical structure do data files correspond to?
This grants users access to the database.

19. What does process CJQ0 do?
CREATE PROFILE xxxxx LIMIT FAILED_LOGIN_ATTEMPTS 3;
This tablespace is used for temporary storage.
You must have at least 2 of the log file groups.
This process checks for scheduled tasks within the database.

20. What is the library cache?
This is a library of ready to go SQL Statements.
This file should be named spfile<dbname>.ora
Allows a user to grant an object privilege to another user.
This can only mount to one database

21. What is the block header?
This tablespace stores the core database objects that are used for running the database itself
LGWR starts writing to the next group - A Database checkpoint occurs - The DBWR writes dirty blocks our of the buffer cascade
This is the first part of a data file.
You cannot restore a database with a complete collection of these from your last full backup.

22. What is an object privilege?
This process is primarily responsible for instance recovery. Applies redo information. Cleans and releases temporary space
You should switch these every 15-30 minutes
This controls how a user can access actual data in the database. Primarily applies to rows in a table or a view.
This tablespace stored objects that are auxiliary and not specifically tied to the core features of the database

23. How does updating use Database Buffer Cache
This is a modification applied to something; executing DML generates these applied to data.
The parameter file is read at what point during database startup?
Each concurrent database request gets a server process.
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.

24. What does process DIA0 do?
This controls how a user can access actual data in the database. Primarily applies to rows in a table or a view.
AUDIT - NOAUDIT
This process resolves deadlock situations
This cleans up failed processes by releasing resources and rolling back uncomitted data.

25. What is a password profile
This forces a user to follow guidelines when creating or changing passwords.
LGWR starts writing to the next group - A Database checkpoint occurs - The DBWR writes dirty blocks our of the buffer cascade
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.
Free - Pinned - Dirty are what?

26. What is an instance?
You must have at least 2 of the log file groups.
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.
Memory Size - Database and Instance Name - Archiving parameters - Processes - Over 1900 other parameters
This is a combination of memory and processes that are part of a running installation

27. What kinds of objects are not segments -but are pieces of code in the SYSTEM tablespace.
This processs provides a time reference within the database.
These are copies of redo log files
This cleans up failed processes by releasing resources and rolling back uncomitted data.
Views - Procedures - Synonyms - Sequences

28. How do you assign a password profile to a user
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 the physical component or the files
Alter user HR profile report_writer;
The parameter file is read at what point during database startup?

29. What is the first file read when a database starts?
This cleans up failed processes by releasing resources and rolling back uncomitted data.
CREATE PROFILE xxxxx LIMIT FAILED_LOGIN_ATTEMPTS 3;
The logwriter (LGWR) writes to these files.
The parameter file is read at what point during database startup?

30. What SQL gives a user the ability to grant object privileges to another user?
Grant SELECT on <table> to <user> WITH GRANT OPTION;
Memory Size - Database and Instance Name - Archiving parameters - Processes - Over 1900 other parameters
Memory used by sessions connecting to the database are not controlled by this parameter.
DBA_OBJ_AUDIT_OPTS is a view that does what?

31. What options do you have for auditing?
Create user OPS$REPORTS identified externally;
What goes into the table SYS.AUD$
Users - Objects - System Privileges - Combination are things you can?
Audit create table;

32. Where does auditing data go by default
What goes into the table SYS.AUD$
These are copies of redo log files
Memory Size - Database and Instance Name - Archiving parameters - Processes - Over 1900 other parameters
Free - Pinned - Dirty are what?

33. What kinds of server processes are there?
This process resolves deadlock situations
This process can be dedicated or shared
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 cache is allocated at instance startup

34. What is a system privilege?
DB Block -- minimum size read into database buffer cache - OS Block - physical block determined when you format hard drive.
This controls what a user can do in the database. Primarily applies to adding or changing structures in the database.
This is the logical structure that makes up segments.
Memory used by sessions connecting to the database are not controlled by this parameter.

35. What SQL allows a user access to the database?
This is a small - short-term staging area for change vectors before they are written to redo logs on disk.
These connections always get a dedicated server process.
Free - Pinned - Dirty are what?
Grant create session to <user>;

36. What SQL gives a user the ability to grant system privileges to another user?
This is the logical structure that makes up segments.
Grant create session to <user> with admin option;
Database Buffer Cache - Log Buffer - Shared Pool
Grant SELECT on <table> to <user>;

37. What is Virtual Private Database?
AUDIT - NOAUDIT
This is a combination of memory and processes that are part of a running installation
This file should be named init<dbname>.ora
Row level security is this kind of database.

38. What does a database role do?
The first extent is created when?
DB Block -- minimum size read into database buffer cache - OS Block - physical block determined when you format hard drive.
Row level security is this kind of database.
Allows you to group privileges for ease of management

39. What is the SYSAUX tablespace used for?
This is a library of ready to go SQL Statements.
These use which pool? Oracle Recovery Manager - Oracle Shared Server - Parallel processing - I/O-related server processes.
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

40. What is a database block?
You must have at least 2 of the log file groups.
This lets you encrypt data in your database files
AUDIT - NOAUDIT
This is the minimum amount of storage that Oracle reads or writes.

41. What does the WITH GRANT OPTION do?
If you have a full backup and copies of these you can recover from almost any type of failure.
Allows a user to grant an object privilege to another user.
This process copies filled redo logs to the archived redo storage area. If you aren't in archive mode - this process shuts down.
Grant create session to <user>;

42. What does the Program Global Area (PGA) contain?
You cannot restore a database with a complete collection of these from your last full backup.
The tablespace is what level of logical organization?
This relieves the shared pool of sometimes-transient memory requirements.
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

43. How many databases can an instance mount to?
This can only mount to one database
This tablespace stored objects that are auxiliary and not specifically tied to the core features of the database
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 first extent is created when?

44. 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.
Allows a user to grant a system privilege to another user.
This is a logical structure that represents objects in the database that require physical storage
This file should be named init<dbname>.ora

45. What view lets you look at audits of privileges
Audit create table;
DBA_PRIV_AUDIT_OPTS is a view that does what?
This relieves the shared pool of sometimes-transient memory requirements.
Create role <role>; grant <privilege> on <table> to <role>; grant <role> to <user>;

46. What is the PL/SQL function result cache?
This stores the results of a computation.
This parameter is used to automatically size and manage the SGA - PGA - and all memory used by them.
These all start with 'ora_'
ORACLE's work area for executing SQL

47. What is the first level of logical organization of your physical storage?
The parameter file is read at what point during database startup?
DB Block -- minimum size read into database buffer cache - OS Block - physical block determined when you format hard drive.
This process runs the job given to it by the CJQ0 process
The tablespace is what level of logical organization?

48. What is an Oracle Block?
This grants users access to the database.
Grant SELECT on <table> to <user>;
This logical structure is the minimum unit that Oracle will read or write at any given time.
This process is primarily responsible for instance recovery. Applies redo information. Cleans and releases temporary space

49. What information is NOT stored in redo logs
This lets you encrypt data in your database files
SELECT statement information are not stored in these files?
Allows you to group privileges for ease of management
Grant SELECT on <table> to <user> WITH GRANT OPTION;

50. What is Operating System Authentication?
You should switch these every 15-30 minutes
DBA_PRIV_AUDIT_OPTS is a view that does what?
Whenever successful - whenever not successful - by access - by session
Recognizes a user as logged into the OS and waives the password requirement.