1) When estimating the size of cluster indexes remember that the index is on each cluster key, not the actual rows. Therefore, each key appears only once in the index.
a. True
b. False
|
Answer
Explanation
|
ANSWER: True
Explanation:
No explanation is available for this question!
|
|
2) Which of the following conditions are true when you choose the appropriate tables for the Cluster?
a. The tables are primarily queried--that is, tables that are not predominantly inserted into or updated
b. Records from the tables are frequently queried together or joined
c. Records from the tables are not frequently queried together or joined
d. Both A & C
e. Both A & B
|
Answer
Explanation
|
ANSWER: Both A & B
Explanation:
No explanation is available for this question!
|
|
3) What is the following step used for?
1) Edit the CONTROL_FILES parameter in the database initialization parameter file to delete the old control file name.
a. Creating Initial Control Files
b. Creating Additional Copies, Renaming, and Relocating Control Files
c. Creating New Control Files
d. Dropping Control Files
|
Answer
Explanation
|
ANSWER: Dropping Control Files
Explanation:
No explanation is available for this question!
|
|
4) ASM does not discover a disk that contains an operating system partition table, even if the disk is in an ASM_DISKSTRING search path and ASM has read/write permission on the disk.
a. True
b. False
|
Answer
Explanation
|
ANSWER: True
Explanation:
No explanation is available for this question!
|
|
5) You want to move all the objects of the APPS user in the test database to the DB_USER schema of the production database. Which option of IMPDP would you use to accomplish this task?
a. FULL
b. SCHEMAS
c. REMAP_SCHEMA
d. REMAP_DATAFILES
e. REMAP_TABLESPACE
|
Answer
Explanation
|
ANSWER: REMAP_SCHEMA
Explanation:
No explanation is available for this question!
|
|
6) Which initialization parameter is a dynamic parameter that lets you specify or adjust the size of the large pool component of the SGA?
a. STREAMS_POOL_SIZE
b. JAVA_POOL_SIZE
c. LARGE_POOL_SIZE
d. SHARED_POOL_SIZE
|
Answer
Explanation
|
ANSWER: LARGE_POOL_SIZE
Explanation:
No explanation is available for this question!
|
|
7) In the platform-specific default location, Oracle Database locates your initialization parameter file by examining filenames in which of the following order?
a. spfile$ORACLE_SID.ora, init$ORACLE_SID.ora, spfile.ora
b. spfile.ora, spfile$ORACLE_SID.ora, init$ORACLE_SID.ora
c. spfile$ORACLE_SID.ora, spfile.ora, init$ORACLE_SID.ora
d. Intit$ORACLE_SID.ora, spfile.ora, spfile$ORACLE_SID.ora
|
Answer
Explanation
|
ANSWER: spfile$ORACLE_SID.ora, spfile.ora, init$ORACLE_SID.ora
Explanation:
No explanation is available for this question!
|
|
8) Which view shows “completed window runs” in viewing the scheduler information?
a. *_scheduler_windows
b. *_scheduler_window_log
c. *_scheduler_window_details
d. *_scheduler_window_groups
|
Answer
Explanation
|
ANSWER: *_scheduler_window_details
Explanation:
No explanation is available for this question!
|
|
9) Which view shows that all the jobs or both enabled and disabled?
a. *_SCHEDULER_JOBS
b. *_SCHEDULER_JOB_ROLES
c. *_SCHEDULER_PROGRAMS
d. *_SCHEDULER_JOB_RUN_DETAILS
|
Answer
Explanation
|
ANSWER: *_SCHEDULER_JOBS
Explanation:
No explanation is available for this question!
|
|
10) Job slaves actually execute the jobs you submit. When a job is done, what will the slave do?
a. Reschedule the job if required
b. Update the state in the job table to reflect whether the job has completed or is scheduled to run again
c. Delete an entry into the job log table
d. Do not update the run count, and if necessary, failure count and retry count
e. Both A & B
|
Answer
Explanation
|
ANSWER: Both A & B
Explanation:
No explanation is available for this question!
|
|
11) A set of databases in a distributed system that can appear to applications as a single data source known as ________.
a. Distributed database
b. Distributed processing
c. Both A & B
d. None of the above
|
Answer
Explanation
|
ANSWER: Distributed database
Explanation:
No explanation is available for this question!
|
|
12) Which transaction contains statements that access more than one node?
a. A Remote Transaction
b. A Distributed transaction
c. Both A & B
d. None of the above
|
Answer
Explanation
|
ANSWER: A Distributed transaction
Explanation:
No explanation is available for this question!
|
|
13) Which type of partition will be done for the following?
1. Partition description identifying partition bounds.
a. Range Partition
b. Hash Partition
c. List Partition
d. Range-Hash Partition
|
Answer
Explanation
|
ANSWER: Range Partition
Explanation:
No explanation is available for this question!
|
|
14) Creating an index using key compression enables you to eliminate repeated occurrences of key column prefix values.
a. True
b. False
|
Answer
Explanation
|
ANSWER: True
Explanation:
No explanation is available for this question!
|
|
15) Which modes are used for transmitting archived logs to their destination in the Specifying Mode of Log Transmission?
a. Normal archiving transmission
b. Standby transmission
c. Both A & B
d. None of the above
|
Answer
Explanation
|
ANSWER: Both A & B
Explanation:
No explanation is available for this question!
|
|
16) Which view identifies redo log groups and members and member status in the Redo Log Information?
a. V$LOG
b. V$LOGFILE
c. V$LOG_HISTORY
d. None of the above
|
Answer
Explanation
|
ANSWER: V$LOGFILE
Explanation:
No explanation is available for this question!
|
|
17) Which site supports simple read-only and updatable snapshots of the table data at an associated master site?
a. Snap site
b. Replication Catalog
c. Replication groups
d. Snapshot site
|
Answer
Explanation
|
ANSWER: Snapshot site
Explanation:
No explanation is available for this question!
|
|
18) Where are the LOBs and varrays stored?
a. LOB segments
b. Storage table
c. Both A & B
d. None of the above
|
Answer
Explanation
|
ANSWER: LOB segments
Explanation:
No explanation is available for this question!
|
|
19) What can be included in the CREATE SCHEMA statement which is useful if you want to guarantee the creation of several tables, views, and grants in one operation?
a. CREATE TABLE
b. CREATE VIEW
c. GRANT
d. All mentioned above
|
Answer
Explanation
|
ANSWER: All mentioned above
Explanation:
No explanation is available for this question!
|
|
20) Which method enables you to add rows to a table, either by specifying the column values or by specifying a subquery that selects data from another existing table?
a. INSERT statement
b. MERGE statement
c. Both A & B
d. None of the above
|
Answer
Explanation
|
ANSWER: INSERT statement
Explanation:
No explanation is available for this question!
|
|
21) Which two statements about Flashback Query are true?
a. It helps in row-level recovery from user errors
b. It can be performed to recover ALTER TABLE statements
c. It fails when undo data pertaining to the transaction is overwritten
d. BOTH B & C
e. BOTH A & C
|
Answer
Explanation
|
ANSWER: BOTH A & C
Explanation:
No explanation is available for this question!
|
|
22) AUTOALLOCATE causes the tablespace to be system managed with a minimum extent size of 6K.
a. True
b. False
|
Answer
Explanation
|
ANSWER: False
Explanation:
No explanation is available for this question!
|
|
23) What happens when an entire transaction is roll backed without referencing any save points?
a. All changes are undone made by all of the SQL statements
b. The transaction locks of data is released
c. The transaction ends
d. All of the above
|
Answer
Explanation
|
ANSWER: All of the above
Explanation:
No explanation is available for this question!
|
|
24) What is the exact reason for which you can force the failure of a distributed transaction?
a. To observe RECO automatically resolving the local portion of the transaction
b. To practice manually resolving in-doubt distributed transactions and observing the results
c. Both A & B
d. None of the above
|
Answer
Explanation
|
ANSWER: Both A & B
Explanation:
No explanation is available for this question!
|
|
25) Drop a synonym that is no longer required using DROP SYNONYM statement. To drop a private synonym, omit the PUBLIC keyword. To drop a public synonym, include the PUBLIC keyword.
a. True
b. False
|
Answer
Explanation
|
ANSWER: True
Explanation:
No explanation is available for this question!
|
|
