Technical :: All Aptitude Test ::

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


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