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 - 31
Hassan
1.The ________ keyword is used to access attributes of preceding tables or subqueries in the from clause.
A. In
B. Lateral
C. Having
D. In
2.Which of the following creates temporary relation for the query on which it is defined ?
A. With
B. From
C. Where
D. With
3.In the query given above which one of the following is a temporary relation ?
A. Budget
B. Department
C. Value
D. Budget
4.Subqueries cannot:
A. Use group by or group functions
B. Retrieve data from a table different from the one in the outer query
C. Join tables
D. Use group by or group functions
5. A Delete command operates on ______ relation.
A. One
B. Two
C. Several
D. One
6.Delete from r where P; The above command :
A. Deletes a particular tuple from the relation
B. Deletes the relation
C. Clears all entries from the relation
D. Deletes a particular tuple from the relation
7.In a set, the NOT IN connective tests for the :
A. Set differences
B. Absence of set differences
C. Absence of set membership
D. Set differences
8.Users describe the kinds of operations that will be performed on the data, on the specification of :
A. Data Requirements
B. Data Gathering
C. Procedural Requirements
D. Data Requirements
9. A special case of multisets, which have only one copy of each element, is known to be :
A. Sets
B. Elements
C. Associator
D. Sets
10.In entity relationship model, the basic objects are known as :
A. Instances
B. Entries
C. Nodes
D. Instances
11.With max_budget (value) as :
A. Budget
B. Department
C. Value
D. Budget
12.Aggregate functions are functions that take a ___________ as input and return a single value.
A. Collection of values
B. Single value
C. Aggregate value
D. Collection of values
13.What does the following query do?
A. It increases the marks of all the students by 10%
B. It decreases the marks of all the students by 90%
C. It increases the marks of all the students by 110%
D. It increases the marks of all the students by 10%
14.State true or false: We cannot write a where clause under an update command :
A. True
B. False
C. May be
D. True
15.Scalar Subqueries can be used in the SQL update statement when they are used under the ____ clause :
A. where
B. with
C. set
D. where
16.Which of the following cannot be used to modify the data in a database :
A. update
B. insert
C. delete
D. update
17.What is a correlated sub-query?
A. An independent query that uses the correlation name of another independent query.
B. A sub-query that uses the correlation name of an outer query
C. A sub-query that substitutes the names of the outer query
D. An independent query that uses the correlation name of another independent query.
18.The _________ construct returns true if the argument in the sub-query is void of duplicates :
A. not null
B. not unique
C. unique
D. not null
19.What is a subquery?
A. A subquery is a select-from-where expression that is nested within another query
B. A subquery is any query that is nested within another query
C. A subquery is a relation that is externally specified which can be used to handle data in queries
D. A subquery is a select-from-where expression that is nested within another query
20.If a set is a collection of values given by the select clause, The ______ connective tests for set membership :
A. within
B. include
C. under
D. within
21.What is the result of the following query?
A. The query gives all the studnames for which marks are greater than all the students in section c
B. The query gives all the studnames for which the marks are greater than at least on student in section c
C. The query gives all the studnames for which the marks are less than all the students in section c
D. The query gives all the studnames for which marks are greater than all the students in section c
22.The ________ comparison checker is used to check “each and every” condition :
A. all
B. and
C. every
D. all
23.Using which language can a user request information from a database ?
A. Query
B. Relational
C. Structural
D. Query
24.Student(ID, name, dept name, tot_cred) : In this query which attribute form the primary key?
A. Name
B. Dept
C. Tot_cred
D. Name
25.Which one of the following is a procedural language ?
A. Domain relational calculus
B. Tuple relational calculus
C. Relational algebra
D. Domain relational calculus
26.The_____ operation allows the combining of two relations by merging pairs of tuples, one from each relation, into a single tuple.
A. Select
B. Join
C. Union
D. Select
27.The result which operation contains all pairs of tuples from the two relations, regardless of whether their attribute values match.
A. Join
B. Cartesian product
C. Intersection
D. Join
28.The result which operation contains all pairs of tuples from the two relations, regardless of whether their attribute values match.
A. Join
B. Cartesian product
C. Intersection
D. Join
29.The _______operation performs a set union of two “similarly structured” tables :
A. Union
B. Join
C. Product
D. Union
30.The most commonly used operation in relational algebra for projecting a set of tuple from a relation is :
A. Join
B. Projection
C. Select
D. Join
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]