12th class (Fsc) computer unit 3 MCQs
26. The logical representation of an organization’s data is called a(n):
a. Relationship systems design
b. Database management system
c. Database entity diagram
d. Entity relationship model
27. Which of the following is an example of one-to-one relationship?
a. Mother daughter
b. Student- RegNow
c. Person-phone number
d. Person automobile
28. Which of the following is a one-to-Many relationship?
a. Student- RegNo
b. Person automobile
c. Mother daughter
d. Both B & C
29. Which of the following is used to define objects and describe their characteristics?
a. Attribute
b. Relationship
c. Both A & B
d. None
30. Which of the following keys does not hold uniqueness property?
a. Primary key
b. Candidate key
c. Secondary key
d. Foreign key
31. In hybrid distribution which kind of fragments are stored at only one site:
a. Critical and non-critical fragments
b. Critical fragments
c. Only large fragments
d. Non-critical fragments
32. Which of the following is not a basic data distribution strategy?
a. Replicated
b. Centralized
c. Duplicated
d. Partitioned
33. A technique for physically arranging the records of a file on secondary storage devices is called:
a. File organization
b. Physical pointer
c. Update program
d. Retrieval program
34. Organizing the database in computer disk storage is done in:
a. Physical design
b. Logical design
c. Implementation
d. Analysis
35. ……… refers to a method of database distribution in which one database contains data that are included in another database.
a. Replication
b. Splitting
c. Dividing
d. Partitioning
36. An index may be created on:
a. Foreign key
b. Primary key
c. Secondary key
d. All
37. All of the following are components of physical database design except?
a. File organization
b. Data volume and usage analysis
c. Normalize the relations
d. Data distribution strategy
38. Merging the relation is also known as:
a. View integration
b. View entities
c. Both A & B
d. None
39. Which of the following activities is performed in logical design process?
a. Normalize the relations
b. Represent entities
c. Represent relationships
d. All
40. A factor to consider when choosing a file organization is:
a. Efficient storage
b. Fast data retrieval
c. Security
d. All
41. Physical database design decision must be made carefully because of impacts on:
a. Security
b. Data accessibility
c. Response times
d. All
42. An advantage of partitioning is:
a. Efficiency
b. Extra space and update time
c. Both A & B
d. None
43. A disadvantage of partitioning is:
a. Simplicity
b. Extra space and update time
c. Both A & B
d. None
44. Organization the database in computer disk storage is done in:
a. Analysis
b. Logical design
c. Implementation
d. Physical design
45. Which of the following are basic data distribution strategies?
a. Replication
b. Centralized
c. Partitioned
d. All
46. …… refers to a method of database distribution in which different portions of the database reside at different nodes in the network.
a. Replication
b. Splitting
c. Dividing
d. Partitioning
47. Database development process involve mapping of conceptual data model into:
a. Implementation model
b. Object oriented data model
c. Hierarchical data model
d. Network data model
Click here to go directly on chapter no.4