Discussion
Home ‣ Database ‣ Logical Database Design See What Others Are Saying!
- Question
When mapping a binary many-to-many relationship into a relation which of the following is true?
Options- A. One relation is created.
- B. Two relations are created.
- C. Three relations are created.
- D. Four relations are created.
- Correct Answer
- Three relations are created.
- 1. What is not true about SOAP?
Options- A. SOAP originally meant Simple Object Access Protocol.
- B. SOAP was defined as an XML-based standard for providing remote procedure calls over the Internet.
- C. SOAP now is just a name, not an acronym
- D. SOAP was an early form of XML. Discuss
- 2. You can add a row using SQL in a database with which of the following?
Options- A. ADD
- B. CREATE
- C. INSERT
- D. MAKE Discuss
- 3. A fact is a word or phrase that has a specific meaning for the business.
Options- A. True
- B. False Discuss
- 4. A primary key may be null.
Options- A. True
- B. False Discuss
- 5. Common types of SQL CHECK constraints include range checks and limiting columns values.
Options- A. True
- B. False Discuss
- 6. The different classes of relations created by the technique for preventing modification anomalies are called:
Options- A. normal forms.
- B. referential integrity constraints.
- C. functional dependencies.
- D. None of the above is correct. Discuss
- 7. In a relation, the rows are sometimes called "records."
Options- A. True
- B. False Discuss
- 8. One solution to the multivalued dependency constraint problem is to:
Options- A. split the relation into two relations, each with a single theme.
- B. change the theme.
- C. create a new theme.
- D. add a composite key. Discuss
- 9. A CASE SQL statement is which of the following?
Options- A. A way to establish an IF-THEN-ELSE in SQL.
- B. A way to establish a loop in SQL.
- C. A way to establish a data definition in SQL.
- D. All of the above. Discuss
- 10. FOR XML EXPLICIT tells SQL Server to place the values of the columns as attributes in the resulting XML document.
Options- A. True
- B. False Discuss
More questions
Correct Answer: SOAP was an early form of XML.
Correct Answer: INSERT
Correct Answer: False
Correct Answer: False
Correct Answer: True
Correct Answer: normal forms.
Correct Answer: True
Correct Answer: split the relation into two relations, each with a single theme.
Correct Answer: A way to establish an IF-THEN-ELSE in SQL.
Correct Answer: False
Comments
There are no comments.More in Database:
Programming
Copyright ©CuriousTab. All rights reserved.