Discussion
Home ‣ Database ‣ Object-Oriented Database See What Others Are Saying!
- Question
The reserved word enum is used for which of the following?
Options- A. To define a range for an attribute.
- B. To define a range for a class.
- C. To define a range for a relationship.
- D. All of the above.
- Correct Answer
- To define a range for an attribute.
- 1. What SQL command will allow you to change the table STUDENT to add the constraint named GradeCheck that states that the values of the Grade column must be greater than 0?
Options- A. ALTER TABLE STUDENT ALTER CONSTRAINT GradeCheck (Grade > 0);
- B. ALTER TABLE STUDENT ADD CONSTRAINT GradeCheck (Grade > 0);
- C. ALTER TABLE STUDENT ADD CONSTRAINT GradeCheck CHECK (Grade > 0);
- D. None of the above is correct. Discuss
- 2. Before any changes to database structure are attempted one should first:
Options- A. clearly understand the current structure and contents of the database only.
- B. test any changes on a test database only.
- C. create a complete backup of the operational database only.
- D. All of the above should be done. Discuss
- 3. Which of the following is not true of SQL views?
Options- A. Oracle views cannot use the ORDER BY clause in view definitions.
- B. Oracle views are created using the standard SQL-92 CREATE VIEW command.
- C. Oracle views can by queried.
- D. The SQL-92 standard does not allow the use of the ORDER BY clause in view definitions. Discuss
- 4. In OLE DB, which of the following represents characteristics of the recordset abstraction?
Options- A. Properties
- B. Collections
- C. Methods
- D. Abstractions Discuss
- 5. Indexes can usually be created for both primary and secondary keys.
Options- A. True
- B. False Discuss
- 6. A data warehouse uses:
Options- A. partial operational data.
- B. historical operational data.
- C. future operational data.
- D. health care data. Discuss
- 7. Which of the following is true concerning the standard network protocol for connecting a client to a Web or database server via the Internet?
Options- A. Both TCP and IP are needed.
- B. TCP is needed but IP is not needed.
- C. TCP is not needed but IP is needed.
- D. Neither TCP and IP are needed. Discuss
- 8. If you know all the possible values that an attribute can have, you can enumerate those values in ODL.
Options- A. True
- B. False Discuss
- 9. The keyword LIKE can be used in a WHERE clause to refer to a range of values.
Options- A. True
- B. False Discuss
- 10. Business Intelligence (BI) systems fall into two broad categories: reporting and data warehousing.
Options- A. True
- B. False Discuss
More questions
Correct Answer: ALTER TABLE STUDENT ADD CONSTRAINT GradeCheck CHECK (Grade > 0);
Correct Answer: All of the above should be done.
Correct Answer: Oracle views cannot use the ORDER BY clause in view definitions.
Correct Answer: Properties
Correct Answer: True
Correct Answer: historical operational data.
Correct Answer: Both TCP and IP are needed.
Correct Answer: True
Correct Answer: False
Correct Answer: False
Comments
There are no comments.More in Database:
Programming
Copyright ©CuriousTab. All rights reserved.