1) Database users interact with the database through applications or utilities. Which of these tasks are a typical user's responsibilities?
a. Entering, modifying, and deleting data
b. Generating reports from the data
c. Both A & B
d. None of the above
|
Answer
Explanation
|
ANSWER: Both A & B
Explanation:
No explanation is available for this question!
|
|
2) A database link is a pointer in the local database that lets you access objects on a remote database in order to create a private database link. Which privilege is required for creation of any type of database link?
a. CREATE DATABASE LINK
b. CREATE PUBLIC DATABASE LINK
c. CREATE SESSION
d. Both A & B
|
Answer
Explanation
|
ANSWER: CREATE SESSION
Explanation:
No explanation is available for this question!
|
|
3) Which area of PGA stores binding variables and runtime buffers information?
a. SQL area
b. Private SQL area
c. Stack space
d. Session area
|
Answer
Explanation
|
ANSWER: Private SQL area
Explanation:
No explanation is available for this question!
|
|
4) The size and content of the PGA is independent on the Oracle server options installed.
a. True
b. False
|
Answer
Explanation
|
ANSWER: False
Explanation:
No explanation is available for this question!
|
|
5) Which files do the following structural changes occur?
1) Adding, dropping or renaming datafiles
2) Adding or dropping a tablespace, or altering the read / write state of the tablespace
3) Adding or dropping redo log files or groups
a. Manage the Size of Control Files
b. Back up Control Files
c. Provide Filenames for the Control Files
d. All Mentioned above
|
Answer
Explanation
|
ANSWER: Back up Control Files
Explanation:
No explanation is available for this question!
|
|
6) The CONTROL_FILES initialization parameter can use the alias filenames of the control files.
a. True
b. False
|
Answer
Explanation
|
ANSWER: True
Explanation:
No explanation is available for this question!
|
|
7) You are using the backup scheduler in Enterprise Manager (EM) to schedule a backup of your database. Which type of script does the backup scheduler generate?
a. SQL script
b. PL/SQL script
c. Operating System (OS) script
d. Enterprise Manager (EM) script
e. Recovery Manager (RMAN) script
|
Answer
Explanation
|
ANSWER: Recovery Manager (RMAN) script
Explanation:
No explanation is available for this question!
|
|
8) Which of the following reasons can make job disabled?
a. The job was manually disabled
b. The job class it belongs to was dropped
c. The program, chain, or schedule that it points to was dropped
d. A window or window group is its schedule and the window or window group is dropped
e. All mentioned above
|
Answer
Explanation
|
ANSWER: All mentioned above
Explanation:
No explanation is available for this question!
|
|
9) If you create a job without specifying a job class, the job will be assigned to which job class?
a. DEFAULT_JOB_CLASS
b. JOB_CLASS
c. CREATE_JOB_CLASS
d. DROP_JOB_CLASS
|
Answer
Explanation
|
ANSWER: DEFAULT_JOB_CLASS
Explanation:
No explanation is available for this question!
|
|
10) Jobs are database objects, and can therefore accumulate and take up too much space. To avoid this, job objects are automatically dropped by default after completion. This behavior is controlled by which job attribute?
a. auto_view
b. auto_drop
c. auto_cancel
d. drop
|
Answer
Explanation
|
ANSWER: auto_drop
Explanation:
No explanation is available for this question!
|
|
11) In a non-shared database link, the connection is shared across multiple sessions.
a. True
b. False
|
Answer
Explanation
|
ANSWER: False
Explanation:
No explanation is available for this question!
|
|
12) Which partition forms of composite partitioning is well suited for historical data, but lets you further group the rows of data based on unordered or unrelated column values?
a. Range-Hash Partition
b. Range-List Partition
c. Both A & B
d. None of the above
|
Answer
Explanation
|
ANSWER: Range-List Partition
Explanation:
No explanation is available for this question!
|
|
13) What Enables you to quickly change storage and tablespace parameters without having to drop the original index?
a. Coalesce Index
b. Rebuild Index
c. Both A & B
d. None of the above
|
Answer
Explanation
|
ANSWER: Rebuild Index
Explanation:
No explanation is available for this question!
|
|
14) What does the status DEFER indicate in the LOG_ARCHIVE_DEST_STATE_n initialization parameter which lets you control the availability state of the specified destination (n)?
a. Indicates that the database can use the destination
b. Indicates that the location is temporarily disabled
c. Indicates that the destination is an alternate
d. All mentioned above
|
Answer
Explanation
|
ANSWER: Indicates that the location is temporarily disabled
Explanation:
No explanation is available for this question!
|
|
15) Advanced replication facility allows applications to insert, update, and delete table rows through updatable snapshots.
a. True
b. False
|
Answer
Explanation
|
ANSWER: True
Explanation:
No explanation is available for this question!
|
|
16) Which of the following object types cannot be replicated?
a. Data
b. Trigger
c. View
d. Sequence
|
Answer
Explanation
|
ANSWER: Sequence
Explanation:
No explanation is available for this question!
|
|
17) The following query lists all of the base objects for the synonyms created by user jward. What is displayed by the following example?
SELECT TABLE_OWNER, TABLE_NAME, SYNONYM_NAME
FROM DBA_SYNONYMS
WHERE OWNER = 'JWARD';
The following is the query output:
TABLE_OWNER----TABLE_NAME----SYNONYM_NAME
---------------------- ----------- -----------------
SACHIN---------DEPT----------DEPT
SACHIN---------EMP-----------EMP
a. Displaying Schema Objects by Type
b. Displaying Dependencies of Views and Synonyms
c. Both A & B
d. None of the above
|
Answer
Explanation
|
ANSWER: Displaying Dependencies of Views and Synonyms
Explanation:
No explanation is available for this question!
|
|
18) In which mode Oracle Database performs full redo logging for instance and media recovery. If the database is in ARCHIVELOG mode, then you can archive redo logs to tape. If the database is in NOARCHIVELOG mode, then you can recover instance crashes but not disk failures?
a. Direct-path INSERT without Logging
b. Direct-Path INSERT with Logging
c. Both A & B
d. None of the above
|
Answer
Explanation
|
ANSWER: Direct-Path INSERT with Logging
Explanation:
No explanation is available for this question!
|
|
19) You require the Oracle server to manage the undo segments and space among various active sessions automatically. You created an undo tablespace, UNDO_TBS1, in your database. Which two additional steps would you perform to achieve this?
a. Set the UNDO_RETENTION parameter to 900 or more
b. Create an initial undo segment in the undo tablespace
c. Set the UNDO_TABLESPACE parameter to UNDO_TBS1
d. Set the UNDO_MANAGEMENT initialization parameter to AUTO
e. Both C & D
|
Answer
Explanation
|
ANSWER: Both C & D
Explanation:
No explanation is available for this question!
|
|
20) Which SQL statement from the following is used to create a new tablespace?
a. CREATE TABLESPACE
b. CREATE TEMPORARY TABLESPACE
c. CREATE UNDO TABLESPACE
d. Both A & B
|
Answer
Explanation
|
ANSWER: Both A & B
Explanation:
No explanation is available for this question!
|
|
21) When a statement is suspended, it results in automatically suspending the transaction.
a. True
b. False
|
Answer
Explanation
|
ANSWER: True
Explanation:
No explanation is available for this question!
|
|
22) A DML statement that requires locks on a remote database can be blocked if any another transaction own locks on the requested data. If these locks continue to block the requesting SQL statement then which sequence of events occurs?
a. A timeout occurs
b. The database rolls back the statement
c. The database returns this error message to the use
d. All mentioned above
e. Both B & C
|
Answer
Explanation
|
ANSWER: All mentioned above
Explanation:
No explanation is available for this question!
|
|
23) Which of the following way can the Distributed transactions 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 connected
c. An unhandled software error does not occurs
d. None of the above
|
Answer
Explanation
|
ANSWER: A server machine running Oracle Database software crashes
Explanation:
No explanation is available for this question!
|
|
24) When a view is dropped, all grants of corresponding object privileges are revoked from roles and users. After the view is re-created, privileges must be regranted.
a. True
b. False
|
Answer
Explanation
|
ANSWER: True
Explanation:
No explanation is available for this question!
|
|
25) What is a Sequence with each new sequence number that is generated by a reference to the sequence pseudocolumn called?
a. CURRVAL
b. NEXTVAL
c. Both A & B
d. None of the above
|
Answer
Explanation
|
ANSWER: NEXTVAL
Explanation:
No explanation is available for this question!
|
|
