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

Professional Development

•

45 Qs

Similar activities

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

Professional Development

•

40 Qs

AI900-01

Professional Development

•

40 Qs

ACTIVE DIRECTORY

University - Professional Development

•

50 Qs

[AZ-900] Simulado #01

Professional Development

•

43 Qs

Banco de Dados II

Professional Development

•

47 Qs

POSTES_IHT PEMBUATAN MEDIA VIDEO PEMBELAJARAN

1st Grade - Professional Development

•

50 Qs

Computer technology

Professional Development

•

50 Qs

CUESTIONARIO DE REPASO DE PUESTA EN PRODUCCIÓN SEGURA

Professional Development

•

50 Qs

MySql Basics

Quiz

•

Computers

•

Professional Development

•

Practice Problem

•

Hard

Rion Daneal

Used 5+ times

FREE Resource

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

Classification & Regression - 2

Quiz

•

Professional Development

40 questions

ITIL 4-Practice Test 1

Quiz

•

Professional Development

47 questions

AZ-900 MÓDULO 01

Quiz

•

Professional Development

43 questions

[AZ-900] Simulado #02

Quiz

•

Professional Development

50 questions

Test Mendix 3

Quiz

•

Professional Development

50 questions

REDES1

Quiz

•

University - Professi...

50 questions

Reti, internet e servizi

Quiz

•

Professional Development

49 questions

UJIAN DASAR DESAIN GRAFIS

Quiz

•

Professional Development

Popular Resources on Wayground

15 questions

Fractions on a Number Line

Quiz

•

3rd Grade

20 questions

Equivalent Fractions

Quiz

•

3rd Grade

25 questions

Multiplication Facts

Quiz

•

5th Grade

54 questions

Analyzing Line Graphs & Tables

Quiz

•

4th Grade

$fractions$

22 questions

fractions

Quiz

•

3rd Grade

20 questions

Main Idea and Details

Quiz

•

5th Grade

20 questions

Context Clues

Quiz

•

6th Grade

15 questions

Equivalent Fractions

Quiz

•

4th Grade

Discover more resources for Computers

20 questions

Black History Month Trivia Game #1

Quiz

•

Professional Development

100 questions

Screening Test Customer Service

Quiz

•

Professional Development

20 questions

90s Cartoons

Quiz

•

Professional Development

10 questions

Reading a ruler in Inches

Quiz

•

4th Grade - Professio...

16 questions

Parallel, Perpendicular, and Intersecting Lines

Quiz

•

KG - Professional Dev...

12 questions

Valentines Day Trivia

Quiz

•

Professional Development

MySql Basics

45 questions

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