OracleDBA用户管理笔试题

OracleDBA用户管理笔试题

q. 1 : the default tablespace clause in the create user command sets the location for
　　
　　1. database objects created by the user
　　2. temporary objects created by the user
　　3. system objects created by the user
　　4. none of the above
　　
　　q. 2 : what does sessions_per_user in a resource limit set
　　
　　1. no of concurrent sessions for the database
　　2. no of sessions per user
　　3. no of processes per user
　　4. none of the above
　　
　　q. 3 : what keyword during the create user command, limits the space used by users objects in the database
　　
　　1. size
　　2. next_extent
　　3. max_extents
　　4. quota
　　
　　
　　q. 4 : what value sets the no activity time in minutes before a user is disconnected
　　
　　1. idle_time
　　2. disconnect_time
　　3. connect_time
　　4. none of the above
　　
　　q. 5 : what operations are limited by the quota on a tablespace
　　
　　1. update
　　2. delete
　　3. create
　　4. all of the above