Answer Key Section 1 Quiz Oracle Database Programming with SQL

Test: Section 1 Quiz Review your answers, feedback, and question scores below. An asterisk (*) indicates a correct answer. Section 1 Quiz (Answer all questions in this section) 1. What language is used to query data in a Relational Database?

Mark for Review (1) Points

SQL (*) Java C++ BASIC Correct 2. A Relational Database generally contains two or more tables. True or False?


True (*) False Correct 3. Most of the well know Internet search engines use databases to store data. True or False?


True (*) False Correct 4. In the real world, databases used by businesses generally have a single table . True or False?


True False (*) Correct 5. Every row in a relational database table is unique.


True (*) False Correct Page 1 of 3

Next Summary

Test: Section 1 Quiz Review your answers, feedback, and question scores below. An asterisk (*) indicates a correct answer.

Section 1 Quiz (Answer all questions in this section) 6. What command can be used to create a new row in a table in the database?


ADD CREATE NEW INSERT (*) Correct. 7. All computers in the world speak the same languages, so you only need to learn one programming language - Oracle SQL. True or False?


True False (*) Correct. 8. There is only one kind of software used by all computers. True or False?


True False (*) Correct. 9. The _______ clause can be added to a SELECT statement to return a subset of the data.


EVERY WHERE (*) WHICH ANYWHERE Correct. 10. What command retrieves data from the database?

SELECT (*) ALTER INSERT DESCRIBE Correct

Previous

Page 2 of 3

Next Summary


Test: Section 1 Quiz Review your answers, feedback, and question scores below. An asterisk (*) indicates a correct answer. Section 1 Quiz (Answer all questions in this section) 11. You query the database with this SQL statement: SELECT * FROM students;


Why would you use this statement? To view data (*) To delete data To insert data To display the table structure Correct. 12. Which SQL statement will return an error?


SELECT star FROM sky; SELECT * FROM sky; select star from sky; SEL * FR sky; (*) Correct. 13. In a SQL statement, which clause specifies one or more columns to be returned by the query?


SELECT (*) FROM WHERE Any of the above options; you can list columns wherever you want to in a SELECT statement. Correct. 14. In which clause of a SELECT statement would you specify the name of the table or tables being queried?


The FROM clause (*) The SELECT clause The WHERE clause Any of the above options; you can list tables wherever you want in a SELECT statement. Correct. 15. What is a NULL value?

Mark for Review

(1) Points An unknown value (*) A known value less than zero A perfect zero A blank space Incorrect. See Section 1 Lesson 3.

Previous

Page 3 of 3

Summary

Answer Key Section 1 Quiz Oracle Database Programming with SQL

Recommend Documents