Tag: databases

Questions Related to databases

User system granted SELECT ANY TABLE to user A using WITH ADMIN OPTION. A then granted SELECT ANY TABLE to user B. Ian A left the company, and his account is dropped. What happens to B's privileges?
technology databases

  1. B loses his privileges.

  2. B retains his privileges.

  3. B loses his privileges if A was dropped with the CASCADE REVOKE option.

  4. B retains his privileges if A was dropped with the NOCASCADE REVOKE option.

Show answer
Correct Option: B

Which of the following system privileges can allow the grantee to masquerade as another user and therefore should be granted judiciously?
technology databases

  1. CREATE ANY JOB

  2. ALTER USER

  3. CREATE ANY PROCEDURE

  4. All of the above

Show answer
Correct Option: D

Which of the following statements enables the role user_admin in the current session?
technology databases

  1. alter session enable role user_admin;

  2. alter session set role user_admin;

  3. alter role user_admin enable;

  4. set role user_admin;

Show answer
Correct Option: D

Which of the following SQL statements allows user augustin to use the privileges associated with the password-protected role info_czar, which has been granted to him?
technology databases

  1. set role all;

  2. alter user augustin default role all;

  3. alter session enable role info_czar;

  4. alter session enable info_czar identified by brozo

Show answer
Correct Option: B

Which things should be considered while deciding the size of undo tablespace in your database ( choose three)
technology databases

  1. The size of an undo block

  2. The size of the redo log files.

  3. The size of the database buffer cache.

  4. The value of the UNDO_RETENTION parameter.

  5. Undo blocks generated per second.

Show answer
Correct Option: A,D,E

You suspect unauthorized data manipulation language (DML) operations on a particular table. You want to track users who performing the transactions and the values used in the transactions. Also you plan to transfer these values to another table for analysis. How would you achieve this?
technology databases

  1. By auditing the all DML operations on table.

  2. By using external table.

  3. By using triggers.

  4. By using anonymous PL/SQL blocks

Show answer
Correct Option: C

Which of the following is invalid db2 component :
technology databases

  1. System Services

  2. Locking Services

  3. SQL Services

  4. Distributed DATA Facilities

Show answer
Correct Option: C

Package is a
technology databases

  1. Compiled form of application plan

  2. Compiled form of Database Requests

  3. Collection of Sql statements

  4. Collection of Application plansCollection of Application plans

Show answer
Correct Option: B

Responsibility of OPTIMIZER is :
technology databases

  1. Compiles the SQL statements

  2. Complies the list of packages into application plan

  3. Stored the application plan and packages into Directory

  4. Chooses the best access path from catalog tables

Show answer
Correct Option: D
Explanation:

To answer this question, the user needs to know about the role of an optimizer in database management systems.

The optimizer is a component of a database management system (DBMS) that is responsible for generating the most efficient execution plan for a given SQL query.

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

A. Compiles the SQL statements: This option is partially correct. The optimizer does not compile SQL statements, but it does analyze the query and generates an execution plan to execute the SQL statement.

B. Complies the list of packages into application plan: This option is incorrect. The job of the precompiler is to compile the list of packages into an application plan, not the optimizer.

C. Stored the application plan and packages into Directory: This option is incorrect. The job of the precompiler is to store the application plan and packages into a directory, not the optimizer.

D. Chooses the best access path from catalog tables: This option is correct. The optimizer analyzes the query and chooses the best access path from a set of possible access paths based on the metadata stored in the catalog tables.

Therefore, the correct answer is:

The Answer is: D

If an object is dropped , all Application plans that were using the object are marked by DB2 as invalid ( True or False)
technology databases

  1. True

  2. False

Show answer
Correct Option: A
Explanation:

To solve this question, the user needs to understand the concept of object dropping in DB2 and how it affects application plans.

When an object is dropped in DB2, all application plans that use that object are invalidated by DB2. This is because the object no longer exists and any references to it in the application plans are no longer valid. Therefore, the correct answer is:

The Answer is: A. True