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
Pre-Test Node-Red SQL

10 questions

Pre-Test Node-Red SQL

assessment

Professional Development

SQL Commands 101

10 questions

SQL Commands 101

assessment

University - Professi...

SQL - 1

12 questions

SQL - 1

assessment

Professional Development

Introduction to SQL Concepts

10 questions

Introduction to SQL Concepts

assessment

Professional Development

IT DBMS Quiz

16 questions

IT DBMS Quiz

assessment

Professional Development

PL/SQL, Cursors, Joins

11 questions

PL/SQL, Cursors, Joins

assessment

Professional Development

DBMS -23

7 questions

DBMS -23

assessment

Professional Development

Databases - SQL 1

10 questions

Databases - SQL 1

assessment

Professional Development