Database Query Quiz

What is the purpose of a query in a database?

• To define the fields in a database

• To create a database structure

• To get information out of your database

• To determine relationships between tables

Do most databases require knowledge of SQL to perform a query?

• Yes, all databases require SQL knowledge

• No, they provide a function to translate your query

• Yes, but only for complex queries

• No, queries are not used in most databases

What is a query in the context of database languages like SQL?

• A command to modify the structure of a database

• A request for information from a database using pre-defined commands

• A method to delete records from a database

• A protocol for securing database transactions

Which SQL command is used to retrieve all the tables that are part of a database?

• SELECT *

• UPDATE TABLES

• SHOW TABLES

• DELETE FROM

What does the SQL command "SELECT * WHERE name != 'Bob'" do?

• It selects all records where the name field equals 'Bob'

• It deletes all records where the name field does not equal 'Bob'

• It selects all records where the name field does not equal 'Bob'

• It updates all records to change the name field to 'Bob'

What is the result of chaining the commands "SELECT * WHERE name != 'Bob'" and "AND age = '34'"?

• It selects all records where the name is not 'Bob' or the age is 34

• It selects all records where the name is 'Bob' and the age is not 34

• It selects all records where the name is not 'Bob' and the age is 34

• It deletes all records where the name is not 'Bob' and the age is 34

Which tab must you move to in order to set up a query in your database?

• Home

• Create

• Design

• External Data

Which tool is easier to use for setting up queries according to the text?

• Query Design

• Form Wizard

• Query Wizard

• Report Wizard

What does the Query Wizard allow you to do?

• Only create a Simple query

• Only create a Find Duplicates query

• Only create a Find Unmatched query

• Inform the database what you are looking for

What type of query does the wizard create when you select the option shown in the image?

• A select query

• A delete query

• An update query

• A create table query