1) In viewing information about the SGA which view Displays information about the amount of SGA memory available for future dynamic SGA resize operations?
a. V$SGA_DYNAMIC_COMPONENTS
b. V$SGA_DYNAMIC_FREE_MEMORY
c. V$SGASTAT
d. V$SGAINFO
|
Answer
Explanation
|
ANSWER: V$SGA_DYNAMIC_FREE_MEMORY
Explanation:
No explanation is available for this question!
|
|
2) What is used to execute STARTUP and SHUTDOWN commands while starting up a database?
a. SQL*Plus
b. Recovery Manager
c. Enterprise Manager
d. None of the above
|
Answer
Explanation
|
ANSWER: Recovery Manager
Explanation:
No explanation is available for this question!
|
|
3) Which attribute enables you to control the amount of logging in the Scheduler performs for setting the scheduler attribute?
a. Default_timezone
b. Log_history
c. Max_job_slave_processes
d. Event_expiry_time
|
Answer
Explanation
|
ANSWER: Log_history
Explanation:
No explanation is available for this question!
|
|
4) Which is the correct parameter used for CREATE_PROGRAM?
a. program_type
b. schedule_name
c. start_date
d. program_name
|
Answer
Explanation
|
ANSWER: program_type
Explanation:
No explanation is available for this question!
|
|
5) Jobs that are scheduled to run only once will have only one instance. Jobs that have a repeating schedule will have multiple instances, with each run of the job representing an instance.
a. True
b. False
|
Answer
Explanation
|
ANSWER: True
Explanation:
No explanation is available for this question!
|
|
6) While designing the database for one of your online transaction processing (OLTP) applications, you want to achieve the following:
a) High availability of data
b) Faster primary key access to the table data
c) Compact storage for the table
Which type of tables would you use to achieve these objectives?
a. Heap tables
b. Object tables
c. Partitioned tables
d. Index-organized tables (IOTs)
|
Answer
Explanation
|
ANSWER: Partitioned tables
Explanation:
No explanation is available for this question!
|
|
7) Which of the following condition is true to create an index in your own schema?
a. The table or cluster to be indexed is in another schema
b. You don’t have INDEX privilege on the table to be indexed
c. You have CREATE ANY INDEX system privilege
d. None of the above
|
Answer
Explanation
|
ANSWER: You have CREATE ANY INDEX system privilege
Explanation:
No explanation is available for this question!
|
|
8) Which shows if the database is in ARCHIVELOG or NOARCHIVELOG mode and if MANUAL (archiving mode) has been specified in a Dynamic performance view?
a. V$ARCHIVED_LOG
b. V$DATABASE
c. V$ARCHIVE_DEST
d. V$ARCHIEVE_PROCESSES
|
Answer
Explanation
|
ANSWER: V$DATABASE
Explanation:
No explanation is available for this question!
|
|
9) Which mode protects a database from instance failure but not from media failure?
a. ARCHIVELOG MODE
b. NOARCHIVELOG MODE
c. Both A & B
d. None of the above
|
Answer
Explanation
|
ANSWER: NOARCHIVELOG MODE
Explanation:
No explanation is available for this question!
|
|
10) By default which refresh on a snapshot is performed by Oracle?
a. Fast refresh
b. Complete refresh
c. Automatic refresh
d. Attempts fast refresh, if it cannot be preformed server performs a complete refresh
|
Answer
Explanation
|
ANSWER: Attempts fast refresh, if it cannot be preformed server performs a complete refresh
Explanation:
No explanation is available for this question!
|
|
11) In Suspended Statements which view is used When a statement is suspended the session invoking the statement is put into a wait state. A row is inserted into this view for the session with the EVENT column containing "statement suspended, wait error to be cleared"?
a. V$SESSION_WAIT
b. DBA_RESUMABLE
c. USER_RESUMABLE
d. None of the above
|
Answer
Explanation
|
ANSWER: V$SESSION_WAIT
Explanation:
No explanation is available for this question!
|
|
12) Deferrable unique and primary keys must use nonunique indexes.
a. True
b. False
|
Answer
Explanation
|
ANSWER: True
Explanation:
No explanation is available for this question!
|
|
13) In Viewing and querying Objects in the recycle bin which view gives administrators visibility to all dropped objects in the recycle bin?
a. USER_RECYCLEBIN
b. DBA_RECYCLEBIN
c. Both A & B
d. None of the above
|
Answer
Explanation
|
ANSWER: DBA_RECYCLEBIN
Explanation:
No explanation is available for this question!
|
|
14) Identify the common Dynamic Performance views which are accessible in NOMOUNT stage?
a. V$PARAMETER, V$OPTION, V$SGA
b. V$THREAT, V$LOGFILE, V$DATAFILE
c. Both A & B
d. V$CONTROLFILE, V$DATABASE
|
Answer
Explanation
|
ANSWER: V$PARAMETER, V$OPTION, V$SGA
Explanation:
No explanation is available for this question!
|
|
15) The DBMS_SPACE_ADMIN package provides maintenance procedures for locally managed tablespaces.
a. True
b. False
|
Answer
Explanation
|
ANSWER: True
Explanation:
No explanation is available for this question!
|
|
16) RECO process is an acronym of?
a. Record
b. Recover
c. Recognize
d. None of the company
|
Answer
Explanation
|
ANSWER: Recover
Explanation:
No explanation is available for this question!
|
|
17) What is the correct privilege which is required for manually committing an in-doubt transaction?
a. System privilege
b. Force any transaction
c. Both a & b
d. None of the above
|
Answer
Explanation
|
ANSWER: Force any transaction
Explanation:
No explanation is available for this question!
|
|
18) If all statements of a transaction reference to only a single remote node, then the transaction is remote and it is not distributed.
a. True
b. False
|
Answer
Explanation
|
ANSWER: True
Explanation:
No explanation is available for this question!
|
|
19) Which view Shows all columns in all tables and views accessible to the user that are modifiable in the UPDATABLE_COLUMNS VIEWS?
a. DBA_UPDATABLE_COLUMNS
b. ALL_UPDATABLE_COLUMNS
c. USER_UPDATABLE_COLUMNS
d. None of the above
|
Answer
Explanation
|
ANSWER: ALL_UPDATABLE_COLUMNS
Explanation:
No explanation is available for this question!
|
|
20) How many tasks present a prioritized approach for designing, implementing, and maintaining an Oracle Database in a Database Administrator?
a. 10
b. 9
c. 8
d. 11
|
Answer
Explanation
|
ANSWER: 11
Explanation:
No explanation is available for this question!
|
|
21) OPEN_LINKS is the static initialization parameter that controls the number of remote connections that a single user session can use concurrently in distributed transactions.
a. True
b. False
|
Answer
Explanation
|
ANSWER: True
Explanation:
No explanation is available for this question!
|
|
22) Which process of one instance can perform Instance recovery for other instances that have failed in Oracle Database Background ?
a. Log Writer
b. System Monitor
c. Process Monitor
d. Checkpoint
|
Answer
Explanation
|
ANSWER: System Monitor
Explanation:
No explanation is available for this question!
|
|
23) Where is the data dictionary kept?
a. SYSTEM tablespace
b. Stack Space
c. Data file
d. None of the above
|
Answer
Explanation
|
ANSWER: SYSTEM tablespace
Explanation:
No explanation is available for this question!
|
|
24) What is the reason that SORT_AREA SIZE and HASH_AREA_SIZE parameters are ignored in some of the user sessions?
a. The User Global Area (UGA) is not configured
b. The sessions were started using the login name SYS
c. The sessions are running in the Automatic Shared Memory Management mode
d. The sessions are running in the automatic Program Global Area (PGA) memory management mode
|
Answer
Explanation
|
ANSWER: The sessions are running in the Automatic Shared Memory Management mode
Explanation:
No explanation is available for this question!
|
|
25) Disk I/O is reduced and access time improves for joins of clustered tables.
a. True
b. False
|
Answer
Explanation
|
ANSWER: True
Explanation:
No explanation is available for this question!
|
|
