Advanced SQL Mcqs

Our collections of Multiple choice questions and answers focuses on study of ” Advanced SQL “. These questions are chosen from a collection of most authoritative and best reference books on DBMS.Our aim is to prepare an individual for competitive exams like NTS | GAT | ECAT | Data Warehouse jobs | Data Mining | DB administration jobs | Nadra Jobs | Software House and Data Base and Web Developer jobs | University and College entrance exams and various tests and job interviews. One should practice our Mcqs to assimilate DBMS Advanced SQL comprehensively.

  1. Home
  2. »
  3. Computer Science Mcqs
  4. »
  5. DBMS Mcqs
  6. »
  7. Advanced SQL Mcqs
  8. »
  9. Page 3

31.
Which JDBC Driver is the most efficient of all the JDBC drivers?

Type 1 Driver

Type 2 Driver

Type 3 Driver

Type 4 Driver

33.
What is the full form of OLAP?

Online Application Programming

Online Application Processing

Online Analytical programming

Online Analytical Processing

34.
Data that can be modelled as dimension attributes and measure attributes are called ___________

Mono-dimensional data

Multi-dimensional data

Measurable data

Efficient data

35.
The operation of changing a dimensions used in a cross-tab is called as ________

Alteration

Pivoting

Piloting

Renewing

36.
The operation of moving from finer granular data to coarser granular data is called _______

Reduction

Increment

Roll up

Drill down

37.
How many dimensions of multi-dimensional data do cross tabs enable analysts to view?

1

2

3

None of the mentioned

38.
The _______ function allows substitution of values in an attribute of a tuple

Cube

Unknown

Decode

Substitute

39.
Which of the following OLAP systems do not exist?

HOLAP

MOLAP

ROLAP

None of the mentioned

40.
The operation of moving from coarser granular data to finer granular data is called _______

Reduction

Increment

Roll back

Drill down

42.
The select operation’s function in relational algebra is identical to the _______ clause in SQL

Where

From

Select

None of the mentioned

43.
The project operation’s function in relational algebra is identical to the _______ clause in SQL

Where

From

Select

None of the mentioned

44.
What does the following relational operation perform?ρx(A1,A2,A3…) (E)

It returns the result of expression E with the previous attribute names

It returns the result of expression E renaming the attributes as A1, A2, …

It returns the result of the relation E but saves the old attributes

None of the mentioned

45.
What does the following relational algebra expression do?σamount > 1200 (loan)

Finds all the tuples in loan

Finds the tuples in loan where the amount is greater than 12000

Finds all the tuples in loan where the amount is greater than 1200

Finds all the amounts in loan where the number of values is greater than 1200

error: You are not allowed to do so.....
0Shares
0
Scroll to Top