SQL Commands - UPDATE Statements

SQL Commands - UPDATE Statements

Professional Development

10 Qs

quiz-placeholder

Similar activities

PKS Quiz

PKS Quiz

Professional Development

10 Qs

Appreciation of ICT and 3D BIM

Appreciation of ICT and 3D BIM

Professional Development

12 Qs

Advance MS Excel Tips and Tricks

Advance MS Excel Tips and Tricks

Professional Development

10 Qs

SQL

SQL

Professional Development

10 Qs

Fun Facts about AI !

Fun Facts about AI !

Professional Development

12 Qs

SQL Server - Transact SQL e Desenvolvimento [DEV]

SQL Server - Transact SQL e Desenvolvimento [DEV]

Professional Development

11 Qs

Office Integrado

Office Integrado

Professional Development

15 Qs

PL-900 MODULO 4

PL-900 MODULO 4

Professional Development

12 Qs

SQL Commands - UPDATE Statements

SQL Commands - UPDATE Statements

Assessment

Quiz

Computers

Professional Development

Practice Problem

Medium

Created by

JX Chow

Used 6+ times

FREE Resource

AI

Enhance your content in a minute

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

10 questions

Show all answers

1.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Media Image

Order the following Images to create a valid UPDATE statement

1, 2, 3

2, 3, 1

3, 2, 1

3, 1, 2

2.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What is ABC the name of?

UPDATE ABC

SET C1 = “V”

WHERE C2 = “V”

The Database

The User

The Table

The Columns

3.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What do C1 and C2 represent?

UPDATE ABC

SET C1 = “V”

WHERE C2 = “V”

The Database

The User

The Table

The Columns

4.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What is the purpose of line as indicated?

UPDATE ABC

SET C1 = “V” <-

WHERE C1 = “V”

To specify what Column to Update

To specify what Row to Update

To specify what Table to Update

To specify what Database to Update

5.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What is the purpose of line as indicated?

UPDATE ABC

SET C1 = “V”

WHERE C1 = “V” <-

To specify what Column to Update

To specify what Row to Update

To specify what Table to Update

To specify what Database to Update

6.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Media Image

Given the following Table, what will the SELECT statement retrieve after both SQL statements are run?

UPDATE Contacts SET Email = 'james2@home.com'

SELECT Phone FROM Contacts WHERE Name = 'Jane'

Answer explanation

If no WHERE Clause is specified, ALL rows will be updated with the new value

7.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Media Image

Which line in the following Statement has an error

1. UPDATE Contacts

2. SET Emial = 'james2@home.com'

3. WHERE Name = 'Jane'

1

2

3

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?