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 kinds of blocks do data files have?
This is the concept that adding and removing privileges from a role immediately affect all users who have the role.
DB Block -- minimum size read into database buffer cache - OS Block - physical block determined when you format hard drive.
Users - Objects - System Privileges - Combination are things you can?
This is the physical component or the files

2. What are redo log files?
DBA_STMT_AUDIT_OPTS is a view that does what?
CREATE PROFILE xxxxx LIMIT FAILED_LOGIN_ATTEMPTS 3;
This file should be named init<dbname>.ora
These files store information from the log buffer.

3. What is an instance?
These files contain information about how your running database is configured.
This is a combination of memory and processes that are part of a running installation
Tables - Indexes - Materialized Views - Partitions
This pool does not use LRU and will fill up.

4. How many datafiles does a tablespace organize?
This is the concept that adding and removing privileges from a role immediately affect all users who have the role.
This logical structure organizes one or more data files.
This is a collection of information about you and the database's objects.
Database Buffer Cache - Log Buffer - Shared Pool

5. List the kinds of files used to run an Oracle Instance?
Data Files - Control Files - Redo Log Files - Archive Log Files - Server and initialization parameter files
What goes into the table SYS.AUD$
This process takes dirty blocks from dirty list and writes them to disk.
Grant create session to <user> with admin option;

6. What are the 8 object priviliges?
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.
What logical structure do data files correspond to?
SELECT - INSERT - UPDATE - DELETE - REFERENCES - INDEX - ALTER - EXECUTE
Data blocks copied into database buffer cache - relevant rows copied into user session PGA - blocks stay in cache until buffer needed for something else.

7. What is a database block?
Background processes - Server Processes - User Processes are part of what?
This logical structure is the minimum unit that Oracle will read or write at any given time.
These are usually configured 3 groups with 2 mirrored members in each.
This is the minimum amount of storage that Oracle reads or writes.

8. What is a segment
DBA_STMT_AUDIT_OPTS is a view that does what?
This is a logical structure that represents objects in the database that require physical storage
SELECT - INSERT - UPDATE - DELETE - REFERENCES - INDEX - ALTER - EXECUTE
Create role <role>; grant <privilege> on <table> to <role>; grant <role> to <user>;

9. What kind of server process does a DBA connection get?
These connections always get a dedicated server process.
CREATE PROFILE xxxxx LIMIT FAILED_LOGIN_ATTEMPTS 3;
This is the first part of a data file.
DBA_STMT_AUDIT_OPTS is a view that does what?

10. What is the highest privileged role?
DBA_PRIV_AUDIT_OPTS is a view that does what?
The logwriter (LGWR) writes to these files.
SYSDBA is this kind of role.
ORACLE's work area for executing SQL

11. What are the names of the parameter files?
These are the PFILE and the SPFILE
This contains the information used for backup and recovery - free space - file status details.
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 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.

12. What does process ARCn do?

13. What are the 3 processes that are part of an instance?
Background processes - Server Processes - User Processes are part of what?
The tablespace is what level of logical organization?
Recognizes a user as logged into the OS and waives the password requirement.
Tables - Indexes - Materialized Views - Partitions

14. How does a shared server architecture work?
Each concurrent database request gets a server process.
Create user OPS$REPORTS identified externally;
The parameter file is read at what point during database startup?
These are copies of redo log files

15. How does select use Database Buffer Cache
This is a library of ready to go SQL Statements.
Data blocks copied into database buffer cache - relevant rows copied into user session PGA - blocks stay in cache until buffer needed for something else.
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 is the physical component or the files

16. What SQL gives a user the ability to grant object privileges to another user?
This lets you encrypt data in your database files
DBA_OBJ_AUDIT_OPTS is a view that does what?
This tablespace stores the core database objects that are used for running the database itself
Grant SELECT on <table> to <user> WITH GRANT OPTION;

17. When is database buffer cache allocated?
Whenever successful - whenever not successful - by access - by session
When are connections with SYSDBA privilege audited?
This cache is allocated at instance startup
Allows a user to grant a system privilege to another user.

18. What does process DIA0 do?
When are connections with SYSDBA privilege audited?
This process resolves deadlock situations
Allows a user to grant a system privilege to another user.
Allows you to group privileges for ease of management

19. What options can you add to audits?
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.
Whenever successful - whenever not successful - by access - by session
Database Buffer Cache - Log Buffer - Shared Pool

20. how do you turn on or off auditing?
The first extent is created when?
This tablespace is used for temporary storage.
AUDIT - NOAUDIT
This logical structure organizes one or more data files.

21. Where does auditing data go by default
This can only mount to one database
The logwriter (LGWR) writes to these files.
Row level security is this kind of database.
What goes into the table SYS.AUD$

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
Show parameter audit_file_dest;
This lets you encrypt data in your database files
What is OPS$

23. What is the PL/SQL function result cache?
This stores the results of a computation.
These connections always get a dedicated server process.
This records every SQL statement that changes data. The redo entry is in the redo log buffer before written to redo log.
This process flushes the redo log buffer. Writes redo entries to disk and signals a completion.

24. What is an OS Block?
This controls what a user can do in the database. Primarily applies to adding or changing structures in the database.
This physical structure is the formatted size of the minimum unit of storage on the device
Parsed SQL - syntax - objects are checked - Oracle permissions - p-code - optimum path or plan.
These files store information from the log buffer.

