
DBMS-1
Quiz
•
Computers
•
University
•
Practice Problem
•
Hard
RAVINDER B
Used 3+ times
FREE Resource
Enhance your content in a minute
10 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
45 sec • 1 pt
Which of the following is not allowed when a table already has data in it?
ALTER TABLE ADD COLUMN
ALTER TABLE DROP COLUMN
ALTER TABLE RENAME COLUMN
ALTER TABLE MODIFY COLUMN data type
2.
MULTIPLE CHOICE QUESTION
45 sec • 1 pt
What does the following SQL command do?
TRUNCATE TABLE employees;
Deletes all rows and can't be rolled back
Deletes all rows and can be rolled back
Deletes the table structure and data
Deletes rows based on WHERE clause
3.
MULTIPLE CHOICE QUESTION
45 sec • 1 pt
What will be the result of this query?
SELECT * FROM students WHERE marks = NULL;
All rows with marks = NULL
Syntax error
No rows selected
Only NULL rows returned
4.
MULTIPLE CHOICE QUESTION
45 sec • 1 pt
Which DML command can insert multiple rows in one statement?
INSERT INTO ... VALUES
INSERT ALL
INSERT EACH
APPEND ROWS
5.
MULTIPLE CHOICE QUESTION
45 sec • 1 pt
Which query will give you the 3rd highest salary from a salaries table?
SELECT salary FROM salaries ORDER BY salary DESC LIMIT 3;
SELECT MAX(salary) FROM salaries LIMIT 2,1;
SELECT salary FROM (SELECT DISTINCT salary FROM salaries ORDER BY salary DESC LIMIT 2,1);
SELECT salary FROM salaries OFFSET 2 ROWS FETCH NEXT 1 ROW ONLY;
6.
MULTIPLE CHOICE QUESTION
45 sec • 1 pt
Which of the following commands creates a new copy of a table with only structure and no data?
CREATE TABLE new_table LIKE old_table;
CREATE TABLE new_table AS SELECT * FROM old_table;
SELECT * INTO new_table FROM old_table;
CREATE TABLE new_table FROM old_table;
7.
MULTIPLE CHOICE QUESTION
45 sec • 1 pt
What is the effect of this command: DELETE FROM orders WHERE 1=1;
Deletes no rows
Deletes all rows
Deletes only rows with ID=1
Causes syntax error
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
12 questions
Quiz 2 - Stack
Quiz
•
University
15 questions
DBC CHAPTER 3 - REVISION
Quiz
•
University
14 questions
Excel Quiz
Quiz
•
University
15 questions
4.6.4 Logic Gates
Quiz
•
10th Grade - Professi...
10 questions
Big Data Analytics - Week 2 (Data storage)
Quiz
•
University - Professi...
15 questions
Kuis Pra-UTS
Quiz
•
University
12 questions
Database Management system
Quiz
•
University
15 questions
bootstrap let's play
Quiz
•
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
