DMLC

DMLC

Professional Development

12 Qs

quiz-placeholder

Similar activities

Operations Management

Operations Management

Professional Development

15 Qs

Ohana Bible Quiz Lev. 21-27

Ohana Bible Quiz Lev. 21-27

KG - Professional Development

10 Qs

?Riddles for kids?

?Riddles for kids?

3rd Grade - Professional Development

10 Qs

LIVOLUK - Refresher

LIVOLUK - Refresher

Professional Development

14 Qs

Minecraft Quiz

Minecraft Quiz

KG - Professional Development

10 Qs

CASH BOOK

CASH BOOK

Professional Development

10 Qs

Acts 1-3

Acts 1-3

KG - Professional Development

15 Qs

Medicaid Ro Co Remix #2

Medicaid Ro Co Remix #2

Professional Development

11 Qs

DMLC

DMLC

Assessment

Quiz

Other, Other

Professional Development

Practice Problem

Hard

Created by

V Analysts

Used 8+ times

FREE Resource

AI

Enhance your content in a minute

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

12 questions

Show all answers

1.

MULTIPLE CHOICE QUESTION

45 sec • 1 pt

The command to change some records/ rows of a particular column is?

Change command

Update command

modify command

Alter command

2.

MULTIPLE CHOICE QUESTION

45 sec • 1 pt

The query to update a field Designation to “Data Scientist” of all records in a table UserDetails is?

update userdetails set designation = "Data Scientist"

Modify userdetails set designation = "Data Scientist"

Alter userdetails set designation = "Data Scientist"

change userdetails set designation = "Data Scientist"

3.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

The query to update a field Designation to “Data Scientist” of all records having Name = ”Julie” in a table UserDetails is?

update userdetails set designation = "Data Scientist" where Name ="Julie"

update userdetails to designation = "Data Scientist" where Name ="Julie"

modify userdetails set designation = "Data Scientist" change Name ="Julie"

update userdetails set designation = "Data Scientist" change Name ="Julie"

4.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Choose the correct option:

Update command can be used to modify multiple columns at same time

Modify command is used to rename the column name

Update command can be used to modify single column at same time

5.

MULTIPLE SELECT QUESTION

1 min • 1 pt

Lets say we have a table named Users which has fields name, email and phonenumber. Suppose a particular user named “Ashley” has left the portal and we want to remove her record from the table. Which of the following queries will do the required job?

remove user where name is Ashley

delete from users where name ="Ashley"

delete from users where name in ("Ashley")

remove user from users where name in ("Ashley")

6.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What will the command “delete from Users;” do in MySQL

It will ask for which users to delete

it is an incorrect statement it will throw error

It will delete all rows and make table empty

It will delete first row

7.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

The command to permanently remove data from a table is?

Select

Delete

Ampute

Purge

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?