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 an Extent?
Free - Pinned - Dirty are what?
Grant SELECT on <table> to <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 logical structure that makes up segments.

2. What is a segment
Block in the database buffer cache does not match what is on disk.
This is a logical structure that represents objects in the database that require physical storage
This process is primarily responsible for instance recovery. Applies redo information. Cleans and releases temporary space
Each concurrent database request gets a server process.

3. What kinds of server processes are there?
You should switch these every 15-30 minutes
Data requested by user is found in the database buffer cache. No need to read from disk.
This process can be dedicated or shared
What logical structure do data files correspond to?

4. How does a shared server architecture work?
Allows a user to grant an object privilege to another user.
Each concurrent database request gets a server process.
These connections always get a dedicated server process.
This is a special type of database file holding only information for sorts or temporary tables.

5. What is a tempfile?
You should switch these every 15-30 minutes
This grants users access to the database.
This logical structure organizes one or more data files.
This is a special type of database file holding only information for sorts or temporary tables.

6. how do you turn on or off auditing?
This is a collection of information about you and the database's objects.
AUDIT - NOAUDIT
This process takes dirty blocks from dirty list and writes them to disk.
Background process that write database buffer cache to disk

7. What prefix must precede the OS username for an OS-Authenticated user?
What is OPS$
This is the concept that adding and removing privileges from a role immediately affect all users who have the role.
This lets you encrypt data in your database files
This is a small - short-term staging area for change vectors before they are written to redo logs on disk.

8. What does process DIA0 do?
This process resolves deadlock situations
This is a logical structure that represents objects in the database that require physical storage
This process runs the job given to it by the CJQ0 process
Allows a user to grant a system privilege to another user.

9. What is a dirty buffer?
CREATE PROFILE xxxxx LIMIT FAILED_LOGIN_ATTEMPTS 3;
Block in the database buffer cache does not match what is on disk.
This relieves the shared pool of sometimes-transient memory requirements.
Grant SELECT on <table> to <user>;

10. What kinds of objects are not segments -but are pieces of code in the SYSTEM tablespace.
Memory Size - Database and Instance Name - Archiving parameters - Processes - Over 1900 other parameters
Views - Procedures - Synonyms - Sequences
This controls how a user can access actual data in the database. Primarily applies to rows in a table or a view.
These files are stored in ORACLE_HOME: $ORACLE_HOME/dbs - %ORACLE_HOMEdatabase

11. What SQL gives a user the ability to grant system privileges to another user?
This is the concept that adding and removing privileges from a role immediately affect all users who have the role.
Grant create session to <user> with admin option;
This process copies filled redo logs to the archived redo storage area. If you aren't in archive mode - this process shuts down.
Data Files - Control Files - Redo Log Files - Archive Log Files - Server and initialization parameter files

12. What is the highest privileged role?
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.
Whenever successful - whenever not successful - by access - by session
Parsed SQL - syntax - objects are checked - Oracle permissions - p-code - optimum path or plan.
SYSDBA is this kind of role.

13. What is the PL/SQL function result cache?
This stores the results of a computation.
Grant create session to <user> with admin option;
This process runs the job given to it by the CJQ0 process
Oracle background processes and server processes share this.

14. 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
This grants users access to the database.
You must have at least 2 of the log file groups.
These connections always get a dedicated server process.

15. How do you assign a password profile to a user
You must have at least 2 of the log file groups.
Alter user HR profile report_writer;
Background processes - Server Processes - User Processes are part of what?
DBA_OBJ_AUDIT_OPTS is a view that does what?

16. How many databases can an instance mount to?
Parsed SQL - syntax - objects are checked - Oracle permissions - p-code - optimum path or plan.
This can only mount to one database
This records every SQL statement that changes data. The redo entry is in the redo log buffer before written to redo log.
Data requested by user is found in the database buffer cache. No need to read from disk.

