Database final

What is MySQL?

• All the options are correct     

• A relational database management system

• Cross-platform, open-source and free

• Developed, distributed, and supported by Oracle Corporation

What does SQL stand for?

• a.     Strong Question Language

• a.     Structured Question Language

• a.     Structured Query Language

• a.     Systematic Query language  

What is the primary purpose of a primary key in a MySQL table?

• Allowing duplicate values

• a.    Ensuring data uniqueness

• a.    Storing large amounts of data

• a.    None of the above

Answer explanation

  How do you define a primary key when creating a table?

• a.    PRIMARY KEY

• a.    KEY

• a.    UNIQUE

• a.    INDEX

What is the main function of a foreign key in MySQL?

• a.    Ensuring data uniqueness

• Linking two tables together

• Storing large amounts of data

• None of the above

How do you establish a foreign key relationship between two tables?

• FOREIGN KEY

• LINK KEY

• CONNECT KEY

• RELATE KEY

In MySQL, filter out unwanted groups?

• Having

• Where

• Group by

• Group by

What will be installed first during installing the Sakila database?

• Schema

• Data

• Table

• Order doesn’t matter

mysql -u root -p; What -u stands for?

• User

• Unique

• Update

• Utilize

mysql -u root -p; What -p stands for?

• Process

• Prompt

• Password

• Permission