Discussion
Home ‣ Database ‣ ER Model and Business Rules See What Others Are Saying!
- Question
Which one of the following symbols is not used in an ERD?
Options- A. Rectangle
- B. Oval
- C. Diamond
- D. Circle
- Correct Answer
- Circle
- 1. Which of the following column properties would be used to specify that cells in a column must contain a monetary value?
Options- A. Null status
- B. Data type
- C. Default value
- D. Data constraints Discuss
- 2. Specialization is which of the following processes?
Options- A. Defining one or more subtypes of the supertype and forming supertype/subtype relationships.
- B. Defining one or more supertypes of the subtype and forming supertype/subtype relationships.
- C. Defining one or more subtypes of the supertype and not forming supertype/subtype relationships.
- D. Defining one or more supertypes of the subtype and not forming supertype/subtype relationships. Discuss
- 3. Performance analysis and tuning is which of the following?
Options- A. Undertaken one time at the time of a DBMS installation
- B. Undertaken one time at the time of the implementation of a new application
- C. Undertaken as an ongoing part of the backup of a database
- D. Undertaken as an ongoing part of managing a database Discuss
- 4. Web servers should be configured in which of the following ways?
Options- A. unauthorized access is restricted.
- B. unauthorized access is unrestricted.
- C. unauthorized access is impossible.
- D. unauthorized access is possible. Discuss
- 5. To establish a range of values, < and > can be used.
Options- A. True
- B. False Discuss
- 6. 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
- 7. 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
- 8. 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
- 9. An identifier determines the type of relationship that an entity has.
Options- A. True
- B. False Discuss
- 10. 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
More questions
Correct Answer: Data type
Correct Answer: Defining one or more subtypes of the supertype and forming supertype/subtype relationships.
Correct Answer: Undertaken as an ongoing part of managing a database
Correct Answer: unauthorized access is restricted.
Correct Answer: True
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.
Comments
There are no comments.More in Database:
Programming
Copyright ©CuriousTab. All rights reserved.