Database Management and SQL Quiz

Which command is used to drop a table in a database management system like MySQL?

• CREATE TABLE

• ALTER

• DROP

• INSERT

Which command is used to create a table in a database management system like MySQL?

• DROP

• ALTER

• INSERT

• CREATE TABLE

What are the three major models mentioned in the text?

• Optimization, linear regression, and time series analysis.

• Decision modeling, linear regression, and time series analysis.

• Optimization analysis, decision modeling, and linear regression.

• Objective variable, decision variables, and objective function.

How does optimization analysis differ from other linear models?

• By using objective variable, decision variables, objective function, and constraints.

• By using linear regression analysis and time series analysis.

• By using major models such as optimization, linear regression, and time series analysis.

• By using objective variable, decision variables, linear regression, and time series analysis.

How does decision modeling differ from other linear models?

• By using major models such as optimization, linear regression, and time series analysis.

• By using objective variable, decision variables, objective function, and constraints.

• By using linear regression analysis and time series analysis.

• By using objective variable, decision variables, linear regression, and time series analysis.

What is the purpose of using VIEWS in SQL?

• To retrieve data from a database management system.

• To implement database prototypes in MySQL.

• To perform simple data analysis in a database management system.

• To transform ERD to relational tables.

Which command is used to alter a table in a database management system like MySQL?

• CREATE TABLE

• DROP

• ALTER

• INSERT

Which SQL command is used to set constraints such as PRIMARY KEY and FOREIGN KEY?

• DROP

• ALTER

• INSERT

• CREATE TABLE

What are the two main purposes of using SQL in a database management system?

• To retrieve data and perform simple data analysis.

• To create tables and set constraints.

• To transform ERD to relational tables and implement database prototypes.

• To critically review reports by technical specialists and solve business problems.

What is the purpose of using subquery, GROUP BY, HAVING, VIEWS, and conditional testing in SQL?

• To retrieve data from a database management system.

• To implement database prototypes in MySQL.

• To perform simple data analysis in a database management system.

• To transform ERD to relational tables.