Tag: databases

Questions Related to databases

Which of the following products is used to shred Extensible Mark up Language documents?
technology databases

  1. DB2 AVI Extender

  2. DB2 Text Extender

  3. DB2 XML Extender

  4. DB2 Spatial Extender

Show answer
Correct Option: C

Which of the following does DB2 Configuration Advisor recommend?
technology databases

  1. SQL statements

  2. New indexes

  3. DDL

  4. Database configuration parameter settings

Show answer
Correct Option: D

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