Join Us ::

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

Technical :: All Aptitude Test ::

Home » Technical » Aptitude Test - 33
Hassan
1.Which of the following is the component of a tuple relational calculus expression?
A. The relation R for which tuple variable T is defined.
B. A condition P(T) on the basis of which a set of tuples is to be retrieved.
C. An attribute list specifying the required attributes to be retrieved for the tuples satisfying the given condition.
D. The relation R for which tuple variable T is defined.
2.If relation R has m tuples and relation S has n tuples, then the result of join on relations R and S will have up to_________tuples.
A. m * n
B. m / n
C. m + n
D. m * n
3.Which of the following relational algebra operations require two tables as input with exactly the same attributes?
A. Join, cartesian product (multiplication), division
B. Project, restriction, union
C. Union, intersection, minus
D. Join, cartesian product (multiplication), division
4.Which of the following operations is used to select some required attributes from a relation while discarding the other attributes?
A. Select operation
B. Project operation
C. Rename operation
D. Select operation
5.Intersection operation is_____________. ?
A. Commutative
B. Associative
C. Both (a) and (b)
D. Commutative
6.A many to many relationship between two entities usually results in how many tables?
A. One
B. Two
C. Three
D. One
7. An ________ is a set of entities of the same type that share the same properties, or attributes.
A. Entity set
B. Attribute set
C. Relation set
D. Entity set
8.Entity is a _________?
A. Object of relation
B. Present working model
C. Thing in real world
D. Object of relation
9.Every weak entity set can be converted into a strong entity set by:
A. using generalization
B. adding appropriate attributes
C. using aggregation
D. using generalization
10.E-R modeling technique is a :
A. Top-down approach
B. Bottom-up approach
C. Left-right approach
D. Top-down approach
11.Every weak entity set can be converted to a strong entity set by :
A. Using generalization
B. Simply adding appropriate attribute
C. Using aggregation
D. Using generalization
12.In ER model the details of the entities are hidden from the user. This process is called :
A. generalization
B. specialization
C. abstraction
D. generalization
13.The attribute AGE is calculated from DATE_OF_BIRTH. The attribute AGE is :
A. Single valued
B. Multi valued
C. Composite
D. Single valued
14.Which of the following can be a multivalued attribute?
A. Phone_number
B. Name
C. Date_of_birth
D. Phone_number
15.Which of the following is a single valued attribute?
A. Register_number
B. Address
C. SUBJECT_TAKEN
D. Register_number
16.In a many to one relationship, the primary key of one entity acts as foreign key on which side?
A. On the side where single (one) relationship is defined
B. On the side where many relationship is defined
C. On both the sides
D. On the side where single (one) relationship is defined
17. In a many to one relationship, the primary key of one entity acts as foreign key on which side?
A. On the side where single (one) relationship is defined
B. On the side where many relationship is defined
C. On both the sides
D. On the side where single (one) relationship is defined
18.A weak entity set in an E-R diagram is an entity set that :
A. has a primary key
B. must be part of a one to many relationship set
C. is not existence dependent on a dominant entity
D. has a primary key
19.In an E-R, Y is the dominant entity and X is a subordinate entity. Then which of the following is incorrect ?
A. operationally, If Y is deleted, so is X
B. operationally, if X is deleted, Y remains the same
C. operationally, if X is deleted, so is Y
D. operationally, If Y is deleted, so is X
20.The number of entities to which another entity can be associated via a relationship set is expressed as :
A. Entity
B. Cardinality
C. Schema
D. Entity
21.Relations produced from an E-R model will always be in :
A. First normal form
B. Second normal form
C. Third normal form
D. First normal form
22.The attributes made up of more than one single attributes are called :
A. Composite attribute
B. Derived attribute
C. Single value attribute
D. Composite attribute
23. An association of several entities in an Entity-Relation model is called :
A. Tuple
B. Record
C. Relationship
D. Tuple
24.We wish to ensure that a value that appears in one relation for a given set of attributes also appears for a certain set of attributes in another relation. This condition is called ___________ .?
A. Join integrity
B. Relational integrity
C. Referential integrity
D. Join integrity
25.What is oracle error code for exception COLLECTION_IS_NULL?
A. "06530"
B. "06592"
C. "06531"
D. "06530"
26.Data integrity constraints are used to:
A. Control who is allowed access to the data
B. Ensure that duplicate records are not entered into the table
C. Improve the quality of data entered for a specific property (i.e., table column)
D. Control who is allowed access to the data
27.The relationship between the two tables are created using __________?
A. Candidate Key
B. Primary Key
C. Foreign Key
D. Candidate Key
28.Which of the following statement(s) is/are FALSE about primary key?
A. There can be more than one primary key for a table
B. Columns with string data types cannot be made Primary Key because they are large
C. Both A and B
D. There can be more than one primary key for a table
29.Referential triggered action clause in Standard Query Language is attached to constraint called :
A. primary key constraint
B. stamped key constraint
C. interval notation constraint
D. primary key constraint
30. If the referential integrity constraint is violated then the specific action clause attached by the database designers other than by default action is classified as :
A. referential triggered action
B. foreign key triggered action
C. primary key triggered action
D. referential triggered action
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]