Tag: databases

Questions Related to databases

What is control file?
technology databases

  1. It describe how to interpret the flat file and options to load the data.

  2. It describe the location and format of the data file.

  3. It describe the location of the Bad and Discard records file .

  4. It has the control to connect database

Show answer
Correct Option: A,B,C

What are the mandatory options in the control(*.ctl) file.
technology databases

  1. LOAD DATA, INFILE, COLUMNS OF THE TARGET TABLE

  2. BADFILE

  3. DISCARDFILE

  4. LOADING OPTIONS, FILE FORMATTER

Show answer
Correct Option: A,D

Pick the correct options about Control File
technology databases

  1. The LOAD DATA statement is required at the beginning of the control file.

  2. The INFILE option specifies where the input file is located

  3. Specifying BADFILE, then bad records found during loading will be stored in this file.

  4. Specifying DISCARDFILE , then records which do not meet a WHEN condition will be written to this file.

  5. Field Seperator - how the fields are separated in input file.

Show answer
Correct Option: A,B,C,D,E

Pick the correct options about Control File
technology databases

  1. The LOAD DATA statement is required at the beginning of the control file.

  2. The INFILE option specifies where the input file is located

  3. Specifying BADFILE, then bad records found during loading will be stored in this file.

  4. Specifying DISCARDFILE , then records which do not meet a WHEN condition will be written to this file.

  5. Field Seperator - how the fields are separated in input file.

Show answer
Correct Option: A,B,C,D,E

what are the loading options allowed in sqlldr
technology databases

  1. INSERT

  2. APPEND

  3. REPLACE TRUNCATE

  4. DELETE UPDATE

Show answer
Correct Option: A,B,C

Pick the correct options about loading parameters
technology databases

  1. INSERT : Loads rows only if the target table is empty

  2. APPEND: Load rows if the target table is empty or not.

  3. REPLACE: First deletes all the rows in the existing table and then, load rows.

  4. TRUNCATE: First truncates the table and then load rows.

Show answer
Correct Option: A,B,C,D

What are the two types of loads used by oracle sqldr
technology databases

  1. Conventional

  2. Direct

  3. Indirect

  4. Insert

Show answer
Correct Option: A,B

Conventional type is the default load type used by Sql Loader
technology databases

  1. True

  2. False

Show answer
Correct Option: A

Conventional path load (the default) uses the SQL INSERT statement and a bind array buffer to load data into database tables. When SQL*Loader performs a conventional path load, it wont competes equally with all other processes for buffer resources. This can slow the load significantly. Extra overhead is added as SQL statements are generated, passed to Oracle, and executed. Although appropriate during normal use, this can slow bulk loads dramatically.
technology databases

  1. True

  2. False

Show answer
Correct Option: A

In Direct Path Loading, Oracle will not use SQL INSERT statement for loading rows. It directly writes the rows, into fresh blocks beyond High Water Mark, in datafiles i.e. it does not scan for free blocks before high water mark. Direct Path load is very fast because Partial blocks are not used, so no reads are needed to find them, and fewer writes are performed. SQL*Loader need not execute any SQL INSERT statements; therefore, the processing load on the Oracle database is reduced. A direct path load calls on Oracle to lock tables and indexes at the start of the load and releases them when the load is finished. During a direct path load, processes perform their own write I/O, instead of using Oracle's buffer cache. This minimizes contention with other Oracle users.
technology databases

  1. True

  2. False

Show answer
Correct Option: A