Databases Fundamental Quiz 1

In which situation do you need to perform a restore on a database?

• when data becomes corrupted in the database
• when you need to roll back a transaction
• when you encounter an error in your application
• when data needs to be deleted from the database

Which command should you use to give a user permission to read the data in a table?

• ALLOW SELECT
• LET READ
• PERMIT READ
• GRANT SELECT

Which keyword can be used in a create table statement?

• ORDER BY
• DISTINCT
• GROUP BY
• UNIQUE

You need to store product quantities, and you want to minimize the amount of storage space that is used. Which data type should you use?

• INTEGER
• DOUBLE
• COUNT
• FLOAT

Which statement will result in the creation of an index?

• Option A
• Option B
• Option C
• Option D

You have the following table definition: CREATE TABLE Road (RoadID INTEGER NOT NULL, Distance INTEGER NOT NULL) The Road table contains the following data: You execute the following statement: INSERT INTO Road VALUES (1234, 36) What is the result?

• an error stating that NULL values are not allowed
• a new row in the table
• an error stating that duplicate IDs are not allowed
• a syntax error

One reason to create a stored procedure is to:

• Improve performance.
• Minimize storage space.
• Bypass case sensitivity requirements.
• Give the user control of the query logic.

Which permission does a user need in order to run a stored procedure?

• EXECUTE
• ALLOW
• CALL
• RUN

You have a table named Product. You create a view that includes all the products from the Product table that are in the Furniture category. You execute a statement on the Product table that deletes all the products in the Furniture category. After you execute the statement, the result set of the view is:

• Empty
• Deleted
• Unchanged
• Archived

You have two tables. Each table has three rows. How many rows will be included in the Cartesian product of these two tables?

• 1
• 3
• 6
• 9