Discussion
Home ‣ Database ‣ The Relational Model and Normalization See What Others Are Saying!
- Question
A relation is in 5NF when multivalued dependencies are isolated in their own relation.
Options- A. True
- B. False
- Correct Answer
- False
- 1. An operational system is which of the following?
Options- A. A system that is used to run the business in real time and is based on historical data.
- B. A system that is used to run the business in real time and is based on current data.
- C. A system that is used to support decision making and is based on current data.
- D. A system that is used to support decision making and is based on historical data. Discuss
- 2. In a one-to-many relationship, the entity that is on the many side of the relationship is called a(n) ________ entity.
Options- A. parent
- B. child
- C. instance
- D. subtype Discuss
- 3. How can you find rows that do not match some specified condition?
Options- A. EXISTS
- B. Double use of NOT EXISTS
- C. NOT EXISTS
- D. None of the above is correct. Discuss
- 4. When using ODBC, which of the following serves as an intermediary between the application and the DBMS drivers?
Options- A. Data source
- B. Driver
- C. Driver manager
- D. OLE DB Discuss
- 5. What servlet processor was developed by Apache Foundation and Sun?
Options- A. Apache Tomcat
- B. Apache Web server
- C. Sun servlet processor
- D. None of the above is correct. Discuss
- 6. What SQL command can be used to delete columns from a table?
Options- A. MODIFY TABLE TableName DROP COLUMN ColumnName
- B. MODIFY TABLE TableName DROP ColumnName
- C. ALTER TABLE TableName DROP COLUMN ColumnName
- D. ALTER TABLE TableName DROP ColumnName Discuss
- 7. The EXISTS keyword will be true if:
Options- A. any row in the subquery meets the condition only.
- B. all rows in the subquery fail the condition only.
- C. both of these two conditions are met.
- D. neither of these two conditions is met. Discuss
- 8. The data model that is produced from reverse engineering is:
Options- A. a conceptual model.
- B. an internal model.
- C. a logical model.
- D. None of the above is correct. Discuss
- 9. The process of reading a database schema and producing a data model from that schema is known as:
Options- A. data modeling.
- B. database design.
- C. reverse engineering.
- D. None of the above is correct. Discuss
- 10. 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
More questions
Correct Answer: A system that is used to run the business in real time and is based on current data.
Correct Answer: child
Correct Answer: Double use of NOT EXISTS
Correct Answer: Driver manager
Correct Answer: Apache Tomcat
Correct Answer: ALTER TABLE TableName DROP COLUMN ColumnName
Correct Answer: any row in the subquery meets the condition only.
Correct Answer: None of the above is correct.
Correct Answer: reverse engineering.
Correct Answer: ALTER TABLE STUDENT ADD CONSTRAINT GradeCheck CHECK (Grade > 0);
Comments
There are no comments.More in Database:
Programming
Copyright ©CuriousTab. All rights reserved.