1z0-062: Oracle Database 12c Installation and Administration Examine Practice Questions
The free 1z0-062: Oracle Database 12c Installation and Administration questions that deal with examine, with answers and explanations. The full bank and the timed practice test cover every topic the exam asks about.
Question #5
Examine the contents of SQL loader control file: Which three statements are true regarding the SQL* Loader operation performed using the control file? (Choose three.)
Select 3 answers.
Correct answer: B, D, E
Explanation
A: The APPEND keyword tells SQL*Loader to preserve any preexisting data in the table. Other options allow you to delete preexisting data, or to fail with an error if the table is not empty to begin with. B (not D): Note: * SQL*Loader-00210: first data file is empty, cannot process the FIELD NAMES record Cause: The data file listed in the next message was empty. Therefore, the FIELD NAMES FIRST FILE directive could not be processed. Action: Check the listed data file and fix it. Then retry the operation E: * A comma-separated values (CSV) (also sometimes called character-separated values, because the separator character does not have to be a comma) file stores tabular data (numbers and text) in plain-text form. Plain text means that the file is a sequence of characters, with no data that has to be interpreted instead, as binary numbers. ACSV file consists of any number of records, separated by line breaks of some kind; each record consists of fields, separated by some other character or string, most commonly a literal comma or tab. Usually, all records have an identical sequence of fields. * Fields with embedded commas must be quoted. Example: 1997,Ford,E350,"Super, luxurious truck" Note: * SQL*Loader is a bulk loader utility used for moving data from external files into the Oracle database.
Question #8
Examine the resources consumed by a database instance whose current Resource Manager plan is displayed. Which two statements are true? (Choose two.)
Select 2 answers.
Correct answer: C, E
Explanation
CPU_WAIT_TIME reports only the time sessions were held back by Resource Manager scheduling, not waits for I/O or contention. When a group's active session limit is reached, new sessions are queued rather than failing with an error.
Continue with 1z0-062: Oracle Database 12c Installation and Administration
Unlock the full question bank
You have read the first 10 questions. A subscription opens every question in 1z0-062: Oracle Database 12c Installation and Administration, the full timed practice test, and your progress and weak-topic reporting.
Single exam
$19.99for 30 days
Full question bank and practice test for one exam, for 30 days.
Single exam
$49.99for 1 year
One exam for a full year. Nothing renews and nothing to cancel.
Full access
$39.99/mo
Every exam in the catalogue, month to month.
Full access
$199.99/yr
Every exam in the catalogue for a year.
Already subscribed? Sign in to pick up where you left off.
All 1z0-062: Oracle Database 12c Installation and Administration practice questions →