• databases Online Quiz - 77
Back
0

databases Online Quiz - 77

Description: databases Online Quiz - 77
Number of Questions: 20
Created by:
Tags: databases
Start the Quiz
Attempted 0/20 Correct 0 Score 0
‹
›

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

technology databases

  1. CONTROL

  2. BIND

  3. EXECUTE

  4. BINDADD

Show answer
Correct Option: B

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

technology databases

  1. CONTROL

  2. BIND

  3. EXECUTE

  4. BINDADD

Show answer
Correct Option: B

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

  1. GRANT INDEX ON employee TO db2user WITH GRANT OPTION

  2. GRANT UPDATE (salary, bonus) ON employee TO PUBLIC WITH GRANT

  3. GRANT CONTROL ON employee TO PUBLIC WITH GRANT OPTION

  4. GRANT ALTERIN, CREATEIN, DROPIN ON schema1 TO db2user WITH GRANT

Show answer
Correct Option: C

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

technology databases

  1. SERVER

  2. SERVER_ENCRYPT

  3. CLIENT

  4. DCS

Show answer
Correct Option: D

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

technology databases

  1. CONTROL

  2. UPDATE

  3. INSERT

  4. INSERT WITH GRANT OPTION

Show answer
Correct Option: C
Explanation:

To solve this question, the user needs to know the different types of privileges in a database management system and their corresponding actions.

Now, let's go through each option and explain why it is right or wrong:

A. CONTROL: This option is incorrect because the CONTROL privilege provides all privileges on an object, including the ability to modify, delete, and grant privileges. It is not specific to the INSERT action only.

B. UPDATE: This option is incorrect because the UPDATE privilege allows the user to modify existing data in a table but not add new data.

C. INSERT: This option is correct. The INSERT privilege allows the user to add new data to a table. By granting only the INSERT privilege to USER1 on the EMPLOYEE table, USER1 will be able to add new data to the table but not modify or delete existing data.

D. INSERT WITH GRANT OPTION: This option is incorrect because INSERT WITH GRANT OPTION not only allows the user to insert data into the table but also to grant the INSERT privilege to other users. This means that USER1 can give the INSERT privilege to another user, which is not a requirement in this scenario.

Therefore, the correct answer is:

The Answer is: C. INSERT

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

technology databases

  1. System Catalog

  2. Client Applications

  3. Client Operating Systems

  4. Application Server

Show answer
Correct Option: C,D

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

technology databases

  1. &

  2. %

  3. !

  4. @

Show answer
Correct Option: C

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

  1. QUIT

  2. END

  3. TERMINATE

  4. LOGOFF

Show answer
Correct Option: C

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

technology databases

  1. Task Center

  2. Command Center

  3. Health Center

  4. Control Center

Show answer
Correct Option: C

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

technology databases

  1. XML

  2. File

  3. Spatial data

  4. Music

Show answer
Correct Option: B

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

technology databases

  1. Inclusive

  2. Exclusive

  3. Read

  4. Write

Show answer
Correct Option: B

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

technology databases

  1. Fastexp

  2. Fastload

  3. Multiload

  4. Tpump

Show answer
Correct Option: D

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

  1. Fastexp

  2. Fastload

  3. Multiload

  4. Bteq

Show answer
Correct Option: B

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

technology databases

  1. 16

  2. 32

  3. 64

  4. There is no limit on the no. of columns.

Show answer
Correct Option: D

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

technology databases

  1. Derived Table

  2. Volatile Table

  3. Global Temporary Table

  4. None

Show answer
Correct Option: A,B

Teradata runs on which architecture ?

technology databases

  1. shared memory

  2. shared nothing

  3. shared everything

  4. shared all

Show answer
Correct Option: B

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

technology databases

  1. Teradata Manager

  2. DBQM

  3. Queryman

  4. Teradata Warehouse builder

Show answer
Correct Option: A

Teradata Company founded in..?

technology databases

  1. 1981

  2. 1978

  3. 1979

  4. 1989

Show answer
Correct Option: C

What does the ‘Help Table’ display?

technology databases

  1. Column names, data type, Comments

  2. Column names, Indexes, data types, Comments

  3. Displays the table id, Column names, data types, Comments

  4. Tell the session number of the user

Show answer
Correct Option: A

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

technology databases

  1. +

  2. *

  3. -

  4. /

Show answer
Correct Option: B
- Hide questions
ADVERTISEMENT

Find more quizzes from top tags

general knowledge
3615 Quizzes
119858 Questions
 technology
307 Quizzes
36705 Questions
 sports
963 Quizzes
19148 Questions
 history
1187 Quizzes
13475 Questions
 physics
598 Quizzes
13441 Questions
 biology
1160 Quizzes
12174 Questions
 science & technology
551 Quizzes
11015 Questions
 chemistry
490 Quizzes
9892 Questions
 maths
518 Quizzes
9324 Questions
 softskills
0 Quizzes
7131 Questions