| 1: | Through what Windows-only, browser-based interface would you enter SQL statements to retrieve information from the database? A. SQL*Plus B. OEM C. SQL Worksheet D. iSQL*Plus
|
| A1: | Answer D is correct; iSQL*Plus is the Windows browser-based interface that you use to access or manipulate data in the database. Answer A is incorrect; SQL*Plus is a command-line interface but is not browser based. Answer B is incorrect; OEM itself provides a command-line interface but is not only on Windows. Answer C is incorrect; SQL Worksheet is the interface presented through OEM but is not a Windows-only interface. |
| 2: | What is one thing that you cannot do through the OEM interface? A. Start a database B. Create users C. Delete roles D. Create tablespaces E. Create a database
|
| A2: | Answer E is correct; the only thing listed that you cannot do through the OEM interface is create a new database. Answers A, B, C, and D are all incorrect because you can create all these things through the OEM interface. |
| 3: | What utility do you run to create the password file? A. runInstaller B. orapwd C. OEM D. iSQL*Plus
|
| A3: | Answer B is correct; running orapwd creates the password file. Answer A is incorrect; runInstaller runs the Java-based installation interface. Answer C is incorrect; OEM offers no direct way to create a password file. Answer D is incorrect; iSQL*Plus is a command-line interface, not a password creation utility. |
| 4: | What is Oracle's Java-based installation utility? |
| A4: | Answer C is correct; the name of the Java-based utility used to install the Oracle software is the Oracle Universal Installer. Answer A is incorrect; runInstaller is the command used in Unix to launch the OUI. Answer B is incorrect; it is referred to as Oracle Universal Installer because it is universally employed across any Java-enabled platform. Answer D is incorrect; you do not use the OEM utility to install the software. |
| 5: | Users with what roles can be governed by the password file? [select all that apply] A. DBA B. SYSDBA C. SYSTEM D. SYSOPER E. PUBLIC
|
| A5: | Answers B and D are correct; the password file can be used to govern the access to the database by those who have been defined with the role of SYSDBA or SYSOPER. Answer A is incorrect; DBA role information is not stored in the password file. Answer C is incorrect; SYSTEM is a userid not a role. Answer E is incorrect; PUBLIC is not a role governed in the password file. |
| 6: | What is the difference between interactive and noninteractive mode of the OUI? [select all that apply] A. OUI runs in character mode in noninteractive. B. Interactive mode means that you deliberately answer questions interactively. C. Interactive mode is character mode. D. Noninteractive mode uses a response file.
|
| A6: | Answers B and D are correct; interactive means that you actively answer questions as you go, and noninteractive means that you have those answers in a response file. Answers A and C are incorrect; neither interactive nor noninteractive modes means that the installer will be running in character mode. |
| 7: | What utility is used to create and configure databases? [select all that apply] A. OEM B. OUI C. DBCA D. OMS
|
| A7: | Answers B and C are correct; DBCA (Database Configuration Assistant) is used to create and configure databases, and OUI calls DBCA if you choose to create an initial database as an installation choice. Answer A is incorrect; OEM does not allow you to create a new database. Answer D is incorrect; OMS is a component of OEM. |
| 8: | What is not an advantage of OFA? A. It allows you to separate objects with different behaviors into different tablespaces. B. It assists you with organization of a large amount of software components, products, and data. C. It allows you to install all binaries into the same Oracle home. D. It helps to separate software from data.
|
| A8: | Answer C is correct; the only given answer that is not an advantage of OFA is that it allows you to install all binaries into a single Oracle home. Separation into individual Oracle homes is a vital way to maintain Oracle software products and is the only way to install different versions of the binaries on a single physical server. |
| 9: | What is the default password for SYS when the database is created with DBCA? |
| A9: | Answer D is correct; DBCA makes you choose your own password for both the SYS and SYSTEM users. Answer A is incorrect; change_on_install is the default password if you create the database manually. Answer B is incorrect; manager is the default SYSTEM password if you create the database manually. Answer C is incorrect; sys is not anyone's default password. |
| 10: | You have been hired as a DBA in a company. What tool would you use to get a quick idea of all the databases running in the company? A. OEM B. OUI C. SQL*Plus D. DBCA
|
| A10: | Answer A is correct; OEM can give you an overall idea of all running databases and their objects and components. Answer B is incorrect; OUI installs databases but does not provide any information on already running databases. Answer C is incorrect; you need a basic idea of what databases are accessible to use SQL*Plus. Answer D is incorrect; DBCA configures an existing database but does not tell you what databases are running. |
