What happens if a tablespace clause is left off of a primary key constraint clause?
- 0 Answers
- 347 Views
- I also Faced
- E-Mail Answers
No Answer is Posted For this Question
Be the First to Post Answer
How many control files should you have? Where should they be located?
Explain dual table. Is any data internally stored in dual table. Lot of users is accessing select sysdate from dual and they getting some millisecond differences. If we execute select sysdate from emp; what error will we get. Why?
what does the no logging option do? Why would we use it?
I have applied the following commands: now what will happen, will the database will give an error / it will work?
What file will give you oracle instance status information? Where is it located?
What is pct free/pct used/pct increase parameter in segment? What is growth factor?
Where can you get a list of all initialization parameters for your instance? How about an indication if they are default settings or have been changed?
If a tablespace has a default pctincrease of zero what will this cause (in relationship to the smon process)?
Users get the following error: ora-00055 maximum number of dml locks exceeded? What is the problem and how do you fix it?
A developer is trying to create a view and the database won’t let him. He has the "developer" role which has the "create view" system privilege and select grants on the tables he is using, what is the problem?
How do you generate file output from sql?
What does a dba do all day?
Oracle General 
