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

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

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

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

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

خذ اختبارات أخرى عبر الإنترنت
السؤال #1
Which three statements are true regarding the data types?
A. The minimum column width that can be specified for a VARCHAR2 data type column is one
B. Only one LONG column can be used per table
C. A TIMESTAMP data type column stores only time values with fractional seconds
D. The BLOB data type column is used to store binary data in an operating system file
E. The value for a CHAR data type column is blank-padded to the maximum defined column width
عرض الإجابة
اجابة صحيحة: B
السؤال #2
Examine the commands used to create DEPARTMENT_DETAILS and COURSE_DETAILS: SQL>CREATE TABLE DEPARTMENT_DETAILS (DEPARTMENT_ID NUMBER PRIMARY KEY, DEPARTMENT_NAMEVARCHAR2(50), HODVARCHAR2(50)); SQL>CREATE TABLE COURSE_DETAILS (COURSE_IDNUMBER PRIMARY KEY, COURSE_NAMEVARCHAR2(50), DEPARTMENT_IDVARCHAR2(50)); You want to generate a list of all department IDs along with any course IDs that may have been assigned to them. Which SQL statement must you use?
A. SELECT d
B. department_id);
C. SELECT d
D. department_id);
E. SELECT d
F. department_id); G
عرض الإجابة
اجابة صحيحة: C
السؤال #3
View the exhibit for the structure of the STUDENT and FACULTY tables. STUDENT NameNull?Type -------------------------------------------------- STUDENT_IDNOT NULLNUMBER(2) STUDENT_NAMEVARCHAR2(20) FACULTY_IDVARCHAR2(2) LOCATION_IDNUMBER(2) FACULTY NameNull?Type -------------------------------------------------- FACULTY_IDNOT NULLNUMBER(2) FACULTY_NAMEVARCHAR2(20) LOCATION_IDNUMBER(2) You need to display the faculty name followed by the number of students handled by the faculty at the base location. Examine t
A. Only statement 2 executes successfully and gives the required result
B. Only statement 1 executes successfully and gives the required result
C. Both statements 1 and 2 execute successfully and give different results
D. Both statements 1 and 2 execute successfully and give the same required result
عرض الإجابة
اجابة صحيحة: C
السؤال #4
Examine the commands used to create DEPARTMENT_DETAILS and COURSE_DETAILS: You want to generate a report that shows all course IDs irrespective of whether they have corresponding department IDs or not but no department IDs if they do not have any courses. Which SQL statement must you use?
A. SELECT course_id, department_id, FROM department_details d RIGHT OUTER JOIN course_details c USING (department_id)
B. SELECT c
C. SELECT c
D. department_id)
E. SELECT c
F. department_id)
عرض الإجابة
اجابة صحيحة: B
السؤال #5
Which two statements are true regarding subqueries? (Choose two.)
A. A subquery can appear on either side of a comparison operator
B. Only two subqueries can be placed at one level
C. A subquery can retrieve zero or more rows
D. A subquery can be used only in SQL query statements
E. There is no limit on the number of subquery levels in the WHERE clause of a SELECT statement
عرض الإجابة
اجابة صحيحة: BC
السؤال #6
Evaluate the following query: Which is the correct output of the above query?
A. +00-300, +54-02,+00 11:12:10
B. +00-300,+00-650,+00 11:12:10
C. +25-00, +54-02, +00 11:12:10
D. +25-00,+00-650,+00 11:12:10
عرض الإجابة
اجابة صحيحة: AEF
السؤال #7
Which three arithmetic operations can be performed on a column by using a SQL function that is built into Oracle database? (Choose three.)
A. Finding the lowest value
B. Finding the quotient
C. Raising to a power
D. Subtraction
E. Addition
عرض الإجابة
اجابة صحيحة: AC
السؤال #8
Which task can be performed by using a single Data Manipulation Language (DML) statement?
A. Removing all data only from a single column on which a primary key constraint is defined
B. Removing all data from a single column on which a unique constraint is defined
C. Adding a column with a default value while inserting a row into a table
D. Adding a column constraint while inserting a row into a table
عرض الإجابة
اجابة صحيحة: A
السؤال #9
A subquery is called a single-row subquery when .
A. There is only one subquery in the outer query and the inner query returns one or more values
B. The inner query returns a single value to the outer query
C. The inner query uses an aggregating function and returns one or more values
D. The inner query returns one or more values and the outer query returns a single value
عرض الإجابة
اجابة صحيحة: CDE

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

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

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

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


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