associated objects under a new schema name and move the associated data from
the previous schema to the new tables?
A) SQL*Loader
B) Direct-load insert
C) Schema Manager
D) Export/import utilities
Correct Answer(s): D) Export/import utilities
Explanation:
Answer d is correct. Export/import utilities are used to move tables, their
associated objects, and their data from one user to another user. SQL*Loader
is used to load data from external files into Oracle tables. Direct-load
insert writes data directly into Oracle datafiles, without using the buffer
cache. Schema Manager is an OEM utility used to create, edit, and examine
schema objects. It cannot move data from one schema to another.
Q2. What is the default port for the host naming method?
A) 1520
B) 1521
C) 1526
D) 1601
E) Any port may be used.
Correct Answer(s): B) 1521
Explanation:
The correct answer is b. The default port number of 1521 is required when
you configure host naming.
Q3. What is the purpose of the library cache area of the shared pool?
A) To store data on data dictionary caches
B) To store data retrieved from data files
C) To store shared SQL and PL/SQL
D) To provide for sort areas
Correct Answer(s): (C) To store shared SQL and PL/SQL
Explanation:
The correct answer is c. The library cache area of the SGA is used to store
shared SQL and PL/SQL. Answer a is incorrect because this is the function of
the data dictionary cache, which is a separate section of the shared pool
from the library cache. Answer b is incorrect because this is the function
of the database buffer pool, which is a separate section of the SGA from the
shared pool, which contains the library cache. Answer d is incorrect because
this is the function of the sort areas provided as a separate section of the
shared pool (in multithreaded servers) or as a part of the user's memory
area in multithreaded server (MTS) mode databases.
Q4. After you placed the tablespace LOOKUP_DATA in read-only mode, you took a
backup of LOOKUP_DATA. How often do you need to perform subsequent backups?
A) Each time a data file is added to the database.
B) Each time the control file is changed.
B) Each time the control file is changed.
C) Each time a database backup is performed.
D) Subsequent backups are not required.
Correct Answer(s):
D) Subsequent backups are not required.
Explanation:
The correct answer is d. The data in a read-only tablespace is static. You
only need to back up the LOOKUP_DATA tablespace immediately after it becomes
read-only. Answers a, b, and c are incorrect, because read-only tablespaces
don't need to be backed up under these circumstances.
Your production database has 15 data files spread across three disk drives.
How many backup sets are created by the following command sequence?
RMAN> RUN {
2> ALLOCATE CHANNEL c1 TYPE 'SBT_TAPE';
3> BACKUP
4> (DATABASE FILESPERSET = 3);
5> RELEASE CHANNEL c1; }
A) None
B) One
B) One
C) Two
D) Three
E) Four
F) Five
Correct Answer(s):
F) Five
Explanation:
The correct answer is f. The FILESPERSET option of the BACKUP command
specifies the number of files included in each backup set. For the sample
command, five backup sets with three files in each backup set will be
created. Answers a, b, c, d, and e are incorrect, because they don't match
the five backup sets the sample command will create.
What is the minimum number of redo log groups you need to configure for your
Oracle database?
A) One
B) Two
B) Two
C) Three
D) Four
Which of the following would be suitable circumstances in which to operate a
database in NOARCHIVELOG mode?
A) Control files are multiplexed.
B) Redo log files are multiplexed.
B) Redo log files are multiplexed.
C) The database can be shut down regularly to perform OS backups.
D) You can perform online backups while the database is in use.
Correct Answer(s):
C) The database can be shut down regularly to perform OS backups.
Explanation:
The correct answer is c. If you can regularly shut down a database for
backups, then you could consider operating the database in NOARCHIVELOG mode
if any lost data can be tolerated. Answers a and b are incorrect, because
these files should be multiplexed independent of the database log mode.
Answer d is incorrect, because ARCHIVELOG mode enables you to perform online
backups while the database is open and in use.
What is the minimum number of redo log groups you need to configure for your
Oracle database?
A) One
B) Two
B) Two
C) Three
D) Four
Which of the following would be suitable circumstances in which to operate a
database in NOARCHIVELOG mode?
A) Control files are multiplexed.
B) Redo log files are multiplexed.
B) Redo log files are multiplexed.
C) The database can be shut down regularly to perform OS backups.
D) You can perform online backups while the database is in use.
Correct Answer(s):
C) The database can be shut down regularly to perform OS backups.
Explanation:
The correct answer is c. If you can regularly shut down a database for
backups, then you could consider operating the database in NOARCHIVELOG mode
if any lost data can be tolerated. Answers a and b are incorrect, because
these files should be multiplexed independent of the database log mode.
Answer d is incorrect, because ARCHIVELOG mode enables you to perform online
backups while the database is open and in use.
Which of the following statements is NOT true about the recovery catalog?
A) The recovery catalog should be created in a database that is separate
from the target database.
B) The recovery catalog should be used when stored scripts are required.
B) The recovery catalog should be used when stored scripts are required.
C) The recovery catalog should be used when incremental block level backups
are required.
D) The recovery catalog should be used when historical information about
backup, restore, and recovery operations needs to be retained.
E) The recovery catalog should reside in the same database as the target
database.
What is the minimum number of redo log groups you need to configure for your
Oracle database?
A) One
B) Two
B) Two
C) Three
D) Four
Correct Answer(s):
B) Two
B) Two
Explanation:
The correct answer is b. The LGWR process writes redo log files in a
circular fashion, so two redo log groups are required to support this
operation. By default, Oracle creates two redo log groups. Answers a, b, and
d are incorrect, because they don't match the default number of two.
Which of the following statements is NOT true about the recovery catalog?
A) The recovery catalog should be created in a database that is separate
from the target database.
B) The recovery catalog should be used when stored scripts are required.
B) The recovery catalog should be used when stored scripts are required.
C) The recovery catalog should be used when incremental block level backups
are required.
D) The recovery catalog should be used when historical information about
backup, restore, and recovery operations needs to be retained.
E) The recovery catalog should reside in the same database as the target
database.
What is the minimum number of redo log groups you need to configure for your
Oracle database?
A) One
B) Two
B) Two
C) Three
D) Four
Correct Answer(s):
B) Two
B) Two
Explanation:
The correct answer is b. The LGWR process writes redo log files in a
circular fashion, so two redo log groups are required to support this
operation. By default, Oracle creates two redo log groups. Answers a, b, and
d are incorrect, because they don't match the default number of two.
Which of the following statements is NOT true about the recovery catalog?
A) The recovery catalog should be created in a database that is separate
from the target database.
B) The recovery catalog should be used when stored scripts are required.
B) The recovery catalog should be used when stored scripts are required.
C) The recovery catalog should be used when incremental block level backups
are required.
D) The recovery catalog should be used when historical information about
backup, restore, and recovery operations needs to be retained.
E) The recovery catalog should reside in the same database as the target
database.
What is the minimum number of redo log groups you need to configure for your
Oracle database?
A) One
B) Two
B) Two
C) Three
D) Four
Correct Answer(s):
B) Two
B) Two
Explanation:
The correct answer is b. The LGWR process writes redo log files in a
circular fashion, so two redo log groups are required to support this
operation. By default, Oracle creates two redo log groups. Answers a, b, and
d are incorrect, because they don't match the default number of two.
Which EXPORT mode can be used to export all objects owned by user Steve?
A) Full database
B) Tablespace
B) Tablespace
C) Table
D) User
Which of the following statements is NOT true about the recovery catalog?
A) The recovery catalog should be created in a database that is separate
from the target database.
B) The recovery catalog should be used when stored scripts are required.
B) The recovery catalog should be used when stored scripts are required.
C) The recovery catalog should be used when incremental block level backups
are required.
D) The recovery catalog should be used when historical information about
backup, restore, and recovery operations needs to be retained.
E) The recovery catalog should reside in the same database as the target
database.
Correct Answer(s):
E) The recovery catalog should reside in the same database as the target
database.
Explanation:
The correct answer is e. The recovery catalog should reside in a database
that is separate from the target database. Answers a, b, c, and d are
incorrect, because they are true statements about the recovery catalog.
Which EXPORT mode can be used to export all objects owned by user Steve?
A) Full database
B) Tablespace
B) Tablespace
C) Table
D) User
The answer to today's Question of the Day will appear in tomorrow's mailing.
If you would like to find out the answer immediately, please go to
http://www.examcram.com/studyresource/qod/login.asp The answer will be
accessible until Apr 3 2002.
----------------------------------------------------------------------------
Yesterday's Question of the Day and Answer for Oracle8 DBA: Backup and
Recovery
Mar 28 2002
----------------------------------------------------------------------------
Which of the following statements is NOT true about the recovery catalog?
A) The recovery catalog should be created in a database that is separate
from the target database.
B) The recovery catalog should be used when stored scripts are required.
B) The recovery catalog should be used when stored scripts are required.
C) The recovery catalog should be used when incremental block level backups
are required.
D) The recovery catalog should be used when historical information about
backup, restore, and recovery operations needs to be retained.
E) The recovery catalog should reside in the same database as the target
database.
Correct Answer(s):
E) The recovery catalog should reside in the same database as the target
database.
Explanation:
The correct answer is e. The recovery catalog should reside in a database
that is separate from the target database. Answers a, b, c, and d are
incorrect, because they are true statements about the recovery catalog.
Which of the following initialization parameter settings will enable check
summing for the online redo log files?
A) DB_BLOCK_CHECKSUM=Y
B) DB_BLOCK_CHECKSUM=TRUE
B) DB_BLOCK_CHECKSUM=TRUE
C) LOG_BLOCK_CHECKSUM=Y
D) LOG_BLOCK_CHECKSUM=TRUE
The answer to today's Question of the Day will appear in tomorrow's mailing.
If you would like to find out the answer immediately, please go to
http://www.examcram.com/studyresource/qod/login.asp The answer will be
accessible until Apr 4 2002.
----------------------------------------------------------------------------
Yesterday's Question of the Day and Answer for Oracle8 DBA: Backup and
Recovery
Mar 29 2002
----------------------------------------------------------------------------
Which EXPORT mode can be used to export all objects owned by user Steve?
A) Full database
B) Tablespace
B) Tablespace
C) Table
D) User
Correct Answer(s):
D) User
Explanation:
The correct answer is d. The EXPORT user mode will export all the objects in
a user's schema. Users can back up their own schema. A privileged user such
as the DBA can export all objects owned by one or more schemas. Answer a is
incorrect, because it will export all database objects except those owned by
the SYS schema. Answer b is incorrect, because it is an invalid export mode.
Answer c is incorrect, because it will only export specified tables owned by
the user schema.
When one of the Oracle background processes fails and the database shuts
down, where are the errors recorded?
A) CORE_DUMP_DEST
B) LOG_ARCHIVE_DEST
B) LOG_ARCHIVE_DEST
C) USER_DUMP_DEST
D) BACKGROUND_DUMP_DEST
Which of the following initialization parameter settings will enable check
summing for the online redo log files?
A) DB_BLOCK_CHECKSUM=Y
B) DB_BLOCK_CHECKSUM=TRUE
B) DB_BLOCK_CHECKSUM=TRUE
C) LOG_BLOCK_CHECKSUM=Y
D) LOG_BLOCK_CHECKSUM=TRUE
Correct Answer(s):
D) LOG_BLOCK_CHECKSUM=TRUE
Explanation:
The correct answer is d. When the LOG_BLOCK_CHECKSUM parameter is set to
TRUE, check summing for the online redo log files will be enabled. Answers a
and c are incorrect, because they are invalid parameter specifications.
Answer b is incorrect, because DB_BLOCK_CHECKSUM parameter applies to check
summing of data files.
Which of the following commands is used to perform an online backup of the
control file?
A) ALTER DATABASE BACKUP CONTROLFILE TO TRACE
B) ALTER SYSTEM BACKUP CONTROLFILE TO TRACE
B) ALTER SYSTEM BACKUP CONTROLFILE TO TRACE
C) ALTER SYSTEM BACKUP CONTROLFILE TO
D) ALTER DATABASE BACKUP CONTROLFILE TO
E) ALTER SESSION BACKUP CONTROLFILE TO
When one of the Oracle background processes fails and the database shuts
down, where are the errors recorded?
A) CORE_DUMP_DEST
B) LOG_ARCHIVE_DEST
B) LOG_ARCHIVE_DEST
C) USER_DUMP_DEST
D) BACKGROUND_DUMP_DEST
Correct Answer(s):
D) BACKGROUND_DUMP_DEST
Explanation:
The correct answer is d. When Oracle background processes encounter errors,
they will write the error trace files to the location specified by the
initialization parameter BACKGROUND_DUMP_DEST. Answers a, b, and c are
incorrect, because the background processes don't write error trace files to
these locations.
How will your backup strategy affect recoverability?
A) It will help you determine additional storage device needs.
B) It determines whether complete or incomplete recovery can be performed.
B) It determines whether complete or incomplete recovery can be performed.
C) It will help you get management support.
D) It will not affect recoverability.
Which of the following commands is used to perform an online backup of the
control file?
A) ALTER DATABASE BACKUP CONTROLFILE TO TRACE
B) ALTER SYSTEM BACKUP CONTROLFILE TO TRACE
B) ALTER SYSTEM BACKUP CONTROLFILE TO TRACE
C) ALTER SYSTEM BACKUP CONTROLFILE TO
D) ALTER DATABASE BACKUP CONTROLFILE TO
E) ALTER SESSION BACKUP CONTROLFILE TO
Correct Answer(s):
D) ALTER DATABASE BACKUP CONTROLFILE TO
Explanation:
The correct answer is d. The ALTER DATABASE BACKUP CONTROL-FILE TO
Answer a is incorrect, because it only creates a text script trace file that
may subsequently be modified and executed to create the binary control file.
Answers b, c, and e are incorrect, because they are invalid command
specifications.
After you placed the tablespace LOOKUP_DATA in read-only mode, you took a
backup of LOOKUP_DATA. How often do you need to perform subsequent backups?
A) Each time a data file is added to the database.
B) Each time the control file is changed.
B) Each time the control file is changed.
C) Each time a database backup is performed.
D) Subsequent backups are not required.
How will your backup strategy affect recoverability?
A) It will help you determine additional storage device needs.
B) It determines whether complete or incomplete recovery can be performed.
B) It determines whether complete or incomplete recovery can be performed.
C) It will help you get management support.
D) It will not affect recoverability.
Correct Answer(s):
B) It determines whether complete or incomplete recovery can be performed.
B) It determines whether complete or incomplete recovery can be performed.
Explanation:
The correct answer is b. Your backup strategy determines the type of
recovery that can be performed. Answers a and c are incorrect, because they
don't affect recoverability. Answer d is incorrect, because your backup
strategy does affect recoverability.
Posts
No comments:
Post a Comment