Answer Key Section 1 Quiz Oracle Database Programming With Sql ...

Transcript

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? Mark for Review (1) Points True (*) False Correct 3. Most of the well know Internet search engines use databases to store data. True or False? Mark for Review (1) Points True (*) False Correct 4. In the real world, databases used by businesses generally have a single table . True or False? Mark for Review (1) Points True False (*) Correct 5. Every row in a relational database table is unique. Mark for Review (1) Points 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? Mark for Review (1) Points 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? Mark for Review (1) Points True False (*) Correct. 8. There is only one kind of software used by all computers. True or False? Mark for Review (1) Points True False (*) Correct. 9. The _______ clause can be added to a SELECT statement to return a subset of the data. Mark for Review (1) Points 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 Mark for Review (1) Points 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; Mark for Review (1) Points 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? Mark for Review (1) Points 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? Mark for Review (1) Points 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? Mark for Review (1) Points 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