FiltersDone

Question type

Essay

Multiple Choice

Short Answer

True False

Matching

Exam 7: Introduction to Structured Query Language SQL

Show Answer

Share

---

All types

Filters

Study FlashcardsPractice ExamLearn

Question 1

Multiple Choice

Review LaterAdd Note

Review Later

Which of the following queries will list all the rows in which the inventory stock dates occur on or after January 20,2016?

A) SELECT P_DESCRIPT,P_QOH,P_MIN,P_PRICE,P_INDATE FROM PRODUCT WHERE P_INDATE >= '20-JAN-2016';
B) SELECT P_DESCRIPT,P_QOH,P_MIN,P_PRICE,P_INDATE FROM PRODUCT WHERE P_INDATE >= $20-JAN-2010$;
C) SELECT P_DESCRIPT,P_QOH,P_MIN,P_PRICE,P_INDATE FROM PRODUCT WHERE P_INDATE <= '20-JAN-2010';
D) SELECT P_DESCRIPT,P_QOH,P_MIN,P_PRICE,P_INDATE FROM PRODUCT WHERE P_INDATE >= {20-JAN-2010};

E) None of the above
F) B) and C)

Correct Answer

verified

Show Answer

Question 2

Short Answer

Review LaterAdd Note

Review Later

An alias is especially useful when a table must be joined to itself in a(n)query.

Correct Answer

verified

Show Answer

Question 3

True/False

Review LaterAdd Note

Entity integrity is enforced automatically when the primary key is specified in the CREATE TABLE command sequence.

DATE()and SYSDATE are special functions that return today's date in MS Access and ,respectively.

An alias cannot be used when a table is required to be joined to itself in a recursive query.

In a 1:M relationship,a user must always create the table for the side first.

When a user issues the DELETE FROM tablename command without specifying a WHERE condition,.

The SQL aggregate function that gives the number of rows containing non-null values for a given column is .

Which of the following queries 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?

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

The ANSI SQL standards are also accepted by the ISO.

The specification is used to avoid having duplicated values in a column.

Date procedures are often more software-specific than other SQL procedures.

All SQL commands must be issued on a single line.

A common practice is to create a(n)on any field that is used as a search key,in comparison operations in a conditional expression,or when a user wants to list rows in a specific order.

The constraint assigns a value to an attribute when a new row is added to a table.

The conditional LIKE must be used in conjunction with wildcard characters.

String comparisons are made from left to right.

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

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