Database Reference
In-Depth Information
5.
Which of the following are valid scenarios for using Data Pump? (Choose all that apply.)
A.
Connect to
CDB$ROOT
and import root objects.
B.
Connect to
PDB$SEED
and import objects.
C.
Connect to a C## common user and import objects.
D.
Connect to a local user and import objects.
E.
None of the above.
6.
Which of the following is a SQL*Loader use case?
A.
Loading data from an Oracle table in a source non-CDB directly into a target table
in a PDB using a DB LINK connection
B.
Loading data into an Oracle table from a binary database file from a previous
Oracle database version
C.
Loading contents from a comma-delimited text file into a
CDB$ROOT
table
D.
Loading contents from a comma-delimited text file into a table in a PDB
E.
None of the above
7.
Which of these comments accurately describes the SQL*Loader components?
A.
The control file contains the source data, the parfile contains the optional param-
eters, and the data file describes the layout of the data to be imported.
B.
The parfile is required, the data file is a fixed-length list of records to import, and
the control file specifies the mandatory
BADFILE
and
DISCARDFILE
names.
C.
The optional parfile is used to simplify the management of parameters entered at
the command line.
D.
The
WHEN
clause is required in the control file.
E.
None of the above.
8.
When loading data with SQL*Loader, which of the following are true? (Choose all
that apply.)
A.
Specify the fixed record format using the
INFILE
parameter in the control file.
B.
By default, SQL*Loader assumes all records and fields are fixed length unless
otherwise specified in the parfile.
C.
Variable record format data load performs better than fixed and stream record
format.
D.
The stream record format is the most flexible but performance may suffer.
E.
None of the above.
Search WWH ::
Custom Search