Discussion
Home ‣ Database ‣ Introduction to SQL See What Others Are Saying!
- Question
In an SQL SELECT statement querying a single table, according to the SQL-92 standard the asterisk (*) means that:
Options- A. all columns of the table are to be returned.
- B. all records meeting the full criteria are to be returned.
- C. all records with even partial criteria met are to be returned.
- D. None of the above is correct.
- Correct Answer
- all columns of the table are to be returned.
- 1. A updatable view has its own data.
Options- A. True
- B. False Discuss
- 2. Well-structured relations encourage anomalies of data.
Options- A. True
- B. False Discuss
- 3. Entity instances are associated by relationship classes.
Options- A. True
- B. False Discuss
- 4. Composite identifiers consist of two or more attributes.
Options- A. True
- B. False Discuss
- 5. Queries that do full table scans should be avoided.
Options- A. True
- B. False Discuss
- 6. The World Wide Web Consortium (W3C) is the chief standards body for HTTP and HTML.
Options- A. True
- B. False Discuss
- 7. MySQL is pronounced "my See-quel."
Options- A. True
- B. False Discuss
- 8. The data model produced from the reverse engineering process does not include intersection table data.
Options- A. True
- B. False Discuss
- 9. The DBMS ranked as being the "hardest to use" in the text is Microsoft's SQL Server.
Options- A. True
- B. False Discuss
- 10. Three types of triggers are: BEFORE, AFTER and EXCEPTION.
Options- A. True
- B. False Discuss
More questions
Correct Answer: False
Correct Answer: False
Correct Answer: False
Correct Answer: True
Correct Answer: True
Correct Answer: True
Correct Answer: False
Correct Answer: False
Correct Answer: False
Correct Answer: False
Comments
There are no comments.More in Database:
Programming
Copyright ©CuriousTab. All rights reserved.