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

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

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

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

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

خذ اختبارات أخرى عبر الإنترنت
السؤال #1
Evaluate the following CREATE TABLE command: Which statement is true regarding the above SQL statement?
A. It would execute successfully and only ORD_ITM_IDX index would be created
B. It would give an error because the USING INDEX clause cannot be used on a composite primary
C. It would execute successfully and two indexes ORD_ITM_IDX and ORD_ITM_ID PK would be created
D. It would give an error because the USING INDEX is not permitted in the CRETAE TABLE command
عرض الإجابة
اجابة صحيحة: ABD
السؤال #2
View the exhibit and examine the structure of the STORES table. STORES table NameNull?Type ---------------------- ------------- STORE_IDNUMBER NAMEVARCHAR2(100) ADDRESSVARCHAR2(200) CITYVARCHAR2(100) COUNTRYVARCHAR2(100) START_DATEDATE END_DATEDATE PROPERTY_PRICENUMBER You want to display the NAME of the store along with the ADDRESS, START_DATE, PROPERTY_PRICE, and the projected property price, which is 115% of property price. The stores displayed must have START_DATE in the range of 36 months starting from
A. SELECT name, concat (address| | ','| |city| |', ', country) AS full_address,start_date,property_price, property_price*115/100FROM storesWHERE MONTHS_BETWEEN (start_date, '01-JAN-2000')<=36;
B. SELECT name, concat (address| | ','| |city| |', ', country) AS full_address,start_date,property_price, property_price*115/100FROM storesWHERETO_NUMBER(start_date-TO_DATE('01-JAN-2000','DD-MON-RRRR')) <=36;
C. SELECT name, address||','||city||','||country AS full_address,start_date,property_price, property_price*115/100FROM storesWHERE MONTHS_BETWEEN (start_date, TO_DATE('01-JAN-2000','DD-MON-RRRR')) <=36;
D. SELECT name, concat (address||','| |city| |', ', country) AS full_address,start_date,property_price, property_price*115/100FROM storesWHERE MONTHS_BETWEEN (start_date, TO_DATE('01-JAN-2000','DD-MON-RRRR')) <=36;
عرض الإجابة
اجابة صحيحة: C
السؤال #3
Which statement is true about SQL query processing in an Oracle database instance? (Choose the best answer.)
A. During parsing, a SQL statement containing literals in the WHERE clause that has been executed by any session and which is cached in memory, is always reused for the current execution
B. During executing, the oracle server may read data from storage if the required data is not already in memory
C. During row source generation, rows that satisfy the query are retrieved from the database and stored in memory
D. During optimization, execution plans are formulated based on the statistics gathered by the database instance, and the lowest cost plan is selected for execution
عرض الإجابة
اجابة صحيحة: AC
السؤال #4
The user SCOTT who is the owner of ORDERS and ORDER_ITEMS tables issues the following GRANT command: GRANT ALL ON orders, order_items TO PUBLIC; What correction needs to be done to the above statement?
A. PUBLIC should be replaced with specific usernames
B. ALL should be replaced with a list of specific privileges
C. WITH GRANT OPTION should be added to the statement
D. Separate GRANT statements are required for ORDERS and ORDER_ITEMS tables
عرض الإجابة
اجابة صحيحة: D
السؤال #5
Which three statements are true regarding the usage of the WITH clause in complex correlated subqueries: (Choose three.)
A. It can be used only with the SELECT clause
B. The WITH clause can hold more than one query
C. If the query block name and the table name are the same, then the table name takes precedence
D. The query name in the WITH clause is visible to other query blocks in the WITH clause as well as to the main query block
عرض الإجابة
اجابة صحيحة: ACD

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

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

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

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


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