DBMS Quiz SECE

Which of the following SQL command is used for removing (or deleting) a relation and its schema form the database?

• DROP

• DELETE

• TRUNCATE

• REMOVE

Rectangles in ER diagram represents?

• Tables

• Attributes

• Tuples

• Entity Sets

Which of the following is not a SQL command?

• DELETE

• ORDER BY

• WHERE

• ALTER

Primary Key can contain NULL

• True

• False

Which of the following is not a valid SQL type?

• float

• numeric

• decimal

• character

How can you change "Thomas" into "Michel" in the "LastName" column in the Users table?

• 1. UPDATE User SET LastName = 'Thomas' INTO LastName = 'Michel'

• 1. MODIFY Users SET LastName = 'Michel' WHERE LastName = 'Thomas'

• 1. MODIFY Users SET LastName = 'Thomas' INTO LastName = 'Michel'

• 1. UPDATE Users SET LastName = 'Michel' WHERE LastName = 'Thomas'

Which command is used to change the definition of a table in SQL?

• CREATE

• UPDATE

• ALTER

• SELECT

Which type of JOIN is used to returns rows that do not have matching values?

• Outer Join

• Inner Join

• Self Join

• All of the Above

To which of the following the term "DBA" referred?

• 1. Data Bank Administrator

• Database Administrator

• Database Analyst

• Database Aggregator

Rows of a relation are known as the _______.

• Tuples

• Relations

• Attributes

• All of the above