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

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

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

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

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

خذ اختبارات أخرى عبر الإنترنت
السؤال #1
Which statement is true regarding external tables?
A. The CREATE TABLE AS SELECT statement can be used to upload data into regular table in the database from an external table
B. The data and metadata for an external table are stored outside the database
C. The default REJECT LIMIT for external tables is UNLIMITED
D. ORACLE_LOADER and ORACLE_DATAPUMP have exactly the same functionality when used with an external table
عرض الإجابة
اجابة صحيحة: D
السؤال #2
Examine these SQL statements that are executed in the given order: CREATE TABLE emp (emp_no NUMBER (2) CONSTRAINT emp_emp_no_pk PRIMARY KEY, ename VARCHAR 2 (15), salary NUMBER (8, 2), mgr_no NUMBER(2) CONSTRAINT emp_mgr_fk REFERENCES emp (emp_no)); ALTER TABLE emp DISABLE CONSTRAINT emp_emp_no_pk CASCADE; ALTER TABLE emp ENABLE CONSTRAINT emp_emp_no_pk; What will be the status of the foreign key EMP_MGR_FK?
A. It will be enabled and immediate
B. It will be enabled and deferred
C. It will remain disabled and can be re-enabled manually
D. It will remain disabled and can be enabled only by dropping the foreign key constraint and re-creating it
عرض الإجابة
اجابة صحيحة: AB
السؤال #3
On your Oracle 12c database, you invoked SQL *Loader to load data into the EMPLOYEES table in the HR schema by issuing the following command: $> sqlldr hr/hr@pdb table=employees Which two statements are true regarding the command?
A. It succeeds with default settings if the EMPLOYEES table belonging to HR is already defined in the database
B. It fails because no SQL *Loader data file location is specified
C. It fails if the HR user does not have the CREATE ANY DIRECTORY privilege
D. It fails because no SQL *Loader control file location is specified
عرض الإجابة
اجابة صحيحة: B
السؤال #4
View the exhibit and examine the description of the PRODUCT_INFORMATION table. Which SQL statement would retrieve from the table the number of products having LIST_PRICE as NULL?
A. SELECT COUNT (DISTINCT list_price)FROM product_informationWHERE list_price is NULL
B. SELECT COUNT (NVL(list_price, 0))FROM product_informationWHERE list_price is NULL
C. SELECT COUNT (list_price)FROM product_informationWHERE list_price i= NULL
D. SELECT COUNT (list_price)FROM product_informationWHERE list_price is NULL
عرض الإجابة
اجابة صحيحة: B
السؤال #5
Which two statements are true regarding constraints?
A. A table can have only one primary key and one foreign key
B. A table can have only one primary key but multiple foreign keys
C. Only the primary key can be defined at the column and table levels
D. The foreign key and parent table primary key must have the same name
E. Both primary key and foreign key constraints can be defined at both column and table levels
عرض الإجابة
اجابة صحيحة: C
السؤال #6
Which two statements are true regarding the SQL GROUP BY clause?
A. You can use a column alias in the GROUP BY clause
B. Using the WHERE clause after the GROUP BY clause excludes rows after creating groups
C. The GROUP BY clause is mandatory if you are using an aggregating function in the SELECT clause
D. Using the WHERE clause before the GROUP BY clause excludes rows before creating groups
E. If the SELECT clause has an aggregating function, then columns without an aggregating function in the SELECT clause should be included in the GROUP BY clause
عرض الإجابة
اجابة صحيحة: AC
السؤال #7
Examine the structure of the PROMOTIONS table: (Choose the best answer.) Management requires a report of unique promotion costs in each promotion category. Which query would satisfy this requirement?
A. SELECT DISTINCT promo_category, promo_cost FROM promotions ORDER BY 1
B. SELECT promo_category, DISTINCT promo_cost FROM promotions
C. SELECT DISTINCT promo_cost, promo_category FROM promotions
D. SELECT DISTINCT promo_cost, DISTINCT promo_category FROM promotions;
عرض الإجابة
اجابة صحيحة: D

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

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

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

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


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