final DBMS lab quiz

Which is the subset of SQL commands used to manipulate Oracle Database structure, including tables?

• Data Definition Language(DDL)

• Data Manipulation Language(DML)

• Both of above

• None

Which operator performs pattern matching?

• BETWEEN operator

• LIKE operator

• EXISTS operator

• None of these

Which of the following is not a DDL command?

• UPDATE

• TRUNCATE

• ALTER

• None of the Mentioned

Which data type can store unstructured data in a column?

• RAW

• CHAR

• NUMERIC

• VARCHAR

The virtual table that its created by data from the result of an SQL 'Select' statement is called _________

• View

• Synonym

• Sequence

• Transaction

Which of the following is an aggregate function in SQL?

• Union

• Like

• Group

• Min

An alias is:

• An alternate name given to a relation.

• An alternate name given to an inner query.

• An alternate name given to a user.

• None of the above

Point out the correct statement.

• CHECK constraints enforce domain integrity

• UNIQUE constraints enforce the uniqueness of the values in a set of columns

• In a UNIQUE constraint, no two rows in the table can have the same value for the columns

• All of the mentioned

Which of the following constraint does not enforce uniqueness?

• UNIQUE

• Primary key

• Foreign key

• None of the mentioned

Constraints can be applied on ___________

• Column

• Table

• Field

• All of the mentioned