SQL Quiz #1

SQL Quiz #1

Assessment

Assessment

Created by

Sarah T

Computers

Professional Development

5 plays

Medium

Student preview

quiz-placeholder

12 questions

Show answers

1.

Multiple Choice

45 sec

1 pt

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

45 sec

1 pt

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

45 sec

1 pt

How many Primary keys can be created on a table?

Infinity

2

1

24

4.

Multiple Choice

45 sec

1 pt

Which keyword allows us to find the unique values in the database?

DISTINCT

UNIQUE

FIND

DIFF

5.

Multiple Choice

45 sec

1 pt

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

45 sec

1 pt

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;

cartoon woman

Explore this activity with a free account

Find a similar activity

Create activity tailored to your needs using

Quizizz AI
Computer Hardware

12 questions

Computer Hardware

assessment

9th - 12th Grade

Hardware & Software

23 questions

Hardware & Software

assessment

6th - 7th Grade

Computer Basics

24 questions

Computer Basics

assessment

6th - 8th Grade

Coding

12 questions

Coding

assessment

5th - 8th Grade

Python

10 questions

Python

assessment

7th - 8th Grade

Parts of a Computer

15 questions

Parts of a Computer

lesson

KG - 1st Grade

Computer Basics

10 questions

Computer Basics

assessment

University

Computer Basics

20 questions

Computer Basics

assessment

9th - 12th Grade