Which statement describes a way to minimize the impact of a RUNSTATS operation?
Which statement describes a way to minimize the impact of a RUNSTATS operation?
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?
Which statement is true?
If the following command is executed: Which statement is true?
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 statement describes adaptive row compression?
Which statement describes adaptive row compression?
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?