Discussion
Home ‣ Database ‣ The Database Development Process See What Others Are Saying!
- Question
User views are included as part of which schema?
Options- A. Internal
- B. Conceptual
- C. External
- D. None of the above.
- Correct Answer
- External
- 1. When the minimum 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
- 2. Find the SQL statement below that is equal to the following: SELECT NAME FROM CUSTOMER WHERE STATE = 'VA';
Options- A. SELECT NAME IN CUSTOMER WHERE STATE IN ('VA');
- B. SELECT NAME IN CUSTOMER WHERE STATE = 'VA';
- C. SELECT NAME IN CUSTOMER WHERE STATE = 'V';
- D. SELECT NAME FROM CUSTOMER WHERE STATE IN ('VA'); Discuss
- 3. Common Gateway Interface (CGI) is which of the following?
Options- A. An interface that accepts and returns data that may be written in SQL.
- B. An interface that accepts and returns data that may be written in any language that produces an executable file.
- C. A small program that executes within another application and is stored on the server.
- D. A small program that executes within another application and is stored on the client. Discuss
- 4. An identifier determines the type of relationship that an entity has.
Options- A. True
- B. False Discuss
- 5. 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
- 6. 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
- 7. 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
- 8. 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
- 9. 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
- 10. 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
More questions
Correct Answer: Cannot tell
Correct Answer: SELECT NAME FROM CUSTOMER WHERE STATE IN ('VA');
Correct Answer: An interface that accepts and returns data that may be written in any language that produces an executable file.
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.
Comments
There are no comments.More in Database:
Programming
Copyright ©CuriousTab. All rights reserved.