Search Header Logo

SQL Basics

Authored by Julissa Rokohl

Computers

Professional Development

Used 2+ times

SQL Basics
AI

AI Actions

Add similar questions

Adjust reading levels

Convert to real-world scenario

Translate activity

More...

    Content View

    Student View

16 questions

Show all answers

1.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What is DML?

Database Management Language

Data Manipulation Language

Data Management Language

2.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

A DML statement is executed when you...

Add new records to a table

Modify existing rows in a table

Remove existing rows from a table

All of the above

3.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What kind of statement is this?
INSERT INTO users VALUES (20, 'Mary', 'Ann', 12, 90000);

insert clause

implicit insert statement

addition statement

4.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What kind of statement is this?
INSERT INTO users (age, first_name, middle_name, member, points) VALUES (20, 'Mary', 'Ann', 12, 90000);

explicit clause

explicit insert statement

explicit addition statement

5.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What is a JOIN operation that creates an implicit join clause for you based on the common columns in the two tables being joined?

a join statement

a natural join

an outer join

a join function

6.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What is a field (or collection of fields) in one table, that refers to the primary key in another table?

a natural key

a foreign key

a primary key

a joined key

7.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Where should the ORDER BY clause go in a statement?

at the beginning

at the end

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?