1) Sufficient disk storage space must be available for the planned database on the computer that runs Oracle Database.
a. True
b. False
|
Answer
Explanation
|
ANSWER: True
Explanation:
No explanation is available for this question!
|
|
2) Abbreviate the term DBCA?
a. Database Control Assistant
b. Database Configuration Application
c. Database Control Application
d. Database Configuration Assistant
|
Answer
Explanation
|
ANSWER: Database Configuration Assistant
Explanation:
No explanation is available for this question!
|
|
3) If you want the user APP_DBA to administer the oracle database from a remote machine .APP_DBA is granted the SYSDBA privilege to perform administrative tasks on the database. Which file is used by the Oracle database server to authenticate APP_DBA?
a. Control file
b. Password file
c. Listener controller file
d. Control file and password file
|
Answer
Explanation
|
ANSWER: Password file
Explanation:
No explanation is available for this question!
|
|
4) When a job is stopped, only the current transaction is rolled back. This can cause data inconsistency.
a. True
b. False
|
Answer
Explanation
|
ANSWER: True
Explanation:
No explanation is available for this question!
|
|
5) 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
Explanation
|
ANSWER: Major Database Release Number
Explanation:
No explanation is available for this question!
|
|
6) 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
Explanation
|
ANSWER: Both A & B
Explanation:
No explanation is available for this question!
|
|
7) The PMON (process monitor) background process can terminate shared servers below the value specified by SHARED_SERVERS.
a. True
b. False
|
Answer
Explanation
|
ANSWER: False
Explanation:
No explanation is available for this question!
|
|
8) What is the use of Library cache?
a. Contains User information, such as user privileges
b. Used to store shared SQL
c. Log of changes made to the database
d. All of the above
|
Answer
Explanation
|
ANSWER: Used to store shared SQL
Explanation:
No explanation is available for this question!
|
|
9) What alternative does a hash cluster provide to a non-clustered table?
a. Index
b. Index Cluster
c. Both A & B
d. None of the above
|
Answer
Explanation
|
ANSWER: Both A & B
Explanation:
No explanation is available for this question!
|
|
10) When you drop a single table from a cluster, the database deletes which row of the table?
a. Column data
b. Row data
c. Each row
d. Only deletes few data
|
Answer
Explanation
|
ANSWER: Each row
Explanation:
No explanation is available for this question!
|
|
11) Oracle strongly recommends that your database has a minimum of four control files and that they are located on separate physical disks.
a. True
b. False
|
Answer
Explanation
|
ANSWER: False
Explanation:
No explanation is available for this question!
|
|
12) Which Shutdown Mode in the ASM instance immediately shuts down without the orderly dismount of disk groups?
a. ABORT
b. NORMAL
c. IMMEDIATE
d. TRANSACTIONAL
|
Answer
Explanation
|
ANSWER: ABORT
Explanation:
No explanation is available for this question!
|
|
13) What is used by Oracle during Table and Index creation and for sorting?
a. Tables
b. Indexes
c. Temporary Segments
d. Schemas
|
Answer
Explanation
|
ANSWER: Temporary Segments
Explanation:
No explanation is available for this question!
|
|
14) How many types of database links does the oracle database lets you create?
a. 2
b. 3
c. 4
d. 5
|
Answer
Explanation
|
ANSWER: 3
Explanation:
No explanation is available for this question!
|
|
15) To close a database link connection in your user session, you must have the ALTER SESSION system privilege.
a. True
b. False
|
Answer
Explanation
|
ANSWER: True
Explanation:
No explanation is available for this question!
|
|
16) How many partitioning keys columns are specified for range-and-hash-partitioning tables?
a. 18
b. 14
c. 16
d. 17
|
Answer
Explanation
|
ANSWER: 16
Explanation:
No explanation is available for this question!
|
|
17) If a table is dropped, all associated indexes are dropped automatically.
a. True
b. False
|
Answer
Explanation
|
ANSWER: True
Explanation:
No explanation is available for this question!
|
|
18) What is the default size of an Oracle-managed redo log file?
a. 50MB
b. 100MB
c. 60MB
d. 120MB
|
Answer
Explanation
|
ANSWER: 100MB
Explanation:
No explanation is available for this question!
|
|
19) A log switch is the point at which the database starts writing to one redo log file and begins writing to another.
a. True
b. False
|
Answer
Explanation
|
ANSWER: False
Explanation:
No explanation is available for this question!
|
|
20) What do you mean by Quiescence?
a. Act of suspending DML activity for all tables in a given replication group
b. Act of suspending DML activity for selected tables in a given replication group
c. Act of granting DML activity for selected tables in a given replication group
d. Act of granting DML activity for all tables in a given replication group
|
Answer
Explanation
|
ANSWER: Act of suspending DML activity for all tables in a given replication group
Explanation:
No explanation is available for this question!
|
|
21) The storage parameters for temporary segments always use the default storage parameters set for the associated tablespace.
a. True
b. False
|
Answer
Explanation
|
ANSWER: True
Explanation:
No explanation is available for this question!
|
|
22) Which two are the valid locking levels that are used by transactions in an Oracle database?
a. Row level
b. Block level
c. Object level
d. Schema level
e. Both A & C
|
Answer
Explanation
|
ANSWER: Both A & C
Explanation:
No explanation is available for this question!
|
|
23) Which tables in the Tables schema cannot be redefined?
a. SYS
b. SYSTEM
c. Both A & B
d. None of the above
|
Answer
Explanation
|
ANSWER: Both A & B
Explanation:
No explanation is available for this question!
|
|
24) Which operations require undo data?
a. Committing a transaction
b. Rolling back a transaction
c. Recovering from failed transactions
d. Both B & C
e. Both A & B
|
Answer
Explanation
|
ANSWER: Both B & C
Explanation:
No explanation is available for this question!
|
|
25) What is an executable SQL statement?
a. A statement that can be executed without errors
b. Statement that generates calls to an instance, including DDL statements only.
c. Statement that generates calls to an instance including statements only.
d. Statement that generates calls to an instance, including DML and DDL statements.
|
Answer
Explanation
|
ANSWER: Statement that generates calls to an instance, including DML and DDL statements.
Explanation:
No explanation is available for this question!
|
|
