Which statement is true regarding synonyms?

Synonyms are used to reference only those tables that are owned by another user

Synonyms can be created for tables but not views

Synonyms are used to reference only those tables that are owned by another user

A public synonym and a private synonym can exist with the same name for the same table

The DROP SYNONYM statement removes the synonym, and the status of the table on which the synonym has been created becomes invalid

A non-correlated subquery can be defined as________

A set of sequential queries, all of which must always return a single value

A set of sequential queries, all of which must return values from the same table

A SELECT statement that can be embedded in a clause of another SELECT statement only

A set of one or more sequential queries in which generally the result of the inner query is used as the search value in the outer query

Which statements are correct regarding indexes?

When a table is dropped, the corresponding indexes are automatically dropped

For each DML operation performed, the corresponding indexes are automatically updated

A non-deferrable PRIMARY KEY or UNIQUE KEY constraint in a table automatically creates a unique index

Explore topic-wise MCQs in Database.

This section includes 3 Mcqs, each offering curated multiple-choice questions to sharpen your Database knowledge and support exam preparation. Choose a topic below to get started.

1.	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 status of the table on which the synonym has been created becomes invalid
Answer» B. Synonyms are used to reference only those tables that are owned by another user

Discussion

2.	A non-correlated subquery can be defined as________
A.	A set of sequential queries, all of which must always return a single value
B.	A set of sequential queries, all of which must return values from the same table
C.	A SELECT statement that can be embedded in a clause of another SELECT statement only
D.	A set of one or more sequential queries in which generally the result of the inner query is used as the search value in the outer query
Answer» E.

Discussion

3.	Which statements are correct regarding indexes?
A.	When a table is dropped, the corresponding indexes are automatically dropped
B.	For each DML operation performed, the corresponding indexes are automatically updated
C.	A non-deferrable PRIMARY KEY or UNIQUE KEY constraint in a table automatically creates a unique index
D.	All of the mentioned
Answer» E.

Discussion