يا اخوان لدي استفسار سريع


هذا السؤال



Which two statements are true about constraints? (Choose two.)



A. The UNIQUE constraint does not permit a null value for the column
B. A UNIQUE index gets created for columns with PRIMARY KEY and UNIQUE
constraints.
C. The PRIMARY KEY and FOREIGN KEY constraints create a UNIQUE index.
D. The NOT NULL constraint ensures that null values are not permitted for the column.



موقع تيست كينج يقول ان الجواب الصحيح هو A و D

و P4S يقول ان الجواب الصحيح هو B و D

b and d the correct answer

أيضا هناك تضاربات و اريد منكم التصحيح جزاكم الله خيرا



السؤال الاول :


What is true about sequence?


هل الجواب الصحيح

The start value of the sequence is always 1.

أو

The minimum value of an ascending sequence defaults to 1.

؟؟


لان لدي ملفين و كل واحد فيهم فيه اجابه مختلفه







السؤال الثاني:

True about MERGE؟


A. A MERGE statement is used to merge the data of one table with data from another.
B. A MERGE statement replaces the data of one table with that of another.
C. A MERGE statement can be used to insert new rows into a table.



أو


A. A MERGE statement is used to merge the data of one table with data from another.
B. A MERGE statement replaces the data of one table with that of another.
D. A MERGE statement can be used to update existing rows in a table.



؟؟؟؟

السؤال الثالث


What is true regarding to subqueries?

inner query always sorts the results of the outer query


أو


inner query returns a value to the outer query



????

What is true about sequence?


هل الجواب الصحيح

The start value of the sequence is always 1.

أو

The minimum value of an ascending sequence defaults to 1.

؟؟
الاجابه
The minimum value of an ascending sequence defaults to 1.

شكرا لك اخي مصطفى و جزاك الله كل خير


واتمنى منكم الاجابه عن بقية الاسئله جزاكم الله خيرا

السؤال الثاني:

True about MERGE؟


A. A MERGE statement is used to merge the data of one table with data from another.
B. A MERGE statement replaces the data of one table with that of another.
C. A MERGE statement can be used to insert new rows into a table.



أو


A. A MERGE statement is used to merge the data of one table with data from another.
B. A MERGE statement replaces the data of one table with that of another.
D. A MERGE statement can be used to update existing rows in a table.
الاجابه

A. A MERGE statement is used to merge the data of one table with data from another.
B. A MERGE statement replaces the data of one table with that of another.
D. A MERGE statement can be used to update existing rows in a table.


السؤال الثالث


What is true regarding to subqueries?

inner query always sorts the results of the outer query


أو


inner query returns a value to the outer query
الاجابه

inner query returns a value to the outer query

بالتوفيق.

بصراحه لاحظت تضارب الاراء و الاجوبه و اريد التاكد جزاكم الله خيرا و اريد منكم اجوبه انتم متاكدون منها


Which three statements about subqueries are true? (Choose three)
A. A single row subquery can retrieve only one column and one row.
B. A single row subquery can retrieve only one row but many columns.
C. A multiple row subquery can retrieve multiple rows and multiple columns.
D. A multiple row subquery can be compared by using the “>” operator.
E. A single row subquery can use the IN operator.
F. A multiple row subquery can use the “=” operator





السؤال الثاني



When should you create a role? (Choose two)
A. To simplify the process of creating new users using the CREATE USER xxx
IDENTIFIED by yyy 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.





وفقكم الله

Which three statements about subqueries are true? (Choose three)
A. A single row subquery can retrieve only one column and one row.
B. A single row subquery can retrieve only one row but many columns.
C. A multiple row subquery can retrieve multiple rows and multiple columns.
D. A multiple row subquery can be compared by using the “>” operator.
E. A single row subquery can use the IN operator.
F. A multiple row subquery can use the “=” operator

الاجابه bcd



When should you create a role? (Choose two)
A. To simplify the process of creating new users using the CREATE USER xxx
IDENTIFIED by yyy 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.
الاجابهB,D
اخى الكريم ما اقولها ما هو الا اجتهد يحتمل الصواب و الخطاء و الهدف تاكيد اجابه و المساعده .وفقك الله الى ما يحبه ويرضها
اخى الكريو لو فى اسئله لو ممكن تجمعهم كلهم فى مشاركه واحده .
بالتوفيق لجميع .

بالنسبه للصب كويريز

هل < تستخدم مع multiple row subquery

؟؟؟

What are two reasons to create synonyms? (Choose two.)



