0

databases Online Quiz - 87

Description: databases Online Quiz - 87
Number of Questions: 20
Created by:
Tags: databases
Attempted 0/20 Correct 0 Score 0

Pick the correct options about Control File

  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.


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

Pick the correct options about Control File

  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.


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

what are the loading options allowed in sqlldr

  1. INSERT

  2. APPEND

  3. REPLACE TRUNCATE

  4. DELETE UPDATE


Correct Option: A,B,C

Pick the correct options about loading parameters

  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.


Correct Option: A,B,C,D
  1. Conventional

  2. Direct

  3. Indirect

  4. Insert


Correct Option: A,B

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.

  1. True

  2. False


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.

  1. True

  2. False


Correct Option: A

What are the conditions must be satisfied to use the direct path load method

  1. Tables are not clustered.

  2. Tables to be loaded do not have any active transactions pending.

  3. Loading a parent table together with a child Table

  4. Loading BFILE columns


Correct Option: A,B,C,D

What is the default index that is being created when a table is created in Sybase IQ?

  1. LF

  2. HG

  3. HNG

  4. FP


Correct Option: D
  1. HG,LF,HNG

  2. DATE,DTTM,CMP,WD

  3. TIME

  4. None of the above


Correct Option: D

Give the number of distinct values that LF index can hold

  1. 5000

  2. 10000

  3. 3000

  4. 1500


Correct Option: B
  1. select * from EMP where nvl(EMPNO, '00000') = '59384';

  2. select * from EMP where EMPNO = '59384';

  3. select EMPNO, LASTNAME from EMP where EMPNO = '59384';

  4. select 1 from EMP where EMPNO = '59834';


Correct Option: A

SELECT address1||','||address2||','||address2 "Adress" FROM employee;

  1. 1

  2. 2

  3. 3

  4. 4


Correct Option: A

AI Explanation

To answer this question, let's go through each option:

Option A) 1 - This option is the correct answer. The given SQL statement concatenates the values of the columns address1, address2, and address2 using the concatenation operator ||. The result is then aliased as "Adress" using the AS keyword. Therefore, the output of the query will be the concatenation of these three columns, separated by commas.

Option B) 2 - This option is incorrect. The given SQL statement does not involve any calculations or arithmetic operations. It simply concatenates the values of the specified columns.

Option C) 3 - This option is incorrect. The given SQL statement does not involve any calculations or arithmetic operations. It simply concatenates the values of the specified columns.

Option D) 4 - This option is incorrect. The given SQL statement does not involve any calculations or arithmetic operations. It simply concatenates the values of the specified columns.

The correct answer is Option A.

Which Oracle access method is the fastest way for Oracle to retrieve a single row?

  1. Primary key access

  2. Access via unique index

  3. Table access by ROWID

  4. Full table scan


Correct Option: C

Which of the following can be a valid column name?

  1. Column

  2. 1966_Invoices

  3. Catch_#22

  4. #Invoices


Correct Option: C

Which command will delete all data from a table and will not write to the rollback segment?

  1. DROP

  2. DELETE

  3. CASCADE

  4. TRUNCATE


Correct Option: D

Which character function can be used to return a specified portion of a character string?

  1. INSTR

  2. SUBSTRING

  3. SUBSTR

  4. POS


Correct Option: C
- Hide questions