1) Configuration parameters such as MAXLOGFILES, MAXLOGMEMBERS, MAXLOGHISTORY, MAXDATAFILES, and MAXINSTANCES affect control file size.
a. True
b. False
|
Answer
Explanation
|
ANSWER: True
Explanation:
No explanation is available for this question!
|
|
2) Abbreviate the term CSS?
a. Command Synchronization Services
b. Cluster Synchronization Services
c. Command Synchronization Statement
d. Cluster Synchronization Statement
|
Answer
Explanation
|
ANSWER: Cluster Synchronization Services
Explanation:
No explanation is available for this question!
|
|
3) Which view would you query at this stage to investigate this missing control file?
a. V$INSTANCE
b. V$CONTROLFILE
c. DBA_CONTROL_FILES
d. V$DATABASE_PROPERTIES
|
Answer
Explanation
|
ANSWER: V$CONTROLFILE
Explanation:
No explanation is available for this question!
|
|
4) In Run Scripts to build data dictionary views which script Creates the views of the data dictionary tables, the dynamic performance views, and public synonyms for many of the views, Grants PUBLIC access to the synonyms?
a. CATALOG.SQL
b. CATPROC.SQL
c. Both A & B
d. None of the above
|
Answer
Explanation
|
ANSWER: CATALOG.SQL
Explanation:
No explanation is available for this question!
|
|
5) Quiesced state, in the sense that no ongoing non-DBA transactions, queries, fetches, or PL/SQL statements are running in the system.
a. True
b. False
|
Answer
Explanation
|
ANSWER: True
Explanation:
No explanation is available for this question!
|
|
6) Which view shows the state of information on all jobs that are currently being run in the viewing Scheduler information?
a. *_scheduler_running_jobs
b. *_scheduler_job_run_details
c. *_scheduler_windows
d. *_scheduler_job_classes
|
Answer
Explanation
|
ANSWER: *_scheduler_running_jobs
Explanation:
No explanation is available for this question!
|
|
7) After creating the chain object with CREATE_CHAIN, you define chain steps and chain rules separately. What is the correct argument which is set to NULL?
a. Evaluation_interval
b. Define_chain_step
c. Define_chain_event
d. Schedules
|
Answer
Explanation
|
ANSWER: Evaluation_interval
Explanation:
No explanation is available for this question!
|
|
8) Generic connectivity is to access non-oracle database data stores as long as the non-oracle database system supports the ODBC or OLE DB protocols.
a. True
b. False
|
Answer
Explanation
|
ANSWER: True
Explanation:
No explanation is available for this question!
|
|
9) In a distributed database environment, while coordinating with the database administrator to determine the best location for the data, which of these issues will be considered?
a. Number of transactions posted from each location
b. Amount of data (portion of table) used by each node
c. Performance characteristics and reliability of the network
d. Speed of various nodes, capacities of disks
e. All mentioned above
|
Answer
Explanation
|
ANSWER: All mentioned above
Explanation:
No explanation is available for this question!
|
|
10) In ALTER TABLE Maintenance Operations for Table Partitions which maintenance operation partition is used by range, hash, list, composite(range/hash), composite(range/list) from the following?
a. Coalescing Partitions
b. Dropping Partitions
c. Adding partitions
d. Both A & B
|
Answer
Explanation
|
ANSWER: Adding partitions
Explanation:
No explanation is available for this question!
|
|
11) While considering Costs and Benefits of Coalescing or Rebuilding Indexes which has lower costs and does not require more disk space?
a. Coalesce Index
b. Rebuild Index
c. Both A & B
d. None of the above
|
Answer
Explanation
|
ANSWER: Coalesce Index
Explanation:
No explanation is available for this question!
|
|
12) Archived logs in RMAN backups are created in the flash recovery area.
a. True
b. False
|
Answer
Explanation
|
ANSWER: True
Explanation:
No explanation is available for this question!
|
|
13) Which parameter uses all MANDATORY destinations plus some number of non-standby OPTIONAL destinations to determine whether LGWR can overwrite the online log?
a. LOG_ARCHIVE_DEST_n
b. LOG_ARCHIVE_MIN_SUCCEED_DEST=n
c. Both A & B
d. None of the above
|
Answer
Explanation
|
ANSWER: LOG_ARCHIVE_MIN_SUCCEED_DEST=n
Explanation:
No explanation is available for this question!
|
|
14) What is the minimum size permitted for a redo log file?
a. 10 MB
b. 6 MB
c. 8 MB
d. 4 MB
|
Answer
Explanation
|
ANSWER: 4 MB
Explanation:
No explanation is available for this question!
|
|
15) A _____________ is a database object existing on multiple servers in a distributed database system.
a. Replication object
b. replica object
c. replication groups
d. Both A and C
|
Answer
Explanation
|
ANSWER: Replication object
Explanation:
No explanation is available for this question!
|
|
16) Using PL/SQL Packages to Display Information About Schema Object Space Usage which Returns information about free data blocks in an object (table, index, or cluster) whose segment space management is AUTO?
a. DBMS_SPACE.FREE_BLOCKS
b. DBMS_SPACE.UNUSED_SPACE
c. DBMS_SPACE.SPACE_USAGE
d. None of the above
|
Answer
Explanation
|
ANSWER: DBMS_SPACE.SPACE_USAGE
Explanation:
No explanation is available for this question!
|
|
17) Which DBA System Privilege used for the operations authorized for drops a table in any schema?
a. CREATE USER
b. DROP USER
c. BACKUP ANY TABLE
d. DROP ANY TABLE
|
Answer
Explanation
|
ANSWER: DROP ANY TABLE
Explanation:
No explanation is available for this question!
|
|
18) Oracle Database provides a mechanism to make table structure modifications with significantly affecting the availability of the table. The mechanism is called online table redefinition.
a. True
b. False
|
Answer
Explanation
|
ANSWER: False
Explanation:
No explanation is available for this question!
|
|
19) The UNDO_RETENTION parameter in your database is set to 1000 and undo retention is not guaranteed. Which statement regarding retention of undo data is correct?
a. Undo data becomes obsolete after 1,000 seconds
b. Undo data gets refreshed after every 1,000 seconds
c. Undo data will be stored permanently after 1,000 seconds
d. Committed undo data would be retained for 1,000 seconds if free undo space is available
e. Undo data will be retained in the UNDO tablespace for 1,000 seconds, then it gets moved to the TEMPORARY tablespace to provide read consistency
|
Answer
Explanation
|
ANSWER: Committed undo data would be retained for 1,000 seconds if free undo space is available
Explanation:
No explanation is available for this question!
|
|
20) Which parameter specifies the exported file containing the metadata for the tablespaces to be imported?
a. TRANSPORT_DATAFILES
b. DUMPFILE
c. DIRECTORY
d. REMAP_SCHEMA
|
Answer
Explanation
|
ANSWER: DUMPFILE
Explanation:
No explanation is available for this question!
|
|
21) Applications should always _____________ commit or roll back transactions before program termination.
a. Implicitly
b. Explicitly
c. Either of a and b
d. None of the above
|
Answer
Explanation
|
ANSWER: Explicitly
Explanation:
No explanation is available for this question!
|
|
22) RECO can use an existing connection or establish a new connection to other nodes involved in the failed transaction. When a connection is established, RECO automatically resolves all in-doubt transactions.
a. True
b. False
|
Answer
Explanation
|
ANSWER: True
Explanation:
No explanation is available for this question!
|
|
23) A system change number (SCN) is not an internal timestamp for a committed version of the database.
a. True
b. False
|
Answer
Explanation
|
ANSWER: False
Explanation:
No explanation is available for this question!
|
|
24) A synonym is an alias for which object?
a. Schema
b. Segment
c. Extents
d. Rollback Segments
|
Answer
Explanation
|
ANSWER: Schema
Explanation:
No explanation is available for this question!
|
|
25) A session is INACTIVE when it is making a SQL call to Oracle Database. A session is ACTIVE if it is not making a SQL call to the database.
a. True
b. False
|
Answer
Explanation
|
ANSWER: False
Explanation:
No explanation is available for this question!
|
|
