لا تريد أن تفوت شيئا؟

نصائح اجتياز امتحان الشهادة

آخر أخبار الامتحانات ومعلومات الخصم

برعاية وحديثة من قبل خبرائنا

نعم، أرسل لي النشرة الإخبارية

خذ اختبارات أخرى عبر الإنترنت
السؤال #1
Examine the structure of the EMPLOYEES table. NameNull?Type ---------------------- ------------ EMPLOYEE_IDNOT NULLNUMBER(6) FIRST_NAMEVARCHAR2(20) LAST_NAMENOT NULLVARCHAR2(25) EMAILNOT NULLVARCHAR2(25) PHONE NUMBERVARCHAR2(20) HIRE_DATENOT NULLDATE JOB_IDNOT NULLVARCHAR2(10) SALARYNUMBER(8,2) COMMISSION_PCTNUMBER(2,2) MANAGER_IDNUMBER(6) DEPARTMENT_IDNUMBER(4) There is a parent/child relationship between EMPLOYEE_ID and MANAGER_ID. You want to display the last names and manager IDs of employees who work f
A. SELECT e
B. SELECT e
C. SELECT e
D. SELECT m
عرض الإجابة
اجابة صحيحة: AC
السؤال #2
You issue this command which succeeds: SQL> DROP TABLE products; Which three statements are true?
A. All existing views and synonyms that refer to the table are invalidated but retained
B. Any uncommitted transaction in the session is committed
C. Table data and the table structure are deleted
D. All the table’s indexes if any exist, are invalidated but retained
E. Table data is deleted but the table structure is retained
عرض الإجابة
اجابة صحيحة: BCD
السؤال #3
View the Exhibits and examine PRODUCTS and SALES tables. Exhibit 1 Exhibit 2 You issue the following query to display product name the number of times the product has been sold: What happens when the above statement is executed?
A. The statement executes successfully and produces the required output
B. The statement produces an error because a subquery in the FROM clause and outer-joins cannot be used together
C. The statement produces an error because the GROUP BY clause cannot be used in a subquery in the FROM clause
D. The statement produces an error because ITEM_CNT cannot be displayed in the outer query
عرض الإجابة
اجابة صحيحة: D
السؤال #4
You want to display 5 percent of the rows from the SALES table for products with the lowest AMOUNT_SOLD and also want to include the rows that have the same AMOUNT_SOLD even if this causes the output to exceed 5 percent of the rows. Which query will provide the required result?
A. SELECT prod_id, cust_id, amount_soldFROM salesORDER BY amount_soldFETCH FIRST 5 PERCENT ROWS WITH TIES;
B. SELECT prod_id, cust_id, amount_soldFROM salesORDER BY amount_soldFETCH FIRST 5 PERCENT ROWS ONLY WITH TIES;
C. SELECT prod_id, cust_id, amount_soldFROM salesORDER BY amount_soldFETCH FIRST 5 PERCENT ROWS WITH TIES ONLY;
D. SELECT prod_id, cust_id, amount_soldFROM salesORDER BY amount_soldFETCH FIRST 5 PERCENT ROWS ONLY;
عرض الإجابة
اجابة صحيحة: B
السؤال #5
Which two statements are true regarding the GROUP BY clause in a SQL statement? (Choose two.)
A. You can use column alias in the GROUP BY clause
B. Using the WHERE clause after the GROUP BY clause excludes the rows after creating groups
C. The GROUP BY clause is mandatory if you are using an aggregate function in the SELECT clause
D. Using the WHERE clause before the GROUP BY clause excludes the rows before creating groups
E. If the SELECT clause has an aggregate function, then those individual columns without an aggregate function in the SELECT clause should be included in the GROUP BY cause
عرض الإجابة
اجابة صحيحة: D
السؤال #6
View the exhibit and examine the data in the PROJ_TASK_DETAILS table. (Choose the best answer.) The PROJ_TASK_DETAILS table stores information about project tasks and the relation between them. The BASED_ON column indicates dependencies between tasks. Some tasks do not depend on the completion of other tasks. You must generate a report listing all task IDs, the task ID of any task upon which it depends and the name of the employee in charge of the task upon which it depends. Which query would give the requi
A. SELECT p
B. SELECT p
C. SELECT p
D. SELECT p
عرض الإجابة
اجابة صحيحة: A
السؤال #7
Examine the data in the CUST_NAME column of the CUSTOMERS table. CUST_NAME ------------------- Renske Ladwig Jason Mallin Samuel McCain Allan MCEwen Irene Mikilineni Julia Nayer You need to display customers' second names where the second name starts with "Mc" or "MC". Which query gives the required output?
A. SELECT SUBSTR (cust_name, INSTR (cust_name, ' ')+1)FROM customersWHERE SUBSTR (cust_name, INSTR (cust_name, ' ')+1)LIKE INITCAP ('MC%');
B. SELECT SUBSTR (cust_name, INSTR (cust_name, ' ')+1)FROM customersWHERE INITCAP (SUBSTR(cust_name, INSTR (cust_name, ' ')+1)) ='Mc';
C. SELECT SUBSTR (cust_name, INSTR (cust_name, ' ')+1)FROM customersWHERE INITCAP (SUBSTR(cust_name, INSTR (cust_name, ' ')+1))LIKE 'Mc%';
D. SELECT SUBSTR (cust_name, INSTR (cust_name, ' ')+1)FROM customersWHERE INITCAP (SUBSTR(cust_name, INSTR (cust_name, ' ')+1)) =INITCAP 'MC%';
عرض الإجابة
اجابة صحيحة: B
السؤال #8
Which statement is true regarding the UNION operator?
A. By default, the output is not sorted
B. Null values are not ignored during duplicate checking
C. Names of all columns must be identical across all select statements
D. The number of columns selected in all select statements need not be the same
عرض الإجابة
اجابة صحيحة: D

عرض الإجابات بعد التقديم

يرجى إرسال البريد الإلكتروني الخاص بك والواتس اب للحصول على إجابات الأسئلة.

ملحوظة: يرجى التأكد من صلاحية معرف البريد الإلكتروني وWhatsApp حتى تتمكن من الحصول على نتائج الاختبار الصحيحة.

بريد إلكتروني:
رقم الواتس اب/الهاتف:


Copyright © 2024. Designer by SPOTO Official Website. All Rights Reserved.