Tag: databases

Questions Related to databases

For which of the following is a data warehouse optimized?

technology databases

  1. Backup and Recovery

  2. Transactions

  3. Security

  4. Queries

Show answer
Correct Option: D

Which of the following is a typical data warehouse query?
technology databases

  1. What is this customer’s address?

  2. Does this customer have any unpaid bills?

  3. What is the balance in this customer’s account?

  4. What is the total sales for each of the last 6 months?

Show answer
Correct Option: D

Which of the following best describes the age of the data in an OLTP system?
technology databases

  1. Current

  2. Projected

  3. Historical

  4. Current and Projected

Show answer
Correct Option: A

) Which of the following tools can make recommendations for indexes and/or MQTs to improve the performance of DB2 applications?
technology databases

  1. Design Advisor

  2. Visual Explain

  3. Performance Advisor

  4. Configuration Assistant

Show answer
Correct Option: A

Which of the following is NOT a valid method of authentication that can be used by DB2 9?
technology databases

  1. SERVER

  2. SERVER_ENCRYPT

  3. CLIENT

  4. DCS

Show answer
Correct Option: D

A table named DEPARTMENT has the following columns: DEPT_ID DEPT_NAME MANAGER AVG_SALARY Which of the following is the best way to prevent most users from viewing AVG_SALARY data?

technology databases

  1. Encrypt the table's data

  2. Create a view that does not contain the AVG_SALARY column

  3. Revoke SELECT access for the AVG_SALARY column from users who should not see AVG_SALARY data

  4. Store AVG_SALARY data in a separate table and grant SELECT privilege for that table to the appropriate users

Show answer
Correct Option: B

Assuming USER1 has no authorities or privileges, which of the following will allow USER1 to create a view named VIEW1 that references two tables named TAB1 and TAB2?
technology databases

  1. CREATEIN privilege on the database

  2. REFERENCES privilege on TAB1 and TAB2

  3. CREATE_TAB privilege on the database

  4. SELECT privilege on TAB1 and TAB2

Show answer
Correct Option: D

After the following SQL statement is executed: GRANT ALL PRIVILEGES ON TABLE employee TO USER user1 Assuming user USER1 has no other authorities or privileges, which of the following actions is USER1 allowed to perform?

technology databases

  1. Drop an index on the EMPLOYEE table

  2. Grant all privileges on the EMPLOYEE table to other users

  3. Alter the table definition

  4. Drop the EMPLOYEE table

Show answer
Correct Option: C

A user wishing to invoke an SQL stored procedure that queries a table must have which of the following privileges?
technology databases

  1. CALL privilege on the procedure; SELECT privilege on the table

  2. CALL privilege on the procedure; REFERENCES privilege on the table

  3. EXECUTE privilege on the procedure; SELECT privilege on the table

  4. EXECUTE privilege on the procedure; REFERENCES privilege on the table

Show answer
Correct Option: C

User USER1 wants to utilize an alias to remove rows from a table. Assuming USER1 has no authorities or privileges, which of the following privileges are needed?
technology databases

  1. DELETE privilege on the table

  2. DELETE privilege on the alias

  3. DELETE privilege on the alias; REFERENCES privilege on the table

  4. REFERENCES privilege on the alias; DELETE privilege on the table

Show answer
Correct Option: A