The following is true about SQL

SQL usually runs on top of another language

It has loops just like any other language

SQL is hard to read due to a lot of abbreviated keywords

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 [all] FROM Persons WHERE FirstName LIKE 'Peter'

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

SELECT * FROM Persons WHERE FirstName<>Peter

The LIKE operator is used to

To use partial matching when searching

Approve SQL statements before execution

When we deal with Boolean fields

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 LIKE '%a'

SELECT * FROM Persons WHERE FirstName = '%a%'

SELECT * FROM Persons WHERE FirstName='a'

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 LastName>'Hansen' AND LastName<'Pettersen' FROM Persons

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

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

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

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

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

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

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

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

Nested SELECT queries are used

When retrieving data from multiple tables

When Boolean operators get too complex

For validation and quality control

2.2 SQL & Records

Authored by Alice Adlam

others

Used 3+ times

AI Actions

Add similar questions

Adjust reading levels

Convert to real-world scenario

Translate activity

More...

Content View

Student View

25 questions

Show all answers

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What does SQL stand for

Structures Question Language

Strong Question Language

Structured Query Language

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

A record is....

A table is simply a collection of data that relates to a person or object (often referred to as an entity (e.g. students))

A collection of data about a single entity (e.g. a student)

A unique piece of data about an entity (student surnames)

An identifier for the single piece of data (e.g. ‘surnames’)

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

A field name is....

A table is simply a collection of data that relates to a person or object (often referred to as an entity (e.g. students))

A collection of data about a single entity (e.g. a student)

A unique piece of data about an entity (student surnames)

An identifier for the single piece of data (e.g. ‘surnames’)

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

A field is....

A table is simply a collection of data that relates to a person or object (often referred to as an entity (e.g. students))

A collection of data about a single entity (e.g. a student)

A unique piece of data about an entity (student surnames)

An identifier for the single piece of data (e.g. ‘surnames’)

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

A table is....

A table is simply a collection of data that relates to a person or object (often referred to as an entity (e.g. students))

A collection of data about a single entity (e.g. a student)

A unique piece of data about an entity (student surnames)

An identifier for the single piece of data (e.g. ‘surnames’)

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

In Record structures, VARCHAR keyword means

A field can be any number of characters or bytes in length

A field can be up to a certain number of characters or bytes in length

A field is an integer

The name of the field is about to be changed

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

The following is true about Records

They must have an index

Fields are made up of records

Records can combine multiple data types in their fields

Record arrays are 2D arrays

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

27 questions

Grammar 5 Entrance Test

Quiz

•

KG - University

20 questions

UH TIKOM 9

Quiz

•

KG - University

20 questions

End of 9 Weeks Test

Quiz

•

KG - University

20 questions

CH07 INTERNET, WEBSITE

Quiz

•

University

20 questions

MAJOR SUMMATIVE 1: INTRO

Quiz

•

10th Grade

23 questions

ทบทวนเนื้อหา True P.6 68

Quiz

•

6th Grade

25 questions

Final Exam: Part 1 Review

Quiz

•

9th - 12th Grade

25 questions

Infinitive/ The -ing form

Quiz

•

KG - 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 others

4 questions

Conflict Resolution

Lesson

•

20 questions

Place Value

Quiz

•

KG - 3rd Grade

20 questions

CVC Words

Quiz

•

KG - 1st Grade

24 questions

CKLA Unit 5 assessment K

Quiz

•

10 questions

STAAR Review - Editing & Revising Clusters

Quiz

•

10 questions

Reflexive Pronouns

Quiz

•

KG - 5th Grade

10 questions

Long i- igh, ie, and y Quiz

Quiz

•

KG - 3rd Grade

12 questions

Quarter Past, Half Past, and Quarter To

Quiz

•

KG - 12th Grade

2.2 SQL & Records

What does SQL stand for

A record is....

A field name is....

A field is....

A table is....

In Record structures, VARCHAR keyword means

The following is true about Records

SQL is used to work with files in this format

The following is true about SQL

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

Access all questions and much more by creating a free account

Similar Resources on Wayground

Popular Resources on Wayground

Discover more resources for others