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

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

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

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

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

خذ اختبارات أخرى عبر الإنترنت
السؤال #1
Evaluate the following two queries: SQL> SELECT cust_last_name, cust_city FROM customers WHERE cust_credit_limit IN (1000, 2000, 3000); SQL> SELECT cust_last_name, cust_city FROM customers WHERE cust_credit_limit = 1000 or cust_credit_limit = 2000 or cust_credit_limit = 3000 Which statement is true regarding the above two queries?
A. Performance would improve in query 2 only if there are null values in the CUST_CREDIT_LIMIT column
B. There would be no change in performance
C. Performance would degrade in query 2
D. Performance would improve in query 2
عرض الإجابة
اجابة صحيحة: B
السؤال #2
Which two statements are true regarding single row functions? (Choose two.)
A. MOD : returns the quotient of a division
B. TRUNC : can be used with NUMBER and DATE values
C. CONCAT : can be used to combine any number of values
D. SYSDATE : returns the database server current date and time
E. INSTR : can be used to find only the first occurrence of a character in a string
F. TRIM : can be used to remove all the occurrences of a character from a string
عرض الإجابة
اجابة صحيحة: C
السؤال #3
Which three statements are true about the ALTER TABLE....DROP COLUMN.... command?
A. A column can be dropped only if it does not contain any data
B. A column can be dropped only if another column exists in the table
C. A dropped column can be rolled back
D. The column in a composite PRIMARY KEY with the CASCADE option can be dropped
E. A parent key column in the table cannot be dropped
عرض الإجابة
اجابة صحيحة: D
السؤال #4
Examine the structure of the CUSTOMERS table: (Choose two.) CUSTNO is the PRIMARY KEY. You must determine if any customers' details have been entered more than once using a different CUSTNO, by listing all duplicate names. Which two methods can you use to get the required result?
A. Subquery
B. Self-join
C. Full outer-join with self-join
D. Left outer-join with self-join
E. Right outer-join with self-join
عرض الإجابة
اجابة صحيحة: A
السؤال #5
Examine the SQL statement used to create the TRANSACTION table. (Choose the best answer.) SQL > CREATE TABLE transaction (trn_id char(2) primary key, Start_date date DEFAULT SYSDATE, End_date date NOT NULL); The value 'A1' does not exist for trn_id in this table. Which SQL statement successfully inserts a row into the table with the default value for START_DATE?
A. INSERT INTO transaction VALUES ('A1', DEFAULT, TO_DATE(DEFAULT+10))
B. INSERT INTO transaction VALUES ('A1', DEFAULT, TO_DATE('SYSDATE+10'))
C. INSERT INTO transaction (trn_id, end_date) VALUES ('A1', '10-DEC-2014')
D. INSERT INTO transaction (trn_id, start_date, end_date) VALUES ('A1', , '10-DEC-2014')
عرض الإجابة
اجابة صحيحة: B
السؤال #6
View the Exhibit and examine the structure of the EMPLOYEES table. You want to display all employees and their managers having 100 as the MANAGER_ID. You want the output in two columns: the first column would have the LAST_NAME of the managers and the second column would have LAST_NAME of the employees. Which SQL statement would you execute?
A. SELECT m
B. SELECT m
C. SELECT m
D. SELECT m
عرض الإجابة
اجابة صحيحة: D
السؤال #7
You execute the SQL statement: SQL> CREATE TABLE citizens (citizen_id CHAR (10) PRIMARY KEY, last_name VARCHAR2 (50) NOT NULL, first_name VARCHAR2 (50), address VARCHAR2 (100), city VARCHAR2 (30) DEFAULT ‘SEATTLE’ NOT NULL, CONSTRAINT cnames CHECK (first_name<>last_name) ); What is the outcome?
A. It fails because the NOT NULL and DEFAULT options cannot be combined for the same column
B. It succeeds and CITY can contain only ‘SEATTLE’ or null for all rows
C. It fails because the condition for the CANAMES constraint is not valid
D. It succeeds and an index is crated for CITIZEN_ID
عرض الإجابة
اجابة صحيحة: C
السؤال #8
View the exhibit and examine the structure of the CUSTOMERS table. Which two tasks would require subqueries or joins to be executed in a single statement?
A. finding the number of customers, in each city, whose credit limit is more than the average credit limit of all the customers
B. finding the average credit limit of male customers residing in 'Tokyo' or 'Sydney'
C. listing of customers who do not have a credit limit and were born before 1980
D. finding the number of customers, in each city, who’s marital status is 'married'
E. listing of those customers, whose credit limit is the same as the credit limit of customers residing in the city 'Tokyo'
عرض الإجابة
اجابة صحيحة: AE
السؤال #9
The first DROP operation is performed on PRODUCTS table using the following command: DROP TABLE products PURGE; Then you performed the FLASHBACK operation by using the following command: FLASHBACK TABLE products TO BEFORE DROP; Which statement describes the outcome of the FLASHBACK command?
A. It recovers only the table structure
B. It recovers the table structure, data, and the indexes
C. It recovers the table structure and data but not the related indexes
D. It is not possible to recover the table structure, data, or the related indexes
عرض الإجابة
اجابة صحيحة: ABD
السؤال #10
Which three statements are true regarding group functions? (Choose three.)
A. They can be used on columns or expressions
B. They can be passed as an argument to another group function
C. They can be used only with a SQL statement that has the GROUP BY clause
D. They can be used on only one column in the SELECT clause of a SQL statement
E. They can be used along with the single-row function in the SELECT clause of a SQL statement
عرض الإجابة
اجابة صحيحة: C

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

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

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

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


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