NEW
Font size
WorksheetsDBMS Quiz SECE
Total questions: 10
Worksheet time: 5mins
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?
UPDATE User SET LastName = 'Thomas' INTO LastName = 'Michel'
MODIFY Users SET LastName = 'Michel' WHERE LastName = 'Thomas'
MODIFY Users SET LastName = 'Thomas' INTO LastName = 'Michel'
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?
Data Bank Administrator
Database Administrator
Database Analyst
Database Aggregator
Rows of a relation are known as the _______.
Tuples
Relations
Attributes
All of the above
