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;)
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;)
