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

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

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

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

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

خذ اختبارات أخرى عبر الإنترنت
السؤال #1
In which normal form is a table, if it has no multi-valued attributes and no partial dependencies?
A. second normal form
B. first normal form
C. third normal form
D. fourth normal form
عرض الإجابة
اجابة صحيحة: A
السؤال #2
Which two statements are true about sequences crated in a single instance Oracle database?
A. The numbers generated by an explicitly defined sequence can only be used to insert data in one table
B. DELETE would remove a sequence from the database
C. CURRVAL is used to refer to the most recent sequence number that has been generated for a particular sequence
D. When the MAXVALUE limit for a sequence is reached, it can be increased by using the ALTER SEQUENCE statement
E. When the database instance shuts down abnormally, sequence numbers that have been cached but not used are available again when the instance is restarted
عرض الإجابة
اجابة صحيحة: D
السؤال #3
Which statement is true regarding the default behaviour of the ORDER by clause?
A. Numeric values are displayed in descending order if they have decimal positions
B. Only columns that are specified in the SELECT list can be used in the ORDER by clause
C. In a character sort, the values are case-sensitive
D. NULLs are not including in the sort operation
عرض الإجابة
اجابة صحيحة: C
السؤال #4
Examine the structure of the SALES table. (Choose two.) Examine this statement: SQL > CREATE TABLE sales1 (prod_id, cust_id, quantity_sold, price) AS SELECT product_id, customer_id, quantity_sold, price FROM sales WHERE 1 = 2; Which two statements are true about the SALES1 table?
A. It will not be created because the column-specified names in the SELECT and CREATE TABLE clauses do not match
B. It will have NOT NULL constraints on the selected columns which had those constraints in the SALES table
C. It will not be created because of the invalid WHERE clause
D. It is created with no rows
E. It has PRIMARY KEY and UNIQUE constraints on the selected columns which had those constraints in the SALES table
عرض الإجابة
اجابة صحيحة: BC
السؤال #5
The BOOKS_TRANSACTIONS table exists in your database. SQL>SELECT * FROM books_transactions ORDER BY 3; What is the outcome on execution?
A. The execution fails unless the numeral 3 in the ORDER BY clause is replaced by a column name
B. Rows are displayed in the order that they are stored in the table only for the three rows with the lowest values in the key column
C. Rows are displayed in the order that they are stored in the table only for the first three rows
D. Rows are displayed sorted in ascending order of the values in the third column in the table
عرض الإجابة
اجابة صحيحة: C
السؤال #6
View the Exhibit and examine, the description for the SALES and CHANNELS tables. (Choose the best answer.) You issued this SQL statement: INSERT INTO SALES VALUES (23, 2300, SYSDATE, (SELECT CAHNNEL_ID FROM CHANNELS WHERE CHANNEL_DESC='DIRECT SALES'), 12, 1, 500); Which statement is true regarding the result?
A. The statement will fail because the sub-query in the VALUES clause is not enclosed within single quotation marks
B. The statement will fail because a subquery cannot be used in a VALUES clause
C. The statement will execute and a new row will be inserted in the SALES table
D. The statement will fail because the VALUES clause is not required with the subquery
عرض الإجابة
اجابة صحيحة: AC
السؤال #7
View the Exhibit and examine the data in the PRODUCT_INFORMATION table. Which two tasks would require subqueries? (Choose two.)
A. displaying all the products whose minimum list prices are more than average list price of products having the status orderable
B. displaying the total number of products supplied by supplier 102071 and having product status OBSOLETE
C. displaying the number of products whose list prices are more than the average list price
D. displaying all supplier IDs whose average list price is more than 500
E. displaying the minimum list price for each product status
عرض الإجابة
اجابة صحيحة: C
السؤال #8
View and Exhibit and examine the structure and data in the INVOICE table. (Choose two.) Which two statements are true regarding data type conversion in query expressions?
A. inv_date = '15-february-2008' :uses implicit conversion
B. inv_amt = '0255982' : requires explicit conversion
C. inv_date > '01-02-2008' : uses implicit conversion
D. CONCAT(inv_amt, inv_date) : requires explicit conversion
E. inv_no BETWEEN '101' AND '110' : uses implicit conversion
عرض الإجابة
اجابة صحيحة: A
السؤال #9
Examine the create table statements for the stores and sales tables. SQL> CREATE TABLE stores(store_id NUMBER(4) CONSTRAINT store_id_pk PRIMARY KEY, store_name VARCHAR2(12), store_address VARCHAR2(20), start_date DATE); SQL> CREATE TABLE sales(sales_id NUMBER(4) CONSTRAINT sales_id_pk PRIMARY KEY, item_id NUMBER(4), quantity NUMBER(10), sales_date DATE, store_id NUMBER(4), CONSTRAINT store_id_fk FOREIGN KEY(store_id) REFERENCES stores(store_id)); You executed the following statement: SQL> DELETE from stores
A. Disable the primary key in the STORES table
B. Use CASCADE keyword with DELETE statement
C. DELETE the rows with STORE_ID = 900 from the SALES table and then delete rows from STORES table
D. Disable the FOREIGN KEY in SALES table and then delete the rows
E. Create the foreign key in the SALES table on SALES_ID column with on DELETE CASCADE option
عرض الإجابة
اجابة صحيحة: AC
السؤال #10
Which two statements are true regarding the WHERE and HAVING clauses in a SELECT statement? (Choose two.)
A. The WHERE and HAVING clauses can be used in the same statement only if they are applied to different columns in the table
B. The aggregate functions and columns used in the HAVING clause must be specified in the SELECT list of the query
C. The WHERE clause can be used to exclude rows after dividing them into groups
D. The HAVING clause can be used with aggregate functions in subqueries
E. The WHERE clause can be used to exclude rows before dividing them into groups
عرض الإجابة
اجابة صحيحة: BD
السؤال #11
You are designing the structure of a table in which two columns have the specifications: COMPONENT_ID – must be able to contain a maximum of 12 alphanumeric characters and uniquely identify the row EXECUTION_DATETIME – contains Century, Year, Month, Day, Hour, Minute, Second to the maximum precision and is used for calculations and comparisons between components. Which two options define the data types that satisfy these requirements most efficiently?
A. The EXECUTION_DATETIME must be of INTERVAL DAY TO SECOND data type
B. The EXECUTION_DATETIME must be of TIMESTAMP data type
C. The EXECUTION_DATETIME must be of DATE data type
D. The COMPONENT_ID must be of ROWID data type
E. The COMPONENT_ID must be of VARCHAR2 data type
F. The COMPONENT_ID column must be of CHAR data type
عرض الإجابة
اجابة صحيحة: CF

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

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

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

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


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