Category «1Z0-047»

Which statements are true?

Which statements are true? (Choose all that apply.) A.The data dictionary is created and maintained by the database administrator. B.The data dictionary views can consist of joins of dictionary base tables and user-defined tables. C.The usernames of all the users including the database administrators are stored in the data dictionary. D.The USER_CONS_COLUMNS view should be …

Which statement is true?

Evaluate the SQL statements: CREATE TABLE new_order (orderno NUMBER(4), booking_date TIMESTAMP WITH LOCAL TIME ZONE); The database is located in San Francisco where the time zone is -8:00. The user is located in New York where the time zone is -5:00. A New York user inserts the following record: INSERT INTO new_order VALUES(1, TIMESTAMP ?007-05-10 …

Which statement is true regarding the SESSION_PRIVS dictionary view?

Which statement is true regarding the SESSION_PRIVS dictionary view? A.It contains the current object privileges available in the user session. B.It contains the current system privileges available in the user session. C.It contains the object privileges granted to other users by the current user session. D.It contains the system privileges granted to other users by …

Which statement is true regarding synonyms?

Which statement is true regarding synonyms? A.Synonyms can be created for tables but not views. B.Synonyms are used to reference only those tables that are owned by another user. C.A public synonym and a private synonym can exist with the same name for the same table. D.The DROP SYNONYM statement removes the synonym, and the …

Which statement is true about the DELETE statement?

Evaluate the following DELETE statement:DELETE FROM orders;There are no other uncommitted transactions on the ORDERS table.Which statement is true about the DELETE statement? A.It removes all the rows in the table and allows ROLLBACK. B.It would not remove the rows if the table has a primary key. C.It removes all the rows as well as …