WorksheetsMTA Mga Questions na mali si Justine
Total questions: 22
Worksheet time: 11mins
return large result sets
return a range of values by using the = operator
do not use ORDER BY or GROUP BY clauses
are accessed randomly
are accessed sequentially
are not unique or contain many common values
Use the ALTER statement to add a new table in a database.
No change is needed
UPDATE
INSERT
CREATE
Which keyword can be used in a create table statement?
ORDER BY
DISTINCT
GROUP BY
UNIQUE
You need to create a view to filter rows of data from an underling table.
Which type of clause must be included in the CREATE VIEW statement?
CONSTRAINT
WHERE
JOIN
FILTER
Which command should you use to add a column to an existing table?
A. MODIFY
B. ALTER
C. UPDATE
D. INSERT
E. CHANGE
The PrcducrID column is the primary key. The CategoryID column is a foreign key to a separate table named Category. You execute the following statement:
INSERT INTO Product
VALUES (3296, 'Table', 4444)
What is the result?
a foreign key constraint violation
a syntax error
a new row in the Product table
D. a primary key constraint violation
a new row in the Category table
You have two tables named Salesperson and Sales.
You need to ensure that each record in the Sales table has a valid associated salesperson record in
the Salesperson table.
Which database object should you add to the Sales table?
A. Nonclusteredindex
B. Primarykey
C. Foreign key
D. Clustered index
Which keyword must be included in a create view statement?
A. WHERE
B. ORDERBY
C. UPDATE
D. SELECT
ALTER TABLE removes all rows from a table without logging the individual row deletions.
A. Nochangeisneeded
B. DROPTABLE
C. TRUNCATE TABLE
D. CREATE TABLE
You need to populate a table named EmployeeCopy with data from an existing table named Employee.
Which statement should you use?
A key defines the amount of storage space that is allocated to a value in a column.
A. Nochangeisneeded
B. format
C. data type
D. validator
Which statement creates a composite key?
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:
A. Empty
B. Deleted
C. Unchanged
D. Archived
One reason to create a stored procedure is to:
A. Improveperformance.
B. Minimizestoragespace.
C. Bypass case sensitivity requirements.
D. Give the user control of the query logic.
You need to combine the results of two queries into a single result that contains all of the rows from both queries.
Which Structured Query Language (SQL) statement should you use?
TRUNCATE
B. JOIN
C. EXCEPT
D. UNION
No non-prime attribute in the table is functionally dependent on a proper subset of a candidate key
1NF
2NF
3NF
4NF
5NF
Every non-trivial join dependency in the table is implied by the superkeys of the table
1NF
2NF
3NF
4NF
5NF
Every non-prime attribute is non-transitively dependent on every candidate key in the table
1NF
2NF
3NF
4NF
5NF
Every non-trivial multivalued dependency in the table is a dependency on a superkey
1NF
2NF
3NF
4NF
5NF
Table has no repeating groups
1NF
2NF
3NF
4NF
5NF
