Master SQL Query Keywords

Play an AI-generated podcast conversation about this lesson

Which database model is based on a tabular data structure and was published by E.F. Codd in 1970?

Relational model (correct)
MySQL Server
MySQL Enterprise
MySQL Workbench

Which database system instance is a single executing copy of a database system?

Database system instance (correct)
DatabaseName
MySQL Server
Database model

Which high-level computer language is used for storing, manipulating, and retrieving data?

MySQL Enterprise
MySQL Community
Relational algebra
Structured Query Language (correct)

Which SQL command is used to create a new database?

CREATE DATABASE (D) Signup and view all the answers

Which of the following statements about data is true?

Data is encoded as zeros and ones in digital format. (A) Signup and view all the answers

What is the role of a database administrator?

To enforce procedures for user access and database system availability (D) Signup and view all the answers

What is the purpose of a query language in a database system?

To read and write data in a database (A) Signup and view all the answers

Which keyword is used to perform case-sensitive pattern matching with the LIKE operator?

BINARY (A) Signup and view all the answers

Which aggregate function counts the number of rows in a set?

COUNT() (A) Signup and view all the answers

Which join clause selects all left table rows, but only matching right table rows?

LEFT JOIN (D) Signup and view all the answers

Which keyword is used to create an alias for a column or table?

AS (A) Signup and view all the answers

Which of the following is true about a materialized view?

A materialized view is a view for which data is stored at all times. (A) Signup and view all the answers

What happens when the WITH CHECK OPTION is specified for a view?

The database rejects inserts and updates that do not satisfy the view query WHERE clause. (A) Signup and view all the answers

What is the purpose of the select operation in relational algebra?

The select operation selects rows from a table. (D) Signup and view all the answers

Which keyword is used to specify the column values to be added in an INSERT statement?

VALUES (C) Signup and view all the answers

What does the PRIMARY KEY constraint ensure in a CREATE TABLE statement?

Uniqueness and non-nullability of a column or group of columns (A) Signup and view all the answers

What is a foreign key?

A column or group of columns that refer to a primary key (A) Signup and view all the answers

Which clause is used to specify actions to be taken when a primary key is updated or deleted?

CASCADE (A) Signup and view all the answers

Which statement is true about the CREATE TABLE statement?

The CREATE TABLE statement creates a new table by specifying the table name, column names, and column data types. (B) Signup and view all the answers

Which data type represents numbers with fractional values?

Decimal (B) Signup and view all the answers

What is the purpose of the SELECT statement?

To select rows from a table. (D) Signup and view all the answers

What does the IS NULL operator do?

Returns TRUE when the value is NULL. (B) Signup and view all the answers

Which one of the following is true about a database user?

A database user is a consumer of data in a database. (B) Signup and view all the answers

Which one of the following statements about a transaction is true?

A transaction is a group of queries that must be either completed or rejected as a whole. (A) Signup and view all the answers

Which one of the following is true about a relational database?

A relational database stores data in tables, columns, and rows, similar to a spreadsheet. (D) Signup and view all the answers

Which one of the following is true about SQL?

SQL stands for 'Structured Query Language' and is the standard query language of relational database systems. (D) Signup and view all the answers