1. You have a table called Students and you need to process the data 1 student a

Question

1. You have a table called Students and you need to process the data 1 student at a time. What should you use?

A. Stored Procedure

B. IF.....ELSE block

C. Cursor

D. Index

2. True/False   There are a total of 7 different normal forms and the database is considered normalized if it is in the 1st form.

3.    Why will the following code fail?

CREATE VIEW makeview

AS (SELECT * FROM product

WHERE makeflag = 1)

ORDER BY listprice;

A. Cannot have an Order By clause in the view without a TOP operator

B. Doesnt create a temporary table

C. Needs to have a COMPUTE clause in it

D. It won't fail, nothing is wrong

Explanation / Answer

1. option A. Stored Procedure                                                                                             

2. True

3. option A. Cannot have an Order By clause in the view without a TOP operator

Related Questions

Navigate

• Browse (All)
• Browse 1
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.