Discussion
Home ‣ Database ‣ Database Design Using Normalization See What Others Are Saying!
- Question
When assessing the table structure of an acquired set of tables with data, determining foreign keys is (part of) the:
Options- A. first step.
- B. second step.
- C. third step.
- D. fourth step.
- Correct Answer
- second step.
- 1. An identifier determines the type of relationship that an entity has.
Options- A. True
- B. False Discuss
- 2. A semijoin is which of the following?
Options- A. Only the joining attributes are sent from one site to another and then all of the rows are returned.
- B. All of the attributes are sent from one site to another and then only the required rows are returned.
- C. Only the joining attributes are sent from one site to another and then only the required rows are returned.
- D. All of the attributes are sent from one site to another and then only the required rows are returned. Discuss
- 3. Which of the following is a correlated subquery?
Options- A. Uses the result of an inner query to determine the processing of an outer query.
- B. Uses the result of an outer query to determine the processing of an inner query.
- C. Uses the result of an inner query to determine the processing of an inner query.
- D. Uses the result of an outer query to determine the processing of an outer query. Discuss
- 4. A binary relationship is which of the following?
Options- A. A relationship between two attributes
- B. A relationship between two entities
- C. An attribute with two different relationships
- D. An entity with two different relationships Discuss
- 5. When the minimum and maximum number of instances of an entity is one, you know which of the following?
Options- A. Mandatory one
- B. Optional one
- C. Mandatory many
- D. Cannot tell Discuss
- 6. Client-side extensions:
Options- A. add functionality to the server.
- B. add functionality to the browser.
- C. add functionality to the firewall.
- D. add functionality to the network. Discuss
- 7. Which of the following is true about Microsoft Active Server Pages (ASP)?
Options- A. It is stored in .cfm files.
- B. It is executed on the client.
- C. It does not use tags.
- D. It allows for coding of custom tags in an HTML file. Discuss
- 8. Which of the following is true concerning triggers?
Options- A. You do not create them with SQL.
- B. They execute against only some applications that access a database.
- C. They have an event, condition, and action.
- D. They cannot cascade (cause another trigger to fire). Discuss
- 9. Which of the following is NOT a basic element of all versions of the E-R model?
Options- A. Entities
- B. Attributes
- C. Relationships
- D. Primary keys Discuss
- 10. A foreign key is:
Options- A. a column containing the primary key of another table.
- B. used to define data types.
- C. used to define null status.
- D. all of the above are above correct. Discuss
More questions
Correct Answer: False
Correct Answer: Only the joining attributes are sent from one site to another and then only the required rows are returned.
Correct Answer: Uses the result of an outer query to determine the processing of an inner query.
Explanation:
Correlated subquery references a column in the outer query and executes the subquery once for every row in the outer query while Uncorrelated subquery executes the subquery first and passes the value to the outer query.
Correct Answer: A relationship between two entities
Correct Answer: Mandatory one
Correct Answer: add functionality to the browser.
Correct Answer: It allows for coding of custom tags in an HTML file.
Correct Answer: They have an event, condition, and action.
Correct Answer: Primary keys
Correct Answer: a column containing the primary key of another table.
Comments
There are no comments.More in Database:
Programming
Copyright ©CuriousTab. All rights reserved.