AllExam Dumps

DUMPS, FREE DUMPS, VCP5 DUMPS| VMWARE DUMPS, VCP DUMPS, VCP4 DUMPS, VCAP DUMPS, VCDX DUMPS, CISCO DUMPS, CCNA, CCNA DUMPS, CCNP DUMPS, CCIE DUMPS, ITIL, EXIN DUMPS,


READ Free Dumps For Oracle- 1z0-007





Question ID 7997

What are two reasons to create synonyms? (Choose two.)

Option A

You have too many tables.

Option B

Your tables are too long.

Option C

Your tables have difficult names.

Option D

You want to work on your own tables.

Option E

You want to use another schema's tables.

Option F

You have too many columns in your tables.

Correct Answer BC
Explanation Explanation/Reference: Explanation : Create a synonyms when the names of the tables are too long or the table names are difficult. Incorrect answers: A The number of tables in a schema is not a consideration when creating a synonym. Refer : Introduction to Oracle9i : SQL, Oracle University Study Guide, 12-24


Question ID 7998

What is true about updates through a view?

Option A

You cannot update a view with group functions.

Option B

When you update a view group functions are automatically computed.

Option C

When you update a view only the constraints on the underlying table will be in effect.

Option D

When you update a view the constraints on the views always override the constraints on the underlying tables.

Correct Answer A
Explanation

Send email to admin@getfreedumps for new dumps request!!!