Q. A _________ is a statement that the system executes whenever a database is modified

View solution

Q. State true or false: Recursive queries are permitted in SQL

View solution

Q. How many different types of drivers are present in JDBC?

View solution

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

View solution

Q. Which package comprises of the core JDBC API?

View solution

Q. What is the full form of OLAP?

View solution

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

View solution

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

View solution

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

View solution

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

View solution

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

View solution

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

View solution

Q. State true or false: OLAP systems can be implemented as client-server systems

View solution

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

View solution

Q. State true or false: In OLAP, analysts cannot view a dimension in different levels of detail.

View solution

Q. Which of the following is not a relational algebra function?

View solution

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

View solution

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

View solution

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

View solution

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

View solution