GAT Subject :: All Aptitude Test ::

Hassan
1.We indicate roles in E-R diagrams by labeling the lines that connect ___________ to __________?
A. Diamond , diamond
B. Rectangle, diamond
C. Rectangle, rectangle
D. Diamond , diamond

2.An entity set that does not have sufficient attributes to form a primary key is termed a __________?
A. Strong entity set
B. Variant set
C. Weak entity set
D. Strong entity set

3.For a weak entity set to be meaningful, it must be associated with another entity set, called the?
A. Identifying set
B. Owner set
C. Neighbour set
D. Identifying set

4.Weak entity set is represented as:
A. Underline
B. Double line
C. Double diamond
D. Underline

5.In the rainy season, doors get swelled up due to
A. Transpiration
B. Imbibition
C. Diffusion
D. Transpiration

6.If you were collecting and storing information about your music collection, an album would be considered a(n) _____?
A. Relation
B. Entity
C. Instance
D. Relation

7.What term is used to refer to a specific record in your music database; for instance; information stored about a specific album?
A. Relation
B. Instance
C. Table
D. Relation

8. This statement regarding enzyme inhibition is correct
A. non-competitive inhibitors often bind to the enzyme irreversibly
B. non-competitive inhibition of an enzyme can be overcome by adding a large amount of substrate
C. competitive inhibition is observed when substrate and inhibitor compete for the active site on enzyme
D. non-competitive inhibitors often bind to the enzyme irreversibly

9.An ER diagram can express the overall __________of a database graphically?
A. View Structure
B. Logical Structure
C. Model Structure
D. View Structure

10. Which of the following structure represent the entity sets?
A. Double rectangle
B. Diamond
C. Rectangle
D. Double rectangle

11. Ellipses represent_________?
A. Relationship sets
B. Attributes
C. Derived attributes
D. Relationship sets

12.Diamond Represents______?
A. Relationship sets
B. Attributes
C. Derived attributes
D. Relationship sets

13.Which of the following diagram link attributes to entity sets and entity sets to relationship sets?
A. Double lines
B. Dashed Ellipses
C. Double ellipses
D. Double lines

14.Double ellipses represents_____?
A. Derived attributes
B. Multi-valued Attributes
C. Total participation of an entity in a relationship set
D. Derived attributes

15.Dashed ellipses represents_____?
A. Derived attributes
B. Multi-valued Attributes
C. Total participation of an entity in a relationship set
D. Derived attributes

16.Double Line indicate_____?
A. Derived attributes
B. Multi-valued Attributes
C. Total participation of an entity in a relationship set
D. Derived attributes

17.Double Rectangle represent____?
A. Derived attributes
B. Multi-valued Attributes
C. Total participation of an entity in a relationship set
D. Derived attributes

18.An entity set that has attributes to form a primary key; such an entity set is termed as______?
A. Strong Entity set
B. Weak Entity set
C. Composite Entity set
D. Strong Entity set

19.For a weak entity set to be meaningful, it must be associated with another entity set called the __________?
A. Strong entity set
B. stronger entity set
C. Owner entity set
D. Strong entity set

20. In the relational modes, cardinality is termed as:?
A. Number of tuples
B. Number of attributes
C. Number of tables
D. Number of tuples

21.A Relation is a:
A. Subset of a Cartesian product of a list of attributes
B. Subset of a Cartesian product of a list of domains
C. Subset of a Cartesian product of a list of tuple
D. Subset of a Cartesian product of a list of attributes

22.In mathematical term Table is referred as:
A. Relation
B. TupleAttribute
C. Tuple
D. Relation

23.In mathematical term Row is referred as:
A. Relation
B. Attributes
C. Tuple
D. Relation

24._______ allow us to identify uniquely a tuple in the relation.?
A. Superkey
B. Domain
C. Attribute
D. Superkey

25.Minimal Superkeys are called?
A. Schema keys
B. Candidate keys
C. Domain keys
D. Schema keys

26.Who proposed the relational model?
A. Bill Gates
B. E.F. Codd
C. Herman Hollerith
D. Bill Gates

27.Data Manipulation Language (DML) is not to?
A. Create information table in the Database
B. Insertion of new information into the Database
C. Deletion of information in the Database
D. Create information table in the Database

28.How many types of keys in Database Design?
A. Candidate key
B. Primary key
C. Foreign key
D. Candidate key

29. The minimal set of super key is called
A. Primary key
B. Secondary key
C. Candidate key
D. Primary key

30.Foreign key is the one in which the ________ of one relation is referenced in another relation.?
A. Foreign key
B. Primary key
C. References
D. Foreign key


Date to Date Current Affairs 2022

PakMCQs.net

Quick Links

GAT Subject



   Computer Science    English Mcqs    Agriculture    

Engineering



   Computer Science    Civil Engineering    

Technical



   Networking    Electronics    Database    

Past Papers



   Model Papers    FPSC Papers