Suppose I have to create a view on a table, that is not yet been
created by DBA. I khow the table structure. Is it possible to
create the view before DBA creates this table? If yes then how?
Is it possible to create synonym in this way?

Answers were Sorted based on User's Feedback



Suppose I have to create a view on a table, that is not yet been created by DBA. I khow the table s..

Answer / monika

Yes, we can create a view on a table that really doesn't
exist yet.We can do this by putting a word (Force) in
create view command-

create force view v1 as
select * from emp;

here view gets created but its staus is invalid,its become
valid when we create table emp(table on which view is
defined).

Is This Answer Correct ?    44 Yes 2 No

Suppose I have to create a view on a table, that is not yet been created by DBA. I khow the table s..

Answer / anitha

It is true that the force option can be used to create the
view. But, this view will remain invalid even after the
creation the the Table. It needs to be recompiled again.

Is This Answer Correct ?    6 Yes 1 No

Suppose I have to create a view on a table, that is not yet been created by DBA. I khow the table s..

Answer / ram

i cannot create a view unless the DBA gives me create view system privilege and to create a view in any schema, rather than just your own we need the create view privilege and be granted the select,insert,update and delete objects on table underlying the view.
synonym is the alias to database object and to hide details of source of the database object. a public synonym is created by the DBA and is available for use by any database user. a private synonym is defined in the schema by the user and is available to the user.

Is This Answer Correct ?    3 Yes 3 No

Suppose I have to create a view on a table, that is not yet been created by DBA. I khow the table s..

Answer / neo

Synonym can be created on non-existing table without using
Force keyword. It automatically become valid once table is
created.

Is This Answer Correct ?    1 Yes 1 No

Post New Answer

More SQL PLSQL Interview Questions

What is informix sql?

0 Answers  


oracle is compiler or interpretter,can any one tell me the answer?

9 Answers   Satyam,


How many subqueries can be nested in a statement?

0 Answers  


What is trigger price?

0 Answers  


How to use sql statements in pl/sql?

0 Answers  






What are sql constraints?

0 Answers  


What is crud diagram?

0 Answers  


How can you know that statistics should be updated?

0 Answers  


What is the difference between microsoft access and sql server?

0 Answers  


Is sql a scripting language?

0 Answers  


What is out parameter used for eventhough return statement can also be used in pl/sql?

0 Answers  


How do sql triggers work?

0 Answers  


Categories