Discussion
Home ‣ Database ‣ The Relational Model and Normalization See What Others Are Saying!
- Question
Which of the following is not a restriction for a table to be a relation?
Options- A. The cells of the table must contain a single value.
- B. All of the entries in any column must be of the same kind.
- C. The columns must be ordered.
- D. No two rows in a table may be identical.
- Correct Answer
- The columns must be ordered.
- 1. 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
- 2. The keyword LIKE can be used in a WHERE clause to refer to a range of values.
Options- A. True
- B. False Discuss
- 3. Business Intelligence (BI) systems fall into two broad categories: reporting and data warehousing.
Options- A. True
- B. False Discuss
- 4. The following SQL is which type of join: SELECT CUSTOMER_T. CUSTOMER_ID, ORDER_T. CUSTOMER_ID, NAME, ORDER_ID FROM CUSTOMER_T,ORDER_T ;
Options- A. Equi-join
- B. Natural join
- C. Outer join
- D. Cartesian join Discuss
- 5. In which of the following is a single-entity instance of one type related to many entity instances of another type?
Options- A. One-to-One Relationship
- B. One-to-Many Relationship
- C. Many-to-Many Relationship
- D. Composite Relationship Discuss
- 6. An enterprise data model is:
Options- A. a graphical model that shows the high-level entities for an organization.
- B. a graphical model that shows all entities for an organization.
- C. a non-graphical model that shows the high-level entities for an organization.
- D. a non-graphical model that shows the all entities for an organization. Discuss
- 7. Which is not a relevant feature of CASE tools?
Options- A. The ability to help draw data models using entity-relationship notations
- B. The ability to generate code
- C. An information repository
- D. Access to a DB via the Internet Discuss
- 8. Which of the following refers to a cursor type that when the cursor is opened, a primary key value is saved for each row in the recordset; when the application accesses a row, the key is used to fetch the current values of the row?
Options- A. Forward only
- B. Static
- C. Keyset
- D. Dynamic Discuss
- 9. With which type of SQL Server recovery model, is no logging done?
Options- A. Differential recovery
- B. Full recovery
- C. Bulk-logged recovery
- D. Simple recovery Discuss
- 10. Which of the following statements is a true statement concerning the open database connectivity standard (ODBC)?
Options- A. Each vendor desiring to be ODBC-complaint provides an ODBC driver.
- B. Requires certain criteria to be met in order to establish an ODBC connection.
- C. Provides a programming interface that provides a common language for application programs to access and process SQL databases independent of the RDBMS accessed.
- D. All of the above. Discuss
More questions
Correct Answer: True
Correct Answer: False
Correct Answer: False
Correct Answer: Cartesian join
Correct Answer: One-to-Many Relationship
Correct Answer: a graphical model that shows the high-level entities for an organization.
Correct Answer: Access to a DB via the Internet
Correct Answer: Keyset
Correct Answer: Simple recovery
Correct Answer: All of the above.
Comments
There are no comments.More in Database:
Programming
Copyright ©CuriousTab. All rights reserved.