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 are the 3 processes that are part of an instance?
This process can be dedicated or shared
Background processes - Server Processes - User Processes are part of what?
This is a collection of information about you and the database's objects.
Grant create session to <user> with admin option;

2. How does a shared server architecture work?
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 logical structure organizes one or more data files.
Each concurrent database request gets a server process.
Commit - every three seconds - redo log buffer is 1/3 full - just before dirty block is written to disk.

3. When does the large pool get cleaned out?
Create role <role>; grant <privilege> on <table> to <role>; grant <role> to <user>;
This pool does not use LRU and will fill up.
AUDIT - NOAUDIT
Background processes - Server Processes - User Processes are part of what?

4. What does the WITH GRANT OPTION do?
Memory used by sessions connecting to the database are not controlled by this parameter.
Allows a user to grant an object privilege to another user.
This forces a user to follow guidelines when creating or changing passwords.
This tablespace stores the rollback or undo segments used for transaction recovery

5. Where does auditing data go by default
Grant SELECT on <table> to <user> WITH GRANT OPTION;
This tablespace stores the core database objects that are used for running the database itself
What goes into the table SYS.AUD$
This is a collection of information about you and the database's objects.

6. How does updating use Database Buffer Cache
If you have a full backup and copies of these you can recover from almost any type of failure.
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 can be dedicated or shared
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.

7. What does parameter MEMORY_TARGET do?
This logical structure is the minimum unit that Oracle will read or write at any given time.
These are copies of redo log files
This parameter is used to automatically size and manage the SGA - PGA - and all memory used by them.
This contains the information used for backup and recovery - free space - file status details.

8. What is a buffer cache hit?
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.
This process resolves deadlock situations
Commit - every three seconds - redo log buffer is 1/3 full - just before dirty block is written to disk.

9. What options can you add to audits?
Parsed SQL - syntax - objects are checked - Oracle permissions - p-code - optimum path or plan.
Whenever successful - whenever not successful - by access - by session
This is written in PL/SQL and examines passwords when they're chosen and accepts or rejects them based on criteria.
This process resolves deadlock situations

10. When is the redo log buffer flushed?
This contains information used for private or session-related information that individual users need
Commit - every three seconds - redo log buffer is 1/3 full - just before dirty block is written to disk.
This process can be dedicated or shared
Audit create table;

11. Where are the PFILE and SPFILE stored?
This is a small - short-term staging area for change vectors before they are written to redo logs on disk.
This tablespace is used for temporary storage.
These files are stored in ORACLE_HOME: $ORACLE_HOME/dbs - %ORACLE_HOMEdatabase
This relieves the shared pool of sometimes-transient memory requirements.

12. What views contain information about your DB Files?
V$TEMPFILE and V$DATAFILE contain this information?
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 is the minimum unit that Oracle will read or write at any given time.
These files store information from the log buffer.

13. how do you turn on or off auditing?
When are connections with SYSDBA privilege audited?
This is a library of ready to go SQL Statements.
If you have a full backup and copies of these you can recover from almost any type of failure.
AUDIT - NOAUDIT

14. What happens if you are missing an archive log?
Data blocks copied into database buffer cache - relevant rows copied into user session PGA - blocks stay in cache until buffer needed for something else.
This file should be named spfile<dbname>.ora
Database Buffer Cache - Log Buffer - Shared Pool
You cannot restore a database with a complete collection of these from your last full backup.

15. What is audited by default in Oracle 11g?
...
Background processes - Server Processes - User Processes are part of what?
AUDIT_TRAIL is set to DB
This controls what a user can do in the database. Primarily applies to adding or changing structures in the database.

16. What is the SQL for creating a password profile
The tablespace is what level of logical organization?
These files contain information about how your running database is configured.
Views - Procedures - Synonyms - Sequences
CREATE PROFILE xxxxx LIMIT FAILED_LOGIN_ATTEMPTS 3;

17. What is Operating System Authentication?
Recognizes a user as logged into the OS and waives the password requirement.
This controls what a user can do in the database. Primarily applies to adding or changing structures in the database.
The tablespace is what level of logical organization?
This processs provides a time reference within the database.

18. What is stored in the block header
CREATE PROFILE xxxxx LIMIT FAILED_LOGIN_ATTEMPTS 3;
These are usually configured 3 groups with 2 mirrored members in each.
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.

19. What does parameter MEMORY_TARGET not control?
Grant create session to <user> with admin option;
Parsed SQL - syntax - objects are checked - Oracle permissions - p-code - optimum path or plan.
The tablespace is what level of logical organization?
Memory used by sessions connecting to the database are not controlled by this parameter.

