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

Which transformation we will use if want to efficiently join two tables residing in same database?

  1. Joiner

  2. Source Qualifier

  3. Both of above

  4. None of above


Correct Option: B
  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

Which of the following task can be made reusable?

  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

Which of the following port is used only in unconnected look up not in connected look up?

  1. Input

  2. Variable

  3. Return

  4. Output


Correct Option: C
  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 efficient transformation which you can use for the same source data with different condition?

  1. Filter

  2. Router

  3. Sorter

  4. All of the above


Correct Option: B

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

Which of the following transformation has override option in properties?

  1. Lookup, Joiner

  2. Lookup, SQ

  3. SQ, Joiner

  4. None of the above


Correct Option: B

What is SQL Loader?

  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