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 server processes are there?
Free - Pinned - Dirty are what?
This process can be dedicated or shared
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.

2. What is the large pool?
This is the concept that adding and removing privileges from a role immediately affect all users who have the role.
SYSTEM - SYSAUX - UNDO - TEMP
When are connections with SYSDBA privilege audited?
This relieves the shared pool of sometimes-transient memory requirements.

3. What does process VKTM do?
Allows a user to grant an object privilege to another user.
This contains information used for private or session-related information that individual users need
This process is primarily responsible for instance recovery. Applies redo information. Cleans and releases temporary space
This processs provides a time reference within the database.

4. What is an Extent?
This stores the results of a computation.
This is the logical structure that makes up segments.
This is the first part of a data file.
This is a combination of memory and processes that are part of a running installation

5. What is the dictionary cache?

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

6. What are the 3 processes that are part of an instance?
This process runs the job given to it by the CJQ0 process
Background processes - Server Processes - User Processes are part of what?
This file should be named spfile<dbname>.ora
This process can be dedicated or shared

7. What is the Redo Log Buffer
This is a logical structure that represents objects in the database that require physical storage
This file should be named init<dbname>.ora
This records every SQL statement that changes data. The redo entry is in the redo log buffer before written to redo log.
This is a combination of memory and processes that are part of a running installation

8. What is Virtual Private Database?
This is a collection of information about you and the database's objects.
AUDIT_TRAIL is set to DB
These files contain information about how your running database is configured.
Row level security is this kind of database.

9. What is a segment
Users - Objects - System Privileges - Combination are things you can?
Database shutdown - full or partial checkpoint - recovery time threshold - free block is needed - some DDL commands - every three seconds
This contains the information used for backup and recovery - free space - file status details.
This is a logical structure that represents objects in the database that require physical storage

10. What are the names of the parameter files?
SELECT statement information are not stored in these files?
This process checks for scheduled tasks within the database.
What is OPS$
These are the PFILE and the SPFILE

11. How do you create an OS-Authenticated user?
DBA_STMT_AUDIT_OPTS is a view that does what?
This is a small - short-term staging area for change vectors before they are written to redo logs on disk.
This physical structure is the formatted size of the minimum unit of storage on the device
Create user OPS$REPORTS identified externally;

12. What options does a password profile allow you to have?
DBA_PRIV_AUDIT_OPTS is a view that does what?
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.
Recognizes a user as logged into the OS and waives the password requirement.
This is a small - short-term staging area for change vectors before they are written to redo logs on disk.

13. What SQL allows a user access to the database?
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 logical structure that makes up segments.
Grant create session to <user>;
This process resolves deadlock situations

14. What is an instance?
This is a combination of memory and processes that are part of a running installation
This tablespace stores the rollback or undo segments used for transaction recovery
This is a library of ready to go SQL Statements.
Tables - Indexes - Materialized Views - Partitions

15. How many databases can an instance mount to?
This can only mount to one database
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 minimum amount of storage that Oracle reads or writes.
What is OPS$

16. What do archive log and redo logs allow you to do?
This processs provides a time reference within the database.
What is OPS$
This is the first part of a data file.
If you have a full backup and copies of these you can recover from almost any type of failure.

17. What SQL revokes user access to the database?
Revoke create session from <user>;
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.
These are copies of redo log files
Data blocks copied into database buffer cache - relevant rows copied into user session PGA - blocks stay in cache until buffer needed for something else.

18. What is stored in the library cache
DBA_STMT_AUDIT_OPTS is a view that does what?
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.
Recognizes a user as logged into the OS and waives the password requirement.
Parsed SQL - syntax - objects are checked - Oracle permissions - p-code - optimum path or plan.

19. What is the highest privileged role?
Users - Objects - System Privileges - Combination are things you can?
This processs provides a time reference within the database.
SYSDBA is this kind of role.
Large Pool - Java Pool - Streams Pool

20. What does process DIA0 do?
This process resolves deadlock situations
This is a modification applied to something; executing DML generates these applied to data.
Background processes - Server Processes - User Processes are part of what?
These are copies of redo log files

21. Which SGA Structures are optional
Large Pool - Java Pool - Streams Pool
AUDIT_TRAIL is set to DB
Parsed SQL - syntax - objects are checked - Oracle permissions - p-code - optimum path or plan.
Memory used by sessions connecting to the database are not controlled by this parameter.

22. How does a shared server architecture work?
This is a logical structure that represents objects in the database that require physical storage
Create user OPS$REPORTS identified externally;
Grant create session to <user>;
Each concurrent database request gets a server process.

23. What does the server process do?
DBA_STMT_AUDIT_OPTS is a view that does what?
Users - Objects - System Privileges - Combination are things you can?
Free - Pinned - Dirty are what?
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.

24. What view lets you look at audits of privileges
The parameter file is read at what point during database startup?
Row level security is this kind of database.
CREATE PROFILE xxxxx LIMIT FAILED_LOGIN_ATTEMPTS 3;
DBA_PRIV_AUDIT_OPTS is a view that does what?

25. What kinds of blocks do data files have?
This stores the results of a computation.
This is a library of ready to go SQL Statements.
DB Block -- minimum size read into database buffer cache - OS Block - physical block determined when you format hard drive.
Data Files - Control Files - Redo Log Files - Archive Log Files - Server and initialization parameter files

