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

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

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

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

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

خذ اختبارات أخرى عبر الإنترنت
السؤال #1
Which statement is true regarding the USING clause in table joins? (Choose two.)
A. It can be used to join a maximum of three tables
B. It can be used to access data from tables through equijoins as well as nonequijoins
C. It can be used to join tables that have columns with the same name and compatible data types
D. It can be used to restrict the number of columns used in a NATURAL join
عرض الإجابة
اجابة صحيحة: B
السؤال #2
Which two statements are true regarding the execution of the correlated subqueries? (Choose two.)
A. The nested query executes after the outer query returns the row
B. The nested query executes first and then the outer query executes
C. The outer query executes only once for the result returned by the inner query
D. Each row returned by the outer query is evaluated for the results returned by the inner query
عرض الإجابة
اجابة صحيحة: AC
السؤال #3
Which statement is true about an inner join specified in the WHERE clause of a query?
A. It must have primary-key and foreign-key constraints defined on the columns used in the join condition
B. It requires the column names to be the same in all tables used for the join conditions
C. It is applicable for equijoin and nonequijoin conditions
D. It is applicable for only equijoin conditions
عرض الإجابة
اجابة صحيحة: ABD
السؤال #4
View the Exhibit and examine the description of the EMPLOYEES table. You want to calculate the total renumeration for each employee. Total renumeration is the sum of the annual salary and the percentage commission earned for a year. Only a few employees earn commission. Which SQL statement would you execute to get the desired output?
A. SELECT first_name, salary, salary*12+(salary*NVL2 (commission_pct, salary,salary+commission_pct))“Total”FROM EMPLOYEES;
B. SELECT first_name, salary, salary*12+salary*commission_pct “Total”FROM EMPLOYEES;
C. SELECT first_name, salary (salary + NVL (commission_pct, 0)*salary)*12 “Total”FROM EMPLOYEES;
D. SELECT first_name, salary*12 + NVL(salary,0)*commission_pct, “Total”FROM EMPLOYEES;
عرض الإجابة
اجابة صحيحة: CE
السؤال #5
Which two statements are true regarding constraints?
A. A foreign key column cannot contain null values
B. A column with the UNIQUE constraint can contain null values
C. A constraint is enforced only for INSERT operation on the table
D. A constraint can be disabled even if the constraint column contains data
E. All constraints can be defined at the column level and at the table level
عرض الإجابة
اجابة صحيحة: BD
السؤال #6
Examine the business rule: Each student can work on multiple projects and each project can have multiple students. You need to design an Entity Relationship Model (ERD) for optimal data storage and allow for generating reports in this format: STUDENT_ID FIRST_NAME LAST_NAME PROJECT_ID PROJECT_NAME PROJECT_TASK Which two statements are true in this scenario?
A. The ERD must have a 1:M relationship between the STUDENTS and PROJECTS entities
B. The ERD must have a M:M relationship between the STUDENTS and PROJECTS entities that must be resolved into 1:M relationships
C. STUDENT_ID must be the primary key in the STUDENTS entity and foreign key in the PROJECTS entity
D. PROJECT_ID must be the primary key in the PROJECTS entity and foreign key in the STUDENTS entity
E. An associative table must be created with a composite key of STUDENT_ID and PROJECT_ID, which is the foreign key linked to the STUDENTS and PROJECTS entities
عرض الإجابة
اجابة صحيحة: C
السؤال #7
When does a transaction complete? (Choose all that apply.)
A. When a PL/SQL anonymous block is executed
B. When a DELETE statement is executed
C. When a data definition language statement is executed
D. When a TRUNCATE statement is executed after the pending transaction
E. When a ROLLBACK command is executed
عرض الإجابة
اجابة صحيحة: AB
السؤال #8
You need to produce a report where each customer’s credit limit has been incremented by $1000. In the output, the customer’s last name should have the heading Name and the incremented credit limit should be labeled New Credit Limit. The column headings should have only the first letter of each word in uppercase. Which statement would accomplish this requirement?
A. SELECT cust_last_name AS “Name”, cust_credit_limit + 1000AS “New Credit Limit”FROM customers;
B. SELECT cust_last_name AS Name, cust_credit_limit + 1000AS New Credit LimitFROM customers;
C. SELECT cust_last_name AS Name, cust_credit_limit + 1000“New Credit Limit”FROM customers;
D. SELECT INITCAP (cust_last_name) “Name”, cust_credit_limit + 1000INITCAP (“NEW CREDIT LIMIT”)FROM customers;
عرض الإجابة
اجابة صحيحة: AC
السؤال #9
In which three situations does a transaction complete?
A. when a PL/SQL anonymous block is executed
B. when a DELETE statement is executed
C. when a ROLLBACK command is executed
D. when a data definition language (DDL) statement is executed
E. when a TRUNCATE statement is executed after the pending transaction
عرض الإجابة
اجابة صحيحة: A
السؤال #10
View the Exhibit and examine the details of the PRODUCT_INFORMATION table. (Choose two.) Evaluate this SQL statement: SELECT TO_CHAR (list_price, '$9,999') From product_information; Which two statements are true regarding the output?
A. A row whose LIST_PRICE column contains value 11235
B. A row whose LIST_PRICE column contains value 1123
C. A row whose LIST_PRICE column contains value 1123
D. A row whose LIST_PRICE column contains value 11235
عرض الإجابة
اجابة صحيحة: A
السؤال #11
View the Exhibit and examine the structure of the PRODUCT_INFORMATION and INVENTORIES tables. You have a requirement from the supplies department to give a list containing PRODUCT_ID, SUPPLIER_ID, and QUANTITY_ON_HAND for all the products wherein QUANTITY_ON_HAND is less than five. Which two SQL statements can accomplish the task? (Choose two.)
A. SELECT i
B. SELECT product_id, quantity_on_hand, supplier_idFROM product_informationNATURAL JOIN inventories AND quantity_on_hand < 5;
C. SELECT i
D. SELECT i
عرض الإجابة
اجابة صحيحة: D
السؤال #12
Examine the structure proposed for the TRANSACTIONS table: Which two statements are true regarding the storage of data in the above table structure? (Choose two.)
A. The CUST_CREDIT_VALUE column would allow storage of positive and negative integers
B. The TRANS_VALIDITY column would allow storage of a time interval in days, hours, minutes, and seconds
C. The CUST_STATUS column would allow storage of data up to the maximum VARCHAR2 size of 4,000 characters
D. The TRANS_DATE column would allow storage of dates only in the dd-mon-yyyy format
عرض الإجابة
اجابة صحيحة: AC

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

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

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

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


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