 |
1 | |
Which of the following rules states that a database must not contain any unmatched foreign keys? |
| | A) | entity integrity |
| | B) | database integrity |
| | C) | referential integrity |
| | D) | key integrity |
| | E) | field integrity |
|
|
2 | |
Which of the following is false for a many-to-many relationship between two tables? |
| | A) | The connecting table contains the primary key fields of the original tables. |
| | B) | The two tables should have a one-to-many relationship to the connecting table. |
| | C) | The connecting table should have a one-to-one relationship with the other two. |
| | D) | both A and B are false statements |
| | E) | A, B, and C are all true statements |
|
|
3 | |
Which of the following SQL commands will specify the tables to be used? |
| | A) | SELECT |
| | B) | WHERE |
| | C) | ORDER BY |
| | D) | FROM |
| | E) | AS |
|
|
4 | |
For a selected query in the Design view, which of the following will display the five cheapest products? The field name for the product's prices is PRICE. |
| | A) | choose descending for sort order for PRICE, click  <![CDATA[<a onClick="window.open('/olcweb/cgi/pluginpop.cgi?it=jpg::::/sites/dl/free/0072834277/138125/ai_07mc_4_all.jpg','popWin', 'width=NaN,height=NaN,resizable,scrollbars');" href="#"><img valign="absmiddle" height="16" width="16" border="0" src="/olcweb/styles/shared/linkicons/image.gif"> (14.0K)</a>]]> , select 5 |
| | B) | choose ascending for sort order for PRICE, click <![CDATA[<a onClick="window.open('/olcweb/cgi/pluginpop.cgi?it=jpg::::/sites/dl/free/0072834277/138125/ai_07mc_4_all.jpg','popWin', 'width=NaN,height=NaN,resizable,scrollbars');" href="#"><img valign="absmiddle" height="16" width="16" border="0" src="/olcweb/styles/shared/linkicons/image.gif"> (14.0K)</a>]]> , select 5 |
| | C) | choose descending for sort order for PRICE, click <![CDATA[<a onClick="window.open('/olcweb/cgi/pluginpop.cgi?it=jpg::::/sites/dl/free/0072834277/138125/ai_07mc_4_all.jpg','popWin', 'width=NaN,height=NaN,resizable,scrollbars');" href="#"><img valign="absmiddle" height="16" width="16" border="0" src="/olcweb/styles/shared/linkicons/image.gif"> (14.0K)</a>]]> , select 5% |
| | D) | choose ascending for sort order for PRICE, click <![CDATA[<a onClick="window.open('/olcweb/cgi/pluginpop.cgi?it=jpg::::/sites/dl/free/0072834277/138125/ai_07mc_4_all.jpg','popWin', 'width=NaN,height=NaN,resizable,scrollbars');" href="#"><img valign="absmiddle" height="16" width="16" border="0" src="/olcweb/styles/shared/linkicons/image.gif"> (14.0K)</a>]]> , select 5% |
| | E) | None of these will work |
|
|
5 | |
In creating a query expression, quotation marks, colons, and asterisks would be classified as: |
| | A) | symbols |
| | B) | values |
| | C) | strings |
| | D) | identifiers |
| | E) | operators |
|