Question 1

Which of the following privilege is required to create a new package in a database?

technology databases

CONTROL
BIND
EXECUTE
BINDADD

Answer

Correct Option: B

Question 2

Which of the following privilege is required to create a new package in a database?

technology databases

CONTROL
BIND
EXECUTE
BINDADD

Answer

Correct Option: B

Question 3

Which of the following statement will NOT allow db2user to grant the privileges specified in the statement to others?

technology databases

GRANT INDEX ON employee TO db2user WITH GRANT OPTION
GRANT UPDATE (salary, bonus) ON employee TO PUBLIC WITH GRANT
GRANT CONTROL ON employee TO PUBLIC WITH GRANT OPTION
GRANT ALTERIN, CREATEIN, DROPIN ON schema1 TO db2user WITH GRANT

Answer

Correct Option: C

Question 4

Which of the following statement is NOT a valid method of authentication that can be used by DB2 UDB VERSION8?

technology databases

SERVER
SERVER_ENCRYPT
CLIENT
DCS

Answer

Correct Option: D

Question 5

Assuming User1 has no privileges/Authorities , which of the following will only Allow USER1 to add data to table EMPLOYEE

technology databases

CONTROL
UPDATE
INSERT
INSERT WITH GRANT OPTION

Answer

Correct Option: C

Question 6

In a client-server environment, which two of the following can be used to verify passwords?

technology databases

System Catalog
Client Applications
Client Operating Systems
Application Server

Answer

Correct Option: C,D

Question 7

What is the prefix key for executing an OS command in the DB2 CLP?

technology databases

&
%
!
@

Answer

Correct Option: C

Question 8

Which of the following command is used to disconnect from the database and end the db2bp process from DB2 CLP?

technology databases

QUIT
END
TERMINATE
LOGOFF

Answer

Correct Option: C

Question 9

Which of the following tool can be used to monitor the state of the DB2 environment?

technology databases

Task Center
Command Center
Health Center
Control Center

Answer

Correct Option: C

Question 10

DB2 Extenders can handle non-traditional data. Which of the following type of data can Extenders not handle?

technology databases

XML
File
Spatial data
Music

Answer

Correct Option: B

Question 11

what is the type of lock that prevents all other types of lock ?

technology databases

Inclusive
Exclusive
Read
Write

Answer

Correct Option: B

Question 12

What is the teradata utility that can continuously load data into tables?

technology databases

Fastexp
Fastload
Multiload
Tpump

Answer

Correct Option: D

Question 13

What is the teradata utility that load data into empty tables?

technology databases

Fastexp
Fastload
Multiload
Bteq

Answer

Correct Option: B

Question 14

What is the limit of the no of columns on a primary key in relational model?

technology databases

16
32
64
There is no limit on the no. of columns.

Answer

Correct Option: D

Question 15

Which of the following tables could be used for a user who wants to create a small Temporary table with Spool Space?

technology databases

Derived Table
Volatile Table
Global Temporary Table
None

Answer

Correct Option: A,B

Question 16

Teradata runs on which architecture ?

technology databases

shared memory
shared nothing
shared everything
shared all

Answer

Correct Option: B

Question 17

What is the teradata utility that restricts queries based on threshold values ?

technology databases

Teradata Manager
DBQM
Queryman
Teradata Warehouse builder

Answer

Correct Option: A

Question 18

Teradata Company founded in..?

technology databases

1981
1978
1979
1989

Answer

Correct Option: C

Question 19

What does the ‘Help Table’ display?

technology databases

Column names, data type, Comments
Column names, Indexes, data types, Comments
Displays the table id, Column names, data types, Comments
Tell the session number of the user

Answer

Correct Option: A

Question 20

Which operator will be evaluated first in the following SELECT statement?

technology databases

+
*
-
/

Answer

Correct Option: B

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

databases Online Quiz - 77

Find more quizzes from top tags