Question 3 3.6 points Save A database language enables the user to perform complex queries designed.

Question 3 3.6 points Save

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

True

False

Question 4 3.6 points Save

Which query will output the table contents when the value of V_CODE is equal to 21344?

SELECT P_DESCRIPT, P_INDATE, P_PRICE, V_CODE

FROM PRODUCT

WHERE V_CODE <> 21344;

SELECT P_DESCRIPT, P_INDATE, P_PRICE, V_CODE

FROM PRODUCT

WHERE V_CODE

SELECT P_DESCRIPT, P_INDATE, P_PRICE, V_CODE

FROM PRODUCT

WHERE V_CODE = 21344;

SELECT P_DESCRIPT, P_INDATE, P_PRICE, V_CODE

FROM PRODUCT

WHERE V_CODE => 21344;

Question 5 3.6 points Save

SQL requires the use of the ADD command to enter data into a table.

True

False

Question 6 3.6 points Save

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

Question 7 3.6 points Save

Which query will use the given columns and column aliases from the PRODUCT table to determine the total value of inventory held on hand and display the results in acolumn labeled TOTVALUE?

SELECT P_DESCRIPT, P_QOH, P_PRICE, P_QOH*P_PRICE AS TOTVALUE

FROM PRODUCT;

SELECT P_DESCRIPT, P_QOH, P_PRICE, P_QOH=P_PRICE AS TOTVALUE

FROM PRODUCT;

SELECT P_DESCRIPT, P_QOH, P_PRICE, P_QOH/P_PRICE AS TOTVALUE

FROM PRODUCT;

SELECT P_DESCRIPT, P_QOH, P_PRICE, P_QOH-P_PRICE AS TOTVALUE

FROM PRODUCT;

Question 8 3.6 points Save

Since computers identify all characters by their numeric codes, mathematical operators cannot be used to place restrictions on character-based attributes.

True

False

Question 9 3.6 points Save

The ____ command would be used to delete the table row where the P_CODE is &#39;BRT-345&#39;.

DELETE FROM PRODUCT

WHERE P_CODE = &#39;BRT-345&#39;;

REMOVE FROM PRODUCT

WHERE P_CODE = &#39;BRT-345&#39;;

ERASE FROM PRODUCT

WHERE P_CODE = &#39;BRT-345&#39;;

ROLLBACK FROM PRODUCT

WHERE P_CODE = &#39;BRT-345&#39;;

Question 10 3.6 points Save

The ____ special operator is used to check whether an attribute value is null.

BETWEEN

IS NULL

LIKE

IN

Question 11 3.6 points Save

The query used to list the P_CODE, P_DESCRIPT, P_INDATE, and P_PRICE fields from the PRODUCT table in ascending order by P_PRICE is ____.

SELECT P_CODE, P_DESCRIPT, P_INDATE, P_PRICE

FROM PRODUCT

SEQUENCE BY P_PRICE;

SELECT P_CODE, P_DESCRIPT, P_INDATE, P_PRICE

FROM PRODUCT

LIST BY P_PRICE;

SELECT P_CODE, P_DESCRIPT, P_INDATE, P_PRICE

FROM PRODUCT

ORDER BY P_PRICE;

SELECT P_CODE, P_DESCRIPT, P_INDATE, P_PRICE

FROM PRODUCT

ASCENDING BY P_PRICE;

Question 12 3.6 points Save

To list the contents of a table, you must use the DISPLAY command.

True

False

Question 13 3.6 points Save

All SQL commands must be issued on a single line.

True

False

Question 14 3.6 points Save

PL/SQL blocks have a section used to declare variables.

True

False

Question 15 3.6 points Save

Assume you are using the UNION ALL operator to combine the results from two tables with identical structure, CUSTOMER and CUSTOMER_2. The CUSTOMER table contains 10rows, while the CUSTOMER_2 table contains 7 rows. Customers Dunne and Olowski are included in the CUSTOMER table as well as in the CUSTOMER_2 table. How many recordsare returned when using the UNION ALL operator?

7

10

15

17

Question 16 3.6 points Save

The Oracle ____ function compares an attribute or expression with a series of values and returns an associated value or a default value if no match is found.

NVL

TO_CHAR

DECODE

CONVERT

Question 17 3.6 points Save

One of the disadvantages of stored procedures is that they increase network traffic.

True

False

Question 18 3.6 points Save

Cursors are held in a reserved memory area in the client computer.

True

False

Question 19 3.6 points Save

PL/SQL functions are executed in the same way as functions such as MIN and AVG.

True

False

Question 20 3.6 points Save

Assume you are using the INTERSECT operator to combine the results from two tables with identical structure, CUSTOMER and CUSTOMER_2. The CUSTOMER table contains 10rows, while the CUSTOMER_2 table contains 7 rows. Customers Dunne and Olowski are included in the CUSTOMER table as well as in the CUSTOMER_2 table. How many recordsare returned when using the INTERSECT operator?

