Copiar y Editar

OCA-18-Using Grid Infrastructure and Data Movement Tools

Descripción

OCA OCA Test sobre OCA-18-Using Grid Infrastructure and Data Movement Tools, creado por Jamonero Blanco el 31/01/2017.
Jamonero Blanco
Test por Jamonero Blanco, actualizado hace más de 1 año
Jamonero Blanco
Creado por Jamonero Blanco hace más de 7 años
10
2
0

Resumen del Recurso

Pregunta 1

Pregunta
1. Which two PL/SQL packages are used by Oracle Data Pump?
Respuesta
  • A. UTL_DATAPUMP
  • B. DBMS_METADATA
  • C. DBMS_DATAPUMP
  • D. UTL_FILE
  • E. DBMS_SQL

Pregunta 2

Pregunta
2. Which of these options is not a benefit of Oracle Data Pump? (Choose two.)
Respuesta
  • 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.

Pregunta 3

Pregunta
3. The Data Pump job maintains a master control table with information about Data Pump. Choose the right statement.
Respuesta
  • 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.

Pregunta 4

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

Pregunta 5

Pregunta
5. Which command-line parameter of expdp and impdp clients connects you to an exist- ing job?
Respuesta
  • A. CONNECT_CLIENT
  • B. CONTINUE_CLIENT
  • C. APPEND
  • D. ATTACH

Pregunta 6

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

Pregunta 7

Pregunta
7. Which parameter is not a valid one for using the impdp client?
Respuesta
  • A. REMAP_INDEX
  • B. REMAP_TABLE
  • C. REMAP_SCHEMA
  • D. REMAP_TABLESPACE
  • E. REMAP_DATAFILE

Pregunta 8

Pregunta
8. When do you use the FLASHBACK_TIME parameter in the impdp utility?
Respuesta
  • 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 .

Pregunta 9

Pregunta
9. To perform a Data Pump import from a live database, which parameter needs to be set?
Respuesta
  • A. db_link
  • B. network_link
  • C. dumpfile
  • D. directory

Pregunta 10

Pregunta
10. When is it most appropriate to use an external table?
Respuesta
  • 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

Pregunta 11

Pregunta
11. Choose the statement that is not true from the following about direct path load.
Respuesta
  • 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.

Pregunta 12

Pregunta
12. Which two statements regarding the Grid Infrastructure are true?
Respuesta
  • 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.

Pregunta 13

Pregunta
13. What is the smallest unit of storage in an ASM disk group?
Respuesta
  • A. Database block
  • B. OS block
  • C. Allocation unit
  • D. Smallest disk in the disk group

Pregunta 14

Pregunta
14. Which privilege is required to start and stop an ASM instance?
Respuesta
  • A. SYSDBA
  • B. SYSASM
  • C. SYSDBA or SYSASM
  • D. SYSDBA or ASMOPER

Pregunta 15

Pregunta
15. What Oracle Restart utility that is used to start and stop ASM instances also starts the listener associated with the ASM?
Respuesta
  • A. crsca
  • B. asmca
  • C. asmcmd
  • D. srvctl

Pregunta 16

Pregunta
16. How many fail groups are required to configure a disk group with NORMAL redundancy?
Respuesta
  • A. 0
  • B. 1
  • C. 2
  • D. Fail groups are not applicable for NORMAL redundancy.

Pregunta 17

Pregunta
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
Respuesta
  • 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

Pregunta 18

Pregunta
18. Which of the following statements can speed up the disk group rebalancing process? (Choose two.)
Respuesta
  • 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

Pregunta 19

Pregunta
19. Choose the option that can be used to start an ASM instance.
Respuesta
  • A. sqlplus
  • B. asmcmd
  • C. asmca
  • D. srvctl
  • E. All of the above

Pregunta 20

Pregunta
20. Which command registers an ASM instance in Oracle Restart?
Respuesta
  • A. srvctl add asm
  • B. srvctl config asm
  • C. srvctl register asm
  • D. srvctl start asm
Mostrar resumen completo Ocultar resumen completo

¿Quieres crear tus propios Tests gratis con GoConqr? Más información.

Similar

Ciencia Abierta en la UNC
Mario Pizzi
ROUND & TRUNC [DATES]
Adrian Mora
PMBOK
Maye Tapia
Matemáticasen la VidaCotidiana
Diego Santos
Gramática para Practicar el First Certificate II
Diego Santos
Normas básicas de acentuación
Edgardo Palomino
Test de Matemáticas para el GMAT (en Inglés)
Diego Santos
Indicadores y parámetros básicos en los sistemas de manufactura
itsel_quistian14
HORARIO DE ESTUDIO (SEMANAL)
Vaaanesa1703
VOCABULARIO DE INGLÉS
Sandra Molina Garcia
Verb tenses
maria.mos2902
Explorar la Librería