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

Variables used for output are associated with what controls on a form?

NikAS [45]

Answer:

The answer to this question is given below in the explanation section

Explanation:

There are different form control. for example HTML form controls are:

Text Input Controls.
Checkboxes Controls.
Radio Box Controls.
Select Box Controls.
File Select boxes.
Hidden Controls.
Clickable Buttons.
Submit and Reset Button.

Variables used for output are associated with text input and label control on a form.

For example, if you want to show the name of the user that is stored in a variable <em>name</em>. Then you want to output the <em>name</em> on a form, for this, you need to associate this variable with label or text input control

8 0

3 years ago

What is the purpose of a mutator?

choli [55]

Answer:

To change the value of private or protected members.

Explanation:

Mutator also known as setters are the member function or method in class that is used to set or change the value of private or protected members. Mutator does not return any values. They are very important in Object Oriented Programming.

3 0

4 years ago

1. Why isn't solar energy usually the only power source for a region?

ale4655 [162]

1. Every region doesnt get the same amount of sunlight as the rest due to whether or location an example would be that a region with alot of rain could have clouds that wouldnt let the solar panels to absorb as much sunlight as a more dry and sunny place
2 wind farms can be used to store energy for a power outage and a way to lower the cost of electricity to a farmer
3 using hydro energy requires people to build a dam that pours the water over a mill that rotates and stores energy from it
4 a type of waste created by nuclear power plants would be daily uses that have radiation such as plastic containers ,gloves , disposable overalls, boots or just plain radioactive waste.
5 would be the total mass of organisms in a given area or volume
6 is a process to further limit carbon dioxide emissions from burning coal
7 is basically the means to tap into energy savings that over time become an asset
8 turning down the water heater thermostat and turning off lights when not in use can save energy
9 smart grids use timing grid to determine how long you use electricity for and for how much you used

6 0

3 years ago

Read 2 more answers

Rebecca completed work on a computer and is verifying the functionality of the system when she finds a new problem. This problem

MariettaO [177]

Answer:

a. Report the new problem

Explanation:

Policies are an essential component of any organization and are important because they address pertinent issues.

Reporting the new problem would make it simpler for her and her colleagues who might encounter similar issues. It would also help the management to understand why it happened, assist her, set priorities and prevent recurrences.

3 0

4 years ago

Assignment 8: Personal Organizer (in edhesive or python please)

serg [7]

Answer:

eventName = []

eventMonth = []

eventDay = []

eventYear = []

def addEvent():

userEventName = input("Enter event name: ")

userEventMonth = int(input("Enter event month (1-12): "))

userEventDay = int(input("Enter event day(1-31): "))

userEventYear = int(input("Enter event year (Ex:2020): "))

userEventMonth = validateMonth(userEventMonth)

userEventDay = validateDay(userEventMonth,userEventDay,userEventYear)

eventName.append(userEventName)

eventMonth.append(userEventMonth)

eventDay.append(userEventDay)

eventYear.append(userEventYear)

def validateMonth(month):

if month >= 1 and month <= 12:

return month

else:

return 1

def validateDay(month,day,year):

# invalid days

if day < 1 or day > 31 :

return 1

# if the month is february

if month == 2:

isleap = False

if year%4 == 0:

if year%100 == 0:

if year%400 == 0:

isleap = True

else:

isleap = True

# if the year is leap

if isleap:

if day < 30:

return day

else:

return 1

else:

if day < 29:

return day

else:

return 1

# month with 31 days

if month in [1,3,5,7,8,10,12]:

return day

# month with 30 days

if month in [4,6,9,11] and day < 31:

return day

else:

return 1

def printEvents():

print("****** LIST OF EVENTS *********")

months = ['January', 'February', 'March', 'April', 'May', 'June', 'July',

'August', 'September', 'October', 'November', 'December']

for index in range(len(eventName)):

print(eventName[index])

print("Date: "+months[eventMonth[index] -1]+ " " + str(eventDay[index]) + ", " + str(eventYear[index]))

def printEventsForMonth(month):

months = ['January', 'February', 'March', 'April', 'May', 'June', 'July',

'August', 'September', 'October', 'November', 'December']

print("****** EVENTS IN " + months[month -1] + " *********")

for index in range(len(eventName)):

if eventMonth[index] == month:

print(eventName[index])

print("Date: "+months[eventMonth[index] -1]+ " " + str(eventDay[index]) + ", " + str(eventYear[index]))

userChoice = "yes"

while userChoice.upper() != "NO":

addEvent()

userChoice = input("Do you want to enter another event? NO to stop: ")

printEvents()

Explanation:

hope this saved somebody from a mental breakdown :)

3 0

3 years ago

Read 2 more answers