MySQL Fundamentals Ed 1 Quiz Questions and Answers

What does RDBMS stand for?

Answer :
  • Relational Database Management System

An RDBMS organizes and stores data in tables.

Answer :
  • TRUE

An association between database entities is called a ____________ and different categories of these exist.

Answer :
  • Relationship

A one-to-one relationship exists when you associate a single entity with another single entity.

Answer :
  • TRUE

A row in a database table contains a value for each ____________ in the table.

Answer :
  • Column

The set of SQL statements that modify data is called _______.

Answer :
  • Data manipulation language

Identify the benefits of using MySQL:

Answer :
  • All of the above

The ____________ is a candidate key that best defines exactly one unique row.

Answer :
  • Primary key

You use the SHOW DATABASES SQL statement to list the available databases.

Answer :
  • TRUE

The following statement retrieves all the records from the CountryLanguage table: mysql> SELECT * FROM CountryLanguage;

Answer :
  • TRUE