Discussion
Home ‣ Database ‣ Data Modeling with ER Model See What Others Are Saying!
- Question
Which type of entity is related to two or more associated entities that each contain specialized attributes that apply to some but not all of the instances of the entity?
Options- A. Supertype entity
- B. Subtype entity
- C. Archetype entity
- D. Instance entity
- Correct Answer
- Supertype entity
- 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.