0

databases Online Quiz - 210

Description: databases Online Quiz - 210
Number of Questions: 20
Created by:
Tags: databases
Attempted 0/20 Correct 0 Score 0

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

  1. in the SQLDA data structure

  2. in the SQLCA data structure

  3. in the DB configuration file

  4. in the event monitor log


Correct Option: B

What does QMF stands for

  1. Query Manager Facility

  2. Query Management Factor

  3. Query Management Facility

  4. None of the above


Correct Option: C

What does SQLCA stands for

  1. SQL Communications Area

  2. SQL Control Area

  3. SQL Connection Area

  4. SQL Control Access


Correct Option: A

What does DCLGEN stands for

  1. Declaration General

  2. Data Control Language Generator

  3. DB2 Control Region

  4. Declaration Generator


Correct Option: D

What does DB2I stands for

  1. DB2 Interchange

  2. DB2 Information

  3. DB2 Intercative

  4. DB2 Init


Correct Option: C

Which Database Services component manages the physical database

  1. DBRM

  2. Buffer Manager

  3. Runtime Supervisor

  4. Data Manager


Correct Option: D

A VIEW MAY NOT CONTAIN

  1. INDICES

  2. COLUMNS

  3. ROWS

  4. NONE OF THE ABOVE


Correct Option: A

TOTAL DATA CAPACITY IN TERADATA

  1. 64 GB PER AMP

  2. 120 GB PER AMP

  3. 32 GB PER AMP

  4. 16 GB PER AMP


Correct Option: B

FASTLOAD WORKS IN FIVE PHASES

  1. True

  2. False


Correct Option: B

HASH JOINS ARE FASTER THAN MERGE JOINS

  1. True

  2. False


Correct Option: A

______ IS USED TO STORE SUCCESSFUL CHECK POINTS DURING LOAD PROCESSING

  1. WORK TABLE

  2. LOG TABLE

  3. UV TABLE

  4. ERROR TABLE


Correct Option: B

MULTILOAD ALLOW NON UNIQUE SECONDARY INDEX

  1. True

  2. False


Correct Option: A

WHICH UTILITY IS USEFUL FOR REAL TIME APPLICATIONS

  1. TPUMP

  2. FASTEXPORT

  3. BTEQ

  4. FASTLOAD


Correct Option: A

DATA IS DISTRIBUTED BASED ON PARTITIONS IN A PPI TABLE

  1. True

  2. False


Correct Option: B

THE FINEST LEVEL OF GRANULARITY POSSIBLE IN TERADATA COMPRESSION IS

  1. ROW LEVEL

  2. BLOCK LEVEL

  3. FIELD COMPRESSION

  4. COLUMN LEVEL


Correct Option: A

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

  1. True

  2. False


Correct Option: A

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

  1. 500

  2. 100

  3. 800

  4. 1000


Correct Option: D

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

  1. Last

  2. Beginning

  3. NULLs wont be displayed

  4. Cant say


Correct Option: A

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

  1. set timing on select * from EMP

  2. set time on select * from EMP

  3. time on select * from EMP

  4. set timings on select * from EMP


Correct Option: A

What is the Datatype of NULL in Oracle?

  1. Long

  2. Int(0)

  3. Char(0)

  4. Binary


Correct Option: C
- Hide questions