Jamonero Blanco
Quiz por , criado more than 1 year ago

OCA OCA Quiz sobre OCA-18-Using Grid Infrastructure and Data Movement Tools, criado por Jamonero Blanco em 31-01-2017.

11
2
0
Jamonero Blanco
Criado por Jamonero Blanco mais de 7 anos atrás
Fechar

OCA-18-Using Grid Infrastructure and Data Movement Tools

Questão 1 de 20

1

1. Which two PL/SQL packages are used by Oracle Data Pump?

Selecione uma ou mais das seguintes:

  • A. UTL_DATAPUMP

  • B. DBMS_METADATA

  • C. DBMS_DATAPUMP

  • D. UTL_FILE

  • E. DBMS_SQL

Explicação

Questão 2 de 20

1

2. Which of these options is not a benefit of Oracle Data Pump? (Choose two.)

Selecione uma ou mais das seguintes:

  • 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.

Explicação

Questão 3 de 20

1

3. The Data Pump job maintains a master control table with information about Data
Pump. Choose the right statement.

Selecione uma ou mais das seguintes:

  • 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.

Explicação

Questão 4 de 20

1

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.

Selecione uma ou mais das seguintes:

  • 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).

Explicação

Questão 5 de 20

1

5. Which command-line parameter of expdp and impdp clients connects you to an exist-
ing job?

Selecione uma ou mais das seguintes:

  • A. CONNECT_CLIENT

  • B. CONTINUE_CLIENT

  • C. APPEND

  • D. ATTACH

Explicação

Questão 6 de 20

1

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.

Selecione uma ou mais das seguintes:

  • A. CONTENT=BOTH TABLES=(not like 'TEMP%') SCHEMAS=SCOTT

  • B. SCHEMAS=SCOTT EXCLUDE=TABLE:"LIKE 'TEMP%'"

  • C. INCLUDE=METADATA EXCLUDE=TABLES:"NOT LIKE 'TEMP%'" SCHEMAS=SCOTT

  • D. TABLES="NOT LIKE 'TEMP%'" SCHEMAS=SCOTT

Explicação

Questão 7 de 20

1

7. Which parameter is not a valid one for using the impdp client?

Selecione uma ou mais das seguintes:

  • A. REMAP_INDEX

  • B. REMAP_TABLE

  • C. REMAP_SCHEMA

  • D. REMAP_TABLESPACE

  • E. REMAP_DATAFILE

Explicação

Questão 8 de 20

1

8. When do you use the FLASHBACK_TIME parameter in the impdp utility?

Selecione uma ou mais das seguintes:

  • 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 .

Explicação

Questão 9 de 20

1

9. To perform a Data Pump import from a live database, which parameter needs to be set?

Selecione uma ou mais das seguintes:

  • A. db_link

  • B. network_link

  • C. dumpfile

  • D. directory

Explicação

Questão 10 de 20

1

10. When is it most appropriate to use an external table?

Selecione uma ou mais das seguintes:

  • 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 quickly

Explicação

Questão 11 de 20

1

11. Choose the statement that is not true from the following about direct path load.

Selecione uma ou mais das seguintes:

  • 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.

Explicação

Questão 12 de 20

1

12. Which two statements regarding the Grid Infrastructure are true?

Selecione uma ou mais das seguintes:

  • 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.

Explicação

Questão 13 de 20

1

13. What is the smallest unit of storage in an ASM disk group?

Selecione uma ou mais das seguintes:

  • A. Database block

  • B. OS block

  • C. Allocation unit

  • D. Smallest disk in the disk group

Explicação

Questão 14 de 20

1

14. Which privilege is required to start and stop an ASM instance?

Selecione uma ou mais das seguintes:

  • A. SYSDBA

  • B. SYSASM

  • C. SYSDBA or SYSASM

  • D. SYSDBA or ASMOPER

Explicação

Questão 15 de 20

1

15. What Oracle Restart utility that is used to start and stop ASM instances also starts the
listener associated with the ASM?

Selecione uma ou mais das seguintes:

  • A. crsca

  • B. asmca

  • C. asmcmd

  • D. srvctl

Explicação

Questão 16 de 20

1

16. How many fail groups are required to configure a disk group with NORMAL
redundancy?

Selecione uma ou mais das seguintes:

  • A. 0

  • B. 1

  • C. 2

  • D. Fail groups are not applicable for NORMAL redundancy.

Explicação

Questão 17 de 20

1

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

Selecione uma ou mais das seguintes:

  • 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

Explicação

Questão 18 de 20

1

18. Which of the following statements can speed up the disk group rebalancing process?
(Choose two.)

Selecione uma ou mais das seguintes:

  • 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

Explicação

Questão 19 de 20

1

19. Choose the option that can be used to start an ASM instance.

Selecione uma ou mais das seguintes:

  • A. sqlplus

  • B. asmcmd

  • C. asmca

  • D. srvctl

  • E. All of the above

Explicação

Questão 20 de 20

1

20. Which command registers an ASM instance in Oracle Restart?

Selecione uma ou mais das seguintes:

  • A. srvctl add asm

  • B. srvctl config asm

  • C. srvctl register asm

  • D. srvctl start asm

Explicação

Anterior
Próximo