1) You can also create views that specify more than one base table or view in the FROM Clause, These are called join views.
a. True
b. False
|
Answer
Explanation
|
ANSWER: True
Explanation:
No explanation is available for this question!
|
|
2) How many user accounts are automatically created when Oracle Database is installed?
a. 4
b. 3
c. 2
d. 1
|
Answer
Explanation
|
ANSWER: 2
Explanation:
No explanation is available for this question!
|
|
3) In a distributed database system, each database should not have a unique global database name.
a. True
b. False
|
Answer
Explanation
|
ANSWER: False
Explanation:
No explanation is available for this question!
|
|
4) Which can service multiple user processes in a Oracle Database which creates server processes to handle the requests of user processes Connected to an instance of a server process?
a. A dedicated server
b. A shared server
c. Both A & B
d. None of the above
|
Answer
Explanation
|
ANSWER: A shared server
Explanation:
No explanation is available for this question!
|
|
5) What is the use of an index?
a. Retrieve data more quickly and efficiently
b. Related data requires much less I/O overhead if accessed simultaneously
c. Simplify the user's perception of data access
d. Both a and c
|
Answer
Explanation
|
ANSWER: Retrieve data more quickly and efficiently
Explanation:
No explanation is available for this question!
|
|
6) Even if you decide to use hashing; a table cannot still separate indexes on any columns, including the cluster key.
a. True
b. False
|
Answer
Explanation
|
ANSWER: False
Explanation:
No explanation is available for this question!
|
|
7) In Displaying Control File Information which view lists the names of control files?
a. V$DATABASE
b. V$PARAMETER
c. V$CONTROLFILE
d. V$CONTROLFILE_RECORD_SECTION
|
Answer
Explanation
|
ANSWER: V$CONTROLFILE
Explanation:
No explanation is available for this question!
|
|
8) A database that uses Automatic Storage Management (ASM) usually has a non-default SPFILE.
a. True
b. False
|
Answer
Explanation
|
ANSWER: True
Explanation:
No explanation is available for this question!
|
|
9) Which statement we used for manually increasing or decreasing the size of a datafile?
a. ALTER DATABASE
b. ALTER TABLESPACE
c. CREATE DATABASE
d. CREATE TABLESPACE
|
Answer
Explanation
|
ANSWER: ALTER DATABASE
Explanation:
No explanation is available for this question!
|
|
10) Which 'view' contains database related information from the control file?
a. V$DATABASE
b. DATABASE_PROPERTIES
c. GLOBAL_NAME
d. None of the above
|
Answer
Explanation
|
ANSWER: V$DATABASE
Explanation:
No explanation is available for this question!
|
|
11) Changes made to parameter file PFILE, Database need to be restarted to take effect the changes.
a. True
b. False
|
Answer
Explanation
|
ANSWER: True
Explanation:
No explanation is available for this question!
|
|
12) ___________ privilege can only be granted for programs, chains, and job classes. It enables you to create a job that runs with the program, chain, or job class. It also enables you to view object attributes
a. Alter
b. All
c. Execute
d. None of the above
|
Answer
Explanation
|
ANSWER: Execute
Explanation:
No explanation is available for this question!
|
|
13) You can run the job synchronously with RUN_JOB by setting which of the following argument.
a. use_current_session=true
b. use_current_session=flase
c. Both A and B can be set
d. failure_count=true
|
Answer
Explanation
|
ANSWER: use_current_session=true
Explanation:
No explanation is available for this question!
|
|
14) At least one rule must have a condition that always evaluates to TRUE so that the chain can start when the job starts.
a. True
b. False
|
Answer
Explanation
|
ANSWER: True
Explanation:
No explanation is available for this question!
|
|
15) Which user type in a database link has username/password as part of the link definition?
a. Current user
b. Connected user
c. Fixed user
d. Both A & B
|
Answer
Explanation
|
ANSWER: Fixed user
Explanation:
No explanation is available for this question!
|
|
16) Where is the file UTLXPLAN.SQL by default located?
a. $ORACLE_HOME/rdbms/admin directory
b. $ORACLE_HOME/rdbms/admin/network directory
c. $ORACLE_HOME/rdbms/ directory
d. $ORACLE_HOME/rdbms/admin/dbs directory
|
Answer
Explanation
|
ANSWER: $ORACLE_HOME/rdbms/admin directory
Explanation:
No explanation is available for this question!
|
|
17) The rules for creating range-partitioned global indexes are similar to those for creating range-partitioned tables.
a. True
b. False
|
Answer
Explanation
|
ANSWER: True
Explanation:
No explanation is available for this question!
|
|
18) CREATE INDEX does not stores the timestamp of the most recent function used in the function-based index.
a. True
b. False
|
Answer
Explanation
|
ANSWER: False
Explanation:
No explanation is available for this question!
|
|
19) Logical volume manager (LVM) is a software package available with most operating systems. Sometimes it is called a logical disk manager (LDM).
a. True
b. False
|
Answer
Explanation
|
ANSWER: True
Explanation:
No explanation is available for this question!
|
|
20) Which transmission involves transmitting files to a local disk?
a. Standby transmission
b. Normal transmission
c. Both A & B
d. None of the above
|
Answer
Explanation
|
ANSWER: Normal transmission
Explanation:
No explanation is available for this question!
|
|
21) What are the Redo log files that are no longer required for instance recovery called?
a. Active Redo log files
b. Inactive Redo log files
c. Current
d. None of the above
|
Answer
Explanation
|
ANSWER: Inactive Redo log files
Explanation:
No explanation is available for this question!
|
|
22) For each replication group there should be ____ master definition site
a. 1
b. 2
c. 3
d. 5
|
Answer
Explanation
|
ANSWER: 1
Explanation:
No explanation is available for this question!
|
|
23) How many levels can we request advice from the Segment Advisor?
a. 4
b. 2
c. 3
d. 1
|
Answer
Explanation
|
ANSWER: 3
Explanation:
No explanation is available for this question!
|
|
24) Which User System Privilege used for this operation authorized to connect to the database?
a. CREATE TABLE
b. CREATE VIEW
c. CREATE SESSION
d. CREATE SEQUENCE
|
Answer
Explanation
|
ANSWER: CREATE SESSION
Explanation:
No explanation is available for this question!
|
|
25) Two-phase commit mechanism is completely transparent to users who issue _________________ .
a. Commit a transaction
b. Rollback a transaction
c. Non distributed transactions
d. Distributed transactions
|
Answer
Explanation
|
ANSWER: Distributed transactions
Explanation:
No explanation is available for this question!
|
|
