Chapter 18 Using Grid Infrastructure and Data Movement Tools
■
Review Questions
1. Which two PL/SQL packages are used by Oracle Data Pump?
A. UTL_DATAPUMP
B. DBMS_METADATA
C. DBMS_DATAPUMP
D. UTL_FILE
E. DBMS_SQL
2. Which of these options is not a benefit of Oracle Data Pump? (Choose two.)
A. Data Pump supports fine-grained object selection using the EXCLUDE, INCLUDE, and
CONTENT options.
B. Data Pump has the ability to specify the target version of the database so that the
objects exported are compatible. This is useful in moving data from Oracle 12c to
Oracle 11g.
C. Data Pump has the ability to specify the maximum number of threads to
unload data.
D. The DBA can choose to perform the export using a direct path or external tables.
E. The Data Pump job can be monitored from another computer on the network.
3. The Data Pump job maintains a master control table with information about Data
Pump. Choose the right statement.
A. The master table is the heart of Data Pump operation and is maintained in the
SYS schema.
B. The master table contains one row for the operation that keeps track of the object
being worked so that the job can be restarted in the event of failure.
C. During the export, the master table is written to the dump-file set at the beginning
of export operation.
D. The Data Pump job runs in the schema of the job creator with that user’s rights
and privileges.
E. All of the above.
4. When using the expdp and impdp clients, the parameters LOGFILE, DUMPFILE, and SQLFILE
need a directory object where the files will be written to or read from. Choose the nonsup-
ported method for nonprivileged users.
A. Specify the DIRECTORY parameter.
B. Specify the filename parameters with directory:file_name.
C. Use the initialization parameter DATA_PUMP_DIR.
D. None of the above (all are supported).
Review Questions
1079
5. Which command-line parameter of expdp and impdp clients connects you to an exist-
ing job?
A. CONNECT_CLIENT
B. CONTINUE_CLIENT
C. APPEND
D. ATTACH
6. Which option unloads the data and metadata of the SCOTT user, except the tables that
begin with TEMP? The dump file also should have the DDL to create the user.
A. CONTENT=BOTH TABLES=(not like 'TEMP%')
B. SCHEMAS=SCOTT
SCHEMAS=SCOTT
EXCLUDE=TABLE:"LIKE 'TEMP%'"
C. INCLUDE=METADATA EXCLUDE=TABLES:"NOT LIKE 'TEMP%'" SCHEMAS=SCOTT
D. TABLES="NOT LIKE 'TEMP%'" SCHEMAS=SCOTT
7. Which parameter is not a valid one for using the impdp client?
A. REMAP_INDEX
B. REMAP_TABLE
C. REMAP_SCHEMA
D. REMAP_TABLESPACE
E. REMAP_DATAFILE
8. When do you use the FLASHBACK_TIME parameter in the impdp utility?
A. To load data from the dump file that was modified after a certain time.
B. To discard data from the dump file that was modified after a certain time.
C. When the NETWORK_LINK parameter is used.
D. FLASHBACK_TIME is valid only with expdp, not with impdp.
9. To perform a Data Pump import from a live database, which parameter needs to be set?
A. db_link
B. network_link
C. dumpfile
D. directory
10. When is it most appropriate to use an external table?
A. When you need to read binary files (PDF and photos) into Oracle Database
B. To query a large file without loading the data into the database
C. When the expdp and impdp utilities are not licensed for use
D. To load a large file into the database quickly1080
Chapter 18 Using Grid Infrastructure and Data Movement Tools
■
11. Choose the statement that is not true from the following about direct path load.
A. Direct path load cannot occur if active transactions against the table are
being loaded.
B. Triggers do not fire during direct path loads.
C. During direct path loads, foreign key constraints are disabled at the beginning of
the load and then re-enabled after the load.
D. Only primary key, unique, and NOT NULL constraints are enforced.
E. Direct path load allows other users to perform DML operations on the table while
the direct load operation is in progress.
12. Which two statements regarding the Grid Infrastructure are true?
A. It is mandatory to create a disk group during the GI install using the Install and
Configure Oracle Grid Infrastructure for a Standalone Server option.
B. You can only create one disk group during the GI install.
C. A disk group must have at least two disks.
D. After a GI install, ASMCA must be run to configure an ASM instance.
13. What is the smallest unit of storage in an ASM disk group?
A. Database block
B. OS block
C. Allocation unit
D. Smallest disk in the disk group
14. Which privilege is required to start and stop an ASM instance?
A. SYSDBA
B. SYSASM
C. SYSDBA or SYSASM
D. SYSDBA or ASMOPER
15. What Oracle Restart utility that is used to start and stop ASM instances also starts the
listener associated with the ASM?
A. crsca
B. asmca
C. asmcmd
D. srvctl
Review Questions
1081
16. How many fail groups are required to configure a disk group with NORMAL
redundancy?
A. 0
B. 1
C. 2
D. Fail groups are not applicable for NORMAL redundancy.
17. Review the following statement, and choose the SQL statement that successfully drops
a disk from the disk group.
SQL> SELECT name, path
FROM
v$asm_disk
WHERE group_number = 1;
NAME
------------
FRADISK_000
FRADISK_001
PATH
------------------------
/dev/rd/sd10c1
/dev/rd/sd11c1
A. DROP DISK FRADISK_000
B. ALTER DISKGROUP DROP DISK FRADISK_000
C. ALTER DISKGROUP DROP DISK '/dev/rd/sd10c1'
D. ALTER DISKGROUP DROP DISK FRADISK_000, FRADISK_001
18. Which of the following statements can speed up the disk group rebalancing process?
(Choose two.)
A. ALTER SYSTEM SET ASM_POWER_LIMIT=0
B. ALTER SYSTEM SET ASM_POWER_LIMIT=100
C. ALTER DISKGROUP oradata REBALANCE POWER 100
D. ALTER DISKGROUP oradata ASM_POWER_LIMIT 100
19. Choose the option that can be used to start an ASM instance.
A. sqlplus
B. asmcmd
C. asmca
D. srvctl
E. All of the above1082
Chapter 18 Using Grid Infrastructure and Data Movement Tools
■
20. Which command registers an ASM instance in Oracle Restart?
A. srvctl add asm
B. srvctl config asm
C. srvctl register asm
D. srvctl start asm
------------------------------------------
Chapter 18: Using Grid Infrastructure
and Data Movement Tools
1. B, C. The DBMS_METADATA package provides the database object definitions to the export
worker processes in the order of their creation. The DBMS_DATAPUMP package has the API
for high-speed export and import for bulk data and metadata loading and unloading.
2. B, D. Oracle Data Pump is known to versions 10g and newer; Oracle9i does not sup-
port Data Pump. Although Data Pump can perform data access using the direct-path
Chapter 18: Using Grid Infrastructure and Data Movement Tools
1117
or external-table method, Data Pump makes the decision automatically; the DBA can-
not specify the data-access method. Data Pump also supports network mode to import
directly from the source database and can estimate the space requirements for the
dump file.
3. D. The master table is the heart of the Data Pump operation and is maintained in the
schema of the job creator. It bears the name of the job, contains one row for each object
and each operation, and keeps status. Using this information helps restart a failed job or
suspend and resume a job. The master table is written to the dump file as the last step of
the export and is loaded to the schema of the user as the first step of the import.
4. C. If a directory object is created with the name DATA_PUMP_DIR, the privileged users can
use this location as the default location for Data Pump files. Privileged users are users
with EXP_FULL_DATABASE or IMP_FULL_DATABASE roles. Using %U in the filename generates
multiple files for parallel unloads, with each parallel process writing to one file.
5. D. The ATTACH parameter lets you attach or connect to an existing Data Pump job and
places you in interactive mode. ATTACH without any parameters attaches to the currently
running job, if there is only one job from the user. Otherwise, you must specify the job
name when using the ATTACH parameter.
6. B. If the CONTENT parameter is not specified, both data and metadata will be unloaded.
The valid values for CONTENT are METADATA_ONLY, DATA_ONLY, and ALL. If SCOTT is per-
forming the export, SCHEMAS=SCOTT is optional.
7. A. REMAP_DATAFILE changes the name of the source data file to the target data filename
in all DDL statements where the source data file is referenced. REMAP_SCHEMA loads
all objects from the source schema into the destination schema. When using REMAP_
TABLESPACE, all objects selected for import with persistent data in the source tablespace
are remapped to be created in the destination tablespace. REMAP_TABLE changes the
name of the table. Because the dump file is in XML format, Data Pump can make these
transformations easily. REMAP_INDEX is an invalid parameter.
8. C. You can specify the FLASHBACK_TIME or FLASHBACK_SCN parameter only when per-
forming a network import where the source is a database.
9. B. The network_link parameter specifies a database link to the source database.
10. B. External tables can be used to read ASCII flat files without loading them into the
database. The external table must be created with the ORACLE_LOADER access driver.
11. E. While the direct path load is in progress, users cannot run any DML statements
against the table. Only queries are allowed.
12. A, B. If you do not want to create a disk group during the GI install, you must choose the
Software Only install option. Only one disk group can be created during the GI install.
Additional disk groups can be created after the installation using ASMCA or SQL*Plus.1118
Appendix A Answers to Review Questions
■
Although we recommend that you have more than one disk in each disk group, it is not
mandatory. GI install configures the ASM instance and uses the disk group created dur-
ing the install to save the parameter file and password file of ASM instance.
13. C. The smallest unit of storage in an ASM disk group is the allocation unit. Oracle
Database 12c permits sizes of 1, 2, 4, 8, 16, 32, or 64MB. The allocation unit is
the size of the blocks allocated to a data file. The AU must be small enough to keep
hot spots from occurring and large enough for efficient sequential reads. 1MB is the
default, and 4MB AU is recommended for most databases.
14. B. You must be connected to the ASM instance with the SYSASM privilege to start and
stop the ASM instance.
15. D. Server control is used to start and stop all Oracle Restart components including
ASM, listener, and database.
16. C. A NORMAL redundancy disk group requires two fail groups, and a HIGH redun-
dancy disk group requires three fail groups.
17. B. Option A is an invalid statement. The disk path can be used only when adding a
disk; when dropping a disk the disk name must be provided. Option C is using a disk
path with the drop clause and is invalid. Option D is syntactically correct, but you can-
not drop all disks from a disk group. A disk group must have at least one disk.
18. B, C. The rebalance speed at an instance level is adjusted using the ASM_POWER_LIMIT
parameter. Rebalance power can be adjusted using the ALTER DISKGROUP statement as
well. The higher the power limit, the more quickly a rebalance operation can complete.
Higher power values consume more I/O resources, which could impact database per-
formance. Rebalancing takes longer with lower power values, but it consumes fewer
processing and I/O resources.
19. E. All of the tools listed in options A to D can be used to start an ASM instance. You have
to explicitly provide start commands in sqlplus, asmcmd, and srvctl, but if asmca finds
that the ASM instance is not started, it gets confirmation from you and starts the instance.
20. A. The Server Control utility (srvctl) is used to register a component during an Oracle
Restart. The add command is used to register a component. The config command
shows the configuration information. The start command starts the component after
it is registered. The register command is not valid.
No comments:
Post a Comment