Search Header Logo

SQL MCQ

Authored by Abdullah Muhammad 201-801-271

Computers

University

Used 9+ times

SQL MCQ
AI

AI Actions

Add similar questions

Adjust reading levels

Convert to real-world scenario

Translate activity

More...

    Content View

    Student View

9 questions

Show all answers

1.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which command is used to retrieve data from an SQLite database?

  • INSERT

  • UPDATE

  • SELECT

  • DELETE

2.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What is the correct syntax to create a new table in SQLite?

  • CREATE NEW TABLE table_name (column1 datatype, column2 datatype);

  • CREATE TABLE table_name (column1 datatype, column2 datatype);

  • CREATE TABLE table_name: (column1 datatype, column2 datatype);

  • NEW TABLE table_name (column1 datatype, column2 datatype);

3.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which keyword is used to eliminate duplicate rows in the result set of a query?

  • UNIQUE

  • DISTINCT

  • DIFFERENT

  • EXCLUSIVE

4.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

How do you retrieve all columns from a table named employees?

  • SELECT * FROM employees;

  • SELECT all FROM employees;

  • SELECT employees.* FROM employees;

  • SELECT columns FROM employees;

5.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What is the purpose of the WHERE clause in SQLite?

  • To sort the result set

  • To filter records

  • To join tables

  • To group records

6.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

How can you update the salary column to 5000 for all employees in the staff table?

  • MODIFY staff SET salary = 5000;

  • ALTER TABLE staff SET salary = 5000;

  • UPDATE staff SET salary = 5000;

  • SET staff.salary = 5000;

7.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which command is used to remove a table named customers from an SQLite database?

  • A) REMOVE TABLE customers;

  • B) DELETE TABLE customers;

  • C) DROP TABLE customers;

  • D) ERASE TABLE customers;

Access all questions and much more by creating a free account

Create resources

Host any resource

Get auto-graded reports

Google

Continue with Google

Email

Continue with Email

Classlink

Continue with Classlink

Clever

Continue with Clever

or continue with

Microsoft

Microsoft

Apple

Apple

Others

Others

Already have an account?