All categories

3 years ago

Which of the following is not a SQL*Loader file?

Computers and Technology

1 answer:

MatroZZZ [7]3 years ago

6 0

Answer:

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.

You might be interested in

12. Your project specifications call for a business rule that the database design can't

fomenos

A lot of business rules needs to be triggered so as to run.

In making of business rule, one can select triggers to run some specific events or run using some particular specified frequency.

The trigger options differs based on the type of rule you are interested in. One can also use multiple triggers when using a single rule.

Learn more about rules from.

brainly.com/question/5707732

8 0

3 years ago

1. Implement a method factorial(int n), that takes a number (int) and returns its factorial. Factorial of an integer is the prod

marysya [2.9K]

Answer:

import java.io.*;

import java.util.*;

public class Main

{

public static int factorial(int n){

if (n == 0)

return 1;

else

return(n * factorial(n-1)); //recursively calling factorial function

}

public static void fibbonaci(int n)

{

if(n>0)

{

c=a+b; //next term in series

a=b;

b=c;

System.out.print(" "+c);

fibbonaci(n-1); //recursively calling fibbonaci function

}

static int a=0,b=1,c;

public static void main(String[] args) {

int list_num,fact;

List<Integer> num=Arrays.asList(1,3,5,7,9); //arraylist with 1,3,5,7,9

for(Integer i:num) //for-each loop

{

a=0;

b=1;

list_num=i.intValue();

System.out.println("Fibbonaci series for "+list_num);

System.out.print(a+" "+b);

fibbonaci(list_num-2); //calling fibbonaci for values in list

fact=factorial(list_num); //calling factorial for values in list

System.out.println();

System.out.println("Factorial for "+list_num+" is "+fact);

System.out.println();

}

6 0

4 years ago

Write a program Using loops to display the following patterns –

lukranit [14]

Answer:mm, no se como

Explanation:ayudarte

5 0

3 years ago

Project planning output is :

-Dominant- [34]

Answer:

Explanation:

The main output of Project palnning is project plan.

5 0

3 years ago

If you want to copy data from one cel to another cell that is several rows down in a worksheet, which method should you use?

bogdanovich [222]

copy and paste

so you can keep the data in the current cell and add it to other cells that you want that data in as well

5 0

3 years ago