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 - 12
Hassan
1.Which is a unary operation?
A. Selection operation
B. Primitive operation
C. Projection operation
D. Selection operation
2.Which is a join condition contains an equality operator?
A. Equijoins
B. Cartesian
C. Natural
D. Equijoins
3.In precedence of set operators, the expression is evaluated from?
A. Left to left
B. Left to right
C. Right to left
D. Left to left
4.Which of the following is not outer join?
A. Left outer join
B. Right outer join
C. Full outer join
D. Left outer join
5.The assignment operator is denoted by?
A. ->
B. <-
C. =
D. ->
6.Find the ID, name, dept name, salary for instructors whose salary is greater than $80,000?
A. {t | t ε instructor ∧ t[salary] > 80000}
B. Э t ∈ r (Q(t))
C. {t | Э s ε instructor (t[ID] = s[ID]∧ s[salary] > 80000)}
D. {t | t ε instructor ∧ t[salary] > 80000}
7.A query in the tuple relational calculus is expressed as?
A. {t | P() | t}
B. {P(t) | t }
C. {t | P(t)}
D. {t | P() | t}
8.Which of the following best describes the query?
A. Finds the names of all instructors whose department is in the Watson building
B. Finds the names of all department is in the Watson building
C. Finds the name of the dapartment whose instructor and building is Watson
D. Finds the names of all instructors whose department is in the Watson building
9.Which of the following symbol is used in the place of except?
A. ^
B. V
C. ¬
D. ^
10.“Find all students who have taken all courses offered in the Biology department.” The expressions that matches this sentence is ?
A. Э t ε r (Q(t))
B. ∀ t ε r (Q(t))
C. ¬ t ε r (Q(t))
D. Э t ε r (Q(t))
11.Which of the following is the comparison operator in tuple relational calculus?
A. ⇒
B. =
C. ε
D. ⇒
12.An expression in the domain relational calculus is of the form?
A. {P(x1, x2, . . . , xn) | < x1, x2, . . . , xn > }
B. {x1, x2, . . . , xn | < x1, x2, . . . , xn > }
C. { x1, x2, . . . , xn | x1, x2, . . . , xn}
D. {P(x1, x2, . . . , xn) | < x1, x2, . . . , xn > }
13. In domain relaional calculus “there exist” can be expressed as?
A. (P1(x))
B. (P1(x)) Э x
C. V x (P1(x))
D. (P1(x))
14.A set of possible data values is called?
A. Attribute
B. Degree
C. Tuple
D. Attribute
15.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
16.Entity is a?
A. Object of relation
B. Present working model
C. Thing in real world
D. Object of relation
17.The descriptive property possessed by each entity set is?
A. Entity
B. Attribute
C. Relation
D. Entity
18.The function that an entity plays in a relationship is called that entity’s?
A. Participation
B. Position
C. Role
D. Participation
19. The attribute name could be structured as an attribute consisting of first name, middle initial, and last name. This type of attribute is called?
A. Simple attribute
B. Composite attribute
C. Multivalued attribute
D. Simple attribute
20.The attribute AGE is calculated from DATE_OF_BIRTH. The attribute AGE is?
A. Single valued
B. Multi valued
C. Composite
D. Single valued
21.Not applicable condition can be represented in relation entry as?
A. NA
B. 0
C. NULL
D. NA
22.Which of the following can be a multi-valued attribute?
A. Phone_number
B. Name
C. Date_of_birth
D. Phone_number
23.Which of the following is a single valued attribute?
A. Register_number
B. Address
C. SUBJECT_TAKEN
D. Register_number
24.In a relation between the entities the type and condition of the relation should be specified. That is called as attribute?
A. Desciptive
B. Derived
C. Recursive
D. Desciptive
25.Which express the number of entities to which another entity can be associated via a relationship set?
A. Mapping Cardinality
B. Relational Cardinality
C. Participation Constraints
D. Mapping Cardinality
26.An entity in A is associated with at most one entity in B, and an entity in B is associated with at most one entity in A.This is called as?
A. One-to-many
B. One-to-one
C. Many-to-many
D. One-to-many
27.An entity in A is associated with at most one entity in B. An entity in B, however, can be associated with any number (zero or more) of entities in A?
A. One-to-many
B. One-to-one
C. Many-to-many
D. One-to-many
28.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
D. Control who is allowed access to the data
29.Which one of the following uniquely identifies the elements in the relation?
A. Secondary Key
B. Primary key
C. Foreign key
D. Secondary Key
30.Drop Table cannot be used to drop a table referenced by a constraint?
A. Local Key
B. Primary Key
C. Composite Key
D. Local Key
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]