اريد اجابات صحيحه لهذه الأسئله لو سمحتم

1-Which two statements complete a transaction? (Choose two.)

A. DELETE employees;
B. DESCRIBE employees;
C. ROLLBACK TO SAVEPOINT C;
D. GRANT SELECT ON employees TO SCOTT;
E. ALTER TABLE employees SET UNUSED COLUMN sal;
F. SELECT MAX(sal) FROM employees WHERE department_id = 20;


2-The STUDENT_GRADES table has these columns:
STUDENT_ID NUMBER (12)
SEMESTER_END DATE
GPA NUMBER (4, 3)

The registrar has requested a report listing the students' grade point averages (GPA),
sorted from highest grade point average to lowest within each semester, starting from
the earliest date. Which statement accomplishes this?

A. SELECT student_id, semester_end, gpa FROM student_grades ORDER BY
semester_end DESC, gpa DESC;
B. SELECT student_id, semester_end, gpa FROM student_grades ORDER BY
semester_end ASC, gpa ASC;
C. SELECT student_id, semester_end, gpa FROM student_grades ORDER BY
semester_end, gpa DESC;
D. SELECT student_id, semester_end, gpa FROM student_grades ORDER BY gpa
DESC, semester_end DESC;
E. SELECT student_id, semester_end, gpa FROM student_grades ORDER BY gpa
DESC, semester_end ASC;



3-When should you create a role? (Choose two)

A. to simplify the process of creating new users using the CREATE USER xxx
IDENTIFIED by yyyy statement
B. to grant a group of related privileges to a user
C. When the number of people using the database is very high
D. to simplify the process of granting and revoking privileges
E. To simplify profile maintenance for a user who is constantly traveling.



4-For which two actions can you use the TO_DATE function? (Choose two.)

A. convert any date literal to a date
B. convert any numeric literal to a date
C. convert any date to a character literal
D. format 'January 10 1999' for input
E. format '10-JAN-99' to 'January 10 1999'