1z0-047 Oracle Database SQL Expert Certified Practice Exam

Sample Questions

Q) Which statements are true? (Choose all that apply.)

a) The data dictionary is created and maintained by the database administrator.

b) The dictionary data may consist of views combining the base tables of the dictionary and user-defined tables.

c) User names of all users, including database administrators are stored in the data dictionary.

d) The USER_CONS_COLUMNS views should be queried to find the names of the columns to which it applies a constraint.

e) Both CAT and USER_OBJECTS views provide the same information on all the objects that are owned by the user.

f) Vista with the same name but different prefixes, as a DBA, ALL and user, use the same basic tables from the data dictionary

Q) The SCOTT user who is the owner of the tables Orders and ORDER_ITEMS issues the following GRANT command: GRANT ALL ON orders, order_items to the Public; What correction should be made to the above statement?

a) Audience should be replaced with specific user names.

b) ALL must be replaced with a list of specific privileges.

c) WITH GRANT OPTION should be added to the declaration.

d) GRANT separate instructions are required for orders and ORDER_ITEMS tables.

Q) Which statement is true regarding the ROLLUP specified in the GROUP BY clause of a SQL?

a) It produces only subtotals for groups specified in the GROUP BY clause.

b) It produces only the totals for the groups specified in the GROUP BY clause.

c) It produces higher-level subtotals, from right to left through the list of grouping columns specified in the GROUP BY clause.

d) It produces higher-level subtotals, moving in all directions through the list of grouping columns specified in the GROUP BY clause.

Q) Which view is used to display the column names and default values for a table?

a) DBA_TABLES

b) DBA_COLUMNS

c) USER_COLUMNS

d) COLUMNS Card User

Q) ORD is a private synonym for OE.ORDERS table. The OE user issues the following command: DROP SYNONYM ord; Which statement is true regarding the above statement SOL?

a) the synonym to decline only.

b) The synonymous would be dropped and the corresponding table would become invalid.

c) The synonymous would be dropped and packets that relate to the synonym would be dropped.

d) The stands would be dropped and any public synonym with the same name is no longer valid.