How would you display all those rows from a table named "Friends" where the value of the column "Hobbies" is "SWIMMING"

SELECT * FROM Friends WHERE Hobbies='SWIMMING';

SELECT ALL FROM Friends WHERE Hobbies IS 'SWIMMING';

SELECT * FROM Friends WHERE Hobbies = 'Swimming" ;

SELECT ALL FROM Friends WHERE Hobbies 'SWIMMING' ;

How do you select all the rows from a table named "Student" where the value of the column "FName" starts with "G"?

SELECT * FROM Student WHERE FName LIKE 'G%' ;

SELECT * FROM Student WHERE FName LIKE 'G_' ;

SELECT * FROM Student WHERE FName='G';

SELECT * WHERE Student WHERE FName='%G%' ;

How would you return all the rows from a table named "Item" sorted in descending order on the column "IName"?

SELECT * FROM Item ORDER BY IName DESC ;

SELECT * FROM Item SORT 'IName' DESC;

SELECT * FROM Item ORDER IName DESC ;

SELECT * FROM Item SORT BY 'IName' DESC ;

Which statement is appropriate to change the first name "Madhur" to "Mridul" in the "FName" column in the 'Student' table?

UPDATE Student SET FName='Mridul' WHERE FName='Madhur' ;

MODIFY Student SET FName='Madhur' INTO FName='Mridul ;

UPDATE Student SET FName='Madhur' INTO FName='Mridul' ;

UPDATE Student SET FName='Madhur' WHERE FName='Mridul' ;

How can you delete the rows with marks below 33 in the 'Student' Table?

DELETE FROM Student WHERE marks<33

DELETE FROM Student WHERE marks <=33;

DELETE marks < 33 FROM Student ;

DELETE ROW marks<33 From Student

Any String function returns

String, number or date type data.

MYSQL Test-1

Authored by Shashank Dwivedi

Computers

11th - 12th Grade

Used 43+ times

AI Actions

Add similar questions

Adjust reading levels

Convert to real-world scenario

Translate activity

More...

Content View
Student View

30 questions

Show all answers

MULTIPLE CHOICE QUESTION

10 sec • 1 pt

A relation can have only one ________.

Primary Key

Alternate Key

Unique key

Foreign Key

MULTIPLE CHOICE QUESTION

10 sec • 1 pt

The vertical subset of a table is known as:

Tuple

Row

Attribute

Relation

MULTIPLE CHOICE QUESTION

10 sec • 1 pt

If software is released under open source, it means:

Its source code is available to the user.

It belongs to a company.

It is expensive.

It is a DBMS.

MULTIPLE CHOICE QUESTION

10 sec • 1 pt

A field or a combination of fields in a table that has a unique value for each row is called:

Candidate key.

Foreign key.

Main key.

Alternate key.

MULTIPLE CHOICE QUESTION

10 sec • 1 pt

Which statement is used to extract data from a table?

SELECT

DISPLAY

EXTRACT

READ

MULTIPLE CHOICE QUESTION

10 sec • 1 pt

How do you select all the columns from a table named "Employee"?

SELECT [all] FROM Employee;

SELECT * FROM Employee ;

SELECT Employee;

SELECT * BY Employee;

MULTIPLE CHOICE QUESTION

10 sec • 1 pt

Which of the following are valid column names?

Marks Eng

66_Marks

Marks_Eng

#Eng_Marks

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 Microsoft

or continue with

Facebook

Apple

Others

By signing up, you agree to our Terms of Service & Privacy Policy

Already have an account?

Similar Resources on Wayground

25 questions

Lesson 1_Getting to Know the Work Area (Adobe Photoshop)

Quiz

•

9th - 12th Grade

25 questions

TIK01

Quiz

•

12th Grade

27 questions

Java Swing/AWT Graphics

Quiz

•

9th - 12th Grade

31 questions

Excel Skills Review

Quiz

•

KG - University

25 questions

Kiểm tra giữa HKII - Tin học 11

Quiz

•

11th Grade

25 questions

ANIMASI 2D PAS GANJIL KISI-KISI 2023

Quiz

•

11th Grade

25 questions

TAD Quiz SAS

Quiz

•

11th Grade

26 questions

Cam Techs IT Unit 2 - Legislation

Quiz

•

12th Grade

Popular Resources on Wayground

10 questions

Safety Day 2026 – Student Review

Quiz

•

9th Grade

21 questions

Continents and Oceans

Quiz

•

6th Grade

20 questions

Parts of Speech

Quiz

•

5th Grade

16 questions

Subject & Predicate

Quiz

•

5th Grade

25 questions

Multiplication Facts

Quiz

•

5th Grade

12 questions

Map Skills

Quiz

•

3rd Grade

22 questions

Continents and Oceans

Quiz

•

5th Grade

15 questions

Rounding Decimals

Quiz

•

5th Grade

Discover more resources for Computers

32 questions

Unit 3: Intro to App Design (APCSP 22-23, Code.org)

Quiz

•

9th - 12th Grade

15 questions

AP CSP - Code.org Unit 3 Review

Quiz

•

9th - 12th Grade

40 questions

Introduction to Microsoft Word

Quiz

•

8th - 12th Grade

MYSQL Test-1

A relation can have only one ________.

The vertical subset of a table is known as:

If software is released under open source, it means:

A field or a combination of fields in a table that has a unique value for each row is called:

Which statement is used to extract data from a table?

How do you select all the columns from a table named "Employee"?

Which of the following are valid column names?

Which statement is used to insert new data in a table?

How would you display all those rows from a table named "Friends" where the value of the column "Hobbies" is "SWIMMING"

Which statement is used to modify data in a table?

Access all questions and much more by creating a free account

Similar Resources on Wayground

Popular Resources on Wayground

Discover more resources for Computers