• databases Online Quiz - 88
Back
0

databases Online Quiz - 88

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

Which of the following can be editable in mapping designer?

technology databases

  1. Source definition

  2. Target definition

  3. Source qualifier

  4. All of above

Show answer
Correct Option: C

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

technology databases

  1. Joiner

  2. Source Qualifier

  3. Both of above

  4. None of above

Show answer
Correct Option: B

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

  1. First

  2. Last

  3. Any

  4. None

Show answer
Correct Option: B

When we can use sorted input in aggregator?

technology databases

  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

Show answer
Correct Option: D

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

  1. Stored procedure, Look up

  2. Stored procedure, filter

  3. Look up , joiner

  4. Filter, Expression

Show answer
Correct Option: A

Which of the following task can be made reusable?

technology databases

  1. Session

  2. Command

  3. Email

  4. All of the above

Show answer
Correct Option: D

Which statement is true regarding sequence generator?
technology databases

  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

Show answer
Correct Option: A

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

technology databases

  1. Input

  2. Variable

  3. Return

  4. Output

Show answer
Correct Option: C

We can use the joiner transformation in case of?

technology databases

  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

Show answer
Correct Option: D

Select the efficient transformation which you can use for the same source data with different condition?

technology databases

  1. Filter

  2. Router

  3. Sorter

  4. All of the above

Show answer
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?

technology databases

  1. Insert

  2. Data driven

  3. Update

  4. Delete

Show answer
Correct Option: B

In which of the transformation we can discard duplicate data?

technology databases

  1. Source qualifier, Sorter

  2. Sorter, Joiner

  3. Joiner, Expression

  4. All of the above

Show answer
Correct Option: A

Which is not true regarding unconnected lookup?

technology databases

  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

Show answer
Correct Option: C

Compare sorter transformation with order by clause on database?
technology databases

  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

Show answer
Correct Option: A

Which of the following transformation has override option in properties?

technology databases

  1. Lookup, Joiner

  2. Lookup, SQ

  3. SQ, Joiner

  4. None of the above

Show answer
Correct Option: B

What is SQL Loader?

technology databases

  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

Show answer
Correct Option: E

Pick the exact syntac for SQL LOADER Utility
technology databases

  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

Show answer
Correct Option: A,B,C,D

What are the components needed for sql loader?.

technology databases

  1. Control File

  2. Data File

  3. Target Table

  4. Bad File

Show answer
Correct Option: A,B,C

What is control file?
technology databases

  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

Show answer
Correct Option: A,B,C

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

technology databases

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

  2. BADFILE

  3. DISCARDFILE

  4. LOADING OPTIONS, FILE FORMATTER

Show answer
Correct Option: A,D
- Hide questions
ADVERTISEMENT

Find more quizzes from top tags

general knowledge
3615 Quizzes
119858 Questions
 technology
307 Quizzes
36705 Questions
 sports
963 Quizzes
19148 Questions
 history
1187 Quizzes
13475 Questions
 physics
598 Quizzes
13441 Questions
 biology
1160 Quizzes
12174 Questions
 science & technology
551 Quizzes
11015 Questions
 chemistry
490 Quizzes
9892 Questions
 maths
518 Quizzes
9324 Questions
 softskills
0 Quizzes
7131 Questions