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

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

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

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

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

خذ اختبارات أخرى عبر الإنترنت
السؤال #1
Which statement is true regarding the default behavior of the ORDER BY clause?
A. In a character sort, the values are case-sensitive
B. NULL values are not considered at all by the sort operation
C. Only those columns that are specified in the SELECT list can be used in the ORDER BY clause
D. Numeric values are displayed from the maximum to the minimum value if they have decimal positions
عرض الإجابة
اجابة صحيحة: B
السؤال #2
Which three statements are true regarding the SQL WHERE and HAVING clauses?
A. The HAVING clause conditions can have aggregating functions
B. The HAVING clause conditions can use aliases for the columns
C. The WHERE and HAVING clauses cannot be used together in a SQL statement
D. The WHERE clause is used to exclude rows before grouping data
E. The HAVING clause is used to exclude one or more aggregated results after grouping data
عرض الإجابة
اجابة صحيحة: AD
السؤال #3
Evaluate the following SQL statements that are issued in the given order: CREATE TABLE emp (emp_no NUMBER(2) CONSTRAINT emp_emp_no_pk PRIMARY KEY, ename VARCHAR2(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 would be the status of the foreign key EMP_MGR_PK?
A. It would remain disabled and can be enabled only by dropping the foreign key constraint and recreating it
B. It would remain disabled and has to be enabled manually using the ALTER TABLE command
C. It would be automatically enabled and immediate
D. It would be automatically enabled and deferred
عرض الإجابة
اجابة صحيحة: B
السؤال #4
View the exhibits and examine the structures of the COSTS and PROMOTIONS tables. Evaluate the following SQL statement: SQL> SELECT prod_id FROM costs WHERE promo_id IN (SELECT promo_id FROM promotions WHERE promo_cost < ALL (SELECT MAX(promo_cost) FROM promotions GROUP BY (promo_end_date- promo_begin_date))); What would be the outcome of the above SQL statement?
A. It displays prod IDs in the promo with the lowest cost
B. It displays prod IDs in the promos with the lowest cost in the same time interval
C. It displays prod IDs in the promos with the highest cost in the same time interval
D. It displays prod IDs in the promos which cost less than the highest cost in the same time interval
عرض الإجابة
اجابة صحيحة: A
السؤال #5
You must write a query that prompts users for column names and conditions every time it is executed. (Choose the best answer.) The user must be prompted only once for the table name. Which statement achieves those objectives?
A. SELECT &col1, '&col2'FROM &tableWHERE &&condition = '&cond';
B. SELECT &col1, &col2 FROM "&table"WHERE &condition =&cond;
C. SELECT &col1, &col2 FROM &&tableWHERE &condition = &cond;
D. SELECT &col1, &col2 FROM &&tableWHERE &condition = &&cond
عرض الإجابة
اجابة صحيحة: C
السؤال #6
You issued the following command: SQL> DROP TABLE employees; Which three statements are true?
A. All uncommitted transactions are committed
B. All indexes and constraints defined on the table being dropped are also dropped
C. Sequences used in the employees table become invalid
D. The space used by the employees table is reclaimed immediately
E. The employees table can be recovered using the rollback command
F. The employees table is moved to the recycle bin
عرض الإجابة
اجابة صحيحة: CD
السؤال #7
Which three tasks can be performed using SQL functions built into Oracle Database?
A. displaying a date in a nondefault format
B. finding the number of characters in an expression
C. substituting a character string in a text expression with a specified string
D. combining more than two columns or expressions into a single column in the output
عرض الإجابة
اجابة صحيحة: D
السؤال #8
You must create a SALES table with these column specifications and data types: (Choose the best answer.) SALESID: Number STOREID: Number ITEMID: Number QTY: Number, should be set to 1 when no value is specified SLSDATE: Date, should be set to current date when no value is specified PAYMENT: Characters up to 30 characters, should be set to CASH when no value is specified Which statement would create the table?
A. CREATE TABLE Sales(SALESID NUMBER (4),STOREID NUMBER (4),ITEMID NUMBER (4),QTY NUMBER DEFAULT = 1,SLSDATE DATE DEFAULT SYSDATE,PAYMENT VARCHAR2(30) DEFAULT = "CASH");
B. CREATE TABLE Sales(SALESID NUMBER (4),STOREID NUMBER (4),ITEMID NUMBER (4),QTY NUMBER DEFAULT = 1,SLSDATE DATE DEFAULT 'SYSDATE',PAYMENT VARCHAR2(30) DEFAULT CASH);
C. CREATE TABLE Sales(SALESID NUMBER (4),STOREID NUMBER (4),ITEMID NUMBER (4),qty NUMBER DEFAULT = 1,SLSDATE DATE DEFAULT SYSDATE,PAYMENT VARCHAR2(30) DEFAULT = "CASH");
D. Create Table sales(salesid NUMBER (4),Storeid NUMBER (4),Itemid NUMBER (4),QTY NUMBER DEFAULT 1,Slsdate DATE DEFAULT SYSDATE,payment VARCHAR2(30) DEFAULT 'CASH');
عرض الإجابة
اجابة صحيحة: A
السؤال #9
Which task can be performed by using a single Data Manipulation Language (DML) statement?
A. adding a column constraint when inserting a row into a table
B. adding a column with a default value when inserting a row into a table
C. removing all data only from one single column on which a unique constraint is defined
D. removing all data only from one single column on which a primary key constraint is defined
عرض الإجابة
اجابة صحيحة: ADE
السؤال #10
Evaluate the following CRTEATE TABLE commands: CREATE_TABLE orders (ord_no NUMBER (2) CONSTRAINT ord_pk PRIMARY KEY, ord_date DATE, cust_id NUMBER (4) ); CREATE TABLE ord_items (ord _no NUMBER (2), item_no NUMBER(3), qty NUMBER (3) CHECK (qty BETWEEEN 100 AND 200), expiry_date date CHECK (expiry_date> SYSDATE), CONSTRAINT it_pk PRIMARY KEY (ord_no, item_no), CONSTARAINT ord_fk FOREIGN KEY (ord_no) REFERENCES orders (ord_no) ); Why would the ORD_ITEMS table not get created?
A. SYSDATE cannot be used with the CHECK constraint
B. The BETWEEN clause cannot be used for the CHECK constraint
C. The CHECK constraint cannot be placed on columns having the DATE data type
D. ORD_NO and ITEM_NO cannot be used as a composite primary key because ORD_NO is also the FOREIGN KEY
عرض الإجابة
اجابة صحيحة: ABC

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

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

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

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


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