Go on. Explore!

lvl 0 • 0 xp

lvl 1

Home Market Decks Interests

Week #9 Quiz - CIST1220-Structured Query Language-SQL

memorize.ai (lvl 286)

(0)

10 cards

()

Section 1

Preview this deck

Which of the following is true? A) Character values are not case-sensitive B) Character strings must be enclosed in double quotation marks C) Date values are enclosed in single quotation marks D) Date values are not format-sensitive

Front

1 / 10

SQL

0.0

0 reviews

5			0
4			0
3			0
2			0
1			0

Active users

All-time users

Favorites

Last updated

4 years ago

Date created

Mar 1, 2020

Cards (10)

Section 1

(10 cards)

Which of the following is true? A) Character values are not case-sensitive B) Character strings must be enclosed in double quotation marks C) Date values are enclosed in single quotation marks D) Date values are not format-sensitive

Front

C) Date values are enclosed in single quotation marks

Back

A(n) ____ is used to indicate how data should relate to a given search condition. A) comparison operator B) logical operator C) search pattern D) criteria

Front

A) comparison operator

Back

Which of the following operators can be used to combine search conditions? A) AND B) = C) IS NOT NULL D) none of the above

Front

A) AND

Back

Search conditions for data contained in non-numeric columns must be enclosed in double quotation marks. A) True B) False

Front

B) False

Back

Which of the following are examples of comparison operators used in the WHERE clause? A) =, >, <, <=, >=, <> B) between _ and _ C) in (..,..,.. ) D) like E) is null F) All of the above

Front

F) All of the above

Back

Which of the following is a valid comparison operator? A) != B) IN C) ^= D) all of the above

Front

D) all of the above

Back

The order in which NULL values appear in the results can be overridden by which of the following keywords? A) NULLS FIRST B) NULLS LAST C) NSEQ D) both a and b

Front

D) both a and b

Back

Retrieving only specific rows from a table is a process known as selection. A) True B) False

Front

A) True

Back

An ORDER BY clause can reference a column to be used for sorting based upon its position in the database table. A) True B) False

Front

B) False

Back

Based upon the contents of the BOOKS table in the accompanying figure, which of the following queries will display all books stored in the BOOKS table that generate more than 60 percent profit? A) SELECT * FROM books WHERE profit > .6; B) SELECT * FROM books WHERE (retail-cost)/cost > .60; C) SELECT * FROM books WHERE (retail-cost)/cost > 60%; D) SELECT * FROM books WHERE (retail-cost)/cost > '60';

Front

B) SELECT * FROM books WHERE (retail-cost)/cost > .60;

Back

Week #9 Quiz - CIST1220-Structured Query Language-SQL

Preview this deck

Which of the following is true? A) Character values are not case-sensitive B) Character strings must be enclosed in double quotation marks C) Date values are enclosed in single quotation marks D) Date values are not format-sensitive

0.0

Cards (10)

Which of the following is true? A) Character values are not case-sensitive B) Character strings must be enclosed in double quotation marks C) Date values are enclosed in single quotation marks D) Date values are not format-sensitive

C) Date values are enclosed in single quotation marks

A(n) ____ is used to indicate how data should relate to a given search condition. A) comparison operator B) logical operator C) search pattern D) criteria

A) comparison operator

Which of the following operators can be used to combine search conditions? A) AND B) = C) IS NOT NULL D) none of the above

A) AND

Search conditions for data contained in non-numeric columns must be enclosed in double quotation marks. A) True B) False

B) False

Which of the following are examples of comparison operators used in the WHERE clause? A) =, >, <, <=, >=, <> B) between ___ and ___ C) in (..,..,.. ) D) like E) is null F) All of the above

F) All of the above

Which of the following is a valid comparison operator? A) != B) IN C) ^= D) all of the above

D) all of the above

The order in which NULL values appear in the results can be overridden by which of the following keywords? A) NULLS FIRST B) NULLS LAST C) NSEQ D) both a and b

D) both a and b

Retrieving only specific rows from a table is a process known as selection. A) True B) False

A) True

An ORDER BY clause can reference a column to be used for sorting based upon its position in the database table. A) True B) False

B) False

B) SELECT * FROM books WHERE (retail-cost)/cost > .60;

Which of the following are examples of comparison operators used in the WHERE clause? A) =, >, <, <=, >=, <> B) between _ and _ C) in (..,..,.. ) D) like E) is null F) All of the above