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 - 22
1.Which of the following indicates the maximum number of entities that can be involved in a relationship?
A. Minimum cardinality
B. Maximum cardinality
C. ERD
D. Minimum cardinality
2.In a one-to-many relationship, the entity that is on the one side of the relationship is called a(n) ________ entity.?
A. parent
B. child
C. instance
D. parent
3.Which type of entity represents an actual occurrence of an associated generalized entity?
A. Supertype entity
B. Subtype entity
C. Archetype entity
D. Supertype entity
4.The database user assigns entities to a given entity set, in the type of generalization's constraints
A. Data-defined
B. User-defined
C. System-defined
D. Data-defined
5.By default, the generalization type applied is:
A. Dependent specialization
B. Partial specialization
C. Complete specialization
D. Dependent specialization
6. An abstraction through which relationships are treated as higher-level entities, is known as:
A. Aggregation
B. Tabulation
C. Simulation
D. Aggregation
7. In the user-defined constraints on generalization, the lower level entity sets can be of type:
A. 2 types
B. 3 types
C. 4 types
D. 2 types
8. Like attribute inheritance, the inheritance that applies through all tiers of lower-level entity sets, is known to be:
A. Execution inheritance
B. Participation inheritance
C. Dependency inheritance
D. Execution inheritance
9. Hierarchical model is also called?
A. Tree structure
B. Plex Structure
C. Normalize Structure
D. Tree structure
10. In E-R diagram generalization is represented by:
A. Ellipse
B. Dashed ellipse
C. Rectangle
D. Ellipse
11. The method of access which uses key transformation is known as?
A. Direct
B. Hash
C. Random
D. Direct
12.A table joined with itself is called?
A. Join
B. Outer Join
C. Self Join
D. Join
13. Which structure is the hierarchical model based?
A. Tree
B. Graph
C. Linked List
D. Tree
14.In the relational model, the number of attributes and number of tuples iri a relation are termed as __________and ______________respectively?
A. Cardinality, domain
B. Degree, cardinality
C. Domain degree
D. Cardinality, domain
15.In domain relational calculus we create a variable for every.?
A. Column
B. Row
C. Table
D. Column
16.Why do we have to create a primary index on a primary key.?
A. Ease of searching
B. Sequential ordering of a file
C. Both (a) and (b)
D. Ease of searching
17.In context with relational Algebra. Which of the following are unary operatiors.?
A. Select,Project
B. Project,Union
C. Union, Product
D. Select,Project
18.Let R is a relation schema, R(A, B, C, D) and F = {A —> B, B --> C, C —> A) is the set of functional dependency. Determine the key of relation ?
A. A
B. B
C. C
D. A
19.Which of the following statement is correct?
A. F |= x ---> x iff y ⊆ x+
B. F |= y ---->x iff y ⊆ x+
C. F |=x --->y iff x+ ⊆ y
D. F |= x ---> x iff y ⊆ x+
20. Given the basic ER and relational model which of the following is incorrect?
A. An entity can have more than one attribute
B. An attribute of an entity can be composite.
C. In row of a relational table, an attribute have more than one value.
D. An entity can have more than one attribute
21.Let r be a relation instance with schema R = (A, B, C, D). We define r1 =∏ A,B,C (r) and r2 = ∏A, D (r).?
A. S ⊂ r
B. r ∪ s = r
C. r ⊂ s
D. S ⊂ r
22.In tuple relational calculus P1 → P2 is equivalent to.?
A. ¬ P1 ∨ P2
B. P1 ∨ P2
C. P1 ∧ P2
D. ¬ P1 ∨ P2
23. A logical schema:
A. Is the entire database.
B. describe data in terms of relational tables and columns, object-oriented classes, and XML tags.
C. Describes how data is actually stored on disk.
D. Is the entire database.
24.Related fields in a database are grouped to form a:
A. Data file
B. Data record
C. Menu
D. Data file
25.The database environment has all of the following components except:
A. Users
B. Separate files
C. Database.
D. Users
26.Which of the following gives a logical structure of the database graphically?
A. Entity-relationship diagram
B. Entity diagram
C. Database diagram
D. Entity-relationship diagram
27.The entity relationship set is represented in E-R diagram as:
A. Double diamonds
B. Undivided rectangles
C. Dashed lines
D. Double diamonds
28.The Rectangles divided into two parts represents:
A. Relationship set
B. Attributes of a relationship set
C. Entity set
D. Relationship set
29.Consider a directed line(->) from the relationship set advisor to both entity sets instructor and student. This indicates _________ cardinality:
A. One to many
B. One to one
C. Many to many
D. One to many
30.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
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]