কম্পিউটার ডাটাবেইজ

• ০০। (STREET ADDRESS, CITY, STATE, ZIP) is an ideal primary key.
• ক) True
• খ) False

• ০১। 1:1, 1:N and N:M relationships are also known as HAS-A relationships.
• ক) True
• খ) False

• ০২। A benefit of the three-tier architecture is which of the following?
• ক) New modules can be built to support specific business needs
• খ) Performance improves for compiled SQL statements
• গ) Results in a thinner client and database server
• ঘ) All of the above.

• ০৩। A benefit of using a stored procedure is that it can be distributed to client computers.
• ক) True
• খ) False

• ০৪। A BI reporting system does not ________ .
• ক) create meaningful information
• খ) deliver information to users on a timely basis
• গ) use statistical procedures to predict future events
• ঘ) use disparate data sources

• ০৫। A binary relationship cannot be which of the following?
• ক) One-to-One
• খ) One-to-Many
• গ) Many-to-Many
• ঘ) Zero-to-Zero

• ০৬। A binary relationship is a relationship between two or more entities.
• ক) True
• খ) False

• ০৭। A binary relationship is which of the following?
• ক) A relationship between two attributes
• খ) A relationship between two entities
• গ) An attribute with two different relationships
• ঘ) An entity with two different relationships

• ০৮। A bitmap index is an index on columns from two or more tables that come from the same domain of values.
• ক) True
• খ) False

• ০৯। A candidate key is a determinant that determines all the other columns is a relation.
• ক) True
• খ) False

• ১০। A candidate key must uniquely identify each row.
• ক) True
• খ) False

• ১১। A CASE SQL statement is which of the following?
• ক) A way to establish an IF-THEN-ELSE in SQL.
• খ) A way to establish a loop in SQL.
• গ) A way to establish a data definition in SQL.
• ঘ) All of the above.

• ১২। A characteristic of a file server is which of the following?
• ক) Manages file operations and is shared on a network.
• খ) Manages file operations and is limited to one PC.
• গ) Acts as a fat client and is shared on a network.
• ঘ) Acts as a fat client and is limited to one PC.

• ১৩। A class is a concept, abstraction, or thing that makes sense in an application context.
• ক) True
• খ) False

• ১৪। A collection of literals or object types is called a bag.
• ক) True
• খ) False

• ১৫। A composite attribute does not get mapped into a relation.
• ক) True
• খ) False

• ১৬। A composite attribute is which of the following?
• ক) An attribute that can be broken into components
• খ) An attribute that cannot be broken into components
• গ) Multiple attributes
• ঘ) An identifier

• ১৭। A conceptual schema is usually depicted in graphical format using E-R or object-modeling notations.
• ক) True
• খ) False

• ১৮। A constructor operation does which of the following?
• ক) Creates a new instance of a class
• খ) Updates an existing instance of a class
• গ) Deletes and existing instance of a class
• ঘ) All of the above.

• ১৯। A correlated subquery is processed as a nested subquery.
• ক) True
• খ) False