Join Us ::

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

Database :: All Aptitude Test ::

Home » Technical » Database » Aptitude Test - 12
1.DRC stands for?
A. Domain Relation Calculus
B. Debug relational calculus
C. Double relational calculus
D. Domain Relation Calculus
2.Which one of the following is a procedural language?
A. Domain relational calculus
B. Tuple relational calculus
C. Relational algebra
D. Domain relational calculus
3.Which of the following is the operation developed specifically for the relational databases?
A. Union
B. Cartesian product
C. Division
D. Union
4.Which of the following is the set-oriented operation?
A. Select
B. Difference
C. Division
D. Select
5.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.
6.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
7.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
8.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
9.Intersection operation is_____________. ?
A. Commutative
B. Associative
C. Both (a) and (b)
D. Commutative
10.A many to many relationship between two entities usually results in how many tables?
A. One
B. Two
C. Three
D. One
11. 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
12.Entity is a _________?
A. Object of relation
B. Present working model
C. Thing in real world
D. Object of relation
13.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
14.E-R modeling technique is a :
A. Top-down approach
B. Bottom-up approach
C. Left-right approach
D. Top-down approach
15.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
16.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
17.The attribute AGE is calculated from DATE_OF_BIRTH. The attribute AGE is :
A. Single valued
B. Multi valued
C. Composite
D. Single valued
18.Which of the following can be a multivalued attribute?
A. Phone_number
B. Name
C. Date_of_birth
D. Phone_number
19.Which of the following is a single valued attribute?
A. Register_number
B. Address
C. SUBJECT_TAKEN
D. Register_number
20.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
21. 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
22.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
23.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
24.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
25.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
26.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
27. An association of several entities in an Entity-Relation model is called :
A. Tuple
B. Record
C. Relationship
D. Tuple
28.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
29.What is oracle error code for exception COLLECTION_IS_NULL?
A. "06530"
B. "06592"
C. "06531"
D. "06530"
30.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
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]