1) 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
Explanation
|
ANSWER: Roll Out to Additional Hosts
Explanation:
No explanation is available for this question!
|
|
2) Which of the following components comprise of an oracle architecture?
a. Database related background processes
b. Tablespaces
c. Datafiles
d. All of the above
|
Answer
Explanation
|
ANSWER: All of the above
Explanation:
No explanation is available for this question!
|
|
3) The basic memory structures associated with Oracle are the System Global Area (SGA) and the Program Global Area (PGA).
a. True
b. False
|
Answer
Explanation
|
ANSWER: True
Explanation:
No explanation is available for this question!
|
|
4) In a sorted hash cluster, the rows corresponding to each value of the hash function are sorted on a specified set of columns in which order and that can improve response time during subsequent operations on the clustered data?
a. Descending order
b. Ascending Order
c. Equal
d. None of the above
|
Answer
Explanation
|
ANSWER: Ascending Order
Explanation:
No explanation is available for this question!
|
|
5) You can create any cluster and associated cluster index in any tablespace that is _____ .
a. OFFLINE
b. CLOSED
c. CURRENTLY ONLINE
d. OPEN
|
Answer
Explanation
|
ANSWER: CURRENTLY ONLINE
Explanation:
No explanation is available for this question!
|
|
6) You are managing an Oracle Database 11g database with the ASM storage. The database is having big file tablespaces. You want files to open faster and less memory to be used in the shared pool to manage the extent maps. What configuration would you effect to achieve your objective?
a. Set the ASM compatibility attribute for the ASM disk group to 11.1.0
b. Set the RDBMS compatibility attribute for the ASM disk group to 11.1.0
c. Set the COMPATIBLE initialization parameter for the ASM instance to 11.1.0
d. Set the COMPATIBLE initialization parameter for the database instance to 11.1.0
e. Both A & D
|
Answer
Explanation
|
ANSWER: Both A & D
Explanation:
No explanation is available for this question!
|
|
7) Which initialization Parameter Specifies the default disk group location to create the following files?
1) Redo log files
2) Control files
a. DB_CREATE_ONLINE_LOG_DEST_n
b. DB_CREATE_FILE_DEST
c. DB_RECOVERY_FILE_DEST
d. CONTROL_FILES
|
Answer
Explanation
|
ANSWER: DB_CREATE_ONLINE_LOG_DEST_n
Explanation:
No explanation is available for this question!
|
|
8) Viewing the Quiesce State of an Instance You can query the ACTIVE_STATE column of the V$INSTANCE view to see the current state of an instance, the column values has one of these values?
a. NORMAL
b. QUIESCING
c. QUIESCED
d. All mentioned above
|
Answer
Explanation
|
ANSWER: All mentioned above
Explanation:
No explanation is available for this question!
|
|
9) Select the correct object privilege that can only be granted to programs, chains and job classes.
a. EXECUTE
b. ALTER
c. ALL
d. Both A and B
|
Answer
Explanation
|
ANSWER: EXECUTE
Explanation:
No explanation is available for this question!
|
|
10) Which view shows all chains?
a. *_scheduler_chains
b. *_scheduler_chain_rules
c. *_scheduler_chain_steps
d. None of the above
|
Answer
Explanation
|
ANSWER: *_scheduler_chains
Explanation:
No explanation is available for this question!
|
|
11) Which of these additional attributes must be set to create an event-based job?
a. queue_spec
b. event_condition
c. Both A & B
d. None of the above
|
Answer
Explanation
|
ANSWER: Both A & B
Explanation:
No explanation is available for this question!
|
|
12) Where can we use the Scheduler which provides the complex enterprise scheduling functionality?
a. Schedule job execution based on time or events
b. Schedule job processing in a way that models your business requirements
c. Manage and monitor jobs
d. Execute and manage jobs in a clustered environment
e. All of the above
|
Answer
Explanation
|
ANSWER: All of the above
Explanation:
No explanation is available for this question!
|
|
13) Depending on the situation each node in the Distributed Database system can act as, _________ .
a. A client
b. A server
c. Both A & B
d. None of the above
|
Answer
Explanation
|
ANSWER: Both A & B
Explanation:
No explanation is available for this question!
|
|
14) Which key have automatically indexes, but you might want to create an index on a foreign key?
a. Primary
b. Unique
c. Both A & B
d. None of the above
|
Answer
Explanation
|
ANSWER: Both A & B
Explanation:
No explanation is available for this question!
|
|
15) You want to protect your database from single point of failure by multiplexing the control file. Your database is started using SPFILE. You have to perform the following tasks, Give the correct order in which these tasks to be performed.
1. Shut down the database instance.
2. Copy the control file to new location.
3. Configure the CONTROL_FILES parameter.
4. Restart the instance.
a. 3, 2, 1, 4
b. 3, 1, 2, 4
c. 3, 2, 1, 4
d. 2, 3, 1, 4
|
Answer
Explanation
|
ANSWER: 3, 1, 2, 4
Explanation:
No explanation is available for this question!
|
|
16) Which of these statements overcomes two situations where dropping redo logs is not possible?
a. If there are only two log groups
b. The corrupt redo log file belongs to the current group
c. The corrupt redo log file belongs to the Inactive group
d. If there are only four log groups
e. Both A & B
|
Answer
Explanation
|
ANSWER: Both A & B
Explanation:
No explanation is available for this question!
|
|
17) Advance data replication is useful to which types of Application Systems?
a. Disconnected Environments
b. Failover Site
c. Distributing Application Loads
d. All of the above
|
Answer
Explanation
|
ANSWER: All of the above
Explanation:
No explanation is available for this question!
|
|
18) If the replication interval is smaller, there are few update conflicts.
a. True
b. False
|
Answer
Explanation
|
ANSWER: True
Explanation:
No explanation is available for this question!
|
|
19) In Schema Objects Data Dictionary Views which view List the name, type, and owner (USER view does not display owner) for all tables, views, synonyms, and sequences in the database?
a. DBA_OBJECTS, ALL_OBJECTS, USER_OBJECTS
b. DBA_DEPENDENCIES, ALL_DEPENDENCIES, USER_DEPENDENCIES
c. DBA_CATALOG, ALL_CATALOG, USER_CATALOG
d. None of the above
|
Answer
Explanation
|
ANSWER: DBA_CATALOG, ALL_CATALOG, USER_CATALOG
Explanation:
No explanation is available for this question!
|
|
20) DBMS_ADVISOR package procedures relevant to the segment advisor which package procedure name use this procedure to create the Segment Advisor task. Specify 'Segment Advisor ‘as the value of the ADVISOR_NAME parameter?
a. CREATE_TASK
b. CREATE_OBJECT
c. EXECUTE_TASK
d. SET_TASK_PARAMETER
|
Answer
Explanation
|
ANSWER: CREATE_TASK
Explanation:
No explanation is available for this question!
|
|
21) Error Logging Restrictions and Caveats Oracle Database logs which of the following errors during DML operations?
a. Column values those are too large
b. Constraint violations (NOT NULL, unique, referential, and check constraints)
c. Errors raised during trigger execution
d. Partition mapping errors
e. All mentioned above
|
Answer
Explanation
|
ANSWER: All mentioned above
Explanation:
No explanation is available for this question!
|
|
22) What migrates a locally managed tablespace to dictionary-managed in Diagnosing and Repairing Locally Managed Tablespace Problems?
a. TABLESPACE_MIGRATE_TO_LOCAL
b. TABLESPACE_REBUILD_QUOTAS
c. TABLESPACE_MIGRATE_FROM_LOCAL
d. TABLESPACE_VERIFY
|
Answer
Explanation
|
ANSWER: TABLESPACE_MIGRATE_TO_LOCAL
Explanation:
No explanation is available for this question!
|
|
23) What are the additional limitations for Transporting tablespaces with XMLTypes?
a. Advanced Queues
b. SYSTEM Tablespace Objects
c. Opaque Types
d. Floating-Point Numbers
e. All mentioned above
|
Answer
Explanation
|
ANSWER: All mentioned above
Explanation:
No explanation is available for this question!
|
|
24) Which of the following scenarios ends an Oracle transaction?
a. COMMIT or ROLLBACK is issued
b. User disconnects from Oracle
c. User process terminates abnormally
d. All of the above
|
Answer
Explanation
|
ANSWER: All of the above
Explanation:
No explanation is available for this question!
|
|
25) A transaction is in-doubt when there is a failure during any aspect of the two-phase commit. From the following give the exact way for which distributed transactions can become in-doubt?
a. A server machine running Oracle Database software crashes
b. A network connection between two or more Oracle Databases involved in distributed processing is disconnected
c. An unhandled software error occurs
d. All mentioned above
e. Both A & B
|
Answer
Explanation
|
ANSWER: All mentioned above
Explanation:
No explanation is available for this question!
|
|
