Discussion
Home ‣ Database ‣ Introduction to SQL Comments
- Question
Which of the following is the original purpose of SQL?
Options- A. To specify the syntax and semantics of SQL data definition language
- B. To specify the syntax and semantics of SQL manipulation language
- C. To define the data structures
- D. All of the above.
- Correct Answer
- All of the above.
- 1. The SQL statement that queries or reads data from a table is ________ .
Options- A. SELECT
- B. READ
- C. QUERY
- D. None of the above is correct. Discuss
- 2. SQL can be used to:
Options- A. create database structures only.
- B. query database data only.
- C. modify database data only.
- D. All of the above can be done by SQL. Discuss
- 3. Which one of the following sorts rows in SQL?
Options- A. SORT BY
- B. ALIGN BY
- C. ORDER BY
- D. GROUP BY Discuss
- 4. You can add a row using SQL in a database with which of the following?
Options- A. ADD
- B. CREATE
- C. INSERT
- D. MAKE Discuss
- 5. The SQL WHERE clause:
Options- A. limits the column data that are returned.
- B. limits the row data are returned.
- C. Both A and B are correct.
- D. Neither A nor B are correct. Discuss
- 6. Read-only databases are ________ updated.
Options- A. always
- B. commonly
- C. seldom
- D. never Discuss
- 7. Each answer below shows example data from a table. Which answer is an example of the inconsistent values problem?
Options- A. Three columns have the values 534-2435, 534-7867, and 546-2356 in the same row.
- B. Three rows have the values Brown Small Chair, Small Chair Brown, and Small Brown Chair in the same column.
- C. Three rows have the values Brown, NULL, and Blue in the same column.
- D. One row has the value "He is interested in a Silver Porsche from the years 1978-1988" in a column. Discuss
- 8. Needing to using more complicated SQL in database applications is a(n) ________ of normalization.
Options- A. advantage
- B. disadvantage
- C. either an advantage or disadvantage
- D. neither an advantage nor disadvantage Discuss
- 9. Normalization ________ data duplication.
Options- A. eliminates
- B. reduces
- C. increases
- D. maximizes Discuss
- 10. When assessing the table structure of an acquired set of tables with data, determining primary keys is (part of) the:
Options- A. first step.
- B. second step.
- C. third step.
- D. fourth step. Discuss
Introduction to SQL problems
Search Results
Correct Answer: SELECT
Correct Answer: All of the above can be done by SQL.
Correct Answer: ORDER BY
Correct Answer: INSERT
Correct Answer: limits the row data are returned.
Correct Answer: never
Correct Answer: Three rows have the values Brown Small Chair, Small Chair Brown, and Small Brown Chair in the same column.
Correct Answer: disadvantage
Correct Answer: eliminates
Correct Answer: second step.
Comments
There are no comments.More in Database:
Programming
Copyright ©CuriousTab. All rights reserved.