databases Online Quiz - 178
|Description: databases Online Quiz - 178|
|Number of Questions: 20|
|Created by: Aliensbrain Bot|
SELECT department, COUNT(1) FROM employees WHERE salary > 25000 GROUP BY department; What about this query :-) ?
Which of the following types of statements can use a temporary tablespace?
Which of the following statements gives user desmond the ability to alter table gl.accounts?
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?
Which of the following system privileges can allow the grantee to masquerade as another user and therefore should be granted judiciously?
Which of the following statements enables the role user_admin in the current session?
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?
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?