1) 1. Which administrator's responsibilities can include the following tasks?
1) Planning for backup and recovery of database information
2) Maintaining archived data on tape
3) Backing up and restoring the database
4) Contacting Oracle for technical support
a. Network Administrator
b. Application Administrators
c. Database Administrators
d. Security Officers
|
Answer
Explanation
|
ANSWER: Database Administrators
Explanation:
No explanation is available for this question!
|
|
2) Select the correct query to view the links that you own.
a. select db_link from user_db_links;
b. select _link from user_db_links;
c. select db_link from dblinks;
d. select link from user_db_links;
|
Answer
Explanation
|
ANSWER: select db_link from user_db_links;
Explanation:
No explanation is available for this question!
|
|
3) Which are the examples of setting the DISPATCHERS initialization parameter?
a. Typical
b. Forcing the Port Used by Dispatchers
c. Forcing the IP Address Used for Dispatchers
d. All mentioned above
|
Answer
Explanation
|
ANSWER: All mentioned above
Explanation:
No explanation is available for this question!
|
|
4) Can there be more than one datafile per tablespace?
a. Yes
b. No
|
Answer
Explanation
|
ANSWER: Yes
Explanation:
No explanation is available for this question!
|
|
5) The Implications of dropping hash clusters and tables in hash clusters are not same as those for dropping index clusters.
a. True
b. False
|
Answer
Explanation
|
ANSWER: False
Explanation:
No explanation is available for this question!
|
|
6) Which SYSTEM privilege must be used to create a cluster in another user's schema?
a. CREATE ANY CLUSTER
b. CREATE ANY SCHEMA CLUSTER
c. CREATE SCHEMA CLUSTER
d. CREATE CLUSTER
|
Answer
Explanation
|
ANSWER: CREATE ANY CLUSTER
Explanation:
No explanation is available for this question!
|
|
7) Which errors can be encountered by Troubleshooting after Creating Control Files after issuing the CREATE CONTROLFILE statement?
a. Checking for Missing or Extra Files
b. Handling Errors During CREATE CONTROLFILE
c. Both A & B
d. None of the above
|
Answer
Explanation
|
ANSWER: Both A & B
Explanation:
No explanation is available for this question!
|
|
8) The database must be opened by using a text-based parameter file instead of a server parameter file (SPFILE).
a. True
b. False
|
Answer
Explanation
|
ANSWER: True
Explanation:
No explanation is available for this question!
|
|
9) Which SQL Statement creates a new empty datafile in place of an old one-useful to re-create a datafile that was lost with no backup?
a. ALTER DATABASE...CREATE DATAFILE
b. CREATE DATABASE
c. ALTER TABLESPACE...ADD TEMPFILE
d. CREATE TEMPORARY TABLESPACE
|
Answer
Explanation
|
ANSWER: ALTER DATABASE...CREATE DATAFILE
Explanation:
No explanation is available for this question!
|
|
10) Which sub clause is specified for the UNDO TABLESPACE clause in Specifying Oracle-Managed Files at Database creation?
a. No LOGFILE
b. No SYSAUX DATAFILE
c. No DATAFILE
d. No TEMPFILE
|
Answer
Explanation
|
ANSWER: No DATAFILE
Explanation:
No explanation is available for this question!
|
|
11) What should a database do to start an instance and it should read the instance configuration parameters (the initialization parameters)?
a. SPFILE
b. PFILE
c. Both A & B
d. None of the above
|
Answer
Explanation
|
ANSWER: Both A & B
Explanation:
No explanation is available for this question!
|
|
12) Using oracle scheduler you have scheduled two jobs, JOB_A and JOB_B, to run at 9:00 p.m. every friday. You want both the jobs to use a single resource plan, weekend_plan. Which task must have already been performed to enable you to achieve this objective?
a. A window must have been created with the WEEKEND_PLAN resource plan
b. A program must have been created with the WEEKEND_PLAN resource plan
c. A job class must have been created with the WEEKEND_PLAN resource plan
d. A window group must have been created with the WEEKEND_PLAN resource plan
|
Answer
Explanation
|
ANSWER: A window must have been created with the WEEKEND_PLAN resource plan
Explanation:
No explanation is available for this question!
|
|
13) Which task does the SET_ATTRIBUTE procedure come under the Job tasks and their procedures?
a. Create a job
b. Alter a job
c. Run a job
d. Disable a job
|
Answer
Explanation
|
ANSWER: Alter a job
Explanation:
No explanation is available for this question!
|
|
14) A job must be part of exactly one class. When you create a job, you can specify which class the job is part of. If you do not specify a class, the job will automatically become part of which class?
a. default_job_class
b. job_class
c. job_over_max_dur
d. Both A and B
|
Answer
Explanation
|
ANSWER: default_job_class
Explanation:
No explanation is available for this question!
|
|
15) Which of these is used to process information requests in the distributed databases?
a. Homogeneous Distributed Database Systems
b. Heterogeneous Distributed Database Systems
c. Client/Server Database Architecture
d. All mentioned above
|
Answer
Explanation
|
ANSWER: Client/Server Database Architecture
Explanation:
No explanation is available for this question!
|
|
16) How many types of exceptions can occur when the database executes a procedure locally or at a remote location?
a. PL/SQL user-defined exceptions, which must be declared using the keyword EXCEPTION
b. PL/SQL predefined exceptions such as the NO_DATA_FOUND keyword
c. SQL errors such as ORA-00900 and ORA-02015
d. Application exceptions generated using the RAISE_APPLICATION_ERROR() Procedure
e. All mentioned above
|
Answer
Explanation
|
ANSWER: All mentioned above
Explanation:
No explanation is available for this question!
|
|
17) You can compress some or all partitions of a B-tree index using key compression. Key compression is applicable only to B-tree indexes.
a. True
b. False
|
Answer
Explanation
|
ANSWER: True
Explanation:
No explanation is available for this question!
|
|
18) In the following example which method is used to partition the index-organized table, sales?
CREATE TABLE sales(acct_no NUMBER(5),
acct_name CHAR(30),
amount_of_sale NUMBER(6),
week_no INTEGER,
sale_details VARCHAR2(1000),
PRIMARY KEY (acct_no, acct_name, week_no))
ORGANIZATION INDEX
INCLUDING week_no
OVERFLOW
PARTITION BY HASH (week_no)
PARTITIONS 16
STORE IN (ts1, ts2, ts3, ts4)
OVERFLOW STORE IN (ts3, ts6, ts9);
a. List
b. Hash
c. Range
d. None of the above
|
Answer
Explanation
|
ANSWER: Hash
Explanation:
No explanation is available for this question!
|
|
19) What benefits does creating an index with NOLOGGING have?
a. Space is saved in the redo log files
b. The time it takes to create the index is decreased
c. Performance improves for parallel creation of large indexes
d. All mentioned above
|
Answer
Explanation
|
ANSWER: All mentioned above
Explanation:
No explanation is available for this question!
|
|
20) What does the DB_CREATE_ONLINE_LOG_DEST_n initialization parameter in your initialization parameter file to identify the default location for the database server to create?
a. Datafiles
b. Redo log files
c. Control files
d. Both A & B
e. Both B & C
|
Answer
Explanation
|
ANSWER: Both B & C
Explanation:
No explanation is available for this question!
|
|
21) Which parameter is used to specify a maximum of two locations,used to specify a primary archive destination?
a. LOG_ARCHIVE_DEST
b. LOG_ARCHIVE_DUPLEX_DEST
c. LOG_ARCHIVE_FORMAT
d. None of the above
|
Answer
Explanation
|
ANSWER: LOG_ARCHIVE_DEST
Explanation:
No explanation is available for this question!
|
|
22) Which parameter is used in the CREATE DATABASE statement that determines the maximum number of groups of redo log files for each database?
a. MAXLOGMEMBERS
b. MAXLOGFILES
c. DEFAULT
d. Both A & B
|
Answer
Explanation
|
ANSWER: MAXLOGFILES
Explanation:
No explanation is available for this question!
|
|
23) What needs to be done to perform a fast refresh?
a. The server that manages the snapshot executes the snapshot's defining query
b. Query should replace the existing snapshot data to refresh the snapshot
c. The server that manages the snapshot first identifies the changes that occurred in the master since the most recent refresh of the snapshot and then applies them to the snapshot
d. Create a snapshot log for the table so that fast refreshes of the snapshots are an option
|
Answer
Explanation
|
ANSWER: The server that manages the snapshot first identifies the changes that occurred in the master since the most recent refresh of the snapshot and then applies them to the snapshot
Explanation:
No explanation is available for this question!
|
|
24) INITRANS specifies the number of update transaction entries for which space is initially reserved in the data block header.
a. True
b. False
|
Answer
Explanation
|
ANSWER: True
Explanation:
No explanation is available for this question!
|
|
25) Why do you analyze a schema object (table, index, or cluster)?
a. No need to Collect and manage statistics for it
b. Does not verify the validity of its storage format
c. UnIdentify migrated and chained rows of a table or cluster
d. None of the above
|
Answer
Explanation
|
ANSWER: None of the above
Explanation:
No explanation is available for this question!
|
|
