Answer Posted / 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).

What are tables and fields in the database?

1184

---

What is record variable?

1037

---

Is sql open source?

1022

---

How do I run a sql trace?

1000

---

i have some prob lem to tell me about my self in interview first round ...

2214

---

Is sql pronounced sequel or sql?

1336

---

Can one improve the performance of sql*loader? : aql loader

1097

---

what is a composite key ? : Sql dba

1099

---

How can you maintain the integrity of your database on instances where deleting an element in a table result in the deletion of the element(s) within another table?

1173

---

Can a procedure in a package be overloaded?

1099

---

What is the use of nvl function?

1239

---

Write the order of precedence for validation of a column in a table? I. Done using database triggers. Ii. Done using integarity constraints

1130

---

Can a view be mutating? If yes, then how?

1086

---

Explain the the update statement in sql?

1098

---

name 3 ways to get an accurate count of the number of records in a table? : Sql dba

1116

---