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?
A. GRANT EXECUTE ON APPLICATION benefits TO user1
B. GRANT EXECUTE ON PACKAGE corpdata.pkga TO user1
C. GRANT EXECUTE ON APPLICATION PACKAGE corpdata.pkga TO user1
D. GRANT EXECUTE ON APPLICATION benefits USING PACKAGE corpdata.pkga TO user1
Which of the following privileges allow a user to update the comment on a sequence?
A. ALTER
B. USAGE
C. UPDATE
D. COMMENT
What privilege is required to create a view on a table that you are not the owner of?
A. INSERT
B. SELECT
C. CREATE
D. TRIGGER
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?
A. BIND
B. REBIND
C. BINDADD
D. BIND_REBIND
When is a mask used to limit access to data in a table?
A. When mandatory access control (MAC) is used to protect the table.
B. When discretionary access control (DAC) is used to protect the table.
C. When label-based access control (LBAC) is used to protect the table.
D. When row and column access control (RCAC) is used to protect the table.
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?
A. Locked
B. Waiting
C. Pending
D. Unconnected
Which SQL statement will take the ability to create tables in a table space named MYTBSP away from user USER1?
A. REVOKE USE OF TABLESPACE mytbsp FROM user1
B. REVOKE ALTER ON TABLESPACE mytbsp FROM user1
C. REVOKE UPDATE OF TABLESPACE mytbsp FROM user1
D. REVOKE CREATETAB ON TABLESPACE mytbsp FROM user1
Which method for restricting data access relies on a SQL search condition that describes what set of rows a user has access to?
A. Authentication
B. Authorities and privileges
C. Label-based access control
D. Row and column access control
Given the following statement:
GRANT DELETE ON TABLE sales TO User1 WITH GRANT OPTION; Which statement is correct?
A. USER1 can only remove the SALES table.
B. USER1 can only remove records from the SALES table.
C. USER1 can remove the SALES table and grant the privilege to remove the SALES table to other users.
D. USER1 can remove records from the SALES table and grant the privilege to remove records from the SALES table to other users.
Which case will require a sequence to be dropped and recreated instead of being modified by the ALTER SEQUENCE statement?
A. Change the data type of the sequence.
B. Reset the sequence to its starting value.
C. Establish new minimum or maximum values.
D. Change the increment between future values.
Nowadays, the certification exams become more and more important and required by more and more enterprises when applying for a job. But how to prepare for the exam effectively? How to prepare for the exam in a short time with less efforts? How to get a ideal result and how to find the most reliable resources? Here on Vcedump.com, you will find all the answers. Vcedump.com provide not only IBM exam questions, answers and explanations but also complete assistance on your exam preparation and certification application. If you are confused on your A2090-610 exam preparations and IBM certification application, do not hesitate to visit our Vcedump.com to find your solutions here.