25. 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.
Commit - every three seconds - redo log buffer is 1/3 full - just before dirty block is written to disk.
Database shutdown - full or partial checkpoint - recovery time threshold - free block is needed - some DDL commands - every three seconds

26. What SQL revokes user access to the database?
These files are stored in ORACLE_HOME: $ORACLE_HOME/dbs - %ORACLE_HOMEdatabase
Revoke create session from <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.
What logical structure do data files correspond to?

27. What kind of objects can be in a segment
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 is the first part of a data file.
Tables - Indexes - Materialized Views - Partitions

28. What happens during a log switch operation? What causes the following: LGWR finishes writing to the current group
Data requested by user is found in the database buffer cache. No need to read from disk.
LGWR starts writing to the next group - A Database checkpoint occurs - The DBWR writes dirty blocks our of the buffer cascade
This is the logical structure that makes up segments.
These files contain information about how your running database is configured.

29. What SQL allows a user access to the database?
The logwriter (LGWR) writes to these files.
Grant create session to <user>;
Show parameter audit_file_dest;
The first extent is created when?

30. What does process SMON do
This process is primarily responsible for instance recovery. Applies redo information. Cleans and releases temporary space
These files contain information about how your running database is configured.
The parameter file is read at what point during database startup?
This is the first part of a data file.

31. What does a database role do?
Grant create session to <user> with admin option;
This stores the results of a computation.
This pool does not use LRU and will fill up.
Allows you to group privileges for ease of management

32. What SQL gives a user the ability to grant system privileges to another user?
This parameter is used to automatically size and manage the SGA - PGA - and all memory used by them.
This contains information used for private or session-related information that individual users need
Recognizes a user as logged into the OS and waives the password requirement.
Grant create session to <user> with admin option;

33. What views contain information about your DB Files?
Parsed SQL - syntax - objects are checked - Oracle permissions - p-code - optimum path or plan.
This is a special type of database file holding only information for sorts or temporary tables.
CREATE PROFILE xxxxx LIMIT FAILED_LOGIN_ATTEMPTS 3;
V$TEMPFILE and V$DATAFILE contain this information?

34. What is the Database Buffer Cache

35. What is a dirty buffer?
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.
If you have a full backup and copies of these you can recover from almost any type of failure.

36. What is the Program Global Area -- PGA?
You must have at least 2 of the log file groups.
This contains the information used for backup and recovery - free space - file status details.
Create user OPS$REPORTS identified externally;
This contains information used for private or session-related information that individual users need

37. Which process writes to the Redo Log Files?
Parsed SQL - syntax - objects are checked - Oracle permissions - p-code - optimum path or plan.
Allows a user to grant a system privilege to another user.
The logwriter (LGWR) writes to these files.
This lets you encrypt data in your database files

38. What is the large pool?
This relieves the shared pool of sometimes-transient memory requirements.
The tablespace is what level of logical organization?
What logical structure do data files correspond to?
Data blocks copied into database buffer cache - relevant rows copied into user session PGA - blocks stay in cache until buffer needed for something else.

39. What is Advanced Security Option
This lets you encrypt data in your database files
These are usually configured 3 groups with 2 mirrored members in each.
Memory Size - Database and Instance Name - Archiving parameters - Processes - Over 1900 other parameters
This process takes dirty blocks from dirty list and writes them to disk.

40. What options do you have for auditing?
This is the logical structure that makes up segments.
Users - Objects - System Privileges - Combination are things you can?
If you have a full backup and copies of these you can recover from almost any type of failure.
This file should be named spfile<dbname>.ora

41. What is dynamic privilege management?
AUDIT - NOAUDIT
This is the concept that adding and removing privileges from a role immediately affect all users who have the role.
Allows a user to grant an object privilege to another user.
The first extent is created when?

42. What SQL Would let you audit people creating tables?
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
This is written in PL/SQL and examines passwords when they're chosen and accepts or rejects them based on criteria.
Audit create table;

43. What is a change vector?
This is the first part of a data file.
This is a modification applied to something; executing DML generates these applied to data.
This stores the results of a computation.
This is a logical structure that represents objects in the database that require physical storage

44. What is a database
This forces a user to follow guidelines when creating or changing passwords.
This is the physical component or the files
What goes into the table SYS.AUD$
DB Block -- minimum size read into database buffer cache - OS Block - physical block determined when you format hard drive.

45. What is the minimum number of redo log groups you must have?
This process runs the job given to it by the CJQ0 process
You must have at least 2 of the log file groups.
LGWR starts writing to the next group - A Database checkpoint occurs - The DBWR writes dirty blocks our of the buffer cascade
This logical structure organizes one or more data files.

46. What does process J000 do?
This process runs the job given to it by the CJQ0 process
This process can be dedicated or shared
Views - Procedures - Synonyms - Sequences
Database Buffer Cache - Log Buffer - Shared Pool

47. What is the Log Buffer
This contains information used for private or session-related information that individual users need
This is a small - short-term staging area for change vectors before they are written to redo logs on disk.
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

48. What uses the large pool?
These use which pool? Oracle Recovery Manager - Oracle Shared Server - Parallel processing - I/O-related server processes.
What logical structure do data files correspond to?
This logical structure organizes one or more data files.
Block in the database buffer cache does not match what is on disk.

49. What view lets you look at audits of privileges
This process resolves deadlock situations
Audit create table;
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.
DBA_PRIV_AUDIT_OPTS is a view that does what?

50. What is a password verify function