MCQOPTIONS
Saved Bookmarks
MCQOPTIONS
This section includes 19 Mcqs, each offering curated multiple-choice questions to sharpen your Oracle (MCQ) questions and answers knowledge and support exam preparation. Choose a topic below to get started.
| 1. |
Select the correct SQL statement. |
| A. | Select * from global_name; |
| B. | Select from global_name; |
| C. | Select * from domain_name; |
| D. | Both A and C |
| Answer» B. Select from global_name; | |
| 2. |
Abbreviate the term OUI? |
| A. | Oracle Unicode Installer |
| B. | Oracle Universal Installer |
| C. | Oracle Universal Information |
| D. | Oracle Unicode Information |
| Answer» C. Oracle Universal Information | |
| 3. |
Which view lists all database links in the database? |
| A. | dba_db_links |
| B. | all_db_links |
| C. | user_db_links |
| D. | dba_link |
| Answer» B. all_db_links | |
| 4. |
Which methods are available for authenticating database administrators? |
| A. | A Password file |
| B. | Operations system |
| C. | Both A & B |
| D. | None of the above |
| Answer» D. None of the above | |
| 5. |
How many tasks present a prioritized approach for designing, implementing, and maintaining an Oracle Database in a Database Administrator? |
| A. | 10 |
| B. | 9 |
| C. | 8 |
| D. | 11 |
| Answer» E. | |
| 6. |
Which system privileges in the Administration Privileges allows access to a database instance even when the database is not open and the control of these privileges is totally outside of the database itself? |
| A. | SYSOPER |
| B. | SYSDBA |
| C. | Both A & B |
| D. | OSDBA |
| Answer» D. OSDBA | |
| 7. |
1. Which administrator's responsibilities can include the following tasks?1) Planning for backup and recovery of database information2) Maintaining archived data on tape3) Backing up and restoring the database4) Contacting Oracle for technical support |
| A. | Network Administrator |
| B. | Application Administrators |
| C. | Database Administrators |
| D. | Security Officers |
| Answer» D. Security Officers | |
| 8. |
Select the correct query to view the links that you own. |
| A. | select db_link from user_db_links; |
| B. | select _link from user_db_links; |
| C. | select db_link from dblinks; |
| D. | select link from user_db_links; |
| Answer» B. select _link from user_db_links; | |
| 9. |
Which Release number represents a major new version of the software that contains significant new functionality? |
| A. | Application Server Release Number |
| B. | Platform-Specific Release Number |
| C. | Component-Specific Release Number |
| D. | Major Database Release Number |
| Answer» E. | |
| 10. |
Which method is used by the clients to connect to the oracle database server? |
| A. | TCP/IP |
| B. | DECNET |
| C. | Both A & B |
| D. | None of the above |
| Answer» D. None of the above | |
| 11. |
How many user accounts are automatically created when Oracle Database is installed? |
| A. | 4 |
| B. | 3 |
| C. | 2 |
| D. | 1 |
| Answer» D. 1 | |
| 12. |
The syntax to create a synonym is:CREATE [PUBLIC] synonym_nameFOR [schema.]object_name[@database_link_name];In this syntax what specifies either a table, view, sequence, materialized view, type, procedure, function or package as appropriate? |
| A. | PUBLIC |
| B. | Synonym_name |
| C. | Schema |
| D. | Object_name |
| Answer» E. | |
| 13. |
Which server mode application uses a standard public database link in which 100 users simultaneously require a connection and then 100 direct network connections to the remote database are required? |
| A. | Deactivated/Shared server |
| B. | Shared Server |
| C. | Dedicated |
| D. | None of the above |
| Answer» B. Shared Server | |
| 14. |
In Database Administrator evaluate how Oracle Database and its applications can best use the available computer resources; this evaluation should reveal which of the following information? |
| A. | How many disk drives are available to the Oracle Products? |
| B. | How many, if any, dedicated tape drives are available to Oracle products |
| C. | How much memory is available to the instances of Oracle Database you will run |
| D. | All mentioned above |
| Answer» E. | |
| 15. |
Which task of the Database Administrator is available for cloning on Oracle home and on a database? |
| A. | Back Up the Fully Functional Database |
| B. | Tune Database Performance |
| C. | Download and Install Patches |
| D. | Roll Out to Additional Hosts |
| Answer» E. | |
| 16. |
A database link is a pointer in the local database that lets you access objects on a remote database in order to create a private database link. Which privilege is required for creation of any type of database link? |
| A. | CREATE DATABASE LINK |
| B. | CREATE PUBLIC DATABASE LINK |
| C. | CREATE SESSION |
| D. | Both A & B |
| Answer» D. Both A & B | |
| 17. |
Database users interact with the database through applications or utilities. Which of these tasks are a typical user's responsibilities? |
| A. | Entering, modifying, and deleting data |
| B. | Generating reports from the data |
| C. | Both A & B |
| D. | None of the above |
| Answer» D. None of the above | |
| 18. |
Which groups are created and assigned specific names as part of the database installation processin an Operating System Authentication? |
| A. | OSDBA |
| B. | OSOPER |
| C. | Both A & B |
| D. | None of the above |
| Answer» D. None of the above | |
| 19. |
Which are the several utilities that are available to help you maintain the data in your Oracle Database? |
| A. | SQL*Loader |
| B. | Export and Import Utilities |
| C. | Both A & B |
| D. | None of the above |
| Answer» D. None of the above | |