Tag: databases

Quizzes (243) Questions (4862)

Questions Related to databases

Multiple choice technology databases

The right syntax insert a row into a table is

Insert to table tablename (….);
Insert into table tablename (….);
Insert into table tablename values (…..);
Any one of the above

Reveal answer Fill a bubble to check yourself

Multiple choice technology databases

Which is the function that records the current date?

Date
Sysdate
Current Date
System Date

Reveal answer Fill a bubble to check yourself

Multiple choice technology databases

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

True
False

Reveal answer Fill a bubble to check yourself

Multiple choice technology databases

FastExport does NOT support error files or error limits

True
False

Reveal answer Fill a bubble to check yourself

Multiple choice technology databases

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

True
False

Reveal answer Fill a bubble to check yourself

Multiple choice technology databases

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

True
False

Reveal answer Fill a bubble to check yourself

Multiple choice technology databases

TPump does not allow Non-Unique Secondary Indexes

True
False

Reveal answer Fill a bubble to check yourself

Multiple choice technology databases

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.

Record Mode
Field Mode
DIF Mode
Query Mode

Reveal answer Fill a bubble to check yourself

Multiple choice technology databases

The .LOGOFF is optional in BTEQ

True
False

Reveal answer Fill a bubble to check yourself

Multiple choice technology databases

Explain QUIT command in BTEQ.

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

Reveal answer Fill a bubble to check yourself

← Previous
1
2
…
167
168
169
170
171
172
173
174
175
…
486
487
Next →