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 - 31
Hassan
1.The contents of the A register after is ________.?
A. 0000
B. 1010
C. 0001
D. 0000
2.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
3.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
4.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
5.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
6.By default, the generalization type applied is:
A. Dependent specialization
B. Partial specialization
C. Complete specialization
D. Dependent specialization
7. An abstraction through which relationships are treated as higher-level entities, is known as:
A. Aggregation
B. Tabulation
C. Simulation
D. Aggregation
8. 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
9. 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
10. Hierarchical model is also called?
A. Tree structure
B. Plex Structure
C. Normalize Structure
D. Tree structure
11. In E-R diagram generalization is represented by:
A. Ellipse
B. Dashed ellipse
C. Rectangle
D. Ellipse
12. The method of access which uses key transformation is known as?
A. Direct
B. Hash
C. Random
D. Direct
13.A table joined with itself is called?
A. Join
B. Outer Join
C. Self Join
D. Join
14. Which structure is the hierarchical model based?
A. Tree
B. Graph
C. Linked List
D. Tree
15.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
16.In domain relational calculus we create a variable for every.?
A. Column
B. Row
C. Table
D. Column
17.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
18.In context with relational Algebra. Which of the following are unary operatiors.?
A. Select,Project
B. Project,Union
C. Union, Product
D. Select,Project
19.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
20.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+
21. 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
22.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
23.In tuple relational calculus P1 → P2 is equivalent to.?
A. ¬ P1 ∨ P2
B. P1 ∨ P2
C. P1 ∧ P2
D. ¬ P1 ∨ P2
24. 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.
25.Related fields in a database are grouped to form a:
A. Data file
B. Data record
C. Menu
D. Data file
26.The database environment has all of the following components except:
A. Users
B. Separate files
C. Database.
D. Users
27.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
28.The entity relationship set is represented in E-R diagram as:
A. Double diamonds
B. Undivided rectangles
C. Dashed lines
D. Double diamonds
29.The Rectangles divided into two parts represents:
A. Relationship set
B. Attributes of a relationship set
C. Entity set
D. Relationship set
30.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
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]