Discussion
Home ‣ Database ‣ The Relational Model and Normalization See What Others Are Saying!
- Question
When the values in one or more attributes being used as a foreign key must exist in another set of one or more attributes in another table, we have created a(n):
Options- A. transitive dependency.
- B. insertion anomaly.
- C. referential integrity constraint.
- D. normal form.
- Correct Answer
- referential integrity constraint.
- 1. An attribute is a(n):
Options- A. column of a table.
- B. two dimensional table.
- C. row of a table.
- D. key of a table. Discuss
- 2. If a relation is in third normal form, it does not need to be in second normal form.
Options- A. True
- B. False Discuss
- 3. What programming language(s) or scripting language(s) does Java Server Pages (JSP) support?
Options- A. VBScript only
- B. Jscript only
- C. Java only
- D. All of the above are supported 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 WHERE CUSTOMER_T. CUSTOMER_ID = ORDER_T. CUSTOMER_ID
Options- A. Equi-join
- B. Natural join
- C. Outer join
- D. Cartesian join Discuss
- 5. Locks placed by the DBMS are called ________ .
Options- A. implicit locks
- B. explicit locks
- C. exclusive locks
- D. shared locks Discuss
- 6. The use of packaged data models can offer which of the following benefits?
Options- A. Reduce implementation time and costs
- B. Higher quality models
- C. Both A and B.
- D. Neither A nor B. Discuss
- 7. The identifier of an entity will become the ________ of the new table.
Options- A. foreign key
- B. main attribute
- C. primary key
- D. identity key Discuss
- 8. An autonomous homogenous environment is which of the following?
Options- A. The same DBMS is at each node and each DBMS works independently.
- B. The same DBMS is at each node and a central DBMS coordinates database access.
- C. A different DBMS is at each node and each DBMS works independently.
- D. A different DBMS is at each node and a central DBMS coordinates database access. Discuss
- 9. Writing stored procedures takes less time than using Visual Basic or PowerBuilder to create an application.
Options- A. True
- B. False Discuss
- 10. Datasets which reside on the user's hard drive are created by ADO.NET to facilitate the transformation of XML documents to and from relational database constructs.
Options- A. True
- B. False Discuss
More questions
Correct Answer: column of a table.
Correct Answer: False
Correct Answer: Java only
Correct Answer: Equi-join
Correct Answer: implicit locks
Correct Answer: Both A and B.
Correct Answer: primary key
Correct Answer: The same DBMS is at each node and each DBMS works independently.
Correct Answer: False
Correct Answer: False
Comments
There are no comments.More in Database:
Programming
Copyright ©CuriousTab. All rights reserved.