Search Header Logo

IntroToDatabases W2

Authored by Piotr B

Computers

University

Used 7+ times

IntroToDatabases W2
AI

AI Actions

Add similar questions

Adjust reading levels

Convert to real-world scenario

Translate activity

More...

    Content View

    Student View

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'

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?

Discover more resources for Computers