DAT 380 Wk 4 - Practice: Knowledge Check | eBooks | Education

DAT 380 Wk 4 - Practice: Knowledge Check

DAT 380 Wk 4 - Practice: Knowledge Check PLDZ-12794
In Stock
$ 5.00 USD
Buy and Download   > Description

***************************************************************

Click Here To Download Your Files :   

https://uopcourse.com/category/dat-380/ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

You can buy more tutorials from the below link

https://uopcourse.com/

***************************************************************

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.

*************************************************************** Click Here To Download Your Files : https://uopcourse.com/category/dat-380/ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ You can buy more tutorials from the below link https:
Recent Reviews Write a Review
0 0 0 0 reviews