What is the function of a Foreign Key?

To store the primary key of the table

To create a relationship between rows

What is the purpose of the USE command in SQL?

To switch to a different database

To update the schema of a table

What is the purpose of INSERT INTO in SQL?

To insert new data into a table

To update existing data in a table

What does the SHOW TABLES command do in MySQL?

Displays all tables in a database

Displays all columns in a table

Displays all records in a table

What does the COUNT function in SQL do?

Returns the total number of rows

Finds the maximum value in a column

Returns distinct values in a column

What is the purpose of the GROUP BY clause in SQL?

Filters records based on a condition

What does the MAX function return in SQL?

The largest numeric value in a column

The maximum length of text in a column

The highest number of rows in a table

What does DISTINCT do in an SQL query?

Filters records based on conditions

Which SQL command can be used to retrieve only the users who are marked as active? See Projector Screen

SELECT * FROM login_info WHERE status = 'active';

SELECT * FROM login_info WHERE status = 'inactive';

SELECT * FROM login_info WHERE gender = 'male';

SELECT * FROM login_info WHERE status = 'female';

Which of the following will return all female users in the login_info table? See Projector Screen

SELECT * FROM login_info WHERE gender = 'female';

SELECT * FROM login_info WHERE status = 'female';

SELECT * FROM login_info WHERE mobile LIKE 'female';

SELECT gender FROM login_info WHERE gender = 'female';

Which query can be used to update sanjay_k's status to active? See Projector Screen

UPDATE login_info SET status = 'active' WHERE username = 'sanjay_k';

UPDATE status='active' WHERE username='sanjay_k';

UPDATE login_info WHERE username='sanjay_k' SET status='active';

UPDATE login_info status='active' WHERE username='sanjay_k';

How can you delete the record of the user vikas_r?

DELETE FROM login_info WHERE username='vikas_r';

REMOVE FROM login_info WHERE username='vikas_r';

DROP ROW FROM login_info WHERE username='vikas_r';

DELETE vikas_r FROM login_info;

Which SQL command will display all users sorted by their date_of_birth in ascending order? See Projector Screen

SELECT * FROM login_info ORDER BY date_of_birth ASC;

SELECT * FROM login_info ORDER BY date_of_birth DESC;

SELECT * FROM login_info GROUP BY date_of_birth;

SELECT * FROM login_info WHERE date_of_birth ASC;

MySql Basics

Authored by Rion Daneal

Computers

Professional Development

Used 9+ times

AI Actions

Add similar questions

Adjust reading levels

Convert to real-world scenario

Translate activity

More...

Content View
Student View

45 questions

Show all answers

MULTIPLE CHOICE QUESTION

45 sec • 1 pt

What does RDBMS stand for?

Relational Database Management System

Random Database Management System

Relational Data Managed Storage

Random Data Managed Structure

MULTIPLE CHOICE QUESTION

45 sec • 1 pt

Which of the following is a relational database?

MongoDB

MySQL

Redis

Cassandra

MULTIPLE CHOICE QUESTION

45 sec • 2 pts

What is a Primary Key in a table?

A column with duplicate values

A column that uniquely identifies a row

A foreign key from another table

A column with null values

MULTIPLE CHOICE QUESTION

45 sec • 1 pt

What does SQL stand for?

Structured Query Language

Standard Query Logic

Simple Query Language

Sequential Query Logic

MULTIPLE CHOICE QUESTION

45 sec • 1 pt

Which SQL command is used to create a new database?

CREATE TABLE

CREATE DATABASE

CREATE SCHEMA

CREATE RECORD

MULTIPLE CHOICE QUESTION

45 sec • 2 pts

Which of the following is NOT an RDBMS?

MySQL

PostgreSQL

Oracle

MongoDB

MULTIPLE CHOICE QUESTION

45 sec • 1 pt

In a relational database, data is organized in...

Graphs

Tables

Trees

Lists

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

50 questions

ACTIVE DIRECTORY

Quiz

•

University - Professi...

43 questions

[AZ-900] Simulado #01

Quiz

•

Professional Development

40 questions

US TIK 2021

Quiz

•

Professional Development

40 questions

420-906-LA

Quiz

•

Professional Development

43 questions

Pemrograman_Dasar

Quiz

•

Professional Development

50 questions

CUESTIONARIO DE REPASO DE PUESTA EN PRODUCCIÓN SEGURA

Quiz

•

Professional Development

40 questions

Applications of DMS in A.I AND GATE/JNTUH/NPTEL/PLACEMENTS probl

Quiz

•

Professional Development

40 questions

AI900-01

Quiz

•

Professional Development

Popular Resources on Wayground

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

20 questions

Brand Labels

Quiz

•

5th - 12th Grade

Discover more resources for Computers

10 questions

How to Email your Teacher

Quiz

•

Professional Development

40 questions

Flags of the World

Quiz

•

KG - Professional Dev...

4 questions

Exit ticket for the end of class: Spotlight

Quiz

•

KG - Professional Dev...

20 questions

90s Cartoons

Quiz

•

Professional Development

20 questions

Block Buster Movies

Quiz

•

10th Grade - Professi...

10 questions

How to Email your Teacher

Quiz

•

Professional Development

MySql Basics

What does RDBMS stand for?

Which of the following is a relational database?

What is a Primary Key in a table?

What does SQL stand for?

Which SQL command is used to create a new database?

Which of the following is NOT an RDBMS?

In a relational database, data is organized in...

What is the function of a Foreign Key?

Which of the following commands is used to delete a database?

Which SQL command is used to retrieve 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 Computers