Which two statements are true regarding tables? (Choose two.)

The correct answer is E. A table and a synonym can have the same name in the same schema. F. The same table name can be used in different schemas in the same database. Synonyms are database objects that enable you to call a table by another name. You can create synonyms to give an alternative name to a table.

Using DDL Statements to Create and Manage Tables

Question

Options

AA table name can be of any length.
BA table can have any number of columns.
CA column that has a DEFAULT value cannot store null values.
DA table and a view can have the same name in the same schema.
EA table and a synonym can have the same name in the same schema.
FThe same table name can be used in different schemas in the same database.

How the community answered

(24 responses)

B
4% (1)
C
13% (3)
D
4% (1)
E
79% (19)

Explanation

Synonyms are database objects that enable you to call a table by another name. You can create synonyms to give an alternative name to a table.

Topics

#table naming rules#schema objects#synonyms#DEFAULT value

Community Discussion

No community discussion yet for this question.

Full 1Z0-061 Practice