1) The term replication refers to the operation for copying and maintaining database objects in multiple databases belonging to a distributed system.
a. True
b. False
|
Answer
Explanation
|
ANSWER: True
Explanation:
No explanation is available for this question!
|
|
2) All users on the local database can access the remote database and all use the same userid/password to make the connection. How can user access the remote database through the link?
a. Link type =Public, Authentication = Yes
b. Link type =Public, Authentication = No
c. Link type =Private, Authentication = No
d. Link type =Private, Authentication = Yes
|
Answer
Explanation
|
ANSWER: Link type =Public, Authentication = Yes
Explanation:
No explanation is available for this question!
|
|
3) If your distributed query contains ___________, then the cost-based optimization is not effective.
a. Aggregates
b. Subqueries
c. Complex SQL
d. All mentioned above
|
Answer
Explanation
|
ANSWER: All mentioned above
Explanation:
No explanation is available for this question!
|
|
4) Which of the following operations support the UPDATE INDEXES clause?
a. ADD PARTITION | SUBPARTITION, MERGE PARTITION | SUBPARTITION
b. COALESCE PARTITION | SUBPARTITION, MOVE PARTITION | SUBPARTITION
c. DROP PARTITION | SUBPARTITION, SPLIT PARTITION | SUBPARTITION
d. EXCHANGE PARTITION | SUBPARTITION, TRUNCATE PARTITION | SUBPARTITION
e. All mentioned above
|
Answer
Explanation
|
ANSWER: All mentioned above
Explanation:
No explanation is available for this question!
|
|
5) What does the database let you do if you require more explicit control over the indexes associated with UNIQUE and PRIMARY KEY constraints?
a. Specify a new index that the database is to use to enforce the constraint
b. Specify a CREATE INDEX statement that the database is to use to create the index and enforce the constraint
c. Both A & B
d. None of the above
|
Answer
Explanation
|
ANSWER: Specify a CREATE INDEX statement that the database is to use to create the index and enforce the constraint
Explanation:
No explanation is available for this question!
|
|
6) Which initialization parameter Defines the location of the default file system directory for redo log files and control file creation when no file specification is given in the creation operation?
a. DB_CREATE_FILE_DEST
b. DB_CREATE_ONLINE_LOG_DEST_n
c. DB_RECOVERY_FILE_DEST
d. None of the above
|
Answer
Explanation
|
ANSWER: DB_CREATE_ONLINE_LOG_DEST_n
Explanation:
No explanation is available for this question!
|
|
7) What are the consequences of an ARCHIVE LOG LIST command stated below?
SQL> ARCHIVE LOG LIST
Database log mode Archive Mode
Automatic archival Enabled
Archive destination D:\oracle\oradata\IDDB2\archive
Oldest online log sequence 11160
Next log sequence to archive 11163
Current log sequence 11163
a. The database is currently operating in NOARCHIVELOG mode
b. Automatic archiving is disabled
c. The current redo log file has a sequence number of 11160
d. None of the above
|
Answer
Explanation
|
ANSWER: None of the above
Explanation:
No explanation is available for this question!
|
|
8) Every instance of an Oracle Database is not associated with redo log to protect the database in case of an instance failure.
a. True
b. False
|
Answer
Explanation
|
ANSWER: False
Explanation:
No explanation is available for this question!
|
|
9) Oracle creates an index for the _____________ in the snapshot base table.
a. Primary key
b. Foreign key
c. Super key
d. Both a and c
|
Answer
Explanation
|
ANSWER: Primary key
Explanation:
No explanation is available for this question!
|
|
10) In DBMS_RESUMABLE Package, which function returns the current timeout value of resumable space allocation for the current session and the returned value is in seconds?
a. SET_SESSION_TIMEOUT(sessionID,timeout)
b. GET_TIMEOUT()
c. SET_TIMEOUT(timeout)
d. GET_SESSION_TIMEOUT(sessionID)
|
Answer
Explanation
|
ANSWER: GET_TIMEOUT()
Explanation:
No explanation is available for this question!
|
|
11) To rename an object, it must be in your schema. What are the ways to rename the schema objects?
a. Drop and re-create the object
b. Rename the object using the RENAME statement
c. Create the object
d. Both A & B
|
Answer
Explanation
|
ANSWER: Both A & B
Explanation:
No explanation is available for this question!
|
|
12) A Synonym is another name for an object. It is used to simplify access to objects such as tables owned by another user or to shorten lengthy object name.
a. True
b. False
|
Answer
Explanation
|
ANSWER: True
Explanation:
No explanation is available for this question!
|
|
13) The switch operation waits for transactions in the old undo tablespace to commit.
a. True
b. False
|
Answer
Explanation
|
ANSWER: False
Explanation:
No explanation is available for this question!
|
|
14) In Viewing Tablespace Information, which view gives Information for all extents in all locally managed temporary tablespaces?
a. V$TEMP_EXTENT_POOL
b. V$TEMP_EXTENT_MAP
c. V$TEMPSEG_USAGE
d. V$TEMP_SPACE_HEADER
|
Answer
Explanation
|
ANSWER: V$TEMP_EXTENT_MAP
Explanation:
No explanation is available for this question!
|
|
15) Which of the following are valid optimization methods?
a. Rule based
b. Cost based
c. Both a and b
d. Query based
|
Answer
Explanation
|
ANSWER: Both a and b
Explanation:
No explanation is available for this question!
|
|
16) The indoubt transaction locks data that is required by other transactions. This situation occurs when the ORA-01591 error message interferes with user transactions.
a. True
b. False
|
Answer
Explanation
|
ANSWER: True
Explanation:
No explanation is available for this question!
|
|
17) Which condition is applied while determining the commit point site?
a. A read-only node can be the commit point site
b. If multiple nodes directly referenced by the global coordinator have the same commit point strength, then the database designates one of these as the commit point site
c. If a distributed transaction starts with a rollback, then the prepare and commit phases are not needed
d. None of the above
|
Answer
Explanation
|
ANSWER: If multiple nodes directly referenced by the global coordinator have the same commit point strength, then the database designates one of these as the commit point site
Explanation:
No explanation is available for this question!
|
|
18) What are the following guidelines used for?
1) Be sure the sequence cache can hold all the sequences used concurrently by your applications
2) Increase the number of values for each sequence held in the sequence cache
a. Slow access to all sequence numbers
b. Fast access to all sequence numbers
c. Neutral
d. All mentioned above
|
Answer
Explanation
|
ANSWER: Fast access to all sequence numbers
Explanation:
No explanation is available for this question!
|
|
19) Which are the several utilities that are available to help you maintain the data in your Oracle Database?
a. SQL*Loader
b. Export and Import Utilities
c. Both A & B
d. None of the above
|
Answer
Explanation
|
ANSWER: Both A & B
Explanation:
No explanation is available for this question!
|
|
20) The syntax to create a synonym is:
CREATE [PUBLIC] synonym_name
FOR [schema.]object_name[@database_link_name];
In this syntax what specifies either a table, view, sequence, materialized view, type, procedure, function or package as appropriate?
a. PUBLIC
b. Synonym_name
c. Schema
d. Object_name
|
Answer
Explanation
|
ANSWER: Object_name
Explanation:
No explanation is available for this question!
|
|
21) Which is the smallest unit of storage in an Oracle database?
a. Data Block
b. Segment
c. Extent
d. Data file
|
Answer
Explanation
|
ANSWER: Data Block
Explanation:
No explanation is available for this question!
|
|
22) Which of these must be performed to find or store a row in an indexed table or cluster?
a. One or more I/Os to find or store the key value in the index
b. Another I/O to read or write the row in the table or cluster
c. Both A & B
d. None of the above
|
Answer
Explanation
|
ANSWER: Both A & B
Explanation:
No explanation is available for this question!
|
|
23) You can alter an existing cluster to change which of the following settings?
a. Physical attributes (INITRANS and storage characteristics)
b. The average amount of space is not required to store all the rows for a cluster key value (SIZE)
c. There is no default degree of parallelism
d. All mentioned above
e. None of the above
|
Answer
Explanation
|
ANSWER: Physical attributes (INITRANS and storage characteristics)
Explanation:
No explanation is available for this question!
|
|
24) Back up the control file to a binary file (duplicate of existing control file) using the following statement
ALTER DATABASE BACKUP CONTROLFILE TO '/oracle/backup/control.bkp';
a. True
b. False
|
Answer
Explanation
|
ANSWER: True
Explanation:
No explanation is available for this question!
|
|
25) Which of the following statements are true about Automatic Storage Management (ASM)?
a. ASM provides mirroring on file by file basis
b. ASM provides automatic load balancing across all ASM disks
c. ASM supports the Oracle database and operating system files
d. ASM can be used to store trace files, alert log files, and the server parameter file (SPFILE)
e. Both A & B
|
Answer
Explanation
|
ANSWER: Both A & B
Explanation:
No explanation is available for this question!
|
|
