单选题Evaluate the following command：   SQL>ALTER SYSTEM SET db_securefile = ’IGNORE’；   What is the impact of this setting on the usage of SecureFiles？（）AIt forces BasicFiles to be created even if the SECUREFILE option is specified to create the LOBBIt forc

题目
单选题
Evaluate the following command：   SQL>ALTER SYSTEM SET db_securefile = ’IGNORE’；   What is the impact of this setting on the usage of SecureFiles？（）
A

 It forces BasicFiles to be created even if the SECUREFILE option is specified to create the LOB

B

 It forces SecureFiles to be created even if the BASICFILE option is specified to create the LOB

C

 It does not allow the creation of SecureFiles and generates an error if the SECUREFILE option is specified to create the LOB

D

 It ignores the SECUREFILE option only if a Manual Segment Space Management tablespace is used and creates a BasicFile

相似考题

1.Evaluate the following command:SQL>ALTER SYSTEM SET db_securefile = ‘IGNORE‘;What is the impact of this setting on the usage of SecureFiles?()A. It forces BasicFiles to be created even if the SECUREFILE option is specified to create the LOBB. It forces SecureFiles to be created even if the BASICFILE option is specified to create the LOBC. It does not allow the creation of SecureFiles and generates an error if the SECUREFILE option is specified to create the LOBD. It ignores the SECUREFILE option only if a Manual Segment Space Management tablespace is used and creates a BasicFile

2. In Recovery Manager （RMAN）， you set the retention policy to NONE by executing the following command：  CONFIGURE RETENTION POLICY TO NONE;  What would be the impact of this setting？（）A、The retention policy is cleared.B、RMAN does not consider any backup as obsolete.C、The retention policy is set to its default setting of redundancy 1.D、The retention policy is set to its default setting of recovery window 7.

3.Which of the following is TRUE when creating a file system that resides on the center of a disk?（）A、The logical volume is created first.B、The physical volume will be automatically created.C、The physical partition must be specified as an option.D、The file system will be mounted during the time of creation.

4.Which of the following is TRUE when creating a file system that resides on the center of a disk?()A.The logical volume is created first.B.The physical volume will be automatically created.C.The physical partition must be specified as an option.D.The file system will be mounted during the time of creation.

