Join Us ::

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

Computer Science :: All Aptitude Test ::

Home » GAT Subject » Computer Science » Aptitude Test - 23
1.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
2.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
3.Weak entity set is represented as:
A. Underline
B. Double line
C. Double diamond
D. Underline
4.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
5.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
6.An ER diagram can express the overall __________of a database graphically?
A. View Structure
B. Logical Structure
C. Model Structure
D. View Structure
7. Which of the following structure represent the entity sets?
A. Double rectangle
B. Diamond
C. Rectangle
D. Double rectangle
8. Ellipses represent_________?
A. Relationship sets
B. Attributes
C. Derived attributes
D. Relationship sets
9.Diamond Represents______?
A. Relationship sets
B. Attributes
C. Derived attributes
D. Relationship sets
10.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
11.Double ellipses represents_____?
A. Derived attributes
B. Multi-valued Attributes
C. Total participation of an entity in a relationship set
D. Derived attributes
12.Dashed ellipses represents_____?
A. Derived attributes
B. Multi-valued Attributes
C. Total participation of an entity in a relationship set
D. Derived attributes
13.Double Line indicate_____?
A. Derived attributes
B. Multi-valued Attributes
C. Total participation of an entity in a relationship set
D. Derived attributes
14.Double Rectangle represent____?
A. Derived attributes
B. Multi-valued Attributes
C. Total participation of an entity in a relationship set
D. Derived attributes
15.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
16.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
17. In the relational modes, cardinality is termed as:?
A. Number of tuples
B. Number of attributes
C. Number of tables
D. Number of tuples
18.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
19.In mathematical term Table is referred as:
A. Relation
B. TupleAttribute
C. Tuple
D. Relation
20.In mathematical term Row is referred as:
A. Relation
B. Attributes
C. Tuple
D. Relation
21._______ allow us to identify uniquely a tuple in the relation.?
A. Superkey
B. Domain
C. Attribute
D. Superkey
22.Minimal Superkeys are called?
A. Schema keys
B. Candidate keys
C. Domain keys
D. Schema keys
23.Who proposed the relational model?
A. Bill Gates
B. E.F. Codd
C. Herman Hollerith
D. Bill Gates
24.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
25.How many types of keys in Database Design?
A. Candidate key
B. Primary key
C. Foreign key
D. Candidate key
26. The minimal set of super key is called
A. Primary key
B. Secondary key
C. Candidate key
D. Primary key
27.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
28.Domain constraints, functional dependency and referential integrity are special forms of _________.?
A. Foreign key
B. Primary key
C. Assertion
D. Foreign key
29.A _____ is a property of the entire relation, rather than of the individual tuples in which each tuple is unique.?
A. Rows
B. Key
C. Attribute
D. Rows
30.Which one of the following attribute can be taken as a primary key ?
A. Name
B. Street
C. Id
D. Name
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-2025 by Pak-MCQs.net All Rights Reserved.

Email: [email protected]