当前位置: 网站首页 >
OCP认证
- Oracle 11g OCP认证052考试题库（71）-CUUG内部学员版Which four are true about transactions, undo segments, and undo tablespaces? A)undo tablespaces contain undo segments and Global Temporary Table Data. B)undo segments can be brought offline aut...[详细]
- Oracle 11g OCP认证052考试题库（70）-CUUG内部学员版Which two are true about transactions, UNDO segments, and UNDO tablespaces? A)UNDO tablespaces are created and dropped automatically. B)UNDO tablespaces are brought ONLINE or OFFLINE as require...[详细]
- Oracle 11g OCP认证052考试题库（69）-CUUG内部学员版Which three are true? A)Active UNDO might be retained for 15 or more minutes. B)Inactive UNDO might be retained for 15 or more minutes. C)The UNDO tablespace is guaranteed to be retained forev...[详细]
- Oracle 11g OCP认证052考试题库（68）-CUUG内部学员版Which two are true? A)Inactive expired UNDO will be retained as long as possible within the limits of the current size of the UNDO tablespace. B)The UNDO tablespace can grow automatically if th...[详细]
- Oracle 11g OCP认证052考试题库（67）-CUUG内部学员版Examine these SQL statements and their output: SQL select name,value 2 from v$parameter 3 where name like 'undo%'; NAME VALUE -------------------- ------------------- undo_management AUTO ...[详细]
- Oracle 11g OCP认证052考试题库（66）-CUUG内部学员版Which two are true? A)Transactions will wait until free space becomes available in the undo tablespace when they have failed to allocate space B)The undo tablespace will grow automatically if t...[详细]
- Oracle 11g OCP认证052考试题库（65）-CUUG内部学员版In a database,EXAMPLE is the default tablespace and DEFERED_SEGMENT_CREATION is FALSE. Examine these commands executed by SYS: SQL CREATE USER u1 IDENTIFIED BY Oracle; SQL CREATE TABLE u1.tab1...[详细]
- Oracle 11g OCP认证052考试题库（64）-CUUG内部学员版Examine these facts about a database: 1.USERS is the database default tablespace. 2.USER1 and USER2 have the CREATE SESSION privilege. 3.They also have UNLIMITED QUOTA on the USERS tablespace....[详细]
- Oracle 11g OCP认证052考试题库（63）-CUUG内部学员版You have decided to implement the principle of least privilege and separation of duties. Which two actions must you take? A)Grant SYSOPER to application schema owners. B)Grant access to the Or...[详细]
- Oracle 11g OCP认证052考试题库（62）-CUUG内部学员版IN one of your databases; ?The database default tablespace is EXAMPLE. ?DEFERRED_SEGMENT_CREATION IS FALSE. Examine these commands; SQL CREATE USER user1 IDENTIFIED BY Oracle_4U; User create...[详细]
- Oracle 11g OCP认证052考试题库（61）-CUUG内部学员版In one of your databases,The database default tablespace is EXAMPLE. DEFERRED_SEGMENT_CREATION IS FALSE. Examine these commands; SQL.CREATE USER user1 IDENTIFIED BY Oracle_4U password expire; ...[详细]
