SQL and Databases Quiz

What does SQL stand for?

• Sequential Query Language

• Simple Query Language

• Standard Query Language

• Structured Query Language

Which of the following is NOT a type of database?

• Relational

• Sequential

• Non-relational

• Hierarchical

What is a schema in the context of databases?

• A programming language

• A database management system

• A collection of database objects

• A type of database

Which SQL constraint ensures that all values in a column are unique?

• NOT NULL

• DEFAULT

• UNIQUE

• PRIMARY KEY

What is the purpose of a PRIMARY KEY in a table?

• To allow NULL values

• To provide a default value

• To uniquely identify each row

• To ensure all values are different

What is the main function of a database management system (DBMS)?

• To create websites

• To write programming code

• To design user interfaces

• To manage and maintain databases

Which of the following is NOT a function of a DBMS?

• Data storage

• Data visualization

• Data backup

• Data security

Which of the following is an example of a relational database management system (RDBMS)?

• Cassandra

• Redis

• MongoDB

• MySQL

What is the role of an editor in working with an RDBMS?

• To design user interfaces

• To manage databases and create SQL queries

• To perform data analysis

• To write programming code

Which tool is mentioned as being used in Railsware Academy studies for SQL?

• Redis

• Oracle

• pgAdmin

• MongoDB