اخطاء التست كينج للي داخل الامتحان 1z0-007

السلام عليكم
يا جماعة انا ان شاء الله بحضر نفسي عشان ادخل الامتحانات بتاعه اوراكل ديفلوبير ان شاء الله
فاول امتحان ناوي ادخله ان شاء الله هوه
1z0-007
وده بتاع
sql
انا لقيت نسخة من التست كينج فيها حوالي 204 سؤال
بس انا تقريبا شايف ان فيه اجابات مش مضبوطه ( مش عارف انا اللي صح ولا مش المفروض اني افكر...واخد اللي مكتوب علي طول)
المهم انا جبت ارقام الاسئلة اللي انا شاكك فيها وياريت نفسكم معايه جايز انا اللي خطأ
واللي شايف ان فيه اسئلة شاكك فيها يا ريت يضيفها في الموضوع ده عشان الفائدة تعم ان شاء الله تعالي
وياريت يا جماعة اللي عنده تست كينج جديد او باس فور شور جديد يا ريت يعطي لينا اللينك بتاعه وشكرا
نبتدي بقي الاسئلة مع بعض ان شاء الله

***************************************************************************
السؤال رقم 47 في التست كينج
***************************************************************************

Which two statements accurately describe a role? (Choose two.)
A. A role can be given to a maximum of 1000 users.
B. 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.
Answer: D, F

انا شايف ان الاجابة هيه
E,F
لانها مكتوبه في الكتاب بالنص
A role is a named group of related privileges that can be granted to the user. This method makes it easier to revoke and maintain privileges.
A user can have access to several roles, and several users can be assigned the same role


**************************************************************************
السؤال رقم 74
**************************************************************************
QUESTION 74:
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.
Answer: B, C, D

انا شايف ان الاجابة
B,C,E

وده الكود اللي ممكن تجرب بيه
select last_name
from employees
where salary IN (select min(salary)
from employees
where department_id=10
group by department_id);
وده الجزء بتاع الكود اللي ممكن تجرب بيه
D,F
عشان تتاكد بس انهم خطأ
select last_name
from employees
where salary > (select min(salary)
from employees
group by department_id);

****************************************************************************
السؤال رقم 99
****************************************************************************
QUESTION 99:
Which three are true regarding the use of outer joins? (Choose three.)
A. You cannot use IN operator in a condition that involves an outerjoin.
B. You use (+) on both sides of the WHERE condition to perform an outerjoin.
C. You use (*) on both sides of the WHERE condition to perform an outerjoin.
D. You use an outerjoin to see only the rows that do not meet the join condition.
E. In the WHERE condition, you use (+) following the name of the column in the table without matching rows,
to perform an outerjoin.
F. You cannot link a condition that is involved in an outerjoin to another condition by using the OR operator.
Answer: D, E, F
السؤال ده انا حاسس ان اجابته كلها خطأ من الاول
ومش عارف الحل بتاعه بس اعتقد ان من الحلول الصح
A,F

يا جماعة يا ريت اللي فاهم حاجة في السؤال ده بالذات يفهمنا

*********************************
السؤال رقم 170
********************************
QUESTION 170:
Evaluate the SQL statement:
TRUNCATE TABLE DEPT;
Which three are true about the SQL statement? (Choose three.)
A. It releases the storage space used by the table.
B. It does not release the storage space used by the table.
C. You can roll back the deletion of rows after the statement executes.
D. You can NOT roll back the deletion of rows after the statement executes.
E. An attempt to use DESCRIBE on the DEPT table after the TRUNCATE statement executes will display an
error.
F. You must be the owner of the table or have DELETE ANY TABLE system privileges to truncate the DEPT
table
Answer: A, D, F

انا متفق معاه علي
D,F
بس انا بعتقد ان الاجابة الثالث
B
لان الي انا فاهمه ان الدروب بس هيه اللي بتفضي المساحة اللي كانت مستخدمه عن طريق التابل
ياريت لو خطأ حد يوضح لي وخصوصا الشباب اللي دخلوا الامتحانات قبل كده

