SQL Quiz #1
Assessment
•
Sarah T
•
Computers
•
Professional Development
•
5 plays
•
Medium
Student preview
12 questions
Show answers
1.
Multiple Choice
What is the difference if we truncate a table and if we drop a table?
In both cases, the table is deleted.
In both cases, the data is deleted.
In truncate, the data is deleted and in drop the whole table is deleted.
In truncate, the table is deleted while when the table is dropped the data is deleted.
2.
Multiple Choice
Which of the following query depicts the correct Select statement?
Select # From Daily_Productivity;
Select * From Daily_Productivity;
Select From Daily_Productivity;
Select col1,col2 From;
3.
Multiple Choice
How many Primary keys can be created on a table?
Infinity
2
1
24
4.
Multiple Choice
Which keyword allows us to find the unique values in the database?
DISTINCT
UNIQUE
FIND
DIFF
5.
Multiple Choice
Which of the following is true about NULL values in SQL?
A NULL value means zero.
A null value can only be used with numeric attributes.
Null value just means that data of that attribute is not available.
None of these.
6.
Multiple Choice
Which of the query below is likely to run into an error?
SELECT FROM team_name;
SELECT employee_id, analyst_name FROM department_name;
SELECT analyst_role FROM department_name;
SELECT * FROM team_name;
Explore this activity with a free account
Find a similar activity
Create activity tailored to your needs using
Computer Hardware
•
9th - 12th Grade
Hardware & Software
•
6th - 7th Grade
Computer Basics
•
6th - 8th Grade
Coding
•
5th - 8th Grade
Python
•
7th - 8th Grade
Parts of a Computer
•
KG - 1st Grade
Computer Basics
•
University
Computer Basics
•
9th - 12th Grade