Latest Answer: 1. DBMS is a single user system RDBMS is a multiuser system
2. DBMS stores do not store data in the form of tables while RDBMS stores it in the form of tables.
3. Most of DBMS are not supporting client/server architecture ...
Latest Answer: high water mark is concerned with segments not with the datafilesafter analysing the segments, this query will give the hwm for the segmentselect (blocks-empty_blocks) HWM from dba_segments where segment_name=upper('name') and segment_owner=upper('name'); ...
Latest Answer: The purpose of Product_user_profile table of SYSTEM is to control users from executing SQL commands. For example, if you dont want one of your users to execute DELETE fommand, this can be implemented in this table. ...
Latest Answer: a candidate key is a key that uniquly identifies ...
Latest Answer: Autonomous transaction defined and executed independent of calling program. u need to define PRAGMA AUTONOMOUS_TRANSACTION at declare section. stored procedure, function can be defined as autonomous transaction. ...
How do benefit from a partial partition-wise join for two tables. Explain the usage and what is required?
View page << Previous 1 [2] 3 Next >>
Go Top
