what set of rows a user has access to?
Which method for restricting data access relies on a SQL search condition that describes
what set of rows a user has access to?
Which SQL statement will take the ability to create tables in a table space named MYTBSP away from user USER1?
Which SQL statement will take the ability to create tables in a table space named MYTBSP
away from user USER1?
what state is the connection placed in?
In a trusted context environment, if a switch request is made with an authorization ID that is
not allowed on a trusted connection, what state is the connection placed in?
When is a mask used to limit access to data in a table?
When is a mask used to limit access to data in a table?
What privilege is required to create a view on a table that you are not the owner of?
What privilege is required to create a view on a table that you are not the owner of?
Which authority/privilege must user USER1 be granted in order to re-create the package?
After creating several new indexes and executing RUNSTATS, user USER1 wants to
re-create a package that is stored in the database so it will take advantage of the new
indexes. Which authority/privilege must user USER1 be granted in order to re-create the
package?
Which SQL statement will give a user named USER1 the ability to run an embedded SQL application named BENEFITS
Which SQL statement will give a user named USER1 the ability to run an embedded SQL
application named BENEFITS that calls a package named CORPDATA.PKGA?
Which of the following privileges allow a user to update the comment on a sequence?
Which of the following privileges allow a user to update the comment on a sequence?
Which statement is valid about the Row and Column Access Control (RCAC) feature?
Which statement is valid about the Row and Column Access Control (RCAC) feature?
Which type of table should you use if you want to define specific time periods when data is valid?
Which type of table should you use if you want to define specific time periods when data is
valid?