0

2

7

10

Question 21 3.6 points Save

The ____ data type is compatible with NUMBER.

VARCHAR(15)

SMALLINT

DATE

CHAR(10)

Question 22 3.6 points Save

The most useful feature of PL/SQL blocks is that they let you create code that can be named, stored, and executed by the DBMS.

True

False

Question 23 3.6 points Save

The ____ operator could be used in place of MINUS if the RDBMS does not support it.

IN

NOT IN

AND

UNION

Question 24 3.6 points Save

The syntax for the UNION query is ____.

query + query

UNION (query, query)

UNION: query query

query UNION query

Question 25 3.6 points Save

One of the major advantages of stored procedures is that they can be used to encapsulate and represent business transactions.

True

False

Question 26 3.6 points Save

In Oracle, you can use the SQL*Plus command SHOW ERRORS to help you diagnose errors found in PL/SQL blocks.

True

False

Question 27 3.6 points Save

Repeating groups must be eliminated by making sure that each row defines a single entity.

True

False

Question 28 3.6 points Save

Atomic attributes are attributes that can be further divided.

True

False

Question 29 3.6 points Save

Most designers consider the BCNF as a special case of the ____.

1NF

2NF

3NF

4NF

Question 30 3.6 points Save

A table where every determinant is a candidate key is said to be in ____.

BCNF

2NF

3NF

4NF

Question 31 3.6 points Save

Before converting a table into 3NF, it is imperative the table already be in ____.

1NF

2NF

4NF

BCNF

Question 32 3.6 points Save

A table is in BCNF if every determinant in the table is a foreign key.

True

False

Question 33 3.6 points Save

1NF, 2NF, and 3NF are ____.

normalization stages

anomalies

repeating groups

atomic attributes

Question 34 3.6 points Save

Relational models view the data as part of a table or collection of tables in which all key values must be identified.

True

False

Question 35 3.6 points Save

The conflicts between design efficiency, information requirements, and processing speed are often resolved through ____.

conversion from 1NF to 2NF

conversion from 2NF to 3NF

compromises that include denormalization

conversion from 3NF to 4NF

Question 36 3.6 points Save

Normalization represents a micro view of the ____ within the ERD.

entities

attributes

relationships

forms

Question 37 3.6 points Save

If you have three different transitive dependencies, ____ different determinant(s) exist.

one

two

three

four

Question 38 3.6 points Save

Dependencies that are based on only a part of a composite primary key are called transitive dependencies.

True

False

Question 39 3.6 points Save

An entity cluster is a “virtual” entity type used to represent multiple entities and relationships in the ERD.

True

False

Question 40 3.6 points Save

The “____” characteristic of a primary key states that:

The selected primary key must not be composed of any attribute(s) that might be considered a security risk or violation. For example, using a Social Security number asa PK in an EMPLOYEE table is not a good idea.

unique values

nonintelligent

preferably single-attribute

security compliant

Question 41 3.6 points Save

The property of subtype discriminator enables an entity supertype to inherit the attributes and relationships of the subtype.

True

False

Question 42 3.6 points Save

Specialization is the top-down process of identifying lower-level, more specific entity subtypes from a higher-level entity supertype.

True

False

Question 43 3.6 points Save

An entity supertype can have disjoint or overlapping entity subtypes.

True

False

Question 44 3.6 points Save

____ is a generic entity type that is related to one or more entity subtypes.

A subtype discriminator

Inheritance

A specialization hierarchy

An entity supertype

Question 45 3.6 points Save

Composite primary keys are particularly useful as identifiers of composite entities, where each primary key combination is allowed only once in the ____relationship.

0:1

1:1

1:M

M:N

Question 46 3.6 points Save

Some designs use redundant relationships as a way to simplify the design.

True

False

Question 47 3.6 points Save

The most important characteristic of an entity is its ____ key, used to uniquely identify each entity instance.

primary

natural

foreign

surrogate

Question 48 3.6 points Save

____ is the bottom-up process of identifying a higher-level, more generic entity supertype from lower-level entity subtypes.

Specialization

Generalization

Partial completeness

Total completeness

Question 49 3.6 points Save

The primary key&#39;s main function is to uniquely identify a(n) ____ within a table.

attribute

entity instance or row

entity subtype

natural identifier

Question 50 3.6 points Save

The extended entity relationship model (EERM) is sometimes referred to as the ____.

entity relationship model

enhanced entity relationship model

entity clustering relationship model

extended entity relationship diagram

 

Do you need a similar assignment done for you from scratch? We have qualified writers to help you. We assure you an A+ quality paper that is free from plagiarism. Order now for an Amazing Discount!
Use Discount Code “Newclient” for a 15% Discount!

NB: We do not resell papers. Upon ordering, we do an original paper exclusively for you.

The post Question 3 3.6 points Save A database language enables the user to perform complex queries designed. appeared first on Affordable Nursing Writers.