Total Pageviews

February 27, 2015

2/27/2015 09:38:00 AM

1)b(b. Grant Joshua the CREATE SESSION privilege.)

2)c,d(c. He can create a table in any schema of the database but can drop tables from and create procedures only within his own schemas.

d.He can create a table or procedure in any schema of a database and can also drop tables in any schema of the database.)

3)
b(b.USER_VIEWS)

4)
d(d.None)

5)
a(Replace the view, adding a WHERE clause)

6)
b(The need to create a new view or table is eliminated by placing a sub query in the FROM clause.)

7)d(d. INSERT INTO patient(id_number, last_name, first_name, Birth_date)
VALUES(patient_id_seq.NEXTVAL, &last_name,&first_name, & birth_date))

8)a. Updates on the table will be slower.

9)d.(SELECT TO_CHAR(hire_date,’fmDD “of” MONTH YYYYY’)DATE HIRED
FROM worker;)

10)b(SELECT hire_date.
FROM worker
ORDER BY hire_date;)








 
Related Posts Plugin for WordPress, Blogger...