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.
32. Which package comprises of the core JDBC API?
Java.sql
Java.database
Sql.java
Java.relation
Answer & Solution
No Solution for this Answer..! Report or Discus this Question
33. What is the full form of OLAP?
Online Application Programming
Online Application Processing
Online Analytical programming
Online Analytical Processing
Answer & Solution
No Solution for this Answer..! Report or Discus this Question
34. Data that can be modelled as dimension attributes and measure attributes are called ___________
Mono-dimensional data
Multi-dimensional data
Measurable data
Efficient data
Answer & Solution
No Solution for this Answer..! Report or Discus this Question
35. The operation of changing a dimensions used in a cross-tab is called as ________
Alteration
Pivoting
Piloting
Renewing
Answer & Solution
No Solution for this Answer..! Report or Discus this Question
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
Answer & Solution
No Solution for this Answer..! Report or Discus this Question
40. The operation of moving from coarser granular data to finer granular data is called _______
Reduction
Increment
Roll back
Drill down
Answer & Solution
No Solution for this Answer..! Report or Discus this Question
41. Which of the following is not a relational algebra function?
Select
Project
Manipulate
Union
Answer & Solution
No Solution for this Answer..! Report or Discus this Question
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
Answer & Solution
No Solution for this Answer..! Report or Discus this Question
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
Answer & Solution
No Solution for this Answer..! Report or Discus this Question