***********************************************
السؤال رقم 189
***********************************************
QUESTION 189:
Which are /SQL*Plus commands? (Choose all that apply.)
1Z0-007
Actualtests.com - The Power of Knowing
A. INSERT
B. UPDATE
C. SELECT
D. DESCRIBE
E. DELETE
F. RENAME
Answer: A, B, C, D, E

دا انا مش فاهمه اصلا


******************************************************
السؤال رقم 191
*****************************************************
QUESTION 191:
Which two statements about subqueries are true? (Choose two.)
A. A single row subquery can retrieve data from only one table.
B. A SQL query statement cannot display data from table B that is referred to in its subquery, unless table B is
included in the main query's FROM clause.
C. A SQL query statement can display data from table B that is referred to in its subquery, without including B
in its own FROM clause.
D. A single row subquery can retrieve data from more than one table.
E. A single row subquery cannot be used in a condition where the LIKE operator is used for comparison.
F. A multiple-row subquery cannot be used in an INSERT statement to insert multiple rows at a time.
Answer: D, F
انا شايف ان الاجابة هيه
B,D
**************************************************************
السؤال رقم 200
***************************************************************
QUESTION 200:
What is true regarding subqueries?
A. The inner query always sorts the results of the outer query
B. The outer query always sorts the results of the inner query
C. The outer query must return a value to the outer query
D. The inner query returns a value to the outer query
E. The inner query must always return a value or the outer query will give an error
Answer: A

انا شايف ان الاجابة هيه
D
وخصوصا لانه في الشرح كمان قايل
The inner query returns a value to the outer query

************************************************************************
السؤال رقم 203
***********************************************************************
QUESTION 203:
Which three statements about subqueries are true? (Choose three.)
A. A main query can have more than one subquery.
B. A subquery can have more than one main query.
C. The subquery and main query must retrieve data from the same table.
D. The subquery and main query can retrieve data from different tables.
E. Only one column or expression can be compared between the subquery and main query.
F. Multiple columns or expression can be compared between the subquery and main query.
Answer: A, D, E
انا معاه في الاجابات
A,D
بس انا بعتقد ان "اف" ممكن تكون صح
لان في جزء في الكتاب في شابتر ستة في الكتاب الثاني
SQL FUNDAMENTALS II
Pairwise Comparison

وده مثال موجود
SELECT employee_id, manager_id, department_id
FROM employees
WHERE (manager_id, department_id) IN
(SELECT manager_id, department_id
FROM employees
WHERE employee_id IN (199,174))
AND employee_id NOT IN (199,174);

*****************************************************************************
السؤال رقم 204
******************************************************************************
QUESTION 204:
Evaluate this SQL statement:
SELECT e.emp_name, d.dept_name
FROM employees e
JOIN departments d
USING (department_id)
WHERE d.department_id NOT IN (10,40)
ORSER BY dept_name;
The statement fails when executed. Which change fixes the error?
A. remove the ORDER BY clause
B. remove the table alias prefix from the WHERE clause
C. remove the table alias from the SELECT clause
D. prefix the column in the USING clause with the table alias
E. prefix the column in the ORDER BY clause with the table alias
F. replace the condition
"d.department_id NOT IN (10,40)"
in the WHERE clause with
"d.department_id <> 10 AND d.department_id <> 40"
Answer: C

انا شايف ان الاجابة هيه رقم
B

*********************************************************************
ملحوظة هامة
يا جماعة دي اجتهاد مني يعني مش موضوع مسلم بيه انا شايف ان الاسئلة دي فيها شك
لو حد عنده فكرة تانية ا و شاكك في سؤال ثاني او شايف ان الاجابات صح وانا اللي مخرف مفيش مشكلة يقول علي طول
انا ارجو من المشرفين الدخول والناس اللي دخلت امتحانات قبل كده عشان الفائدة تعم

وشكرا