Which of the following privileges permits a user to update the comment on a sequence?

Which of the following statements is used to revoke all DML privileges on table EMPLOYEE from
user TOM?

What is the lowest privilege and/or authority required to execute the following SQL statement?
CREATE VIEW view1 AS
SELECT * FROM table1
WHERE STATE = ‘TX’

Which of the following statements allows BOB to revoke access to the SAMPLE database from
user TOM?

While attempting to connect to a database stored on an iSeries server from a Windows client, the
following message was displayed:
SQL1013N The database alias name or database name “TEST_DB” could not be found.
Which of the following actions can be used to help determine why this message was displayed?

A database named TEST_DB resides on a z/OS system and listens on port 446. The TCP/IP
address for this system is 192.168.10.20 and the TCP/IP host name is MYHOST. Which of the
following commands is required to make this database accessible to a Linux client?

Which of the following statements will catalog the database MYDB on the node MYNODE and
assign it the alias MYNEWDB?

Which of the following are NOT stored in the system catalog tables?

Which of the following tools can NOT be used to catalog a database?

In which of the following scenarios would a stored procedure be beneficial?