amd_el بتاريخ: 11 يوليو 2007 تقديم بلاغ مشاركة بتاريخ: 11 يوليو 2007 لو سمحتم انا عندي كام سؤال في ال sql كنت عايز الأجابات الصحيحة لهم مع الاعلم اني معي اجابات لهم ولكني مش واثق بهذه الأجابات 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 DATEGPA 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 fromthe earliest date. Which statement accomplishes this?A. SELECT student_id, semester_end, gpa FROM student_grades ORDER BYsemester_end DESC, gpa DESC;B. SELECT student_id, semester_end, gpa FROM student_grades ORDER BYsemester_end ASC, gpa ASC;C. SELECT student_id, semester_end, gpa FROM student_grades ORDER BYsemester_end, gpa DESC;D. SELECT student_id, semester_end, gpa FROM student_grades ORDER BY gpaDESC, semester_end DESC;E. SELECT student_id, semester_end, gpa FROM student_grades ORDER BY gpaDESC, 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 xxxIDENTIFIED by yyyy statementB. to grant a group of related privileges to a userC. When the number of people using the database is very highD. to simplify the process of granting and revoking privilegesE. 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 dateB. convert any numeric literal to a dateC. convert any date to a character literalD. format 'January 10 1999' for inputE. format '10-JAN-99' to 'January 10 1999' اقتباس رابط هذا التعليق شارك المزيد من خيارات المشاركة
Recommended Posts
انضم إلى المناقشة
يمكنك المشاركة الآن والتسجيل لاحقاً. إذا كان لديك حساب, سجل دخولك الآن لتقوم بالمشاركة من خلال حسابك.