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 - 6
1.The _______operation performs a set union of two “similarly structured” tables :
A. Union
B. Intersect
C. Product
D. Union
2.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))
3.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 > }
4.Which of the following is the comparison operator in tuple relational calculus :
A. ⇒
B. =
C. ε
D. ⇒
5.The expression of generalized projection can be written as :
A. π F1, F2, Fn ( R )
B. θ F1, F2, Fn ( R )
C. σ F1, F2, Fn ( R )
D. π F1, F2, Fn ( R )
6.The expression which specifies the procedure to retrieve rather than retrieval content is classified as :
A. procedural expression
B. structural expression
C. functional expression
D. procedural expression
7.In a query tree, the input relations of query are classified as :
A. attribute nodes
B. leaf nodes
C. stem nodes
D. attribute nodes
8.With the help of selection condition, the fraction of selected tuples is classified as :
A. insertion of condition
B. functionality of condition
C. selectivity of the condition
D. insertion of condition
9.The most convenient operation which is used for the queries having universal quantification is classified as :
A. division operation
B. multiply operation
C. add operation
D. division operation
10.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}
11.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}
12.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.
13.Which of the following symbol is used in the place of except ?
A. ^
B. V
C. ¬
D. ^
14. “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))
15.The SELECT operation is performed on :
A. tuples of relation
B. attribute of table
C. entity of DBMS
D. tuples of relation
16.The selection condition of SELECT operator is considered as :
A. column expression
B. row expression
C. string expression
D. column expression
17.The type of JOIN operation through which one can keep all tuples in relations without considering corresponding tuples in any other relation is classified as :
A. stem join
B. leaf join
C. outer join
D. stem join
18.The process in which tuple is created by having combined attributes from two relations is classified as :
A. Cartesian compatibility
B. Cartesian multiples
C. Cartesian product
D. Cartesian compatibility
19.Consider two tuples B and C, the operation whose result includes tuples that are included in both relations or either in B or C is classified as :
A. square of relation B and C
B. union of relation B and C
C. intersection of relation B and C
D. square of relation B and C
20.In relational operations, the SELECT operation is written as :
A. Σ < selection condition > ( S )
B. σ < selection condition > ( R )
C. ω < selection condition > ( R )
D. Σ < selection condition > ( S )
21.The nodes which represents queries in the relations are classified as :
A. relation nodes
B. query nodes
C. truth nodes
D. relation nodes
22.In unary relational operations, the symbol π is used to represent the operation called :
A. OR operation
B. TABLE operation
C. PROJECT operation
D. OR operation
23.Which data manipulation command is used to combines the records from one or more tables?
A. SELECT
B. PROJECT
C. JOIN
D. SELECT
24.Which of the following is not a valid SQL type?
A. DECIMALB
B. NUMERIC
C. CHARACTER
D. DECIMALB
25.Which operator is used to compare a value to a specified list of values?
A. BETWEENB
B. ANY
C. IN
D. BETWEENB
26.The SQL used by front-end application programs to request data from the DBMS is called _______?
A. DML
B. DDL
C. VDLD
D. DML
27.The command used to delete a particular column in a relation is ____________ ?
A. UPDATE TABLE
B. TRUNCATE COLUMN
C. ALTER , DROP
D. UPDATE TABLE
28.Which of the following operations requires the relations to be union compatible?
A. UNION
B. INTERSECTION
C. DIFFERENCE
D. UNION
29.The database language that allows us to access data in a database is called :
A. DCL
B. DML
C. DDL
D. DCL
30.Which of the following is a comparison operator in SQL?
A. Double equal sign ( == )
B. LIKE
C. BETWEEN
D. Double equal sign ( == )
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]