1. Home
  2. Computing & Technology
  3. Computer Certification
OCP 1Z0-001 Practice Test
20 Free OCP Practice Questions from Whizlabs

Question 7

Which of the following statements creates a view and does not allow the values to be changed through the view?

a.
CREATE VIEW empl_vu
AS
SELECT *
FROM employee
WHERE sal > 10000
WITH READ ONLY;

b. 
CREATE VIEW empl_vu
AS
SELECT *
FROM employee
WHERE sal > 10000
WITH CHECK OPTION;

c. 
CREATE VIEW empl_vu
AS
SELECT *
FROM employee
WHERE sal > 10000
WITH CHECK CONSTRAINT;

d. None of the above

Next page > Question 8

Explore Computer Certification
About.com Special Features

Stay connected and entertained with reviews on tips on the latest HDTVs, cellphones and more. More >

Easy ways to connect two computers for networking purposes. More >

  1. Home
  2. Computing & Technology
  3. Computer Certification

©2009 About.com, a part of The New York Times Company.

All rights reserved.