Which SQL statement will allow user USER1 to create a view on a table named EMPLOYEE?
Which SQL statement will allow user USER1 to create a view on a table named EMPLOYEE?
What authority must be granted to user USER1?
A new user named USER1 needs to retrieve information from a database named MYDB. What
authority must be granted to user USER1?
Which privilege is required to invoke a user defined function?
Which privilege is required to invoke a user defined function?
Which statement is true about an index that is used to support a UNIQUE constraint?
Which statement is true about an index that is used to support a UNIQUE constraint?
Which statement regarding triggers is true?
Which statement regarding triggers is true?
What will happen?
A table named STATES was created as follows:
What will happen?
what happens to the temporary table and any data stored in it?
When an application using a temporary table terminates or disconnects from the database
unexpectedly, what happens to the temporary table and any data stored in it?
what schema is used to store the UDF?
When a user-defined function (UDF) is created and no schema is specified, what schema is used
to store the UDF?
Which statement about triggers is true?
Which statement about triggers is true?
Which two statements are true about foreign key constraints?
Which two statements are true about foreign key constraints? (Choose two.)