Technical :: All Aptitude Test ::

Hassan
1.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 )

2.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

3.In a query tree, the input relations of query are classified as :
A. attribute nodes
B. leaf nodes
C. stem nodes
D. attribute nodes

4.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

5.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

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.The SELECT operation is performed on :
A. tuples of relation
B. attribute of table
C. entity of DBMS
D. tuples of relation

12.The selection condition of SELECT operator is considered as :
A. column expression
B. row expression
C. string expression
D. column expression

13.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

14.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

15.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

16.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 )

17.The nodes which represents queries in the relations are classified as :
A. relation nodes
B. query nodes
C. truth nodes
D. relation nodes

18.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

19.Which data manipulation command is used to combines the records from one or more tables?
A. SELECT
B. PROJECT
C. JOIN
D. SELECT

20.Which of the following is not a valid SQL type?
A. DECIMALB
B. NUMERIC
C. CHARACTER
D. DECIMALB

21.Which operator is used to compare a value to a specified list of values?
A. BETWEENB
B. ANY
C. IN
D. BETWEENB

22.The SQL used by front-end application programs to request data from the DBMS is called _______?
A. DML
B. DDL
C. VDLD
D. DML

23.The command used to delete a particular column in a relation is ____________ ?
A. UPDATE TABLE
B. TRUNCATE COLUMN
C. ALTER , DROP
D. UPDATE TABLE

24.Which of the following operations requires the relations to be union compatible?
A. UNION
B. INTERSECTION
C. DIFFERENCE
D. UNION

25.The database language that allows us to access data in a database is called :
A. DCL
B. DML
C. DDL
D. DCL

26.Which of the following is a comparison operator in SQL?
A. Double equal sign ( == )
B. LIKE
C. BETWEEN
D. Double equal sign ( == )

27.Which of the following is a legal expression in SQL?
A. SELECT NULL FROM SALES;
B. SELECT NAME FROM SALES;
C. SELECT * FROM SALES WHEN PRICE = NULL;
D. SELECT NULL FROM SALES;

28.DCL provides commands to perform actions like:
A. Change the structure of Tables
B. Insert, Update or Delete Records and Values
C. Authorizing Access and other control over Database
D. Change the structure of Tables

29.The COUNT function in SQL returns the number of ______________?
A. Values
B. Distinct values
C. Group By
D. Values

30.Which data type can store unstructured data in a column?
A. RAW
B. CHAR
C. NUMERIC
D. RAW


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