NEW
Font size
WorksheetsREVIEWER 1-23
Total questions: 28
Worksheet time: 14mins
Cohort
Relationally dependent
Deterministic
Functionally dependent
Compositional
Which key uniquely identifies a row in a table?
Foreign
Local
Primary
Superkey
Which statement creates a composite key?
Which command should you use to give a user permission to read the in a table?
ALLOW SELECT
LET READ
PERMIT READ
GRANT SELECT
You need to enable a new employee to authenticate to your database. Which command should you use?
Allow user
Create user
Add user
Insert User
Alter User
Which keyword can be used in a CREATE TABLE statement?
ORDER BY
DISTINCT
GROUP BY
UNIQUE
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
You need to store product names that vary from three to 30 characters. You also need to minimize the amount of storage space that is used. Which data type should you use?
VARCHAR(3, 30)
CHAR (3, 30)
VARCHAR (30)
CHAR (30)
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 are writing an SQL statement to retrieve rows from a table. Which data manipulation language (DML) command should you use?
READ
SELECT
OUTPUT
GET
Which constraint ensures a unique value in the ID column for each customer?
DISTINCT
FOREIGN KEY
SEQUENTIAL
PRIMARY KEY
The component that holds information for a single entry in a table is called a;
Data type
Row
Column
View
0
1
2
3
4
You are writing a select statement to find every product whose name contains a specific character. Which keyword should you use in your where clause?
FIND
BETWEEN
INCLUDES
LIKE
The first order for CustomerID 209 is deleted from the Order table.
All orders for CustomerID 209 are deleted from the Order table, and CustomerID 209 is deleted from the Customer table.
All orders for CustomerID 209 are deleted from the Order table.
CustomerID 209 is deleted from the Customer table
You need to populate a table named EmployeeCopy with data from an existing table name Employee. Which Statement should you use?
Subquery
Union
Outer join
Cartesian product
Which keyword would you use in a select statement to return rows that meet a specific condition?
WHERE
UNION
ORDER BY
FROM
1
2
3
4
Which command should you use to remove a table from a database?
REMOVE TABLE
UPDATE TABLE
DROP TABLE
DELETE TABLE
Complete join
Partial join
Inner join
Outer join
Data in a database is stored in:
Tables
Queries
Data types
Stored procedures
All rows in the table will be deleted
All rows containing a NULL value in the FirstName column will be deleted
You will receive an error message
All rows and the table definition will be deleted
You need to establish a set of permissions that you can routinely assign to new users. What should you create?
Resource
Group
List
Role
Which database term is used to describe the process of applying a backup to a damaged or corrupt datebase?
Recover
Restore
Commit
Attach
You need to disable User1's access to view the data in the Customer table. Which statement should you use?
