1) Which two database operations can be performed at the MOUNT stage of database startup?
a. Renaming of data files
b. Dropping the database user
c. Configuring the database in ARCHIVELOG mode
d. Both A & C
e. Both B & C
|
Answer
Explanation
|
ANSWER: Both A & C
Explanation:
No explanation is available for this question!
|
|
2) What indicates whether there was a problem accessing the destination in an Archive Destination Status?
a. Enabled/Disabled
b. Active/Inactive
c. Valid/Invalid
d. All mentioned above
|
Answer
Explanation
|
ANSWER: Active/Inactive
Explanation:
No explanation is available for this question!
|
|
3) What is a redo record called?
a. Redo entry
b. Redo thread
c. Both A & B
d. None of the above
|
Answer
Explanation
|
ANSWER: Redo entry
Explanation:
No explanation is available for this question!
|
|
4) What is replication support used for?
a. Perform certain administrative tasks on objects in a replication group
b. Database performance tuning
c. Detect and resolve conflicts
d. All of above
|
Answer
Explanation
|
ANSWER: Detect and resolve conflicts
Explanation:
No explanation is available for this question!
|
|
5) Which of the following errors are correctable?
a. Out of space condition
b. Space Quota exceeded condition
c. Minimum extents reached condition
d. Both A & B
|
Answer
Explanation
|
ANSWER: Both A & B
Explanation:
No explanation is available for this question!
|
|
6) You cannot issue a SET CONSTRAINT statement inside a trigger.
a. True
b. False
|
Answer
Explanation
|
ANSWER: True
Explanation:
No explanation is available for this question!
|
|
7) Which privileges are required for directory objects containing bad, log, or discard files for external tables?
a. READ
b. WRITE
c. READ & WRITE
d. None of the above
|
Answer
Explanation
|
ANSWER: WRITE
Explanation:
No explanation is available for this question!
|
|
8) Which of the following is the default permanent tablespace?
a. TEMP
b. UNDOTBS1
c. USERS
d. None of the above
|
Answer
Explanation
|
ANSWER: USERS
Explanation:
No explanation is available for this question!
|
|
9) You can use transportable tablespaces to perform tablespace point-in-time recovery (TSPITR).
a. True
b. False
|
Answer
Explanation
|
ANSWER: True
Explanation:
No explanation is available for this question!
|
|
10) ___________________ determines the best possible way to execute a query.
a. Transaction optimizer
b. Query optimizer
c. Optimizer
d. Oracle optimizer
|
Answer
Explanation
|
ANSWER: Query optimizer
Explanation:
No explanation is available for this question!
|
|
11) You can roll back an in-doubt transaction to a savepoint?
a. Yes
b. No
|
Answer
Explanation
|
ANSWER: No
Explanation:
No explanation is available for this question!
|
|
12) Select the correct case for which only queries are issued at one or more nodes.
a. Partially read-only
b. Completely read-only with prepare phase
c. Completely read-only without two-phase commit
d. Both B and C
|
Answer
Explanation
|
ANSWER: Partially read-only
Explanation:
No explanation is available for this question!
|
|
13) Which is a database objects from which multiple users can generate unique integers?
a. Views
b. Sequences
c. Synonyms
d. None of the above
|
Answer
Explanation
|
ANSWER: Sequences
Explanation:
No explanation is available for this question!
|
|
14) Abbreviate the term OUI?
a. Oracle Unicode Installer
b. Oracle Universal Installer
c. Oracle Universal Information
d. Oracle Unicode Information
|
Answer
Explanation
|
ANSWER: Oracle Universal Installer
Explanation:
No explanation is available for this question!
|
|
15) 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
Explanation
|
ANSWER: dba_db_links
Explanation:
No explanation is available for this question!
|
|
16) Which parameter specifies the maximum number of shared servers that can be automatically created by PMON?
a. MAX_DISPATCHERS
b. MAX_SHARED_SERVERS
c. SHARED_SERVER_SESSIONS
d. SHARED_SERVERS
|
Answer
Explanation
|
ANSWER: MAX_SHARED_SERVERS
Explanation:
No explanation is available for this question!
|
|
17) Oracle automatically creates the SYSTEM tablespace.
a. True
b. False
|
Answer
Explanation
|
ANSWER: True
Explanation:
No explanation is available for this question!
|
|
18) You are using flat files as the data source for one of your data warehousing applications. You plan to move the data from the flat file structures to an Oracle database to optimize the application performance. In your database you have clustered tables. While migrating the data, you want to have minimal impact on the database performance and optimize the data load operation. Which method would you use to load data into Oracle database?
a. Use the external table population
b. Use the Oracle Data Pump export and import utility
c. Use the conventional path data load of SQL*Loader utility
d. Use the direct path data load of Oracle export and import utility
|
Answer
Explanation
|
ANSWER: Use the conventional path data load of SQL*Loader utility
Explanation:
No explanation is available for this question!
|
|
19) Which command is used to drop HASH cluster?
a. DROP CLUSTER
b. DROP HASH CLUSTER
c. DROP_CLUSTER_HASH
d. DROP ANY CLUSTER
|
Answer
Explanation
|
ANSWER: DROP CLUSTER
Explanation:
No explanation is available for this question!
|
|
20) The CREATE CONTROLFILE statement can not potentially damage specified datafiles and redo log files.
a. True
b. False
|
Answer
Explanation
|
ANSWER: False
Explanation:
No explanation is available for this question!
|
|
21) Which file allows a no default parameter file to be used to configure the Instance?
a. SPFILE
b. PFILE
c. Both A & B
d. None of the above
|
Answer
Explanation
|
ANSWER: PFILE
Explanation:
No explanation is available for this question!
|
|
22) In mapping structure what describes the link between an element and the next elements in the I/O mapping stack?
a. File Mapping
b. Subelements Mapping
c. Elements Mapping
d. File System Extents Mapping
|
Answer
Explanation
|
ANSWER: Subelements Mapping
Explanation:
No explanation is available for this question!
|
|
23) What is the mechanism which guarantees that all database servers participating in a distributed transaction either all commit or all roll back the statements in the transaction?
a. Commit
b. Commit transaction
c. Two-phase commit
d. Three-phase commit
|
Answer
Explanation
|
ANSWER: Two-phase commit
Explanation:
No explanation is available for this question!
|
|
24) If a part of a distributed statement fails, due to an integrity constraint violation then the database returns which error number?
a. ORA-02055
b. ORA-02067
c. Both A & B
d. None of the above
|
Answer
Explanation
|
ANSWER: ORA-02055
Explanation:
No explanation is available for this question!
|
|
25) In the Oracle Database which file contain the information needed to maintain and verify database integrity, and include the names of all the Data Files and the online and archived log files?
a. Data Files
b. Control Files
c. Redo Log Files
d. Temp Files
|
Answer
Explanation
|
ANSWER: Control Files
Explanation:
No explanation is available for this question!
|
|
