Database Design and Development SQL 1

Database Design and Development SQL 1

University

26 Qs

quiz-placeholder

Similar activities

RA 3 Prueba de Análisis y Diseño

RA 3 Prueba de Análisis y Diseño

4th Grade - University

21 Qs

python-2

python-2

University

23 Qs

ARRAY

ARRAY

University

22 Qs

SQL - sys vars & filters

SQL - sys vars & filters

University

22 Qs

AI/ML MASTERMIND

AI/ML MASTERMIND

University

21 Qs

cit157 finals q2

cit157 finals q2

University

21 Qs

Soal IT

Soal IT

University

21 Qs

thi1

thi1

University

21 Qs

Database Design and Development SQL 1

Database Design and Development SQL 1

Assessment

Quiz

Computers

University

Practice Problem

Medium

Created by

Nicole Donnelly

Used 5+ times

FREE Resource

AI

Enhance your content in a minute

Add similar questions
Adjust reading levels
Convert to real-world scenario
Translate activity
More...

26 questions

Show all answers

1.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which SQL clause is used to filter records?

WHERE

SELECT

GROUP BY

ORDER BY

2.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What does the SQL statement "SELECT * FROM table1 WHERE column1 LIKE '%value%'" do?

Selects all columns from table1 where column1 exactly matches 'value'

Selects all columns from table1 where column1 contains 'value'

Selects all rows from table1 where column1 is greater than 'value'

Selects all unique rows from table1 where column1 contains 'value'

3.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which SQL statement is used to remove a table from a database?

REMOVE TABLE table_name

DELETE TABLE table_name

DROP TABLE table_name

ERASE TABLE table_name

4.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

In SQL, what function is used to count the number of rows in a table?

SUM()

COUNT()

TOTAL()

ADD()

5.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What is the correct SQL statement to create a new table called "Employees"?

CREATE Employees TABLE;

CREATE TABLE Employees;

NEW TABLE Employees;

INIT TABLE Employees;

6.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which of the following SQL statements is used to update data in a database?

MODIFY

UPDATE

CHANGE

ALTER

7.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

In SQL, what is a primary key?

A key that uniquely identifies each row in a table

A key that can be used to encrypt data

A key that is used to create relationships between tables

A key that is used for indexing purposes

Create a free account and access millions of resources

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?