CuriousTab
Search
CuriousTab
Home
Aptitude
Computer
C Programming
C# Programming
C++ Programming
Database
Java Programming
Networking
Engineering
Biochemical Engineering
Biochemistry
Biotechnology
Chemical Engineering
Civil Engineering
Computer Science
Digital Electronics
Electrical Engineering
Electronics
Electronics and Communication Engineering
Mechanical Engineering
Microbiology
Technical Drawing
GK
Current Affairs
General Knowledge
Reasoning
Data Interpretation
Logical Reasoning
Non Verbal Reasoning
Verbal Ability
Verbal Reasoning
Exams
AIEEE
Bank Exams
CAT
GATE
IIT JEE
TOEFL
Jobs
Analyst
Bank PO
Database Administrator
IT Trainer
Network Engineer
Project Manager
Software Architect
Discussion
Home
‣
Database
‣
ER Model and Business Rules
Comments
Question
A subtype entity name should be which of the following?
Options
A. A singular noun
B. Specific to the organization
C. Concise
D. All of the above
Correct Answer
All of the above
ER Model and Business Rules problems
Search Results
1. Which of the following database activities determines the entities, attributes, and relationships of data?
Options
A. Conceptual data modeling
B. Logical database design
C. Physical database design and definition
D. Database implementation
Show Answer
Scratch Pad
Discuss
Correct Answer: Conceptual data modeling
2. CASE tools do not include which of the following features?
Options
A. Help to draw data models
B. Help to generate code
C. Help to manage people
D. Create an information repository
Show Answer
Scratch Pad
Discuss
Correct Answer: Help to manage people
3. Strategic Planning factors do not include which of the following?
Options
A. Organizational goals
B. Critical success factors
C. Information engineering
D. Problem areas
Show Answer
Scratch Pad
Discuss
Correct Answer: Information engineering
4. In enterprise data modeling, which is incorrect?
Options
A. You review current systems.
B. You implement the new database.
C. You describe the data needed at a very high level of abstraction.
D. You plan one or more database development projects.
Show Answer
Scratch Pad
Discuss
Correct Answer: You implement the new database.
5. The three-schema components include all, but:
Options
A. internal schema.
B. conceptual schema.
C. programming schema.
D. external schema.
Show Answer
Scratch Pad
Discuss
Correct Answer: programming schema.
6. A supertype/subtype hierarchy has which of the following features?
Options
A. Subtypes at the lower lever in the hierarchy inherit attributes only from their immediate supertype.
B. Attributes are assigned at the highest logical level.
C. Subtypes at the higher lever in the hierarchy inherit attributes only from their immediate subtype.
D. Attributes are assigned at the lowest logical level.
Show Answer
Scratch Pad
Discuss
Correct Answer: Attributes are assigned at the highest logical level.
7. Which of the following is not one of the three ways to classify an action assertion?
Options
A. Condition
B. Integrity Control
C. Authorization
D. Enabler
Show Answer
Scratch Pad
Discuss
Correct Answer: Enabler
8. When an entity instance may be a member of multiple subtypes or it does not have to be a member of a subtype, it is which of the following?
Options
A. Disjoint with total specialization
B. Disjoint with partial specialization
C. Overlap with total specialization
D. Overlap with partial specialization
Show Answer
Scratch Pad
Discuss
Correct Answer: Overlap with total specialization
9. An action assertion must include which of the following?
Options
A. Anchor object
B. Action
C. Corresponding object
D. All of the above.
Show Answer
Scratch Pad
Discuss
Correct Answer: All of the above.
10. An oval represents which of the following in an EER?
Options
A. Attribute
B. Entity
C. Optional One
D. Relationship
Show Answer
Scratch Pad
Discuss
Correct Answer: Attribute
Comments
There are no comments.
Enter a new Comment
Save
More in Database:
Advanced SQL
Data and Database Administration
Data Modeling with ER Model
Data Models into Database Designs
Data Warehousing
Database Design Using Normalization
Database Processing for BIS
Database Redesign
Distributed Databases
ER Model and Business Rules
Introduction to Database
Introduction to SQL
JDBC, Java Server Pages, and MySQL
Logical Database Design
Managing Databases with Oracle
Managing Multiuser Databases
Modeling Data in the Organization
Object-Oriented Data Modeling
Object-Oriented Database
ODBC, OLE DB, ADO, and ASP
Physical Database Design
SQL for Database Construction
SQL Server 2000
The Client-Server Database
The Database Development Process
The Database Environment
The Internet Database Environment
The Relational Model and Normalization
XML and ADO.NET