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

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

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

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 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

Pick the exact syntac for SQL LOADER Utility

  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

What are the components needed for sql loader?.

  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.





Correct Option: A,D
- Hide questions