1) A sequence is referenced in SQL statements with the NEXTVAL and CURRVAL pseudocolumns, what can be used in the following places?
1) VALUES clause of INSERT statements
2) The SELECT list of a SELECT statement
3) The SET clause of an UPDATE statement
a. CURRVAL
b. NEXTVAL
c. Both A & B
d. None of the above
|
Answer
Explanation
|
ANSWER: Both A & B
Explanation:
No explanation is available for this question!
|
|
2) In Database Administrator evaluate how Oracle Database and its applications can best use the available computer resources; this evaluation should reveal which of the following information?
a. How many disk drives are available to the Oracle Products?
b. How many, if any, dedicated tape drives are available to Oracle products
c. How much memory is available to the instances of Oracle Database you will run
d. All mentioned above
|
Answer
Explanation
|
ANSWER: All mentioned above
Explanation:
No explanation is available for this question!
|
|
3) What do the schema objects comprise of?
a. Table
b. Index
c. Cluster
d. All of the above
|
Answer
Explanation
|
ANSWER: All of the above
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) For maximum distribution of rows in a hash cluster, the database rounds the HASHKEYS value up to the nearest _________ .
a. Prime Number
b. ODD Number
c. Null
d. None of the above
|
Answer
Explanation
|
ANSWER: Prime Number
Explanation:
No explanation is available for this question!
|
|
6) In your Automatic Storage Management (ASM) instance, one of the nonempty disk groups, DGROUP1, is no longer required and you want this disk group to be removed. You execute the following command to achieve this objective.
DROP DISKGROUP dgroup1 EXCLUDING CONTENTS;
What would be the result of this command?
a. This command would result in an error because the disk group is not empty
b. The command would drop the disk group, ignoring the EXCLUDING CONTENTS option
c. The command would result in the disk group being marked as INVALID because it cannot be dropped
d. The command would result in the contents being moved to the parent disk group and dropping of the disk group
|
Answer
Explanation
|
ANSWER: This command would result in an error because the disk group is not empty
Explanation:
No explanation is available for this question!
|
|
7) Which view in an ASM instance contains one row for every ASM file in every disk group mounted by the ASM instance in a DB instance that contains no rows?
a. V$ASM_FILE
b. V$ASM_DISK
c. V$ASM_DISK_STAT
d. V$ASM_DISKGROUP_STAT
|
Answer
Explanation
|
ANSWER: V$ASM_FILE
Explanation:
No explanation is available for this question!
|
|
8) Which DBMS_STORAGE_MAP package procedure enables you to build the mapping information for the database object identified by object name, owner, and type?
a. MAP_ELEMENT
b. MAP_FILE
c. MAP_ALL
d. MAP_OBJECT
|
Answer
Explanation
|
ANSWER: MAP_OBJECT
Explanation:
No explanation is available for this question!
|
|
9) An aborted database shutdown proceeds with which of the following conditions?
a. New connections are allowed, nor are new transactions not allowed to be started, after the statement is issued.
b. Current client SQL statements not being processed by Oracle Database are immediately terminated.
c. Uncommitted transactions are rolled back
d. Oracle Database does wait for users currently connected to the database to Connect. The database implicitly connects all connected users.
e. None of the above
|
Answer
Explanation
|
ANSWER: None of the above
Explanation:
No explanation is available for this question!
|
|
10) You can check a job state by issuing which method for the job that was scheduled to run once and complete successfully?
a. Succeeded
b. Retry Scheduled
c. Scheduled
d. Chain_stalled
|
Answer
Explanation
|
ANSWER: Succeeded
Explanation:
No explanation is available for this question!
|
|
11) Which procedure is used for altering an event based job?
a. set_attribute
b. create_event_schedule
c. create_job
d. create_event_program
|
Answer
Explanation
|
ANSWER: set_attribute
Explanation:
No explanation is available for this question!
|
|
12) In starting the chain at least one rule must have a condition that always evaluates to TRUE.
a. True
b. False
|
Answer
Explanation
|
ANSWER: True
Explanation:
No explanation is available for this question!
|
|
13) Which attribute is currently not implemented in the scheduler event queue?
a. run_count
b. failure_count
c. retry_count
d. spare1-spare8
|
Answer
Explanation
|
ANSWER: spare1-spare8
Explanation:
No explanation is available for this question!
|
|
14) Which process specifies the maximum number of processes that can be created for the execution of jobs?
a. job_queue_processes
b. dbms_scheduler
c. dbms_scheduler.create_job
d. set_job_anydata_value
|
Answer
Explanation
|
ANSWER: job_queue_processes
Explanation:
No explanation is available for this question!
|
|
15) The REMOTE_OS_AUTHENT parameter operates an externally-authenticated user and it can connect to the remote database using a connected user database link, Select the correct parameter to set.
a. REMOTE_OS_AUTHENT = false
b. REMOTE_OS_AUTHENT = true
c. Both A & B
d. None of the above
|
Answer
Explanation
|
ANSWER: REMOTE_OS_AUTHENT = true
Explanation:
No explanation is available for this question!
|
|
16) What is site autonomy?
a. Each server participating in a distributed database is administered independently from all other databases.
b. Nodes of the system cannot mirror the logical organization of companies or groups that need to maintain independence.
c. Local administrators cannot control corresponding local data. Therefore, each database administrator’s domain of responsibility is smaller and more manageable.
d. Administrators cannot recover from isolated system failures independently from other nodes in the system.
|
Answer
Explanation
|
ANSWER: Each server participating in a distributed database is administered independently from all other databases.
Explanation:
No explanation is available for this question!
|
|
17) What are the Memory Structures subdivided as?
a. SGA
b. PGA
c. Sort Area
d. All mentioned above
|
Answer
Explanation
|
ANSWER: All mentioned above
Explanation:
No explanation is available for this question!
|
|
18) A filled redo log file is available after the changes recorded in it have been written to the datafiles if archiving is ______.
a. Enabled
b. Disabled
c. Both A & B
d. None of the above
|
Answer
Explanation
|
ANSWER: Disabled
Explanation:
No explanation is available for this question!
|
|
19) Which one of the following way is correct to turn ON replication?
a. DBMS_REPUTIL_REPLICATION=ON
b. DBMS_REPUTIL.REPLICATION=ON
c. DBMS_REPUTIL.REPLICATION_ON
d. All of the above
|
Answer
Explanation
|
ANSWER: DBMS_REPUTIL.REPLICATION_ON
Explanation:
No explanation is available for this question!
|
|
20) A _______________ is a collection of one or more replicated objects (typically tables) that are administrated together.
a. Replica
b. Replica group
c. Replication
d. Replication group
|
Answer
Explanation
|
ANSWER: Replication group
Explanation:
No explanation is available for this question!
|
|
21) In the error Logging Table format, which set of columns contain data from the row that caused the error and the column names match the column names from the table being inserted into (the "DML table")?
a. Optional set
b. Mandatory set
c. Both A & B
d. None of the above
|
Answer
Explanation
|
ANSWER: Optional set
Explanation:
No explanation is available for this question!
|
|
22) A transportable tablespace set consists of datafiles for the set of tablespaces being transported and an export file containing structural information (metadata) for the set of tablespaces we use ______
a. Data Pump
b. EXP
c. IMP
d. Both A & B
|
Answer
Explanation
|
ANSWER: Both A & B
Explanation:
No explanation is available for this question!
|
|
23) Savepoints divide a long transaction into smaller parts.
a. True
b. False
|
Answer
Explanation
|
ANSWER: True
Explanation:
No explanation is available for this question!
|
|
24) Which of the following performs the following operations during a distributed transaction?
1) Sends all of the distributed transaction SQL statements, remote procedure calls, and so forth to the directly referenced nodes, thus forming the session tree.
2) Instructs all directly referenced nodes other than the commit point site to prepare the transaction.
3) Instructs the commit point site to initiate the global commit of the transaction if all nodes prepare successfully.
a. Database server
b. Local coordinator
c. Global coordinator
d. Commit point site
|
Answer
Explanation
|
ANSWER: Global coordinator
Explanation:
No explanation is available for this question!
|
|
25) What is / are the rules for updatable join views in which rule any INSERT, UPDATE, or DELETE operation on a join view can modify only one underlying base table at a time?
a. UPDATE Rule
b. INSERT Rule
c. DELETE Rule
d. GENERAL Rule
|
Answer
Explanation
|
ANSWER: GENERAL Rule
Explanation:
No explanation is available for this question!
|
|
