IntroToDatabases W2

IntroToDatabases W2

University

12 Qs

quiz-placeholder

Similar activities

ADVACOMT-Quiz No.1 (final term)

ADVACOMT-Quiz No.1 (final term)

University

15 Qs

Què en saps de GSuite?

Què en saps de GSuite?

University - Professional Development

10 Qs

Firewall and Network Security

Firewall and Network Security

University

15 Qs

Soal SKD

Soal SKD

University - Professional Development

10 Qs

Week 4

Week 4

University

15 Qs

4.6.4 Logic Gates

4.6.4 Logic Gates

10th Grade - Professional Development

15 Qs

Software Engineering :TEST 2

Software Engineering :TEST 2

University

10 Qs

Dasar-Dasar Komputer - PPW23

Dasar-Dasar Komputer - PPW23

University

15 Qs

IntroToDatabases W2

IntroToDatabases W2

Assessment

Quiz

Computers

University

Practice Problem

Medium

Created by

Piotr B

Used 7+ times

FREE Resource

AI

Enhance your content in a minute

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

12 questions

Show all answers

1.

MULTIPLE CHOICE QUESTION

45 sec • 1 pt

With SQL, how do you select all the columns from a table named "Persons"?

SELECT [all] FROM Persons

SELECT Persons

SELECT * FROM Persons

SELECT Persons From Persons

2.

MULTIPLE CHOICE QUESTION

45 sec • 1 pt

What does SQL stand for?

Structured Query Language

Strong Question Language

Structured Question Language

Strong Query Language

3.

MULTIPLE CHOICE QUESTION

45 sec • 1 pt

What is SQLite?

A type of SQL database management system

A language to access data stored in a relation database

A programming language for creating data systems

A language to access data stored in a non-relation database

4.

MULTIPLE CHOICE QUESTION

45 sec • 1 pt

Which operator is used to select values within a range?

WITHIN

RANGE

ORDER BY

BETWEEN

5.

MULTIPLE CHOICE QUESTION

45 sec • 1 pt

With SQL, how do you select a column named "FirstName" from a table named "Persons"?

SELECT FirstName FROM Persons

SELECT Persons.FirstName

SELECT Persons Where FirstName

SELECT Persons From FirstName

6.

MULTIPLE CHOICE QUESTION

45 sec • 1 pt

Which SQL statement would return the 'Null' values?

WHERE Address IS NULL

WHERE Address IS NOT NULL

WHERE Address = NULL

For Each Entry; IF value = 'Null': Selection.append(entry) Return Selection

7.

MULTIPLE CHOICE QUESTION

45 sec • 1 pt

With SQL, how do you select all the records from a table named "Persons" where the "FirstName" is "Peter" and the "LastName" is "Jackson"?

SELECT * FROM Persons WHERE FirstName='Peter' AND LastName='Jackson'

SELECT * FROM Persons WHERE FirstName<>'Peter' AND LastName<>'Jackson'

SELECT FirstName='Peter', LastName='Jackson' FROM Persons

SELECT*FROM Persons WHERE FirstName='Peter' OR LastName='Jackson'

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?