Computer Science Quiz: SQL and Records
Instructions
Please read each question carefully and choose the best answer where applicable. Each question is based on a visual description provided in curly brackets.
- The image of a database table with columns labeled "ID", "Name", "Age", and "Email". The rows contain data entries for different users.
What is the primary purpose of this database table?
- A. To store user information
- B. To display user information on websites
- C. To delete user data
- D. To modify programming languages
- The image of an SQL command typed into a command-line interface. The command reads "SELECT Name FROM Users WHERE Age > 18;"
What does this SQL command do?
- A. It selects all users regardless of age.
- B. It selects names of users older than 18 years.
- C. It deletes users younger than 18.
- D. It updates the age of all users.
- The image of an error message in a database management system. The message reads "Syntax Error near 'FROM'".
What does this error indicate about the SQL query that was executed?
- A. It ran successfully.
- B. There was a typo in the query.
- C. The database is full.
- D. The user does not have access.
- The image of a flowchart illustrating the process of inserting a new record into a database. The steps include: "Connect to Database", "Prepare SQL Statement", "Execute SQL Statement", "Close Connection".
What is the first step in inserting a new record?
- A. Prepare SQL Statement
- B. Execute SQL Statement
- C. Connect to Database
- D. Close Connection
- The image of a database schema diagram showing relationships between tables "Users", "Orders", and "Products". Arrows indicate the relationships.
What does the diagram primarily represent?
- A. Data types of each table
- B. Record duplication in the database
- C. Relationships between different tables in the database
- D. A list of all users
- The image of a screen displaying a list of SQL queries. The queries include "UPDATE Users SET Age = 20 WHERE ID = 1;".
What type of query is this?
- A. SELECT Query
- B. INSERT Query
- C. UPDATE Query
- D. DELETE Query
- The image of a locked padlock symbol next to a database.
What does the locked padlock symbol signify in relation to the database?
- A. The database is in use
- B. The database is secure and protected
- C. The database has no records
- D. The database can be modified by anyone
- The image of a data entry screen with fields for "Product Name", "Price", and "Stock".
What type of data entry is being represented?
- A. User Record Entry
- B. Order Record Entry
- C. Product Record Entry
- D. Transaction Record Entry
- The image of an SQL JOIN operation illustrated between two tables: "Customers" and "Orders". Arrows indicate data flowing from both tables.
What is the purpose of an SQL JOIN?
- A. To combine rows from two or more tables based on a related column.
- B. To update existing records in a single table.
- C. To delete records from multiple tables.
- D. To create new tables in a database.
- The image of an SQL SELECT statement with its result set displayed. The output shows a table with filtered data.
What can be inferred from the displayed result set?
- A. It shows no results returned.
- B. It displays all records from the table.
- C. It illustrates the effect of a WHERE clause in filtering data.
- D. It represents an error in the SQL syntax.
End of Quiz
Please review your answers and submit when ready. Good luck!