Q. Which of the following is used to avoid cascading of authorizations from the user ?

View solution

Q. In authorization graph if DBA provides authorization to u1 which in turn gives to u2 which of the following is correct ?

View solution

Q. If we wish to grant a privilege and to allow the recipient to pass the privilege on to other users, we append the __________ clause to the appropriate grant command.

View solution

Q. Which of the following is true regarding views ?

View solution

Q. Which of the following is used to provide delete authorization to instructor ?

View solution

Q. Which of the following statement is used to remove the privilege from the user Amir ?

View solution

Q. Which of the following is used to provide privilege to only a particular attribute ?

View solution

Q. Consider the two relations instructor and department. Which of the following is used to create view for these relations together?

View solution

Q. Select * from employee where employee_id>1009;

Which of the following employee_id will be displayed?

View solution

Q. Which of these query will display the the table given below ?

View solution

Q. Which one of the following is the right syntax for DECODE ?

View solution

Q. What do data warehouses support?

View solution

Q. { (item name, color, clothes size), (item name, color), (item name, clothes size), (color, clothes size), (item name), (color), (clothes size), () }

This can be achieved by using which of the following ?

View solution

Q. In SQL the cross-tabs are created using

View solution

Q. The operation of moving from finer-granularity data to a coarser granularity (by means of aggregation) is called a ________

View solution

Q. The process of viewing the cross-tab (Single dimensional) with a fixed value of one attribute is

View solution

Q. The generalization of cross-tab which is represented visually is ____________ which is also called as data cube.

View solution

Q. Data that can be modeled as dimension attributes and measure attributes are called _______ data.

View solution

Q. OLAP stands for

View solution

Q. The command ________________ such tables are available only within the transaction executing the query, and are dropped when the transaction finishes.

View solution