Creating views with replace option, Database Management System

Creating views with Replace option: This option is used to alter the definition of the view without recreating and dropping it or regranting object privileges previously granted on it.

 

 

Posted Date: 3/11/2013 1:26:31 AM | Location : United States







Related Discussions:- Creating views with replace option, Assignment Help, Ask Question on Creating views with replace option, Get Answer, Expert's Help, Creating views with replace option Discussions

Write discussion on Creating views with replace option
Your posts are moderated
Related Questions
1.Why we need data mining? Give an example to illustrate your answer. 2. Why data mining is considered as "misleading name"? 3. Distinguish the difference between database an

Explain Object oriented Model ? Object Oriented Model - This model is based on the object-oriented programming language paradigm. It involves the features of OOP such as inhe

lock and types of lock

What is Thread splitting A thread of control is a path by which a set of state diagrams on that a single object is active at a time. Objects are shared between threads

Explain controlled redundancy? Controlled redundancy : The replication of data within the data warehouse for the purposes of improved data access or understand ability.

write an SQL statement to create the database in MYSQL server

Question 1 Explain the concept of database recovery management. Explain the different levels of backup used for recovering data Question 2 What are the different types of par

Implementation of association as an object Implement as a separate association object, independent of either class, as in Figure. An association object is a group of pairs

When are they useful? Justify with an example. The temporary tables are commonly used to support specialized rollups or exact application processing needs. Unlike a permanent t

Question (a) Concurrent access to data from a database is a normal part of application program usage. Describe three approaches to concurrency control (b) Distinguish among