17. What are redo log files?
These files store information from the log buffer.
This contains information used for private or session-related information that individual users need
Free - Pinned - Dirty are what?
Commit - every three seconds - redo log buffer is 1/3 full - just before dirty block is written to disk.

18. When is database buffer cache allocated?
This contains the information used for backup and recovery - free space - file status details.
This cache is allocated at instance startup
SYSDBA is this kind of role.
This controls what a user can do in the database. Primarily applies to adding or changing structures in the database.

19. What actions are always audited
Large Pool - Java Pool - Streams Pool
This is the logical structure that makes up segments.
CREATE PROFILE xxxxx LIMIT FAILED_LOGIN_ATTEMPTS 3;
When are connections with SYSDBA privilege audited?

20. What is audited by default in Oracle 11g?
Create role <role>; grant <privilege> on <table> to <role>; grant <role> to <user>;
The tablespace is what level of logical organization?
...
This records every SQL statement that changes data. The redo entry is in the redo log buffer before written to redo log.

21. What is the SQL to grant an object privilege?
Grant SELECT on <table> to <user>;
Each concurrent database request gets a server process.
Allows a user to grant an object privilege to another user.
This is the first part of a data file.

22. What is the first level of logical organization of your physical storage?
Create user OPS$REPORTS identified externally;
The tablespace is what level of logical organization?
Background processes - Server Processes - User Processes are part of what?
This is the first part of a data file.

23. 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
Audit create table;
This cleans up failed processes by releasing resources and rolling back uncomitted data.
This is the first part of a data file.

24. What is a system privilege?
This is a combination of memory and processes that are part of a running installation
This controls what a user can do in the database. Primarily applies to adding or changing structures in the database.
This is a modification applied to something; executing DML generates these applied to data.
Alter user HR profile report_writer;

25. How does a dedicated server process work?
The parameter file is read at what point during database startup?
Grant SELECT on <table> to <user> WITH GRANT OPTION;
With this server process each user process gets its own server process. Server process waits on you. Most responsive.
Create user OPS$REPORTS identified externally;

26. What is a password profile
This forces a user to follow guidelines when creating or changing passwords.
Allows a user to grant an object privilege to another user.
This is a combination of memory and processes that are part of a running installation
Parsed SQL - syntax - objects are checked - Oracle permissions - p-code - optimum path or plan.

27. What options does a password profile allow you to have?
This tablespace stored objects that are auxiliary and not specifically tied to the core features of the database
Oracle background processes and server processes share this.
Allows you to group privileges for ease of management
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.

28. What options do you have for auditing?
This stores the results of a computation.
This processs provides a time reference within the database.
Users - Objects - System Privileges - Combination are things you can?
Recognizes a user as logged into the OS and waives the password requirement.

29. What is the SYSTEM tablespace used for?
This can only mount to one database
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.
This process flushes the redo log buffer. Writes redo entries to disk and signals a completion.
This tablespace stores the core database objects that are used for running the database itself

30. What view lets you look at audits of objects?
This process is primarily responsible for instance recovery. Applies redo information. Cleans and releases temporary space
DBA_OBJ_AUDIT_OPTS is a view that does what?
This cache is allocated at instance startup
This can only mount to one database

31. Is Auditing turned on by default?
Allows you to group privileges for ease of management
Memory used by sessions connecting to the database are not controlled by this parameter.
This is a small - short-term staging area for change vectors before they are written to redo logs on disk.
AUDIT_TRAIL is set to DB

32. What does the server process do?
This is a small - short-term staging area for change vectors before they are written to redo logs on disk.
This is a logical structure that represents objects in the database that require physical storage
This process is primarily responsible for instance recovery. Applies redo information. Cleans and releases temporary space
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.

33. What is the SYSAUX tablespace used for?
This is the concept that adding and removing privileges from a role immediately affect all users who have the role.
This tablespace stores the core database objects that are used for running the database itself
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.

34. What is Advanced Security Option
SYSDBA is this kind of role.
This lets you encrypt data in your database files
Allows a user to grant an object privilege to another user.
CREATE PROFILE xxxxx LIMIT FAILED_LOGIN_ATTEMPTS 3;

