MySql Basics

What does RDBMS stand for?

• Relational Database Management System
• Random Database Management System
• Relational Data Managed Storage
• Random Data Managed Structure

Which of the following is a relational database?

• MongoDB
• MySQL
• Redis
• Cassandra

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

What does SQL stand for?

• Structured Query Language
• Standard Query Logic
• Simple Query Language
• Sequential Query Logic

Which SQL command is used to create a new database?

• CREATE TABLE
• CREATE DATABASE
• CREATE SCHEMA
• CREATE RECORD

Which of the following is NOT an RDBMS?

• MySQL
• PostgreSQL
• Oracle
• MongoDB

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

• Graphs
• Tables
• Trees
• Lists

What is the function of a Foreign Key?

• To uniquely identify a record
• To link two tables together
• To store the primary key of the table
• To create a relationship between rows

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

• DROP DATABASE
• DELETE DATABASE
• REMOVE DATABASE
• PURGE DATABASE

Which SQL command is used to retrieve data from a database?

• SELECT
• FETCH
• GET
• RETRIEVE