1) In a distributed transaction, sessions or remote instances are suspended only if RESUMABLE has been disabled in the remote instance
a. True
b. False
|
Answer
Explanation
|
ANSWER: False
Explanation:
No explanation is available for this question!
|
|
2) On Tuesday, a junior DBA dropped an important application user account, whose schema has important tables. You are asked to recover all the objects in the schema. On investigation, you find that the user account was dropped at 11:00 a.m. and Sunday's backup is the most recent backup. Which flashback feature would you use?
a. Flashback Drop
b. Flashback Table
c. Flashback Database
d. Flashback Version Query
e. Flashback Transaction Query
|
Answer
Explanation
|
ANSWER: Flashback Drop
Explanation:
No explanation is available for this question!
|
|
3) Which type of table is a group of tables that share the same data blocks because they share common columns and are often used together?
a. Ordinary table
b. Partitioned table
c. Clustered table
d. Index-organized table
|
Answer
Explanation
|
ANSWER: Clustered table
Explanation:
No explanation is available for this question!
|
|
4) Data files of which tablespaces can be recovered by performing an open recovery?
a. TEMP
b. INDEX
c. SYSAUX
d. ALL MENTIONED ABOVE
|
Answer
Explanation
|
ANSWER: ALL MENTIONED ABOVE
Explanation:
No explanation is available for this question!
|
|
5) Which utility ensure that the CONSTRAINTS and TRIGGERS parameters are set to Y the default?
a. EXP
b. IMP
c. Both A & B
d. None of the above
|
Answer
Explanation
|
ANSWER: EXP
Explanation:
No explanation is available for this question!
|
|
6) To drop a private synonym in another user's schema, you must have which system privilege?
a. DROP SYNONYM
b. DROP ANY SYNONYM
c. DROP PUBLIC SYNONYM
d. All mentioned above
|
Answer
Explanation
|
ANSWER: DROP ANY SYNONYM
Explanation:
No explanation is available for this question!
|
|
7) LGWR is an acronym for?
a. log writer
b. logger writer
c. log write
d. log written
|
Answer
Explanation
|
ANSWER: log writer
Explanation:
No explanation is available for this question!
|
|
8) As a DBA, you often perform special operations such as shutting down or starting up a database.
a. True
b. False
|
Answer
Explanation
|
ANSWER: True
Explanation:
No explanation is available for this question!
|
|
9) Select the correct SQL statement.
a. Select * from global_name;
b. Select from global_name;
c. Select * from domain_name;
d. Both A and C
|
Answer
Explanation
|
ANSWER: Select * from global_name;
Explanation:
No explanation is available for this question!
|
|
10) What contains information for tuning shared server in a Monitoring Shared Server?
a. V$SHARED_SERVER
b. V$CIRCUIT
c. V$SHARED_SERVER_MONITOR
d. V$SHARED_POOL_RESERVED
|
Answer
Explanation
|
ANSWER: V$SHARED_SERVER_MONITOR
Explanation:
No explanation is available for this question!
|
|
11) Which processes is an instance made of?
a. Oracle background processes
b. Memory processes
c. Data processes
d. All of the above
|
Answer
Explanation
|
ANSWER: Oracle background processes
Explanation:
No explanation is available for this question!
|
|
12) Oracle Database uses a hash function to generate a distribution of numeric values, called hash values, that are based on specific cluster key values.
a. True
b. False
|
Answer
Explanation
|
ANSWER: True
Explanation:
No explanation is available for this question!
|
|
13) Which view describes all clusters in the database?
a. DBA_CLUSTER_HASH_EXPRESSIONS
b. DBA_CLUSTERS
c. DBA_CLUSTERS_ALL
d. DBA_CLUSTERS_INFO
|
Answer
Explanation
|
ANSWER: DBA_CLUSTERS
Explanation:
No explanation is available for this question!
|
|
14) You can change the database name and DBID (internal database identifier) using the DBNEWID utility.
a. True
b. False
|
Answer
Explanation
|
ANSWER: True
Explanation:
No explanation is available for this question!
|
|
15) In your production database you want to use an Automatic Storage Management (ASM) instance to manage the database files. Which option would you use to migrate the database files from a non-ASM instance to an ASM instance?
a. Oracle Migration Assistant
b. Recovery Manager (RMAN)
c. Oracle Data Pump Export and Import
d. Conventional Oracle Export and Import
|
Answer
Explanation
|
ANSWER: Oracle Migration Assistant
Explanation:
No explanation is available for this question!
|
|
16) The value of which is the minimum size of the increments added to the file when it extends?
a. MAXSIZE
b. NEXT
c. BOTH A & B
d. NONE OF THE ABOVE
|
Answer
Explanation
|
ANSWER: NEXT
Explanation:
No explanation is available for this question!
|
|
17) In defining Application Services for Oracle Database 10g which Services describe applications, application functions, and data ranges as either functional services or data-dependent services?
a. Configuring Services
b. Deploying Services
c. Using Services
d. All mentioned above
|
Answer
Explanation
|
ANSWER: Configuring Services
Explanation:
No explanation is available for this question!
|
|
18) You cannot start a database instance if you are connected to the database through a shared server process.
a. True
b. False
|
Answer
Explanation
|
ANSWER: True
Explanation:
No explanation is available for this question!
|
|
19) While creating a scheduler window using the DBMS_SCHEDULER package, a user logged in as DBMGR gets the error message “insufficient privileges”. Which command(s) would you use to resolve this error?
a. GRANT dba TO dbmgr;
b. GRANT connects TO dbmgr;
c. GRANT resource TO dbmgr;
d. GRANT manage scheduler TO dbmgr;
e. a and d
|
Answer
Explanation
|
ANSWER: a and d
Explanation:
No explanation is available for this question!
|
|
20) A job is the combination of a schedule and a program.
a. True
b. False
|
Answer
Explanation
|
ANSWER: True
Explanation:
No explanation is available for this question!
|
|
21) Can a job also be created by pointing to both a named program and schedule.
a. True
b. False
|
Answer
Explanation
|
ANSWER: True
Explanation:
No explanation is available for this question!
|
|
22) Which feature of database reduces the amount of data transfer required between sites when a transaction retrieves data from remote tables and referenced in a distributed SQL statement?
a. Transparency in a distributed database system
b. Remote procedure calls
c. Distributed query optimization
d. All mentioned above
|
Answer
Explanation
|
ANSWER: Distributed query optimization
Explanation:
No explanation is available for this question!
|
|
23) In Rewriting your query to access the remote database once it is achieved by using collocated inline views, which term is used for defining two or more tables that are located in the same database?
a. Collocated
b. Inline view
c. Collocated inline view
d. None of the above
|
Answer
Explanation
|
ANSWER: Collocated
Explanation:
No explanation is available for this question!
|
|
24) You cannot drop the only partition in a table. Instead, you must drop the table.
a. True
b. False
|
Answer
Explanation
|
ANSWER: True
Explanation:
No explanation is available for this question!
|
|
25) What should be done to use a function-based index?
a. The table must be analyzed after the index is created
b. The query must be guaranteed need NULL values from the indexed expression, since NULL values are not stored in indexes
c. Both A & B
d. None of the above
|
Answer
Explanation
|
ANSWER: The table must be analyzed after the index is created
Explanation:
No explanation is available for this question!
|
|
