2016年Oracle DBA用户管理試題及答案
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
Q. 6 : Which of the following statements is incorrect when used with : Alter User James
1. Add Quota 5m
2. indentified by james
3. Defaul tablespace system
4. None of the above
Q. 7 : What view consists information about the resource usage parameters for each profile
1. DBA_PROFILE
2. DBA_PROFILES
3. DBA_USERS
4. DBA_RESOURCES
Q. 8 : What 2 values are required to kill a User Session
1. SID, Process ID
2. SID, Serial #
3. Serial #, Process ID
4. None of the above
Q. 9 : What view contains the information about all users and the roles granted to them
1. DBA_ROLES
2. DBA_ROLE_PRIVS
3. DBA_USERS
4. None of the above
Q. 10 : Where can you obtain the SID and Serial # from
1. DBA_PROCESS
2. DBA_SESSION
3. V$SESSION
4. None of the above
Q. 11 : What is the effect of the following command " Alter system kill session ‘12,123‘;
1. Kill Session with PID=12 and Serial=123
2. Kill Session with SID=12 and Serial =123
3. Kill Session with Serial =123 and SID=12
4. None of the above
Q. 12 : What parameter in enables the resource limits
1. RESOURCE=TRUE
2. RESOURCE_LIMIT=TRUE
3. RES_LIMIT=TRUE
4. They are enabled by default
Answer:
1=>1,
2=>2,
3=>4,
4=>1 : IDLE_TIME (in user profile) limits periods of continious inactive time during a session, expressed in minutes. Oracle Net8 configuration parameter RE_TIME enables dead connection detection sending probe packets from sever to client in a user defined interval.
5=>3,
6=>1,
7=>2,
8=>2,
9=>2,
10=>3,
11=>2,
12=>2,
-
如何操作Oracle數據庫中的(+)連接
本文主要向你介紹的是Oracle數據庫中的(+)連接的`實際操作,本文是以相關使用代碼的描述來引出其實際的操作,你如果是Oracle數據庫中的(+)連接的瘋狂一族的話,就一起來看看吧!1.從表A.A1(+)=主表B.B1複製代碼SELECT_CHAR(_IO_DATE,'YYYY/MM/DD')A12.,_TBD_...
-
華創信科oracle ocm認證費用
Oracle數據庫產品為財富排行榜上的前1000家公司所採用,許多大型網站也選用了Oracle系統。下面是小編收集的華創信科oracleocm認證費用,希望大家認真閲讀!OracleWDP培訓中心CUUG(優技培訓)是國內最早通過甲骨文公司審查成為oracleWDP培訓中心的高端IT培訓機構,主要...
-
Oracle數據庫與FoxPro數據的轉換
我們大家都知道Oracle數據庫的數據格式和微機通用的實際應用格式有所不同,所以在實際操作中我們不能對Oracle的數據直接調用,Oracle數據庫所提供的相關前台的開發工具Developer2000雖然可以訪問Oracle的數據。並有數據訪問接口,但這些數據格式不是微機的`通用格式...
-
OracleDBA面試題彙總
1.解釋冷備份和熱備份的不同點以及各自的優點解答:熱備份針對歸檔模式的數據庫,在數據庫仍舊處於工作狀態時進行備份。而冷備份指在數據庫關閉後,進行備份,適用於所有模式的數據庫。熱備份的優點在於當備份時,數據庫仍舊可以被使用並且可以將數據庫恢復到任意一個時...