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 Classlink

Continue with Clever

or continue with

Microsoft

Apple

Others

Already have an account?

Similar Resources on Wayground

40 questions

Motherboards

Quiz

•

Professional Development

47 questions

MS 900 Review Exam

Quiz

•

Professional Development

40 questions

แบบทดสอบคอมพิวเตอร์

Quiz

•

Professional Development

50 questions

Kompetensi Keahlian TKJ

Quiz

•

Professional Development

50 questions

Ujian TIK

Quiz

•

Professional Development

50 questions

TEST ADMIN J&T Express

Quiz

•

Professional Development

40 questions

Data Preprocessing

Quiz

•

Professional Development

50 questions

Test Mendix 4

Quiz

•

Professional Development

Popular Resources on Wayground

10 questions

5.P.1.3 Distance/Time Graphs

Quiz

•

5th Grade

10 questions

Fire Drill

Quiz

•

2nd - 5th Grade

20 questions

Equivalent Fractions

Quiz

•

3rd Grade

22 questions

School Wide Vocab Group 1 Master

Quiz

•

6th - 8th Grade

20 questions

Main Idea and Details

Quiz

•

5th Grade

20 questions

Context Clues

Quiz

•

6th Grade

20 questions

Inferences

Quiz

•

4th Grade

12 questions

What makes Nebraska's government unique?

Quiz

•

4th - 5th Grade

Discover more resources for Computers

16 questions

Parallel, Perpendicular, and Intersecting Lines

Quiz

•

KG - Professional Dev...

20 questions

NCAA Logo Quiz

Quiz

•

Professional Development

20 questions

Easter trivia

Quiz

•

12th Grade - Professi...

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