Pick the correct options about Control File

Pick the correct options about Control File

what are the loading options allowed in sqlldr

Pick the correct options about loading parameters

What are the two types of loads used by oracle sqldr

Conventional type is the default load type used by Sql Loader

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.

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.

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

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

LF index will be created by default when a FK is created.

As part of PK a unique non high group index will be created

Figure out the indexes which are not part of Sybase IQ?

Give the number of distinct values that LF index can hold

The primary key on table EMP is the EMPNO column. Which of the following statements will not use the associated index on EMPNO?

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

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

Which of the following can be a valid column name?

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

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