1Z0-051 試験問題を無料オンラインアクセス

Which one is a system privilege?

• A.DELETE
• B.ALTER TABLE
• C.SELECT
• D.CREATE TABLE
• E.EXECUTE

Which constraint can be defined only at the column level?

• A.CHECK
• B.UNIQUE
• C.FOREIGN KEY
• D.NOT NULL
• E.PRIMARY KEY

The user Alice wants to grant all users query privileges on her DEPT table. Which SQL statement accomplishes this?

• A.GRANT select ON dept TO ALL;
• B.GRANT select ON dept TO ALL_USERS;
• C.GRANT QUERY ON dept TO ALL_USERS
• D.GRANT select ON dept TO PUBLIC;

You work as a database administrator at ABC.com. You study the exhibit carefully. Exhibit:

You want to create a SALE_PROD view by executing the following SQL statements:

Which statement is true regarding the execution of the above statement?

• A.The view will not be created because the join statements are not allowed for creating a view
• B.The view will be created but no DML operations will be allowed on the view
• C.The view will be created and you can perform DLM operations on the view
• D.The view will not be created because the GROUP BY clause is not allowed for creating a view

Which two statements are true regarding the USING clause in table joins?(Choose two.)

• A.It can be used to join tables that have columns with the same name and compatible data types.
• B.It can be used to join a maximum of three tables.
• C.It can be used to access data from tables through equijoins as well as nonequijoins.
• D.It can be used to restrict the number of columns used in a NATURAL join.