databases Online Quiz - 210 Online Test

Back

databases Online Quiz - 210

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

Start the Quiz

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

What does QMF stands for

technology databases

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

What does SQLCA stands for

technology databases

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

What does DCLGEN stands for

technology databases

Declaration General
Data Control Language Generator
DB2 Control Region
Declaration Generator

What does DB2I stands for

technology databases

DB2 Interchange
DB2 Information
DB2 Intercative
DB2 Init

Which Database Services component manages the physical database

technology databases

DBRM
Buffer Manager
Runtime Supervisor
Data Manager

A VIEW MAY NOT CONTAIN

technology databases

INDICES
COLUMNS
ROWS
NONE OF THE ABOVE

TOTAL DATA CAPACITY IN TERADATA

technology databases

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

FASTLOAD WORKS IN FIVE PHASES

technology databases

True
False

HASH JOINS ARE FASTER THAN MERGE JOINS

technology databases

True
False

______ IS USED TO STORE SUCCESSFUL CHECK POINTS DURING LOAD PROCESSING

technology databases

WORK TABLE
LOG TABLE
UV TABLE
ERROR TABLE

MULTILOAD ALLOW NON UNIQUE SECONDARY INDEX

technology databases

True
False

WHICH UTILITY IS USEFUL FOR REAL TIME APPLICATIONS

technology databases

TPUMP
FASTEXPORT
BTEQ
FASTLOAD

DATA IS DISTRIBUTED BASED ON PARTITIONS IN A PPI TABLE

technology databases

True
False

THE FINEST LEVEL OF GRANULARITY POSSIBLE IN TERADATA COMPRESSION IS

technology databases

ROW LEVEL
BLOCK LEVEL
FIELD COMPRESSION
COLUMN LEVEL

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

technology databases

True
False

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

technology databases

500
100
800
1000

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

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

What is the Datatype of NULL in Oracle?

technology databases

Long
Int(0)
Char(0)
Binary

- Hide questions

databases Online Quiz - 210

Find more quizzes from top tags