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

Which statement shows a list of table column names and settings?

Answer :
  • DESCRIBE table_name

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

Answer :
  • TRUE

Poorly designed table structures result in duplicate data, redundant data, and difficulty using the data.

Answer :
  • TRUE