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 FirstName='Peter', LastName='Jackson' FROM Persons

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

With SQL, how do you select all the records from a table named "Persons" where the "LastName" is alphabetically between (and including) "Hansen" and "Pettersen"?

SELECT * FROM Persons WHERE LastName BETWEEN 'Hansen' AND 'Pettersen'

SELECT * FROM Persons WHERE LastName>'Hansen' AND LastName<'Pettersen'

SELECT LastName>'Hansen' AND LastName<'Pettersen' FROM Persons

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

SELECT * FROM Persons ORDER BY FirstName DESC

SELECT * FROM Persons ORDER FirstName DESC

SELECT * FROM Persons SORT BY 'FirstName' DESC

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

SELECT * FROM Persons ORDER BY FirstName DESC

SELECT * FROM Persons ORDER FirstName DESC

SELECT * FROM Persons SORT 'FirstName' DESC

a) SELECT * FROM Persons SORT BY 'FirstName' DESC

With SQL, how can you insert a new record into the "Persons" table?

INSERT INTO Persons VALUES ('Jimmy', 'Jackson')

INSERT ('Jimmy', 'Jackson') INTO Persons

INSERT VALUES ('Jimmy', 'Jackson') INTO Persons

INSERT ('Jimmy', 'Jackson') INTO table Persons

With SQL, how can you insert "Olsen" as the "LastName" in the "Persons" table?

INSERT INTO Persons (LastName) VALUES ('Olsen')

INSERT ('Olsen') INTO Persons (LastName)

INSERT INTO Persons ('Olsen') INTO LastName

INSERT INTO Persons INTO LastName ('Olsen')

How can you change "Hansen" into "Nilsen" in the "LastName" column in the Persons table?

UPDATE Persons SET LastName='Nilsen' WHERE LastName='Hansen'

UPDATE Persons SET LastName='Hansen' INTO LastName='Nilsen'

MODIFY Persons SET LastName='Hansen' INTO LastName='Nilsen

MODIFY Persons SET LastName='Nilsen' WHERE LastName='Hansen'

With SQL, how can you delete the records where the "FirstName" is "Peter" in the Persons Table?

DELETE FROM Persons WHERE FirstName = 'Peter'

DELETE FirstName='Peter' FROM Persons

DELETE ROW FirstName='Peter' FROM Persons

DROP ROW FirstName='Peter' FROM Persons

What result will the following SQL statement give? SELECT Orders.OrderID, Customers.CustomerName FROM Orders RIGHT JOIN Customers ON Orders.CustomerID=Customers:CustomerID;

It will list the names of all Customers and any Orders they have placed.

It will list all the names of Customers

It will list all the Order ID numbers.

It will list all the Order ID numbers and the names of Customers that placed them.

Which one of the following best describes a relational database?

Each entity in an entity-relationship (ER) diagram converts to a table.

Key values must be null before the entity relationship is defined.

Primary keys must be joined in a one to many entity relationship.

Entities are defined by a list of unique attributes

Which one of the following segments of SQL code adds a new column for startdate to the courses table?

ALTER TABLE courses ADD (startdate DATE)

INSERT startdate INTO TABLE courses

ALTER TABLE courses ADD (startdate (DATE))

INSERT INTO TABLE courses (startdate)

What best describes a data dictionary?

A set of files that contain the metadata for a database.

A definition of the relationships used in a database.

A set of SQL statements to create a database.

A glossary of terms used in the database structure.

Database

University

•

30 Qs

Similar activities

1.4 and 1.5

1st Grade - Professional Development

•

25 Qs

Css-BoxModel

University

•

25 Qs

Quiz Bootstrap (Fullstack Praktikum)

University

•

25 Qs

Module 3 - Security Architecture

University

•

25 Qs

Operating system

7th Grade - University

•

25 Qs

Solutions. Test on un5 (Techn, modal perfect,quantifiers)

9th Grade - University

•

25 Qs

Metro 1

University

•

25 Qs

soal semester 1 kelas 8

7th Grade - University

•

25 Qs

Database

Quiz

•

Computers

•

University

•

Practice Problem

•

Medium

Used 31+ times

FREE Resource

30 questions

Show all answers

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What does SQL stand for?

Structured Question Language

Strong Question Language

Structured Query Language

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

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

OPEN

SELECT

EXTRACT

MULTIPLE CHOICE QUESTION

45 sec • 1 pt

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

SELECT Persons.FirstName

EXTRACT FirstName FROM Persons

SELECT FirstName FROM Persons

MULTIPLE CHOICE QUESTION

1 min • 1 pt

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

SELECT Persons

SELECT *.Persons

SELECT * FROM Persons

MULTIPLE CHOICE QUESTION

1 min • 1 pt

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

SELECT * FROM Persons WHERE FirstName<>'Peter'

SELECT * FROM Persons WHERE FirstName='Peter'

SELECT [all] FROM Persons WHERE FirstName='Peter'

MULTIPLE CHOICE QUESTION

45 sec • 1 pt

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

SELECT * FROM Persons WHERE FirstName LIKE 'a%'

SELECT * FROM Persons WHERE FirstName='a'

SELECT * FROM Persons WHERE FirstName LIKE '%a'

MULTIPLE CHOICE QUESTION

45 sec • 1 pt

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

True

False

Access all questions and much more by creating a free account

Create resources

Host any resource

Get auto-graded reports

Continue with Google

Continue with Email

Continue with Classlink

Continue with Clever

or continue with

Microsoft

Apple

Others

Already have an account?

Similar Resources on Wayground

26 questions

DP-900 pt 1

Quiz

•

University

25 questions

Chapter 10: Customer Relationship Management

Quiz

•

University

25 questions

Cellular wireless networks

Quiz

•

University

25 questions

ITEC 103 | SLM 1 QUIZ

Quiz

•

University

25 questions

IT 104A Quiz - Module 3

Quiz

•

University

30 questions

Round_1 (B)| Coding Combat 2.0

Quiz

•

University

26 questions

Searching Algorithms

Quiz

•

University

26 questions

Cisco Attacks

Quiz

•

10th Grade - University

Popular Resources on Wayground

15 questions

Fractions on a Number Line

Quiz

•

3rd Grade

20 questions

Equivalent Fractions

Quiz

•

3rd Grade

25 questions

Multiplication Facts

Quiz

•

5th Grade

$fractions$

22 questions

fractions

Quiz

•

3rd Grade

20 questions

Main Idea and Details

Quiz

•

5th Grade

20 questions

Context Clues

Quiz

•

6th Grade

15 questions

Equivalent Fractions

Quiz

•

4th Grade

20 questions

Figurative Language Review

Quiz

•

6th Grade

Discover more resources for Computers

30 questions

Quiz 1 Review

Quiz

•

University

Database

30 questions

What does SQL stand for?

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

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

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

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

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

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

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

With SQL, how do you select all the records from a table named "Persons" where the "LastName" is alphabetically between (and including) "Hansen" and "Pettersen"?

Which SQL statement is used to return only different values?

Access all questions and much more by creating a free account

Similar Resources on Wayground

Popular Resources on Wayground

Discover more resources for Computers