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 5+ 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

Already have an account?

Similar Resources on Wayground

40 questions

AI900-06

Quiz

•

Professional Development

40 questions

QUIZ TIK

Quiz

•

Professional Development

50 questions

Test Mendix 2

Quiz

•

Professional Development

50 questions

CAMBRIDGE - A Level - IT - Networks

Quiz

•

12th Grade - Professi...

46 questions

Unit 18 - Design User Interface

Quiz

•

Professional Development

50 questions

Ethical Hacking

Quiz

•

Professional Development

40 questions

AZ-900 Deployment and Management

Quiz

•

Professional Development

50 questions

Networking Quiz 3

Quiz

•

Professional Development

Popular Resources on Wayground

10 questions

HCS SCI 03 Summer School Review 4

Quiz

•

3rd Grade

11 questions

HSMS - Standard Response Protocol

Quiz

•

6th - 8th Grade

16 questions

1.1-1.2 Quiz Review

Quiz

•

9th - 12th Grade

12 questions

Exponent Expressions

Quiz

•

6th Grade

20 questions

Adding and Subtracting Integers

Quiz

•

6th - 7th Grade

11 questions

Northeast States

Quiz

•

3rd - 4th Grade

10 questions

Characterization

Quiz

•

3rd - 7th Grade

10 questions

Common Denominators

Quiz

•

5th Grade

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