Discussion
Home ‣ Database ‣ Data Modeling with ER Model See What Others Are Saying!
- Question
Which type of entity cannot exist in the database unless another type of entity also exists in the database, but does not require that the identifier of that other entity be included as part of its own identifier?
Options- A. Weak entity
- B. Strong entity
- C. ID-dependent entity
- D. ID- independent entity
- Correct Answer
- Weak entity
- 1. Apache Web server does not support servlets.
Options- A. True
- B. False Discuss
- 2. A unique, DBMS-supplied identifier used as the primary key of a relation is called a(n):
Options- A. primary key.
- B. foreign key.
- C. composite key.
- D. surrogate key. Discuss
- 3. If attribute A determines both attributes B and C, then it is also true that:
Options- A. A ? B.
- B. B ? A.
- C. C ? A.
- D. (B,C) ? A. Discuss
- 4. Two basic constructs to link one piece of data with another piece of data: sequential storage and pointers.
Options- A. True
- B. False Discuss
- 5. In an SQL SELECT statement querying a single table, according to the SQL-92 standard the asterisk (*) means that:
Options- A. all columns of the table are to be returned.
- B. all records meeting the full criteria are to be returned.
- C. all records with even partial criteria met are to be returned.
- D. None of the above is correct. Discuss
- 6. An attribute's value is either a literal or an object identifier.
Options- A. True
- B. False Discuss
- 7. Two transactions that run concurrently and generate results that are consistent with the results that would have occurred if they had run separately are referred to as serializable transactions.
Options- A. True
- B. False Discuss
- 8. SUM, AVG, MIN, and MAX can only be used with numeric columns.
Options- A. True
- B. False Discuss
- 9. In a 1:N relationship, the foreign key is placed in:
Options- A. either table without specifying parent and child tables.
- B. the parent table.
- C. the child table.
- D. either the parent table or the child table. Discuss
- 10. SQL is a programming language.
Options- A. True
- B. False Discuss
More questions
Correct Answer: True
Correct Answer: surrogate key.
Correct Answer: A ? B.
Correct Answer: True
Correct Answer: all columns of the table are to be returned.
Correct Answer: True
Correct Answer: True
Correct Answer: False
Correct Answer: the child table.
Correct Answer: False
Comments
There are no comments.More in Database:
Programming
Copyright ©CuriousTab. All rights reserved.