DAT 380 Wk 4 - Practice: Knowledge Check

Click Here To Download Your Files :

http://www.onlinehelp123.com/dat-380

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

You can buy more tutorials from the below link

http://www.onlinehelp123.com/dat-380

DAT 380 Wk 4 - Practice: Knowledge Check

The special operator used to check whether a subquery returns any rows is _____.

•      IN
•      EXISTS
•      BETWEEN
•      LIKE

ANSI-standard SQL allows the use of special operators in conjunction with the WHERE clause.

•      True
•      False

You can select partial table contents by naming the desired fields and by placing restrictions on the rows to be included in the output.

•      True
•      False

A database language enables the user to perform complex queries designed to transform the raw data into useful information.

•      True
•      False

Which query is used to list a unique value for V_CODE, where the list will produce only a list of those values that are different from one another?

•      SELECT UNIQUE V_CODE

FROM PRODUCT;

•      SELECT DISTINCT V_CODE

FROM PRODUCT;

•      SELECT DIFFERENT V_CODE

FROM PRODUCT;

•      SELECT ONLY V_CODE

FROM PRODUCT;

In Oracle, _____ make(s) it possible to merge SQL and traditional programming constructs, such as variables, conditional processing (IF-THEN-ELSE), basic loops (FOR and WHILE loops,) and error trapping.

•      Procedural Language SQL
•      embedded SQL
•      dynamic SQL
•      stored procedures

All changes in a table structure are made using the _____ TABLE command, followed by a keyword that produces the specific changes a user wants to make.

•      ALTER
•      UPDATE
•      ROLLBACK
•      COMMIT

The _____ constraint is used to validate data when an attribute value is entered.

•      UNIQUE
•      CASCADE
•      SET NULL
•      CHECK

_____ is a relational set operator.

•      EXISTS
•      ALL
•      PLUS
•      EXCEPT

The SQL data manipulation command HAVING:

•      restricts the selection of grouped rows based on a condition.
•      modifies an attribute's values in one or more table's rows.
•      groups the selected rows based on one or more attributes.
•      restricts the selection of rows based on a conditional expression.