الانتقال إلى المحتوى

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


amd_el

Recommended Posts

لو سمحتم انا عندي كام سؤال في ال 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 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'

رابط هذا التعليق
شارك

انضم إلى المناقشة

يمكنك المشاركة الآن والتسجيل لاحقاً. إذا كان لديك حساب, سجل دخولك الآن لتقوم بالمشاركة من خلال حسابك.

زائر
أضف رد على هذا الموضوع...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   تمت استعادة المحتوى السابق الخاص بك.   مسح المحرر

×   You cannot paste images directly. Upload or insert images from URL.

جاري التحميل
×
×
  • أضف...

برجاء الإنتباه

بإستخدامك للموقع فأنت تتعهد بالموافقة على هذه البنود: سياسة الخصوصية