Discussion
Home ‣ Database ‣ Introduction to SQL See What Others Are Saying!
- Question
Find the SQL statement below that is equal to the following: SELECT NAME FROM CUSTOMER WHERE STATE = 'VA';
Options- A. SELECT NAME IN CUSTOMER WHERE STATE IN ('VA');
- B. SELECT NAME IN CUSTOMER WHERE STATE = 'VA';
- C. SELECT NAME IN CUSTOMER WHERE STATE = 'V';
- D. SELECT NAME FROM CUSTOMER WHERE STATE IN ('VA');
- Correct Answer
- SELECT NAME FROM CUSTOMER WHERE STATE IN ('VA');
- 1. An abstraction is a generalization of something.
Options- A. True
- B. False Discuss
- 2. SQL Server AFTER Triggers may be assigned views.
Options- A. True
- B. False Discuss
- 3. 'dbo' stands for database object.
Options- A. True
- B. False Discuss
- 4. SQL is a data sublanguage.
Options- A. True
- B. False Discuss
- 5. Which one of the following symbols is not used in an ERD?
Options- A. Rectangle
- B. Oval
- C. Diamond
- D. Circle Discuss
- 6. Data in operational systems are typically fragmented and inconsistent.
Options- A. True
- B. False Discuss
- 7. VBScript is similar to JavaScript.
Options- A. True
- B. False Discuss
- 8. Successful data warehousing requires that a formal program in total quality management (TQM) be implemented.
Options- A. True
- B. False Discuss
- 9. The HAVING clause acts like a WHERE clause, but it identifies groups that meet a criterion, rather than rows.
Options- A. True
- B. False Discuss
- 10. The source of the data is sometimes called the system of record.
Options- A. True
- B. False Discuss
More questions
Correct Answer: True
Correct Answer: False
Correct Answer: False
Correct Answer: True
Correct Answer: Circle
Correct Answer: True
Correct Answer: True
Correct Answer: True
Correct Answer: True
Correct Answer: True
Comments
There are no comments.More in Database:
Programming
Copyright ©CuriousTab. All rights reserved.