×
Detail Form
We will send your result on your email id and phone no. please fill detail
1.
Read the following statements:
Step 1) DBA Team has given CREATE TABLE system privilege to John with the ADMIN OPTION.
Step 2) John creates a table and also gives CREATE TABLE system privilege to Bob.
Step 3) Bob also creates a table.
Step 4) DBA Team revokes CREATE TABLE system privilege from John.
Which of these is correct about the given steps?
Step 1) DBA Team has given CREATE TABLE system privilege to John with the ADMIN OPTION.
Step 2) John creates a table and also gives CREATE TABLE system privilege to Bob.
Step 3) Bob also creates a table.
Step 4) DBA Team revokes CREATE TABLE system privilege from John.
Which of these is correct about the given steps?
2.
Read the following statements:
Step 1) The HR team has given the SELECT Object privilege on EMPLOYEES with GRANT OPTION to John with GRANT OPTION.
Step 2) John grants the SELECT privilege on EMPLOYEE Table to Bob
Step 3)The HR team has revoked the SELECT Object privilege on EMPLOYEE Table from John.
Which of these is correct about the given steps?
Step 1) The HR team has given the SELECT Object privilege on EMPLOYEES with GRANT OPTION to John with GRANT OPTION.
Step 2) John grants the SELECT privilege on EMPLOYEE Table to Bob
Step 3)The HR team has revoked the SELECT Object privilege on EMPLOYEE Table from John.
Which of these is correct about the given steps?
3.
John is executing UPDATE statement on the EMPLOYEE table as follows:
SQL>UPDATE hr.employee set salary = salary + 10 where employee_id = 1;
John is not issuing a commit statement and after 3 minutes, Bob is executing the UPDATE statement on the EMPLOYEE table as follows:
SQL>UPDATE hr.employee set salary = salary + 20 where employee_id = 1;
Which of the following statements is true about the given scenario?
SQL>UPDATE hr.employee set salary = salary + 10 where employee_id = 1;
John is not issuing a commit statement and after 3 minutes, Bob is executing the UPDATE statement on the EMPLOYEE table as follows:
SQL>UPDATE hr.employee set salary = salary + 20 where employee_id = 1;
Which of the following statements is true about the given scenario?