Compiled form of Database Requests

Database Management Fundamentals: DB2 and Oracle

Question 1 True/False

SELECT department, COUNT(1) FROM employees WHERE salary > 25000 GROUP BY department; What about this query :-) ?

True
False

Question 2 Multiple Choice (Single Answer)

where would you find automatic_ipc parameter ?

listener.ora
sqlnet.ora server file
sqlnet.ora client file
tnsnames.ora server file

Question 3 Multiple Choice (Single Answer)

Which of the following statements creates an Oracle account, but lets the operating system authenticate logons?

create user ops$admin identified by os;
create user ops$admin identified externally;
create user ops$admin nopassword;
create user ops$admin authenticated by os;

Question 4 Multiple Choice (Single Answer)

Which of the following types of statements can use a temporary tablespace?

An index creation
SQL statements with a GROUP BY clause
A hash join operation
All of the above

Question 5 Multiple Choice (Single Answer)

Which of the following statements gives user desmond the ability to alter table gl.accounts?

grant alter on gl.accounts to desmond;
grant alter to desmond on gl.accounts;
grant alter table to desmond;
allow desmond to alter table gl.accounts;

Question 6 Multiple Choice (Single Answer)

Which of the following statements gives user desmond the ability to alter table gl.accounts as well as give this ability to other accounts?

grant alter any table with grant option to desmond;
grant alter on gl.accounts to desmond with admin option;
grant alter any table to desmond with grant option;
grant alter any table to desmond with admin option;

Question 7 Multiple Choice (Multiple Answers)

The following SQL statement will allow user regina to perform which operations on sequence oe.orders_seq? GRANT ALL ON oe.orders_seq TO regina;

Select the next value from oe.orders_seq.
Alter sequence oe.orders_seq to change the next value.
Change the number of sequence numbers that will be cached in memory.
Both A and C.
All of the above.

Question 8 Multiple Choice (Single Answer)

User system granted SELECT on sh.products to user A using WITH GRANT OPTION. A then granted SELECT on sh.products to user B. A has left the company, and his account is dropped. What happens to B’s privileges on sh.products?

B loses his SELECT privilege on sh.products.
B retains his SELECT privilege on sh.products.
B loses his SELECT privilege if A was dropped with the CASCADE REVOKE option.
B retains his SELECT privilege if A was dropped with the NOCASCADE REVOKE option

Question 9 Multiple Choice (Single Answer)

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?

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

Question 10 Multiple Choice (Single Answer)

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

CREATE ANY JOB
ALTER USER
CREATE ANY PROCEDURE
All of the above

Question 11 Multiple Choice (Single Answer)

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

alter session enable role user_admin;
alter session set role user_admin;
alter role user_admin enable;
set role user_admin;

Question 12 Multiple Choice (Single Answer)

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?

set role all;
alter user augustin default role all;
alter session enable role info_czar;
alter session enable info_czar identified by brozo

Question 13 Multiple Choice (Multiple Answers)

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

The size of an undo block
The size of the redo log files.
The size of the database buffer cache.
The value of the UNDO_RETENTION parameter.
Undo blocks generated per second.

Question 14 Multiple Choice (Single Answer)

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?

By auditing the all DML operations on table.
By using external table.
By using triggers.
By using anonymous PL/SQL blocks

Question 15 Multiple Choice (Single Answer)

Which of the following is invalid db2 component :

System Services
Locking Services
SQL Services
Distributed DATA Facilities

Question 16 Multiple Choice (Single Answer)

Package is a

Compiled form of application plan
Compiled form of Database Requests
Collection of Sql statements
Collection of Application plansCollection of Application plans

Question 17 Multiple Choice (Single Answer)

Responsibility of OPTIMIZER is :

Compiles the SQL statements
Complies the list of packages into application plan
Stored the application plan and packages into Directory
Chooses the best access path from catalog tables

Question 18 True/False

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

True
False

Question 19 True/False

If a new object is created , DB2 automatically starts using it (True or False)

True
False

Question 20 Multiple Choice (Single Answer)

Which utility is used to retrieve data from a Image copy

LOAD
UNLOAD
REORG
RUNSTATS

Database Management Fundamentals: DB2 and Oracle

Questions