1) Which of these components forms a global database name?
a. A database name
b. A domain name
c. Both A & B
d. None of the above
|
Answer
Explanation
|
ANSWER: Both A & B
Explanation:
No explanation is available for this question!
|
|
2) What are the elements of the redo log buffer and Shared pool?
a. PGA
b. Buffer cache
c. Both a and b
d. SGA
|
Answer
Explanation
|
ANSWER: SGA
Explanation:
No explanation is available for this question!
|
|
3) A _____________ is a set of tables physically stored together as one table that shares a common column.
a. Index
b. Object
c. Datafiles
d. Cluster
|
Answer
Explanation
|
ANSWER: Cluster
Explanation:
No explanation is available for this question!
|
|
4) To create a cluster index, one of the following conditions must be true?
a. Your schema contains the cluster
b. You have the CREATE ANY INDEX system privilege
c. Your schema does not contain cluster
d. You don’t have the CREATE ANY INDEX system privilege
e. Both A & B
|
Answer
Explanation
|
ANSWER: Both A & B
Explanation:
No explanation is available for this question!
|
|
5) Single-table hash cluster, provides fast access to rows in a table and this table must be the only table in the hash cluster. Essentially, there must be which mapping between hash keys and data rows?
a. many-to-one mapping
b. one-to-many mapping
c. One-to-one mapping
d. Both A & B
|
Answer
Explanation
|
ANSWER: One-to-one mapping
Explanation:
No explanation is available for this question!
|
|
6) The disks in a disk group are referred to as ASM disks on Windows operating systems an ASM disk is always a partition, on all other platforms an ASM disk can be _________.
a. A partition of a logical unit number (LUN)
b. A network-attached file
c. Both A & B
d. None of the above
|
Answer
Explanation
|
ANSWER: Both A & B
Explanation:
No explanation is available for this question!
|
|
7) Which scenario are the chains automatically disabled by the scheduler?
a. The program that one of the chain steps points to is dropped
b. The nested chain that one of the chain steps points to is dropped
c. The event schedule that one of the chain event steps points to is dropped
d. All mentioned above
|
Answer
Explanation
|
ANSWER: All mentioned above
Explanation:
No explanation is available for this question!
|
|
8) A chain can become stalled when no steps are running, no steps are scheduled to run, no event steps are waiting for an event, and the evaluation_interval for the chain is NULL.
a. True
b. False
|
Answer
Explanation
|
ANSWER: True
Explanation:
No explanation is available for this question!
|
|
9) Select the correct method for creating jobs.
a. Named Program
b. Named Schedule
c. Named Program and Schedule
d. All mentioned above
|
Answer
Explanation
|
ANSWER: All mentioned above
Explanation:
No explanation is available for this question!
|
|
10) The Scheduler can pass an event-based job for the message content of the event that started the job. To pass an event-based job which of the following rules will be applied?
a. The job must use a named program of type STORED_PROCEDURE
b. One of the named program's arguments must be a metadata argument with metadata_attribute set to EVENT_MESSAGE
c. The stored procedure that implements the program must have an argument at the position corresponding to the named program's metadata argument. The argument type must be the data type of the queue where your application queues the job-start event
d. Both A & B
e. All mentioned above
|
Answer
Explanation
|
ANSWER: All mentioned above
Explanation:
No explanation is available for this question!
|
|
11) In the Scheduler, most components are database objects like a table, which enables you to use normal oracle privileges. Select the correct basic elements of the scheduler.
a. Programs
b. Schedules
c. Events
d. Chains
e. All of the above.
|
Answer
Explanation
|
ANSWER: All of the above.
Explanation:
No explanation is available for this question!
|
|
12) After creating a job, you may need to set job arguments if-
a. The inline job action is a stored procedure or other executable that requires arguments.
b. The job references a named program object and you want to override one or more default program arguments.
c. The job references a named program object and one or more of the program arguments were not assigned a default value.
d. All mentioned above.
|
Answer
Explanation
|
ANSWER: All mentioned above.
Explanation:
No explanation is available for this question!
|
|
13) Which schema does this window group reside?
a. system
b. sysdba
c. sys
d. Both B and C
|
Answer
Explanation
|
ANSWER: sys
Explanation:
No explanation is available for this question!
|
|
14) In ________ type of link users connect as themselves. This means that they must have an account on the remote database with the same username as their account on the local database.
a. Connected user link
b. Fixed user link
c. Current user link
d. Both A & B
|
Answer
Explanation
|
ANSWER: Connected user link
Explanation:
No explanation is available for this question!
|
|
15) In distributed SQL statements, which of the following retrieves information from two or more nodes?
a. Distributed query
b. Distributed update
c. Both A & B
d. None of the above
|
Answer
Explanation
|
ANSWER: Distributed query
Explanation:
No explanation is available for this question!
|
|
16) Each committed transaction has an associated number to uniquely identify the changes made by the statements within the transaction and that number is called, _________ .
a. Supply change number
b. System change number
c. Oracle change number
d. Commit change number
|
Answer
Explanation
|
ANSWER: System change number
Explanation:
No explanation is available for this question!
|
|
17) The Remote File Server process which is required when archiving to a remote destination, is responsible for which the following tasks?
a. Consuming network I/O from the ARCn process
b. Creating file names on the standby database by using the STANDBY_ARCHIVE_DEST parameter
c. Populating the log files at the remote site
d. Updating the standby database control file
e. All mentioned above
|
Answer
Explanation
|
ANSWER: All mentioned above
Explanation:
No explanation is available for this question!
|
|
18) The delay between the time a DML change is applied at the originating database and the time the transaction reaches the destination databases is called as _______ .
a. Propagation
b. Propagation latency
c. Conflict
d. Conflict latency
|
Answer
Explanation
|
ANSWER: Propagation latency
Explanation:
No explanation is available for this question!
|
|
19) Data changes in a snap shot can be triggered ________.
a. Manually
b. Automatically
c. Both a and b
d. Scheduled
|
Answer
Explanation
|
ANSWER: Both a and b
Explanation:
No explanation is available for this question!
|
|
20) A constraint in a table is defined with the INITIALLY IMMEDIATE clause. You executed the ALTER TABLE command with the ENABLE VALIDATE option to enable the constraint that was disabled.
What are the two effects of this command?
a. It fails if any existing row violates the constraint
b. It does not validate the existing data in the table
c. It prevents insert, update, and delete operations on the table while the constraint is in the process of being enabled.
d. Both A & C
e. Both A & B
|
Answer
Explanation
|
ANSWER: Both A & C
Explanation:
No explanation is available for this question!
|
|
21) What do we call transactions in which commit was interrupted by any type of system or network failure?
a. in-doubt distributed transactions
b. doubt distributed transactions
c. in-doubt transactions
d. Both a and b
|
Answer
Explanation
|
ANSWER: in-doubt distributed transactions
Explanation:
No explanation is available for this question!
|
|
22) When does a statement run in a resumable mode?
a. When the client implicitly enables resumable semantics for the session using the ALTER SESSION statement
b. When the client explicitly enables resumable semantics for the session using the ALTER SESSION statement
c. When the client implicitly enables resumable semantics for the session using the CREATE SESSION statement
d. When the client explicitly enables resumable semantics for the session using the CREATE SESSION statement
|
Answer
Explanation
|
ANSWER: When the client explicitly enables resumable semantics for the session using the ALTER SESSION statement
Explanation:
No explanation is available for this question!
|
|
23) To ensure that a transaction does not hang if it cannot obtain a lock, which of the following statements below should be executed?
a. UPDATE ... NOWAIT
b. FOR UPDATE ... WAIT
c. FOR UPDATE ... NOWAIT
d. UPDATE ... WAIT
|
Answer
Explanation
|
ANSWER: FOR UPDATE ... NOWAIT
Explanation:
No explanation is available for this question!
|
|
24) When a transaction is committed, what does the LGWR do?
a. Writes redo log entries in the SGA's redo log buffers to the online redo log file
b. Writes the transaction's SCN to the online redo log file
c. Both a and b
d. Writes the unique system change number (SCN) to redo log file.
|
Answer
Explanation
|
ANSWER: Both a and b
Explanation:
No explanation is available for this question!
|
|
25) ___________________ determines the best possible way to execute a query.
a. Transaction optimizer
b. Query optimizer
c. Optimizer
d. Oracle optimizer
|
Answer
Explanation
|
ANSWER: Query optimizer
Explanation:
No explanation is available for this question!
|
|
26) Errors discovered during SQL statement execution cause
a. statement-level rollback
b. Row-level rollback
c. Deadlock
d. Both a and b
|
Answer
Explanation
|
ANSWER: statement-level rollback
Explanation:
No explanation is available for this question!
|
|
27) You cannot use an ALTER VIEW statement to change the definition of a view but you can replace views in which of the following ways?
a. You can drop and recreate the view
b. You can redefine the view with a CREATE VIEW statement that contains the OR REPLACE clause
c. Both A & B
d. None of the above
|
Answer
Explanation
|
ANSWER: Both A & B
Explanation:
No explanation is available for this question!
|
|
28) Which of the following is / are DML Statements?
a. Insert
b. Update
c. Create
d. Both A and B
|
Answer
Explanation
|
ANSWER: Both A and B
Explanation:
No explanation is available for this question!
|
|
29) Which of the following are types of segments?
a. Permanent segment
b. Object segment
c. Data Segment
d. All of the above
|
Answer
Explanation
|
ANSWER: Data Segment
Explanation:
No explanation is available for this question!
|
|
30) How many layers does the Oracle database have?
a. 1
b. 2
c. 3
d. 4
|
Answer
Explanation
|
ANSWER: 2
Explanation:
No explanation is available for this question!
|
|
31) What is the role in the session tree that has a node which is forced to reference data on other nodes to complete its part of the transaction?
a. Client
b. Database server
c. Global coordinator
d. Local coordinator
|
Answer
Explanation
|
ANSWER: Local coordinator
Explanation:
No explanation is available for this question!
|
|
32) In which of the following ways does the database use SCNs to coordinate the distributed transactions among different databases?
a. An application establishes a connection using a database line
b. The distributed transaction commits with the highest global SCN among all the databases involved
c. The commit global SCN is sent to all databases involved in the transaction
d. Both A & B
e. All mentioned above
|
Answer
Explanation
|
ANSWER: All mentioned above
Explanation:
No explanation is available for this question!
|
|
