Latest Answer: alter database resize ; ...
What are the merits & demerits of uniformed sized extents in locally managed table spaces over non uniformed sized extents in dictionary managed table spaces?
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 ...
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 ...
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.
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. ...
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. ...
Latest Answer: As a dba if you want such info. from your database side.You issue following command from server end.  select owner,table_name,tablespace_name from dba_tables or if you need some specific user info. issue  select owner, table_name ,tablespace_name ...
Latest Answer: There is no need to issue commit command after executing DDL statements as the DDL statements are commited automatically ...
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. ...
View page << Previous 2 3 4 5 [6] 7 Next >>
Go Top
