Answer Posted / orawhiz
A table is the basic unit of data storage in an ORACLE
database. The tables of a database hold all of the user
accessible data. Table data is stored in rows and columns.
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
How to use like conditions in oracle?
How to view existing locks on the database?
What are a collation and state the different types of collation sensitivity?
What is backup in Oracle?
What is different types of joins?
What do you mean by a tablespace?
What is the difference between count (*), count (expression), count (distinct expression)?
How to call a sub procedure?
1) WIll all the user get the DEFAULT profile, if their current profile got deleted at any point of time? 2) What are the Situation we need to MOVE the TABLE between T.spaces? 3) What is the use of MOVING the TABLE between SCHEMA'S? 4) What are the Table Clause, Segment Clause and the Datafile Clause which will override each other? 5) Explain SORT_AREA_SIZE of Tempfile to make UNIFORM SIZE
ur a sql devoloper...what is the process in ur company for finding the database BUGS .. seperate DB testers are there? or devr.s are manage? if DB TESTERS in there what is the process
What is a synonym? What are its various types?
I just want to maintain data like an employee can belongs to 3 or more departments . We can resolve this by using composite key but it avoids normalization rules. So Can anyone tell me how can I maintain data.
What is an oracle table?
What is the effect of setting the value "all_rows" for optimizer_goal parameter of the alter session command? What are the factors that affect optimizer in choosing an optimization approach?
Explain oracle’s server parameter file.