Database Final Exam

What is MySQL?

• A relational database management system

• Cross-platform, open-source and free

• Developed, distributed, and supported by Oracle Corporation

• All the options are correct

What does SQL stand for?

• Strong Question Language

• Structured Question Language

• Structured Query Language

• Systematic Query language

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

• Allowing duplicate values

• Ensuring data uniqueness

• Storing large amounts of data

• None of the above

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

• PRIMARY KEY

• KEY

• UNIQUE

• INDEX

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

• 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

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

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

• Root directory

• Read-only user

• Superuser/Administrator

• Restricted user