DBMS Quiz

What does DBMS stand for?

• Database Management Software

• Data Binary Management System

• Database Management System

• Data Batch Management Software

Which statement correctly inserts a row into a table named 'cars'?

• ADD INTO cars VALUES ('1', 'Toyota', 'Corolla')

• INSERT INTO cars VALUES ('1', 'Toyota', 'Corolla')

• INSERT cars ('1', 'Toyota', 'Corolla')

• UPDATE cars SET VALUES ('1', 'Toyota', 'Corolla')

What is the primary function of the SQL SELECT statement?

• To update the information in a database

• To insert new data into a table

• To retrieve data from a database

• To delete data from a table

Which of the following is NOT a component of a database management system as described in the slides?

• Files

• Tables

• Rows

• Columns

What is the purpose of the 'WHERE' clause in SQL?

• To specify which database to use

• To set the table for data insertion

• To define conditions for selecting, updating, or deleting data

• To list the databases available

What is the first step to use MySQL in a Python script?

• Write a SQL query

• Install the mysql.connector module

• Create a database

• Generate a cursor object

How do you test if your MySQL connector is installed correctly in Python?

• Run a complex SQL query

• Check the version of the MySQL connector

• Import mysql.connector in your script

• Connect to the MySQL database without username and password

What Python object is primarily used to execute SQL commands?

• Database

• Connector

• Cursor

• Script

Which command in Python checks the established connection to the MySQL database?

• db.status()

• db.test()

• print(db)

• db.connect()

In the context of this lab, what does 'carmax' refer to?

• A Python module

• A variable in a script

• A database

• A table in the database