A. You have too many tables.
B. Your tables are too long.
C. Your tables have difficult names.
D. You want to work on your own tables.
E. You want to use another schema's tables.
F. You have too many columns in your tables.


Which two are true about aggregate functions? (Choose two.)
A. You can use aggregate functions in any clause of a SELECT statement.
B. You can use aggregate functions only in the column list of the select clause and in the
WHERE clause of a SELECT statement.
C. You can mix single row columns with aggregate functions in the column list of a
SELECT statement by grouping on the single row columns.
D. You can pass column names, expressions, constants, or functions as parameter to an
aggregate function.
E. You can use aggregate functions on a table, only by grouping the whole table as one
single group.
F. You cannot group the rows of a table by more than one column while using aggregate
functions.

تم تعديل 3 سبتمبر 201015 سنة بواسطة msb2012

أتمنى منكم المساعده يا اخوان فاختباري غدا -ان شاء الله-


وهناك لخبطه كبيره لدي فالمعلومات متضاربه و كل ملف فيه اجوبه مختلفه



تعبت مع P4S و اكشوال تيست و تيست كنج و ان كنت لا ارتاح للاخير بصراحه



ارجو منكم مساعدتي و الدعاء لي بالتوفيق و النجاح غدا

بالنسبه للصب كويريز

هل < تستخدم مع multiple row subquery

؟؟؟

الاجابه bcd اسف فعلا غلاض مخدش بالى
الاجايه bce
E. A single row subquery can use the IN operator.
الدليل
select SALARY from employees where SALARY in (select min(SALARY) from employees )
What are two reasons to create synonyms? (Choose two.)



A. You have too many tables.
B. Your tables are too long.
C. Your tables have difficult names.
D. You want to work on your own tables.
E. You want to use another schema's tables.
F. You have too many columns in your tables.
الاجابه ac

Which two are true about aggregate functions? (Choose two.)
A. You can use aggregate functions in any clause of a SELECT statement.
B. You can use aggregate functions only in the column list of the select clause and in the
WHERE clause of a SELECT statement.
C. You can mix single row columns with aggregate functions in the column list of a
SELECT statement by grouping on the single row columns.
D. You can pass column names, expressions, constants, or functions as parameter to an
aggregate function.
E. You can use aggregate functions on a table, only by grouping the whole table as one
single group.
F. You cannot group the rows of a table by more than one column while using aggregate
functions.

الاجابه C, D
ولا تنسنا من صالح دعائك.

وفقك الله اخي مصطفى


والله والله والله العظيم انني اخجل من نفسي أمام كرمك واخلاقك العاليه و سعة صدرك و اجتهادك لمساعدة زملاءك


وفقك الله اخي مصطفى و حقق لك ما تتمنى


لدي نقطه اريد ان اناقشك فيها

وهي عن Synonym


انا لدي شك بان هذه الاختيار يعتبر من الاختيارات الصحيحه


E. You want to use another schema's tables


لانه كان موجود في الEngine الخاص بP4S والذي كنت اعتمد عليه كثيرا في السابق قبل الاطلاع على ملفات PDF الخاصه ب اكتشوال تيست


بالاضافه الى انني اميل له اكثر من اختيار


A. You have too many tables.



ارجو منك مساعدتي على ذلك




وارجو منك اخي العزيز ان تدعوا لي في هذه الليل المبارك بالتوفيق و النجاح في الغد


مع العلم اني سأقطع ما يقارب 160 كم صباح الغد -ان شاء الله- للذهاب الى مركز الامتحان



ارجو منك انت و الاخوان ان تدعون لي بالتوفيق في الاختبار غدا و ان تدعون لي بالسلامه في طريقي بالغد ان شاء الله




وكلي امل اخي مصطفى ان ابلغك غدا باجتيازي الاختبار باذن الله و ستكون انت الاول باذن الله قبل الجميع


وشكرا

اخى الكربم لا داعى من الخجل او الشكر يكفنى منك دعوه فى السر عسى تستجاب وتكونى لى افضل من الدنيا و ما فيها .
Synonym الاجابه زاى ماقلت صدقنى و انا ان شاءالله متاكد منها .بدون دخول فى تفاصيل احتمالات التى ذكرتها بعيضه عن الصواب .
ربنا يكرم وان شاء الله موفق وابقى قول انا قلت و لكن باذن الله عندما تستلم تقرير النجاح وتجد درجه ممتاز ان شاء الله .ابقى افتكرنى بدعوه ان شاء الله .وفى انتظاره البشره بنجاح ان شاء الله.