Go on. Explore!

lvl 0 • 0 xp

lvl 1

Home Market Decks Interests

SQL - Structured Query Language

memorize.ai (lvl 286)

(0)

24 cards

()

Section 1

Preview this deck

SELECT * FROM Persons

Front

1 / 24

SQL

0.0

0 reviews

5			0
4			0
3			0
2			0
1			0

Active users

All-time users

Favorites

Last updated

6 years ago

Date created

Mar 1, 2020

Cards (24)

Section 1

(24 cards)

SELECT * FROM Persons

Front

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

Back

SELECT * FROM Persons ORDER BY FirstName DESC

Front

With SQL, how can you return all the records from a table named "Persons" sorted descending by "FirstName"?

Back

ORDER BY

Front

This SQL keyword is used to sort the result-set in ascending or descending order

Back

INSERT INTO

Front

Which SQL statement is used to insert new data in a database?

Back

SELECT FirstName FROM Persons

Front

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

Back

WHERE

Front

This SQL clause is used to extract only database records that fulfull a specified condition. Answer is 1 word

Back

SQL

Front

This is the standard language for storing, manipulating and retrieving data in databases

Back

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

Front

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

Back

SELECT * FROM Persons WHERE FirstName='Peter'

Front

With SQL, how do you select all the records from a table named "Persons" where the value of the column "FirstName" is "Peter"?

Back

NOT

Front

This operator operator displays a record if the condition(s) is false

Back

;

Front

What does a SQL statement end with? Don't spell it out

Back

tbl

Front

According to your instructor's examples, what 3 letters should be at the beginning of every table name?

Back

result set

Front

This is the name of the set of records that are returned by a querry. Answer is 2 words

Back

column

Front

What is another name for a database table field?

Back

record

Front

What is another name for a database table row?

Back

AND

Front

This operator displays a record if ALL the conditions separated by it are true

Back

INNER JOIN

Front

This type of join selects records that have matching values in two tables. Answer is 2 words

Back

ORDER BY

Front

Which SQL keyword is used to sort the result-set?

Back

OR

Front

This operator displays a record if ANY of the conditions separated by it are true

Back

SELECT

Front

Which SQL statement is used to extract data from a database?

Back

True

Front

True or False: The OR operator displays a record if ANY conditions listed are true. The AND operator displays a record if ALL of the conditions listed are true

Back

INSERT INTO

Front

This statement is used to add new records in a table. Answer is 2 words

Back

Structured Query Language

Front

What is SQL the acronym for?

Back

SELECT DISTINCT

Front

Which SQL statement is used to return only 1 of each value, even if there are duplicates?

Back