更多“单选题Evaluate the following command：   SQLALTER SYSTEM SET db_securefile = ’IGNORE’；   What is the impact of this setting on the usage of SecureFiles？（）A  It forces BasicFiles to be created even if the SECUREFILE option is specified to create the LOBB  It f”相关问题

  • 第1题：

    A system administrator can create logical volumes and then add file systems to them， or create the file system directly. What is an advantage of the two-step approach instead of the one-step approach？（）

    • A、The number of bytes per inode can be specified.
    • B、Placement of the filesystem on the disk can be specified.
    • C、The jfslog can be specified on creation of the filesystem.
    • D、Either a JFS or JFS2 filesystem can be created on the logical volume.

    正确答案:B

  • 第2题：

    Evaluate the CREATE TABLE statement：   CREATE TABLE products   （product_id NUMBER （6）  CONSTRAINT prod_id_pk PRIMARY KEY，  product_name VARCHAR2 （15））；   Which statement is true regarding the PROD_ID_PK constraint？（）

    • A、 It would be created only if a unique index is manually created first.
    • B、 It would be created and would use an automatically created unique index.
    • C、 It would be created and would use an automatically created nonunique index.
    • D、 It would be created and remains in a disabled state because no index is specified in the command.

    正确答案:B

  • 第3题：

    Examine the following steps performed on a database instance： 1. The DBA grants the CREATE TABLE system privilege to the SKD user with ADMIN OPTION. 2. The SKD user creates a table. 3. The SKD user grants the CREATE TABLE system privilege to the HR user. 4. The HR user creates a table. 5. The DBA revokes the CREATE TABLE system privilege from SKD.  Which statement is true after step 5 isperformed（）

    • A、The table created by SKD is not accessible and SKD cannot create new tables.
    • B、The tables created by SKD and HR remain， but both cannot create new tables.
    • C、The table created by HR remains and HR still has the CREATE TABLE system privilege.
    • D、The table created by HR remains and HR can grant the CREATE TABLE system privilege to other users.

    正确答案:C

  • 第4题：

    Examine the following steps performed on a database instance：  1：The DBA grants the CREATE TABLE system privilege to the SKD user with ADMIN OPTION.  2：The SKD usercreates a table.  3：The SKD user grants theCREATETABLE system privilege to the HR user.  4：The HR user creates a table.  5：The DBA revokes the CREATE TABLE system privilege from SKD.  Which statement is true after step 5 is performed（）

    • A、The table created by SKD isnot accessibleand SKD cannot create new tables.
    • B、The tables created by SKD and HR remain， but both cannot create new tables.
    • C、The table created by HR remains and HR still has the CREATE TABLE system privilege.
    • D、The table created by HR remains and HR can grant the CREATE TABLE system privilege to other users.

    正确答案:C

  • 第5题：

    You issued the following command at the UNIX environment：   % setenv ORA_SDTZ ’OZ_TZ’   What will be the impact of issuing the above command？（）  

    • A、 The operating system local time zone will be set for a user session using the operating system environment variable.
    • B、 The database local time zone will be set for a user session using the operating system environment variable.
    • C、 The operating system local time zone will be set for the database using the operating system environment
    • D、 The database local time zone will be set for the database using the operating system environment variable.

    正确答案:B

  • 第6题：

    单选题
    The warning and critical threshold values have been set to 85% and 97%， respectively， for one of the tablespaces. The current tablespace space usage is 54%. You modify the warning threshold to be 50% and critical threshold to be 53% in Database Control. Which statement is true？（）
    A

    The new setting would be applied but no alerts would be raised immediately.

    B

    The new setting would be applied and an alert would be raised immediately.

    C

    The new setting would be ignored because the tablespace space usage is more than the specified threshold value.

    D

    The new setting would cause an error because the tablespace space usage is more than the specified threshold value.


    正确答案： B
    解析： 暂无解析

  • 第7题：

    单选题
    Evaluate the following command：   SQL> CREATE TABLE design_data （id NUMBER， doc CLOB）  LOB（doc） STORE AS SECUREFILE（DEDUPLICATE）；   Which statement is true regarding the above command？（）
    A

     The LOB values are automatically compressed.

    B

     The LOB values are cached by default in the buffer cache.

    C

     The LOB values are automatically stored in encrypted mode.

    D

     All LOB data that is identical in two or more rows in a LOB column share the same data blocks.


    正确答案： A
    解析： 暂无解析

  • 第8题：

    单选题
    The INV_HISTORY table is created using the command: You would like to store the data belonging to the year 2006 in a single partition and issue the command: What would be the outcome of this command? （）
    A

    It executes successfully, and the transition point is set to '1-apr-2006'.

    B

    It executes successfully, and the transition point is set to '15-apr-2006'.

    C

    It produces an error because the partitions specified for merging are not adjacent.

    D

    It produces an error because the date values specified in the merge do not match the date values stored in the table.


    正确答案： D
    解析： 暂无解析

  • 第9题：

    单选题
    Examine the following steps performed on a database instance： 1. The DBA grants the CREATE TABLE system privilege to the SKD user with ADMIN OPTION. 2. The SKD user creates a table. 3. The SKD user grants the CREATE TABLE system privilege to the HR user. 4. The HR user creates a table. 5. The DBA revokes the CREATE TABLE system privilege from SKD.  Which statement is true after step 5 isperformed（）
    A

    The table created by SKD is not accessible and SKD cannot create new tables.

    B

    The tables created by SKD and HR remain， but both cannot create new tables.

    C

    The table created by HR remains and HR still has the CREATE TABLE system privilege.

    D

    The table created by HR remains and HR can grant the CREATE TABLE system privilege to other users.


    正确答案： C
    解析： 暂无解析

  • 第10题：

    单选题
    The size of the largest datafile， data1.dbf， in your database is 30MB. You issued the following command：   RMAN>CONFIGURE MAXSETSIZE 10MB；     What will be the impact of the above setting？（）
    A

     While performing the backup of the datafile，data1.dbf，one backup set is created.

    B

     While performing the backup of the datafile，data1.dbf，two backup sets are created.

    C

     While performing the backup of the datafile，data1.dbf，three backup sets are created.

    D

     While performing the backup of the datafile，data1.dbf，the command for performing a backup of the datafile，data1.dbf，will fail.


    正确答案： C
    解析： 暂无解析

  • 第11题：

    单选题
    Evaluate the following command：   SQL>ALTER SYSTEM SET db_securefile = ’IGNORE’；   What is the impact of this setting on the usage of SecureFiles？（）
    A

     It forces BasicFiles to be created even if the SECUREFILE option is specified to create the LOB

    B

     It forces SecureFiles to be created even if the BASICFILE option is specified to create the LOB

    C

     It does not allow the creation of SecureFiles and generates an error if the SECUREFILE option is specified to create the LOB

    D

     It ignores the SECUREFILE option only if a Manual Segment Space Management tablespace is used and creates a BasicFile


    正确答案： D
    解析： 暂无解析

  • 第12题：

    多选题
    You decided to increase the value for the SHARED_SERVERS parameter by using the following command：  SQL> ALTER SYSTEM SET SHARED_|SERVERS=3 SCOPE=？；  Which three values can be specified for the SCOPE clause？（）
    A

    ALL

    B

    PFILE

    C

    BOTH

    D

    NONE

    E

    SPFILE

    F

    MEMORY

    G

    INSTANCE

    H

    DATABASE


    正确答案： C,B
    解析： 暂无解析

  • 第13题：

    An  administrator  can  create  logical  volumes  and  then  add  file  systems  to  them，  or  create  the  file  system directly.  What is an dvantage of the two-step approach instead of the one-step approach（）

    • A、The number of bytes per inode can be specified.
    • B、Placement of the filesystem on the disk can be specified.
    • C、The jfslog can be specified on creation of the filesystem.
    • D、Either a JFS or JFS2 filesystem can be created on the logical volume.

    正确答案:B

  • 第14题：

    The warning and critical threshold values have been set to 85% and 97%， respectively， for one of the tablespaces. The current tablespace space usage is 54%. You modify the warning threshold to be 50 % and critical threshold to be 53% in Database Control. Which statement is true？（）

    • A、 The new setting would be applied but no alerts would be raised immediately.
    • B、 The new setting would be applied and an alert would be raised immediately.
    • C、 The new setting would be ignored because the tablespace space usage is more than the specified threshold value.
    • D、 The new setting would cause an error because the tablespace space usage is more than the specified threshold value.

    正确答案:A

  • 第15题：

    The size of the largest datafile， data1.dbf， in your database is 30MB. You issued the following command：   RMAN>CONFIGURE MAXSETSIZE 10MB；     What will be the impact of the above setting？（）

    • A、 While performing the backup of the datafile，data1.dbf，one backup set is created.
    • B、 While performing the backup of the datafile，data1.dbf，two backup sets are created.
    • C、 While performing the backup of the datafile，data1.dbf，three backup sets are created.
    • D、 While performing the backup of the datafile，data1.dbf，the command for performing a backup of the datafile，data1.dbf，will fail.

    正确答案:D

  • 第16题：

    Evaluate the following command：   SQL>ALTER SYSTEM SET db_securefile = ’IGNORE’；   What is the impact of this setting on the usage of SecureFiles？（）

    • A、 It forces BasicFiles to be created even if the SECUREFILE option is specified to create the LOB
    • B、 It forces SecureFiles to be created even if the BASICFILE option is specified to create the LOB
    • C、 It does not allow the creation of SecureFiles and generates an error if the SECUREFILE option is specified to create the LOB
    • D、 It ignores the SECUREFILE option only if a Manual Segment Space Management tablespace is used and creates a BasicFile

    正确答案:A

  • 第17题：

    单选题
    An  administrator  can  create  logical  volumes  and  then  add  file  systems  to  them，  or  create  the  file  system directly.  What is an dvantage of the two-step approach instead of the one-step approach（）
    A

    The number of bytes per inode can be specified.

    B

    Placement of the filesystem on the disk can be specified.

    C

    The jfslog can be specified on creation of the filesystem.

    D

    Either a JFS or JFS2 filesystem can be created on the logical volume.


    正确答案： C
    解析： 暂无解析

  • 第18题：

    单选题
    Examine the following steps performed on a database instance：  1：The DBA grants the CREATE TABLE system privilege to the SKD user with ADMIN OPTION.  2：The SKD usercreates a table.  3：The SKD user grants theCREATETABLE system privilege to the HR user.  4：The HR user creates a table.  5：The DBA revokes the CREATE TABLE system privilege from SKD.  Which statement is true after step 5 is performed（）
    A

    The table created by SKD isnot accessibleand SKD cannot create new tables.

    B

    The tables created by SKD and HR remain， but both cannot create new tables.

    C

    The table created by HR remains and HR still has the CREATE TABLE system privilege.

    D

    The table created by HR remains and HR can grant the CREATE TABLE system privilege to other users.


    正确答案： C
    解析： 暂无解析

  • 第19题：

    单选题
    Evaluate the CREATE TABLE statement：   CREATE TABLE products   （product_id NUMBER （6）  CONSTRAINT prod_id_pk PRIMARY KEY，  product_name VARCHAR2 （15））；   Which statement is true regarding the PROD_ID_PK constraint？（）
    A

     It would be created only if a unique index is manually created first.

    B

     It would be created and would use an automatically created unique index.

    C

     It would be created and would use an automatically created nonunique index.

    D

     It would be created and remains in a disabled state because no index is specified in the command.


    正确答案： A
    解析： 暂无解析

  • 第20题：

    单选题
    You issued the following command at the UNIX environment：   % setenv ORA_SDTZ ’OZ_TZ’   What will be the impact of issuing the above command？（）
    A

     The operating system local time zone will be set for a user session using the operating system environment variable.

    B

     The database local time zone will be set for a user session using the operating system environment variable.

    C

     The operating system local time zone will be set for the database using the operating system environment

    D

     The database local time zone will be set for the database using the operating system environment variable.


    正确答案： A
    解析： 暂无解析

  • 第21题：

    单选题
    A system administrator can create logical volumes and then add file systems to them， or create the file system directly. What is an advantage of the two-step approach instead of the one-step approach？（）
    A

    The number of bytes per inode can be specified.

    B

    Placement of the filesystem on the disk can be specified.

    C

    The jfslog can be specified on creation of the filesystem.

    D

    Either a JFS or JFS2 filesystem can be created on the logical volume.


    正确答案： B
    解析： 暂无解析

  • 第22题：

    单选题
    Evaluate the following command: SQL>ALTER SYSTEM SET db_securefile = 'IGNORE'; What is the impact of this setting on the usage of SecureFiles?（）
    A

    It forces BasicFiles to be created even if the SECUREFILE option is specified to create the LOB

    B

    It forces SecureFiles to be created even if the BASICFILE option is specified to create the LOB

    C

    It does not allow the creation of SecureFiles and generates an error if the SECUREFILE option is specified to create the LOB

    D

    It ignores the SECUREFILE option only if a Manual Segment Space Management tablespace is used and creates a BasicFile


    正确答案： B
    解析： 暂无解析

  • 第23题：

    单选题
    In Recovery Manager （RMAN）， you set the retention policy to NONE by executing the following command：  CONFIGURE RETENTION POLICY TO NONE;  What would be the impact of this setting？（）
    A

    The retention policy is cleared.

    B

    RMAN does not consider any backup as obsolete.

    C

    The retention policy is set to its default setting of redundancy 1.

    D

    The retention policy is set to its default setting of recovery window 7.


    正确答案： A
    解析： 暂无解析

  • 第24题：

    单选题
    Which of the following is TRUE when creating a file system that resides on the center of a disk?（）
    A

    The logical volume is created first.

    B

    The physical volume will be automatically created.

    C

    The physical partition must be specified as an option.

    D

    The file system will be mounted during the time of creation.


    正确答案： B
    解析： 暂无解析

相关内容