Join Us ::

Menu Home Classes GK Engineering Past Papers Current Affairs Technical GAT Subject Programming Medical Papers

GAT Subject :: All Aptitude Test ::

Home » GAT Subject » Aptitude Test - 32
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
Related Subjects

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    
Our Team | Career | Contact | JoinUs | Privacy Policy | DMC

© 2020-2024 by Pak-MCQs.net All Rights Reserved.

Email: [email protected]