DBMS Quiz SECE
Authored by Vengatesh vengatesh
Design
Professional Development
Used 3+ times
AI Actions
Add similar questions
Adjust reading levels
Convert to real-world scenario
Translate activity
More...
Content View
Student View
10 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which of the following SQL command is used for removing (or deleting) a relation and its schema form the database?
DROP
DELETE
TRUNCATE
REMOVE
2.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Rectangles in ER diagram represents?
Tables
Attributes
Tuples
Entity Sets
3.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which of the following is not a SQL command?
DELETE
ORDER BY
WHERE
ALTER
4.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Primary Key can contain NULL
True
False
5.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which of the following is not a valid SQL type?
float
numeric
decimal
character
6.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
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'
7.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which command is used to change the definition of a table in SQL?
CREATE
UPDATE
ALTER
SELECT
Access all questions and much more by creating a free account
Create resources
Host any resource
Get auto-graded reports
Continue with Google
Continue with Email
Continue with Microsoft
or continue with
%20(1).png)
Apple
Others
By signing up, you agree to our Terms of Service & Privacy Policy
Already have an account?
