Question 1

If BTEQ terminates abnormally, all rows (which are in SPOOL) are discarded

technology databases

True
False

Answer

Correct Option: A

Question 2

FastExport does NOT support error files or error limits

technology databases

True
False

Answer

Correct Option: A

Question 3

More than one data type conversion is allowed per column during a FastLoad

technology databases

True
False

Answer

Correct Option: B

Question 4

The MultiLoad DELETE mode is used to perform a global (all AMP) delete on just one table.

technology databases

True
False

Answer

Correct Option: A

Question 5

TPump does not allow Non-Unique Secondary Indexes

technology databases

True
False

Answer

Correct Option: B

Question 6

There are four export formats that a user can choose depending on the desired output in BTEQ EXPORT function. Three of them are Data mode, Report Mode and Indicator Mode. Choose the fourth one.

technology databases

Record Mode
Field Mode
DIF Mode
Query Mode

Answer

Correct Option: C

Question 7

The .LOGOFF is optional in BTEQ

technology databases

True
False

Answer

Correct Option: A

Question 8

Explain QUIT command in BTEQ.

technology databases

End the current session or sessions and exit BTEQ
End the current session or sessions, but do not exit BTEQ
Immediately end the current session or sessions and exit BTEQ
Abort any and all active running requests and transactions and EXIT BTEQ

Answer

Correct Option: A

Question 9

You can over-ride the standard error codes at the time you terminate BTEQ

technology databases

True
False

Answer

Correct Option: A

Question 10

BTEQ can be used to submit SQL in a batch environment only

technology databases

True
False

Answer

Correct Option: B

Question 11

FastExport can also export from multiple tables during a single operation

technology databases

True
False

Answer

Correct Option: A

Question 12

Below DML Commands supported within the FastExport task

technology databases

Delete
Select
Update
Insert

Answer

Correct Option: B

Question 13

Which of the below command defines the client file that provides the USING data values for the SELECT statement

technology databases

Import
Accept
Layout
Export

Answer

Correct Option: A

Question 14

All Fastexport Commans should start with a period ( . ) character

technology databases

True
False

Answer

Correct Option: A

Question 15

The default value for SLEEP command in Fastexprot is

technology databases

6
9
5
10

Answer

Correct Option: A

Question 16

We can use Group functions in the WHERE clause

technology databases

True
False

Answer

Correct Option: B

Question 17

We can use MIN and MAX for any

technology databases

Numeric data
Data type
Char data
None of the Above

Answer

Correct Option: A

Question 18

You can update more than 1 row in a table with one update syntax

technology databases

True
False

Answer

Correct Option: B

Question 19

Delete from Employee where grade = ‘Y’” deletes

technology databases

All rows of the Employee table
Rows of the Employee table where the set grade is ‘Y’
Delete 1 row
Nothing will be deleted

Answer

Correct Option: B

Question 20

Which keyword used in DML statements prohibits you from changing rows that are not in the sub-query?

technology databases

CHECK keyword
WITH CHECK keyword
WITH CHECK OPTION keyword
None of the Above

Answer

Correct Option: C

Description: databases Online Quiz - 158
Number of Questions: 20
Created by: Aliensbrain Bot
Tags: databases

databases Online Quiz - 158

Find more quizzes from top tags