0

databases Online Quiz - 88

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

Which of the following can be editable in mapping designer?

  1. Source definition

  2. Target definition

  3. Source qualifier

  4. All of above


Correct Option: C

When we group the data through aggregator it outputs which row of each group as default?

  1. First

  2. Last

  3. Any

  4. None


Correct Option: B

When we can use sorted input in aggregator?

  1. When nested aggregate function are used in the aggregator expression

  2. Incremental aggregation is used in session

  3. In case of data driven source data

  4. None of above


Correct Option: D

Which of the below transformation can be used as connected and unconnected both way?

  1. Stored procedure, Look up

  2. Stored procedure, filter

  3. Look up , joiner

  4. Filter, Expression


Correct Option: A
  1. Session

  2. Command

  3. Email

  4. All of the above


Correct Option: D

Which statement is true regarding sequence generator?

  1. It is having two ports nextval and currval

  2. We can add ports in it

  3. It is active and connected

  4. All of the above


Correct Option: A

We can use the joiner transformation in case of?

  1. Joining two flat files

  2. To join two table from different data bases

  3. To join flat file and relational table

  4. All of the above


Correct Option: D

Select the which entry we have to made in treat source as option in session properties if we want map to handle insert and update?

  1. Insert

  2. Data driven

  3. Update

  4. Delete


Correct Option: B

In which of the transformation we can discard duplicate data?

  1. Source qualifier, Sorter

  2. Sorter, Joiner

  3. Joiner, Expression

  4. All of the above


Correct Option: A

Which is not true regarding unconnected lookup?

  1. It does not contain return port

  2. Executed for every record passed

  3. Works only when lookup function is called

  4. All of the above


Correct Option: C

Compare sorter transformation with order by clause on database?

  1. Sorter transformation is more faster

  2. Order by clause on database is more faster

  3. Both will take same time

  4. We cannot compare


Correct Option: A
  1. Lookup, Joiner

  2. Lookup, SQ

  3. SQ, Joiner

  4. None of the above


Correct Option: B
  1. SQL LOADER utility is used to load data from other data source into Oracle.

  2. For example, if you have a table in FOXPRO, ACCESS or SYBASE or any other third party database, you can use SQL Loader to load the data into Oracle Tables

  3. SQL Loader will only read the data from Flat files.

  4. If you want to load the data from Foxpro or any other database, first step is to convert that data into Delimited Format flat file or Fixed length format flat file, and then use SQL loader to load the data into Oracle.

  5. All the above


Correct Option: E
  1. sqlldr userid=scott/tiger control=emp.ctl log=emp.log

  2. qlldr userid=scott/tiger control=emp.ctl log=emp.log data=data1.dat

  3. sqlldr userid=scott/tiger control=emp.ctl log=emp.log direct=FALSE

  4. sqlldr userid=scott/tiger control=emp.ctl


Correct Option: A,B,C,D
  1. Control File

  2. Data File

  3. Target Table

  4. Bad File


Correct Option: A,B,C

What is control file?

  1. It describe how to interpret the flat file and options to load the data.

  2. It describe the location and format of the data file.

  3. It describe the location of the Bad and Discard records file .

  4. It has the control to connect database


Correct Option: A,B,C

What are the mandatory options in the control(*.ctl) file.

  1. LOAD DATA, INFILE, COLUMNS OF THE TARGET TABLE

  2. BADFILE

  3. DISCARDFILE

  4. LOADING OPTIONS, FILE FORMATTER


Correct Option: A,D
- Hide questions