Administering an Oracle Database - Oracle placement test
1) Database users interact with the database through applications or utilities. A typical user's responsibilities include which of these tasks?
A) Entering, modifying, and deleting data
B) Generating reports from the data
C) Both A & B
D) None of the above
View Answer / Hide Answer2) In Database Administrator how many tasks present a prioritized approach for designing, implementing, and maintaining an Oracle Database?
A) 10
B) 9
C) 8
D) 11
View Answer / Hide Answer3) In which task of the Database Administrator these two available cloning on Oracle home and cloning a database?
A) Back Up the Fully Functional Database
B) Tune Database Performance
C) Download and Install Patches
D) Roll Out to Additional Hosts
View Answer / Hide AnswerANSWER: D) Roll Out to Additional Hosts
4) In Release number format which digit is the most general identifier? It represents a major new version of the software that contains significant new functionality?
A) First digit
B) Second digit
C) Third digit
D) Fifth digit
View Answer / Hide Answer5) In Which Release number It represents a major new version of theSoftware 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
View Answer / Hide AnswerANSWER: D) Major Database Release Number
6) How many user accounts are automatically created when Oracle Database is installed?
A) 4
B) 3
C) 2
D) 1
View Answer / Hide Answer7) Abbreviate the term OUI?
A) Oracle Unicode Installer
B) Oracle Universal Installer
C) Oracle Universal Information
D) Oracle Unicode Information
View Answer / Hide AnswerANSWER: B) Oracle Universal Installer
8) In Administration Privileges which system privileges allow access to a database instance even when the database is not open, Control of these privileges is totally outside of the database itself?
A) SYSOPER
B) SYSDBA
C) Both A & B
D) OSDBA
View Answer / Hide Answer9) Which administrator's responsibilities can include the following tasks?
Planning for backup and recovery of database information
Maintaining archived data on tape
Backing up and restoring the database
Contacting Oracle for technical support
A) Network Administrator
B) Application Administrators
C) Database Administrators
D) Security Officers
View Answer / Hide AnswerANSWER: C) Database Administrators
10) 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
View Answer / Hide AnswerANSWER: D) All mentioned above
11) As a DBA, you often perform special operations such as shutting down or starting up a database?
A) True
B) False
View Answer / Hide Answer12) In Operating System Authentication which groups are created and assigned specific names as part of the database installation process?
A) OSDBA
B) OSOPER
C) Both A & B
D) None of the above
View Answer / Hide Answer13) Which methods are available for authenticating database administrators?
A) A Password file
B) Operations system
C) Both A & B
D) None of the above
View Answer / Hide Answer14) In Data Utilities several utilities 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
View Answer / Hide Answer
