Discussion
Home ‣ Database ‣ Introduction to SQL Comments
- Question
You can add a row using SQL in a database with which of the following?
Options- A. ADD
- B. CREATE
- C. INSERT
- D. MAKE
- Correct Answer
- INSERT
- 1. 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
- 2. ________ was adopted as a national standard by ANSI in 1992.
Options- A. Oracle
- B. SQL
- C. Microsoft Access
- D. DBase Discuss
- 3. The command to remove rows from a table 'CUSTOMER' is:
Options- A. REMOVE FROM CUSTOMER ...
- B. DROP FROM CUSTOMER ...
- C. DELETE FROM CUSTOMER WHERE ...
- D. UPDATE FROM CUSTOMER ... Discuss
- 4. When three or more AND and OR conditions are combined, it is easier to use the SQL keyword(s):
Options- A. LIKE only.
- B. IN only.
- C. NOT IN only.
- D. Both IN and NOT IN. Discuss
- 5. The SQL keyword BETWEEN is used:
Options- A. for ranges.
- B. to limit the columns displayed.
- C. as a wildcard.
- D. None of the above is correct. Discuss
- 6. Which one of the following sorts rows in SQL?
Options- A. SORT BY
- B. ALIGN BY
- C. ORDER BY
- D. GROUP BY Discuss
- 7. 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
- 8. 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
- 9. 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. Discuss
- 10. Read-only databases are ________ updated.
Options- A. always
- B. commonly
- C. seldom
- D. never Discuss
Introduction to SQL problems
Search Results
Correct Answer: limits the row data are returned.
Correct Answer: SQL
Correct Answer: DELETE FROM CUSTOMER WHERE ...
Correct Answer: Both IN and NOT IN.
Correct Answer: for ranges.
Correct Answer: ORDER BY
Correct Answer: All of the above can be done by SQL.
Correct Answer: SELECT
Correct Answer: All of the above.
Correct Answer: never
Comments
There are no comments.More in Database:
Programming
Copyright ©CuriousTab. All rights reserved.