Which statement is true about TRUNCATE and DELETE?

• A.You can never DELETE rows from a table if foreign key constraints will be violated.
• B.For tables with multiple indexes and triggers DELETE is faster than TRUNCATE.
• C.For large tables TRUNCATE is faster than DELETE.
• D.You can never TRUNCATE a table if foreign key constraints will be violated.

Comment: *

Name: *

Email: *

Verification: *

Which normal form is a table in 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

Comment: *

Name: *

Email: *

Verification: *

Which two statements are true about single row functions?

• A.FLOOR : returns the smallest integer greater than or equal to a specified number
• B.TRUNC : can be used with number and date values
• C.mod : returns the quotient of a division operation
• D.ceil : can be used for positive and negative numbers
• E.CONCAT : can be used to combine any number of values

Comment: *

Name: *

Email: *

Verification: *

You must write a query that prompts users for column names and conditions every time it is executed.
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, &col2FROM "&table"WHERE &condition = &cond;
• C.SELECT &col1, &col2FROM &&tableWHERE &condition = &cond;
• D.SELECT &col1, &col2FROM &&tableWHERE &condition = &&cond

Comment: *

Name: *

Email: *

Verification: *

View the Exhibit and examine the data in the PRODUCTS table.

Which statement would add a column called PRICE, which cannot contain NULL?

• A.ALTER TABLE productsADD price NUMBER(8,2) DEFAULT CONSTRAINT p_nn NOT NULL.
• B.ALTER TABLE productsADD price NUMBER(8,2) NOT NULL;
• C.ALTER TABLE productsADD price NUMBER(8,2) DEFAULT NOT NULL;
• D.ALTER TABLE productsADD price NUMBER(8,2) DEFAULT 0 NOT NULL;

Comment: *

Name: *

Email: *

Verification: *