DBMS Ex 1
Quiz
•
Computers
•
University
•
Hard
Dhanalakshmi B
Used 41+ times
FREE Resource
Enhance your content in a minute
15 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Match SQL language with SQL commands
1)DDL i)Revok, Grant
2)DML ii)rename a table
3)TCL iii)insert, update
4)DCL iv)rollback , commit
1-iii,2-i,3-ii,4-iv
1-iii,2-ii,3-iv,4-i
1-ii,2-iii,3-iv,4-i
1-i,2-iii,3-ii,4-iv
2.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
In existing table, ALTER TABLE statement is used to
Add columns
Add constraints
Delete columns
Delete constrains
All the above
3.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
SQL Query to delete all rows in a table without deleting the table (structure, attributes, and indexes)
DELETE FROM table_name;
DELETE TABLE table_name;
DROP TABLE table_name;
None
4.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Correct syntax query syntax to drop a column from a table is
DELETE COLUMN column_name;
DROP COLUMN column_name;
ALTER TABLE table_name DROP COLUMN column_name;
None is correct.
5.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which command is used for removing a table and all its data from the database:
Create command
Drop table command
Alter table command
All of the mentioned
6.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which Symbol means "All"
*
&
%
!
7.
MULTIPLE SELECT QUESTION
30 sec • 1 pt
Which is the correct query to delete the rows of employees whose exp is less than 10.
DELETE * FROM EMP WHERE EXP<10;
DELETE FROM EMP;
DELETE FROM EMP WHERE EXP<10;
DELETE FROM EMP WHERE EXP>10;
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 Classlink

Continue with Clever
or continue with

Microsoft
%20(1).png)
Apple
Others
Already have an account?
Similar Resources on Wayground
10 questions
CS100||MsWord
Quiz
•
University
10 questions
Round 1: Get to know US :)
Quiz
•
University
11 questions
Types of Mass Media
Quiz
•
10th Grade - Professi...
15 questions
Javascript Array dan Object
Quiz
•
University
11 questions
Capítulo 3
Quiz
•
University - Professi...
10 questions
Hands-on Modul 3
Quiz
•
University
10 questions
PYTHON BASICS PART 1
Quiz
•
University
10 questions
Visual Basic 2010
Quiz
•
8th Grade - University
Popular Resources on Wayground
8 questions
2 Step Word Problems
Quiz
•
KG - University
20 questions
Comparing Fractions
Quiz
•
4th Grade
15 questions
Fractions on a Number Line
Quiz
•
3rd Grade
20 questions
Equivalent Fractions
Quiz
•
3rd Grade
25 questions
Multiplication Facts
Quiz
•
5th Grade
10 questions
Latin Bases claus(clois,clos, clud, clus) and ped
Quiz
•
6th - 8th Grade
22 questions
fractions
Quiz
•
3rd Grade
7 questions
The Story of Books
Quiz
•
6th - 8th Grade
Discover more resources for Computers
8 questions
2 Step Word Problems
Quiz
•
KG - University
7 questions
Comparing Fractions
Interactive video
•
1st Grade - University
7 questions
Force and Motion
Interactive video
•
4th Grade - University
10 questions
14.2 Independent/Dependent Variables
Quiz
•
KG - University
18 questions
Great Lakes States
Quiz
•
KG - University
7 questions
DNA, Chromosomes, Genes, and Traits: An Intro to Heredity
Interactive video
•
11th Grade - University
7 questions
Reflexive Verbs in Spanish
Lesson
•
9th Grade - University
7 questions
Narrative Writing 1
Interactive video
•
4th Grade - University
