أسئلة في امتحان Sql حيرتني

[ANK]

السلام عليكم
وجدت مجموعة من الاسئلة شوشتني لان الحلول التي وضعوها لها لم اقتنع بها، فارجو افادتي يا اخوان لاني مقبل على دخول الامتحان ، الاسئلة هي :

Which four statments correctly describe functions that are available in SQL? (Choose four)
A) INSTR returns the numeric position of a named character
NVL2 returns the first non-null expression in the expression list
C) TRUNCATE rounds the column, expression, or value to n decimal places
D) DECODE translates an expression after comparing it to each search value
E) TRIM trims the heading of trailing characters (or both) from a character string
F) NVL compares two expressions and returns null if they are equal, or the first expression if they are not equal
G) NULLIF compares two expressions and returns null if they are equal, or the first expression if they are not equal

Answers : A,D,E,G

ولكن اعتقد ان الاجابات الصحيحة لهذا السؤال هي
A,B,E,G

Which two statements accurately describe a role? (Choose two)
A) A role can be given to a maximum of 1000 users
A user can have access to a maximum of 10 roles
C) A role can have a maximum of 100 privileges contained in it
D) Privileges are given to a role by using the create role statement
E) A role is a named group of related privileges that can be granted to the user
F) A user can have access to several roles, and several users can be assigned the same role

Answers: D,F
ولكن اعتقد الاجابات الصحيحة هي:
E,F

ما هي الحلول الصحيحة؟

[mhmdsaeed]

السلام عليكم

اخي الكريم

السؤال الأول غير متاكد بشوفها عندي وبرجع برد لك
السؤال الثاني الإجابة الصحيحة متل ما قلت E.F

[qusaisabbagh]

Salam

Sorry I'm writing in english because I dont have arabic leters on my keyboard!!!!!!!

Regarding the first question, the correct answers are: A,D,E,G
Because decode is working like IF statement by comparing a specific value to other values.
But NVL2 is doing the following:

NVL2( string1, value_if_NOT_null, value_if_null )
string1 is the string to test for a null value.
value_if_NOT_null is the value returned if string1 is not null.
value_if_null is the value returned if string1 is null.

And regarding the second question, the correct answers are as you said: E,F

Best of luck.

Qusai.

[hassan978hmk]

الأخ الكريم
الإجابات الموجودة في امتحانات testking وغيرها , فيها الكثير من الأخطاء , لا تثق كثيرا بإجاباتهم , كن واثقا من دراستك وتجربتك .
هناك الكثير من المشاركات المماثلة في المنتدى , استخدم خاصية البحث .
بالتوفيق