MTA Mga Questions na mali si Justine

• 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