What are the merits & demerits of uniformed sized extents in locally managed table spaces over non uniformed sized extents in dictionary managed table spaces?

Read Answers (1) | Asked by : nutan

Answer Question Subscribe

Is it possible to disable the connection sys as sysdba. If yes, does violates oracle 9i?

Latest Answer: in 10g there is a option to lock an acount we can lock system user through this correct me if i am wrong ...

Read Answers (2) | Asked by : reddy

Answer Question Subscribe

What is a lookup table in database? where can we use these type of table?

Latest Answer: Lookup tables are like constraints which hold a value. The content in the lookup tables dosen't change often, hence refered as lookup (reference). Example : Countries table Countries are not added on regular bases hence one can consider the table ...

Read Answers (2) | Asked by : rrvathana

Answer Question Subscribe

I currently can't see my custom SQL views from IDS9 in MS Access when I want to link the table

I currently can't see my custom SQL views from IDS9 in MS Access when I want to link the table to an Access DB which is used for integration.IDS runs on SuSE9, MS Access 2K on XP.

View Question | Asked by : Herr von Klinkenhoffer

Answer Question Subscribe

Whenever a DBA creates a user in which datafile that will be get created ?

none

Latest Answer: When the user is created without mentioning default tablespace, then it will be created in SYSTEM tablespace. If Temporary tablespace is also not mentioned then it will automatically take the default temporary tablespace mentioned by the DBA. ...

Read Answers (5) | Asked by : chinmay

Answer Question Subscribe

How is locking implemented?

Latest Answer: Whenever an SQL is issued for execution, DB2 checks for lock avoidance by checking the SQL.Eg. SELECT ...... WITH UR or BIND with ISOLATION (UR) (UR Uncommitted Read)If not DB2 checks for the number of locks available in the system and the number of locksrequested by the program. ...

Read Answers (4)

Answer Question Subscribe

How can you find all the tables created by an user?

Latest Answer: select sum(bytes)/1024 from dba_segments where segment_name='TABLE_NAME' and owner=' 'As segment_name represents table_name,index_name..provide the table_name and index_name in the above query ...

Read Answers (13)

Answer Question Subscribe

Do you need a commit after DDL statements?

Latest Answer: There is no need to issue commit command after executing DDL statements as the DDL statements are commited automatically ...

Read Answers (8)

Answer Question Subscribe

Is it advisable to force an index when you want to select most of the entries in the table?

Latest Answer: No it isn't. If you are going to select most of the entries then you will have to read through the entire table anyway. Forcing the use of an index will just be an extra overhead. ...

Read Answers (4)

Answer Question Subscribe

View page << Previous 1 2 3 4 [5] 6 Next >>

Go Top

#	User Name	Count
1	Pragati.rch	42
2	shanthiavari	36
3	cmanne	18
4	rajendra_thanekar	8
5	hemant.agarwal03	8
6	senthilora	7
7	satyam_Ora	6
8	nafees	5
9	hasanvtu	5
10	parthokonar1	5

Get Latest Updates Via RSS Reader or by Email
Forum Discussion
Knowledge Base
Learning Series
Freelance Jobs
GeekInterview Blog
Testing Interview Questions
Oracle Interview Questions
Java Interview Questions
Latest Placement Papers
Free Training
Learn AJAX