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

View solution

Q. In SQL the cross-tabs are created using

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. What do data warehouses support?

View solution

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

View solution

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

View solution

Q. Select * from employee where employee_id>1009;

Which of the following employee_id will be displayed?

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. Which of the following is used to provide privilege to only a particular attribute ?

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 delete authorization to instructor ?

View solution

Q. Which of the following is true regarding views ?

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. In authorization graph if DBA provides authorization to u1 which in turn gives to u2 which of the following is correct ?

View solution

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

View solution

Q. The granting and revoking of roles by the user may cause some confusions when that user role is revoked .To overcome the above situation

View solution