Question 1

Where would the SQL error code (SQLSTATE/SQLCODE) be reported

technology databases

in the SQLDA data structure
in the SQLCA data structure
in the DB configuration file
in the event monitor log

Answer

Correct Option: B

Question 2

What does QMF stands for

technology databases

Query Manager Facility
Query Management Factor
Query Management Facility
None of the above

Answer

Correct Option: C

Question 3

What does SQLCA stands for

technology databases

SQL Communications Area
SQL Control Area
SQL Connection Area
SQL Control Access

Answer

Correct Option: A

Question 4

What does DCLGEN stands for

technology databases

Declaration General
Data Control Language Generator
DB2 Control Region
Declaration Generator

Answer

Correct Option: D

Question 5

What does DB2I stands for

technology databases

DB2 Interchange
DB2 Information
DB2 Intercative
DB2 Init

Answer

Correct Option: C

Question 6

Which Database Services component manages the physical database

technology databases

DBRM
Buffer Manager
Runtime Supervisor
Data Manager

Answer

Correct Option: D

Question 7

A VIEW MAY NOT CONTAIN

technology databases

INDICES
COLUMNS
ROWS
NONE OF THE ABOVE

Answer

Correct Option: A

Question 8

TOTAL DATA CAPACITY IN TERADATA

technology databases

64 GB PER AMP
120 GB PER AMP
32 GB PER AMP
16 GB PER AMP

Answer

Correct Option: B

Question 9

FASTLOAD WORKS IN FIVE PHASES

technology databases

True
False

Answer

Correct Option: B

Question 10

HASH JOINS ARE FASTER THAN MERGE JOINS

technology databases

True
False

Answer

Correct Option: A

Question 11

______ IS USED TO STORE SUCCESSFUL CHECK POINTS DURING LOAD PROCESSING

technology databases

WORK TABLE
LOG TABLE
UV TABLE
ERROR TABLE

Answer

Correct Option: B

Question 12

MULTILOAD ALLOW NON UNIQUE SECONDARY INDEX

technology databases

True
False

Answer

Correct Option: A

Question 13

WHICH UTILITY IS USEFUL FOR REAL TIME APPLICATIONS

technology databases

TPUMP
FASTEXPORT
BTEQ
FASTLOAD

Answer

Correct Option: A

Question 14

DATA IS DISTRIBUTED BASED ON PARTITIONS IN A PPI TABLE

technology databases

True
False

Answer

Correct Option: B

Question 15

THE FINEST LEVEL OF GRANULARITY POSSIBLE IN TERADATA COMPRESSION IS

technology databases

ROW LEVEL
BLOCK LEVEL
FIELD COMPRESSION
COLUMN LEVEL

Answer

Correct Option: A

Question 16

Can you delete a column in table with data in Oracle?

technology databases

True
False

Answer

Correct Option: A

Question 17

Maximum number of columns in a table or view in Oracle?

technology databases

500
100
800
1000

Answer

Correct Option: D

Question 18

While doing an ascending order sort on a column having NULL values, where does the NULLs show up in the result set?

technology databases

Last
Beginning
NULLs wont be displayed
Cant say

Answer

Correct Option: A

Question 19

How to see the time of execution of an SQL Statement.

technology databases

set timing on select * from EMP
set time on select * from EMP
time on select * from EMP
set timings on select * from EMP

Answer

Correct Option: A

Question 20

What is the Datatype of NULL in Oracle?

technology databases

Long
Int(0)
Char(0)
Binary

Answer

Correct Option: C

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

databases Online Quiz - 210

Find more quizzes from top tags