26. What is the block header?
Grant SELECT on <table> to <user>;
Each concurrent database request gets a server process.
The logwriter (LGWR) writes to these files.
This is the first part of a data file.

27. What options can you add to audits?
Whenever successful - whenever not successful - by access - by session
Grant create session to <user>;
This is a logical structure that represents objects in the database that require physical storage
What is OPS$

28. What is an Oracle Block?
SELECT statement information are not stored in these files?
When are connections with SYSDBA privilege audited?
This logical structure is the minimum unit that Oracle will read or write at any given time.
This file should be named init<dbname>.ora

29. This logical structure gets created when you first create an object such as a table?
AUDIT - NOAUDIT
The first extent is created when?
CREATE PROFILE xxxxx LIMIT FAILED_LOGIN_ATTEMPTS 3;
This processs provides a time reference within the database.

30. What is a dirty buffer?
...
The parameter file is read at what point during database startup?
Background processes - Server Processes - User Processes are part of what?
Block in the database buffer cache does not match what is on disk.

31. What does process J000 do?
This relieves the shared pool of sometimes-transient memory requirements.
These are usually configured 3 groups with 2 mirrored members in each.
This process runs the job given to it by the CJQ0 process
These are the PFILE and the SPFILE

32. 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 the minimum amount of storage that Oracle reads or writes.
The tablespace is what level of logical organization?
Block in the database buffer cache does not match what is on disk.

33. What is the Log Buffer
This is a small - short-term staging area for change vectors before they are written to redo logs on disk.
Allows a user to grant an object privilege to another user.
The parameter file is read at what point during database startup?
This is the physical component or the files

34. What kinds of objects are not segments -but are pieces of code in the SYSTEM tablespace.
Row level security is this kind of database.
These are copies of redo log files
This logical structure organizes one or more data files.
Views - Procedures - Synonyms - Sequences

35. What is the UNDO tablespace used for?
This processs provides a time reference within the database.
V$TEMPFILE and V$DATAFILE contain this information?
You cannot restore a database with a complete collection of these from your last full backup.
This tablespace stores the rollback or undo segments used for transaction recovery

36. What is audited by default in Oracle 11g?
Allows you to group privileges for ease of management
Large Pool - Java Pool - Streams Pool
This process can be dedicated or shared
...

37. What naming convention should you use for your PFILE
This file should be named spfile<dbname>.ora
This file should be named init<dbname>.ora
The logwriter (LGWR) writes to these files.
V$MEMORY_TARGET_ADVICE

38. What physical structure does a tablespace correspond to?
Free - Pinned - Dirty are what?
The parameter file is read at what point during database startup?
Tables - Indexes - Materialized Views - Partitions
What logical structure do data files correspond to?

39. What are the 3 buffer cache states?
Whenever successful - whenever not successful - by access - by session
Grant create session to <user>;
Free - Pinned - Dirty are what?
This stores the results of a computation.

40. What view lets you look at audits of system privileges
These connections always get a dedicated server process.
Tables - Indexes - Materialized Views - Partitions
With this server process each user process gets its own server process. Server process waits on you. Most responsive.
DBA_STMT_AUDIT_OPTS is a view that does what?

41. What is the SYSTEM tablespace used for?
Grant SELECT on <table> to <user> WITH GRANT OPTION;
This tablespace stores the core database objects that are used for running the database itself
This process resolves deadlock situations
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

42. What does the WITH ADMIN OPTION do?
AUDIT_TRAIL is set to DB
Allows a user to grant an object privilege to another user.
Allows a user to grant a system privilege to another user.
This file should be named spfile<dbname>.ora

43. What does process CJQ0 do?
SYSTEM - SYSAUX - UNDO - TEMP
This cache is allocated at instance startup
This process checks for scheduled tasks within the database.
This tablespace stores the core database objects that are used for running the database itself

44. What is the Database Buffer Cache

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

45. 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.
Show parameter audit_file_dest;
Users - Objects - System Privileges - Combination are things you can?
Large Pool - Java Pool - Streams Pool

46. 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.
Background process that write database buffer cache to disk
This pool does not use LRU and will fill up.
This process takes dirty blocks from dirty list and writes them to disk.

47. What is stored in the block header
This controls what a user can do in the database. Primarily applies to adding or changing structures in the database.
This cache is allocated at instance startup
Background processes - Server Processes - User Processes are part of what?
This contains the information used for backup and recovery - free space - file status details.

48. Where does auditing data go by default
What goes into the table SYS.AUD$
Database shutdown - full or partial checkpoint - recovery time threshold - free block is needed - some DDL commands - every three seconds
DBA_PRIV_AUDIT_OPTS is a view that does what?
DBA_OBJ_AUDIT_OPTS is a view that does what?

49. Which view helps you size memory properly
This process takes dirty blocks from dirty list and writes them to disk.
V$MEMORY_TARGET_ADVICE
Data requested by user is found in the database buffer cache. No need to read from disk.
...

50. What is an OS Block?
This process flushes the redo log buffer. Writes redo entries to disk and signals a completion.
This physical structure is the formatted size of the minimum unit of storage on the device
Audit create table;
The first extent is created when?