×
Detail Form
We will send your result on your email id and phone no. please fill detail
1.
Which SQL statement will execute successfully?
2.
You want to grant user BOB the ability to create tables in table space PLANS and to grant this privilege to others Which command would you use?
3.
What is the purpose of a role?
4.
A DBA wants to use Label Based Access Control (LBAC) to protect Individual rows in a table. Which data type must be used to create a column to hold the necessary LBAC security data?
5.
Which operating system has client side Kerberos support enabled by default?
6.
Which statement is true about unique constraints?
7.
Which statement is correct about using the TAKEOVER HADR command?
8.
A database named FINANCE must be available to users 24x7x365. Which command should be used to create a backup image of the FINANCE database without having a significant impact on running applications?
9.
A database named PAYROLL resides on an IBM System Storage DS8000 and a database administrator would like to use Flash Copy to back up the database. Which command can be used to accomplish this?
10.
A file named db2advise.in contains the text shown below:
-#SET FREQUENCY 100
SELECT COUNTO FROM employee;
SELECT * FROM employee WHERE lastname='HAAS';
What does the line -#SET FREQUENCY 100 convey when this file is used as input for the Design Advisor?
-#SET FREQUENCY 100
SELECT COUNTO FROM employee;
SELECT * FROM employee WHERE lastname='HAAS';
What does the line -#SET FREQUENCY 100 convey when this file is used as input for the Design Advisor?