20. What is the database writer process?
Grant SELECT on <table> to <user> WITH GRANT OPTION;
Parsed SQL - syntax - objects are checked - Oracle permissions - p-code - optimum path or plan.
Recognizes a user as logged into the OS and waives the password requirement.
Background process that write database buffer cache to disk

21. What actions are always audited
When are connections with SYSDBA privilege audited?
CREATE PROFILE xxxxx LIMIT FAILED_LOGIN_ATTEMPTS 3;
SELECT - INSERT - UPDATE - DELETE - REFERENCES - INDEX - ALTER - EXECUTE
SELECT statement information are not stored in these files?

22. What uses the large pool?
These use which pool? Oracle Recovery Manager - Oracle Shared Server - Parallel processing - I/O-related server processes.
This is a combination of memory and processes that are part of a running installation
This logical structure organizes one or more data files.
This relieves the shared pool of sometimes-transient memory requirements.

23. What are redo log files?
Parsed SQL - syntax - objects are checked - Oracle permissions - p-code - optimum path or plan.
These files store information from the log buffer.
Block in the database buffer cache does not match what is on disk.
What is OPS$

24. What information is NOT stored in redo logs
SELECT statement information are not stored in these files?
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 process flushes the redo log buffer. Writes redo entries to disk and signals a completion.
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 is an object privilege?
This is a library of ready to go SQL Statements.
This controls how a user can access actual data in the database. Primarily applies to rows in a table or a view.
Create user OPS$REPORTS identified externally;
AUDIT_TRAIL is set to DB

26. What is a system privilege?
This contains information used for private or session-related information that individual users need
This controls what a user can do in the database. Primarily applies to adding or changing structures in the database.
Database shutdown - full or partial checkpoint - recovery time threshold - free block is needed - some DDL commands - every three seconds
Whenever successful - whenever not successful - by access - by session

27. What does process DBWn do?
This records every SQL statement that changes data. The redo entry is in the redo log buffer before written to redo log.
Memory used by sessions connecting to the database are not controlled by this parameter.
This process takes dirty blocks from dirty list and writes them to disk.
Row level security is this kind of database.

28. What view lets you look at audits of privileges
V$MEMORY_TARGET_ADVICE
DBA_PRIV_AUDIT_OPTS is a view that does what?
This is the minimum amount of storage that Oracle reads or writes.
This file should be named spfile<dbname>.ora

29. Which view helps you size memory properly
Data requested by user is found in the database buffer cache. No need to read from disk.
V$MEMORY_TARGET_ADVICE
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.
If you have a full backup and copies of these you can recover from almost any type of failure.

30. What options do you have for auditing?
Memory Size - Database and Instance Name - Archiving parameters - Processes - Over 1900 other parameters
This is written in PL/SQL and examines passwords when they're chosen and accepts or rejects them based on criteria.
Memory used by sessions connecting to the database are not controlled by this parameter.
Users - Objects - System Privileges - Combination are things you can?

31. What is Advanced Security Option
These files store information from the log buffer.
This lets you encrypt data in your database files
Free - Pinned - Dirty are what?
These all start with 'ora_'

32. What SQL Would let you audit people creating tables?
This is the concept that adding and removing privileges from a role immediately affect all users who have the role.
This controls what a user can do in the database. Primarily applies to adding or changing structures in the database.
These all start with 'ora_'
Audit create table;

33. What is the large pool?
You must have at least 2 of the log file groups.
This stores the results of a computation.
This is the logical structure that makes up segments.
This relieves the shared pool of sometimes-transient memory requirements.

34. What does process ARCn do?

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

35. What is a database block?
This process can be dedicated or shared
This is the minimum amount of storage that Oracle reads or writes.
Block in the database buffer cache does not match what is on disk.
Oracle background processes and server processes share this.

36. What prefix must precede the OS username for an OS-Authenticated user?
This is a small - short-term staging area for change vectors before they are written to redo logs on disk.
This process is primarily responsible for instance recovery. Applies redo information. Cleans and releases temporary space
What is OPS$
Whenever successful - whenever not successful - by access - by session

37. How do you assign a password profile to a user
V$MEMORY_TARGET_ADVICE
Data requested by user is found in the database buffer cache. No need to read from disk.
This is the logical structure that makes up segments.
Alter user HR profile report_writer;

38. What is a segment
This is a logical structure that represents objects in the database that require physical storage
This controls what a user can do in the database. Primarily applies to adding or changing structures in the database.
These connections always get a dedicated server process.
This is a combination of memory and processes that are part of a running installation

