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. Because it contains a description of its own structure, a database is considered to be ________ .
Options- A. described
- B. metadata compatible
- C. self-describing
- D. an application program Discuss
- 2. Databases are not the property of a single function or individual within the organization.
Options- A. True
- B. False Discuss
- 3. Data modeling and database design are key responsibilities of data and data base administration.
Options- A. True
- B. False Discuss
- 4. ORDER BY can be combined with the SELECT statements.
Options- A. True
- B. False Discuss
- 5. Which of the following is not a reason that operational data are difficult to read?
Options- A. Non-duplicated data
- B. Dirty data
- C. Missing values
- D. Non-integrated data Discuss
- 6. Data in the data warehouse are loaded and refreshed from operational systems.
Options- A. True
- B. False Discuss
- 7. Oracle allows the ORDER BY clause in view definitions.
Options- A. True
- B. False Discuss
- 8. Relationship classes are associations between entity classes.
Options- A. True
- B. False Discuss
- 9. For every relationship, there are six possible referential integrity actions.
Options- A. True
- B. False Discuss
- 10. The Microsoft Access wildcards are ____ and ____ .
Options- A. asterisk (*); percent sign (%)
- B. percent sign (%); underscore (_)
- C. underscore(_); question mark (?)
- D. question mark (?); asterisk (*) Discuss
More questions
Correct Answer: self-describing
Correct Answer: True
Correct Answer: True
Correct Answer: True
Correct Answer: Non-duplicated data
Correct Answer: True
Correct Answer: True
Correct Answer: True
Correct Answer: True
Correct Answer: question mark (?); asterisk (*)
Comments
There are no comments.More in Database:
Programming
Copyright ©CuriousTab. All rights reserved.