Question
a.
The user who creates a view cannot be given update authorization on a view without having update authorization on the relations used to define the view
b.
The user who creates a view cannot be given update authorization on a view without having update authorization on the relations used to define the view
c.
If a user creates a view on which no authorization can be granted, the system will allow the view creation request
d.
A user who creates a view receives all privileges on that view
Posted under DBMS
Engage with the Community - Add Your Comment
Confused About the Answer? Ask for Details Here.
Know the Explanation? Add it Here.
Q. Which of the following is true regarding views ?
Similar Questions
Discover Related MCQs
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
Q. The functions which construct histograms and use buckets for ranking is
View solution
Q. Suppose we are given a view tot credits (year, num credits) giving the total number of credits taken by students in each year.The query that computes averages over the 3 preceding tuples in the specified sort order is
View solution
Q. Inorder to simplify the null value confusion in the rank function we can specify
View solution
Q. If there are n tuples in the partition and the rank of the tuple is r , then its ________ is defined as (r ā1)/(nā1) .
View solution
Suggested Topics
Are you eager to expand your knowledge beyond DBMS? We've curated a selection of related categories that you might find intriguing.
Click on the categories below to discover a wealth of MCQs and enrich your understanding of Computer Science. Happy exploring!
.png)