39. What is the TEMP tablespace used for?
This logical structure is the minimum unit that Oracle will read or write at any given time.
This tablespace is used for temporary storage.
These files contain information about how your running database is configured.
The tablespace is what level of logical organization?

40. What is a change vector?
This is a modification applied to something; executing DML generates these applied to data.
Data blocks copied into database buffer cache - relevant rows copied into user session PGA - blocks stay in cache until buffer needed for something else.
These connections always get a dedicated server process.
This cleans up failed processes by releasing resources and rolling back uncomitted data.

41. What is a tempfile?
This is the physical component or the files
This is a special type of database file holding only information for sorts or temporary tables.
This process runs the job given to it by the CJQ0 process
This cleans up failed processes by releasing resources and rolling back uncomitted data.

42. List the kinds of files used to run an Oracle Instance?
Oracle background processes and server processes share this.
This is a logical structure that represents objects in the database that require physical storage
Data Files - Control Files - Redo Log Files - Archive Log Files - Server and initialization parameter files
AUDIT - NOAUDIT

43. 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.
Parsed SQL - syntax - objects are checked - Oracle permissions - p-code - optimum path or plan.
If you have a full backup and copies of these you can recover from almost any type of failure.
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.

44. What are the 3 buffer cache states?
Free - Pinned - Dirty are what?
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.
Audit create table;
Allows you to group privileges for ease of management

45. What is a dirty buffer?
Free - Pinned - Dirty are what?
Allows a user to grant an object privilege to another user.
Block in the database buffer cache does not match what is on disk.
With this server process each user process gets its own server process. Server process waits on you. Most responsive.

46. What is the PL/SQL function result cache?
This stores the results of a computation.
These are usually configured 3 groups with 2 mirrored members in each.
Recognizes a user as logged into the OS and waives the password requirement.
ORACLE's work area for executing SQL

47. What SQL allows a user access to the database?
Grant create session to <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.
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.

48. What is stored in the library cache
Tables - Indexes - Materialized Views - Partitions
Parsed SQL - syntax - objects are checked - Oracle permissions - p-code - optimum path or plan.
The first extent is created when?
CREATE PROFILE xxxxx LIMIT FAILED_LOGIN_ATTEMPTS 3;

49. What is the first level of logical organization of your physical storage?
This is a library of ready to go SQL Statements.
These all start with 'ora_'
Alter user HR profile report_writer;
The tablespace is what level of logical organization?

50. What do archive log and redo logs allow you to do?
Recognizes a user as logged into the OS and waives the password requirement.
Allows you to group privileges for ease of management
If you have a full backup and copies of these you can recover from almost any type of failure.
These use which pool? Oracle Recovery Manager - Oracle Shared Server - Parallel processing - I/O-related server processes.

Sorry!:) No result found.

Can you answer 50 questions in 15 minutes?

Major Subjects
Tests & Exams AP CLEP DSST GRE SAT GMAT	Certifications CISSP go to https://www.isc2.org/ PMP ITIL RHCE MCTS More...	IT Skills Android Programming Data Modeling Objective C Programming Basic Python Programming Adobe Illustrator More...	Business Skills Advertising Techniques Business Accounting Basics Business Strategy Human Resource Management Marketing Basics More...
Soft Skills Body Language People Skills Public Speaking Persuasion Job Hunting And Resumes More...	Vocabulary GRE Vocab SAT Vocab TOEFL Essential Vocab Basic English Words For All Global Words You Should Know Business English More...	Languages AP German Vocab AP Latin Vocab SAT Subject Test: French Italian Survival Norwegian Survival More...	Engineering Audio Engineering Computer Science Engineering Aerospace Engineering Chemical Engineering Structural Engineering More...
Health Sciences Basic Nursing Skills Health Science Language Fundamentals Veterinary Technology Medical Language Cardiology Clinical Surgery More...	English Grammar Fundamentals Literary And Rhetorical Vocab Elements Of Style Vocab Introduction To English Major Complete Advanced Sentences Literature Homonyms More...	Math Algebra Formulas Basic Arithmetic: Measurements Metric Conversions Geometric Properties Important Math Facts Number Sense Vocab Business Math More...	Other Major Subjects Science Economics History Law Performing-arts Cooking Logic & Reasoning Trivia

Test your basic knowledge |

Oracle 11g

Sorry!:) No result found.

Can you answer 50 questions in 15 minutes?

Let me suggest you:

Browse all subjects

Browse all tests

Most popular tests

Major Subjects

Tests & Exams

Certifications

IT Skills

Business Skills

Soft Skills

Vocabulary

Languages

Engineering

Health Sciences

English

Math

Other Major Subjects

Browse all subjects

Browse all tests

Most popular tests