Computers and Technology, 21.08.2019 00:00 Princess14321

Which of the following is not a sql*loader file?
a. bad file
b. control file
c. discard file
d. good file
e. log file

Answers: 3

Show answers

Answers

Answer from: haltomnatnathan3548

D. Good file

Explanation:

SQL loader is responsible for loading data from files into the database. It needs the mandatory control file, bad file, log file and an optional discard file.

A. Bad file

This file shares its name with the data file and has .bad extension.

The bad file holds all the records which are rejected ( bad data ). If a bad file is not available, it is automatically created. The data is either rejected by the SQL loader or by Oracle itself. The rejected records are not placed in the data file and hence, have to be placed in the bad file.

It is mandatory to have a bad file for every data file.

B. Control file

This is a mandatory file. This is a text file needed by the SQL loader to perform the loading process.

It contains the information related to location of data, specifies the criteria for selecting data for insertion, location for inserting data, and the like.

C. Discard file

The discard file is created if the need arises. This is not a mandatory file to be present.

The data which is discarded and gets filtered out, is placed in the discard file.

The data is not inserted in the table because it does not matches the criteria for the data to be inserted.

This criteria is mentioned in the control file.

The data is discarded only due to the mismatch and not because it is rejected or is bad data.

E. Log file

This file is mandatory to the execution. In absence of log file, the loader does not proceeds with execution and gets terminated.

In the beginning of the execution, a log file must be created by the loader. This file contains all the information regarding the data loading and also the errors encountered during the loading process.

Which of the following is not a sql*loader file? a. bad file b. control file c. discard file d. goo

Answer from: Quest

the correct answer is: a.)it is never appropriate to use acronyms and emoticons in business communication.

Answer from: Quest

$1 trillion in certificates of deposit $1 trillion in currency

Another question on Computers and Technology

Computers and Technology, 22.06.2019 01:40

When the pc version of the spreadsheet program became available, the ibm pc quickly became the top-selling personal computer?

Answers: 3

Answer

Computers and Technology, 22.06.2019 22:00

Perform the following tasks: a. create a class named testclass that holds a single private integer field and a public constructor. the only statement in the constructor is one that displays the message “constructing”. write a main()function that instantiates one object of the testclass. save the file as testclass.cpp in the chapter 08 folder. run the program and observe the results. b. write another main()function that instantiates an array of 10 testclass objects. save the file as test class array.c . run this program and observe the results.

Answers: 1

Answer

Computers and Technology, 22.06.2019 23:20

How can you tell if someone sent you a text message to your email instead of a email

Answers: 1

Answer

Computers and Technology, 23.06.2019 01:20

Me with this program in c++ ! computers represent color by combining sub-colors red, green, and blue (rgb). each sub-color's value can range from 0 to 255. thus (255, 0, 0) is bright red. (130, 0, 130) is a medium purple. (0, 0, 0) is black, (255, 255, 255) is white, and (40, 40, 40) is a dark gray. (130, 50, 130) is a faded purple, due to the (50, 50, 50) gray part. (in other word, equal amounts of red, green, blue yield gray).given values for red, green, and blue, remove the gray part. ex: if the input is 130 50 130, the output is: 80 0 80. thus, find the smallest value, and then subtract it from all three values, thus removing the gray.

Answers: 3

Answer

You know the right answer?

Which of the following is not a sql*loader file?
a. bad file
b. control file
c. d...

Questions