35. How should log files be configured?
This controls what a user can do in the database. Primarily applies to adding or changing structures in the database.
These are usually configured 3 groups with 2 mirrored members in each.
This process is primarily responsible for instance recovery. Applies redo information. Cleans and releases temporary space
DBA_PRIV_AUDIT_OPTS is a view that does what?

36. What does process DBWn do?
This tablespace stored objects that are auxiliary and not specifically tied to the core features of the database
This process takes dirty blocks from dirty list and writes them to disk.
This grants users access to the database.
Recognizes a user as logged into the OS and waives the password requirement.

37. What views contain information about your DB 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.
These files are stored in ORACLE_HOME: $ORACLE_HOME/dbs - %ORACLE_HOMEdatabase
DBA_OBJ_AUDIT_OPTS is a view that does what?
V$TEMPFILE and V$DATAFILE contain this information?

38. What is Virtual Private Database?
These are copies of redo log files
Row level security is this kind of database.
This is a modification applied to something; executing DML generates these applied to data.
These files are stored in ORACLE_HOME: $ORACLE_HOME/dbs - %ORACLE_HOMEdatabase

39. What does process ARCn do?

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

40. What does process VKTM do?
This relieves the shared pool of sometimes-transient memory requirements.
This processs provides a time reference within the database.
DBA_PRIV_AUDIT_OPTS is a view that does what?
This cleans up failed processes by releasing resources and rolling back uncomitted data.

41. What does process J000 do?
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 process runs the job given to it by the CJQ0 process
SELECT - INSERT - UPDATE - DELETE - REFERENCES - INDEX - ALTER - EXECUTE
This contains the information used for backup and recovery - free space - file status details.

42. How do you create an OS-Authenticated user?
You cannot restore a database with a complete collection of these from your last full backup.
Create user OPS$REPORTS identified externally;
This is the concept that adding and removing privileges from a role immediately affect all users who have the role.
This is a small - short-term staging area for change vectors before they are written to redo logs on disk.

43. What information is NOT stored in redo logs
Commit - every three seconds - redo log buffer is 1/3 full - just before dirty block is written to disk.
Oracle background processes and server processes share this.
This process can be dedicated or shared
SELECT statement information are not stored in these files?

44. What are the 3 processes that are part of an instance?
This file should be named init<dbname>.ora
Background processes - Server Processes - User Processes are part of what?
This physical structure is the formatted size of the minimum unit of storage on the device
Large Pool - Java Pool - Streams Pool

45. What do archive log and redo logs allow you to do?
If you have a full backup and copies of these you can recover from almost any type of failure.
This logical structure organizes one or more data files.
Allows a user to grant a system privilege to another user.
This is a collection of information about you and the database's objects.

46. What is the large pool?
This grants users access to the database.
This file should be named spfile<dbname>.ora
This relieves the shared pool of sometimes-transient memory requirements.
This process flushes the redo log buffer. Writes redo entries to disk and signals a completion.

47. What is dynamic privilege management?
This is the concept that adding and removing privileges from a role immediately affect all users who have the role.
CREATE PROFILE xxxxx LIMIT FAILED_LOGIN_ATTEMPTS 3;
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
V$TEMPFILE and V$DATAFILE contain this information?

48. 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.
Memory Size - Database and Instance Name - Archiving parameters - Processes - Over 1900 other parameters
Recognizes a user as logged into the OS and waives the password requirement.
Tables - Indexes - Materialized Views - Partitions

49. What do control files contain?
You cannot restore a database with a complete collection of these from your last full backup.
These connections always get a dedicated server process.
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.
This records every SQL statement that changes data. The redo entry is in the redo log buffer before written to redo log.

50. What does parameter MEMORY_TARGET not control?
These are the PFILE and the SPFILE
This contains information used for private or session-related information that individual users need
This cache is allocated at instance startup
Memory used by sessions connecting to the database are not controlled by this parameter.