Test your basic knowledge |

Oracle Test

Subjects : oracle, it-skills
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. The ____ area stores parsed SQL in memory.






2. Current database files are stored in ____/<database name>.






3. ____ processes are only present in shared server mode to distribute user connection requests - between server processes.






4. The ____ initialization parameter defines the directory where all datafiles and tempfiles (files used for storage of temporary data during sorting and other operations) are to be created.






5. The ____ engine included with the Oracle software provides a specialized programming language you can use for creating triggers - packages - and procedures.






6. Load balancing between multiple listener processes is placed in the ____ configuration file on the client computer.






7. A(n) ____ database is used to service Internet applications.






8. OFA provides standards intended to improve performance of the database by - among other things - spreading I/O functions across separate devices...






9. ____ views provide system-related information by querying the database's internal management tables and presenting the data as views (metadata views).






10. The initialization configuration parameters file is ____.






11. The ____ initialization parameter defines one or more directories where control files and redo log files are to be created.






12. Whenever a change is made to data - the ____ stores a copy of the changed data and the original data - in case it is needed.






13. A(n) ____ database allows you to define anything and everything - this one is for the experts.






14. All Oracle software files and database storage files reside on subdirectories under ____.






15. The Oracle Net Services configuration is stored in the ____ configuration file on the client computer.






16. The ____ process cleans up after user sessions are finished.






17. The Oracle ____ tool provides the network link between the Oracle10g database and most applications that communicate with the database.






18. A ____ is a label given to a specific network configuration - usually a specific computer - at a specific TCP/IP address.






19. Setting a user connection as being dedicated or shared can be controlled in the client-side configuration of Oracle Net Services - in the ____ file.






20. When the ____ initialization parameter is set - Oracle 10g knows where to locate all the datafiles.






21. A ____ is a set of database structures - such as tables - indexes - user-defined attributes - and procedures.






22. The ____ tool guides you through database setup and creation using windows with instructions for each step.






23. SHUTDOWN ____ disconnects all users - rolls back pending transactions - and prohibits new connections and new transactions even for already connected users.






24. When choosing the DBA authentication method - you can choose between ____ and password file authentication.






25. The client configuration is a combination of the user interface tier and the...






26. SHUTDOWN ____waits for all users to log off - prohibits new connections - forcibly rolls back currently running transactions - and then shuts down the database.






27. A single machine can contain __________ value for ORACLE_HOME.






28. In the case of a ____ server - every user session (connection) has its own server process.






29. The script files generated by the DBCA tool include numerous SQL*Plus executable ____ files - a configuration parameter file called init.ora - and a batch file for executing all the scripts in a single shell command.






30. The database has a service called the ____ process. This process waits for requests and responds to requests as needed.






31. The ____ collects statistics about tables or objects - validates tables - finds continuing rows.






32. SHUTDOWN ____automatically completes and commits all pending transactions - then forcibly disconnects all connected users - and shuts down the database.






33. The DBCA tool executes the ____ for you - in order to configure the new database's Named Service.






34. A ____ file records changes to database data.






35. The ____ improves response time for background processes and for backup and recovery processes.






36. A ____ file is an administrative file containing up-to-date information on the database structure - log files - checkpoints; critical file for opening the database.






37. If you install Oracle10g Enterprise Edition - Standard Edition - or Personal Edition and choose to have a predefined database created on installation - the database is configured in ____ mode.






38. The <database name> is usually stored as the ____ environment variable






39. STARTUP ____ mounts the database files - essentially creating the connection between file pointers in the control file and the files themselves - such as datafiles and redo log files.






40. SHUTDOWN ____ simply stops all Oracle processes - and releases all memory buffers.






41. STARTUP ____ will open the database in read/write - unrestricted mode.






42. The ____ log is essential because it will contain all the essential information for the smooth running of your database.






43. ____ is a valid client installation configuration.






44. In Oracle10g the buffer cache can consist of multiple buffer caches - of different sizes. The default size is ____.






45. ____ is a valid client installation configuration.






46. The listener.ora file is stored in the ____ directory.






47. The ____ database configuration option allows for a lot of change activity - raising concurrency requirements - and lowering I/O activity requirements.






48. The DBA authentication method encompasses the method used to validate logon of users with the SYSDBA or ____ role.






49. Oracle has standardized its software so that it looks and acts identically at the user interface level on...






50. The ____ tool allows you to create and run queries - add rows - modify data - and write reports using SQL.







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


AP
CLEP
DSST
GRE
SAT
GMAT

Browse all subjects

Browse all tests

Most popular tests