单选题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 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
单选题
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
参考解析
解析：
暂无解析
相关考题：
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 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
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.
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.
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.
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.
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.
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.
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.
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.
The size of the largest datafile， data1.dbf， in your database is 30MB. You issued the following command： RMANCONFIGURE 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.
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.
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 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
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 environmentD、 The database local time zone will be set for the database using the operating system environment variable.
单选题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（）AThe number of bytes per inode can be specified.BPlacement of the filesystem on the disk can be specified.CThe jfslog can be specified on creation of the filesystem.DEither a JFS or JFS2 filesystem can be created on the logical volume.
单选题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？（）AThe new setting would be applied but no alerts would be raised immediately.BThe new setting would be applied and an alert would be raised immediately.CThe new setting would be ignored because the tablespace space usage is more than the specified threshold value.DThe new setting would cause an error because the tablespace space usage is more than the specified threshold value.
单选题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（）AThe table created by SKD isnot accessibleand SKD cannot create new tables.BThe tables created by SKD and HR remain， but both cannot create new tables.CThe table created by HR remains and HR still has the CREATE TABLE system privilege.DThe table created by HR remains and HR can grant the CREATE TABLE system privilege to other users.
单选题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.
单选题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.
单选题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.
单选题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 environmentD The database local time zone will be set for the database using the operating system environment variable.
单选题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（）AThe table created by SKD is not accessible and SKD cannot create new tables.BThe tables created by SKD and HR remain， but both cannot create new tables.CThe table created by HR remains and HR still has the CREATE TABLE system privilege.DThe table created by HR remains and HR can grant the CREATE TABLE system privilege to other users.
单选题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？（）AThe number of bytes per inode can be specified.BPlacement of the filesystem on the disk can be specified.CThe jfslog can be specified on creation of the filesystem.DEither a JFS or JFS2 filesystem can be created on the logical volume.
单选题The size of the largest datafile， data1.dbf， in your database is 30MB. You issued the following command： RMANCONFIGURE 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.
单选题Evaluate the following command: SQLALTER 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 forces SecureFiles to be created even if the BASICFILE option is specified to create the LOBCIt does not allow the creation of SecureFiles and generates an error if the SECUREFILE option is specified to create the LOBDIt ignores the SECUREFILE option only if a Manual Segment Space Management tablespace is used and creates a BasicFile
单选题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 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
单选题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？（）AThe retention policy is cleared.BRMAN does not consider any backup as obsolete.CThe retention policy is set to its default setting of redundancy 1.DThe retention policy is set to its default setting of recovery window 7.
多选题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？（）AALLBPFILECBOTHDNONEESPFILEFMEMORYGINSTANCEHDATABASE
单选题Which of the following is TRUE when creating a file system that resides on the center of a disk?（）AThe logical volume is created first.BThe physical volume will be automatically created.CThe physical partition must be specified as an option.DThe file system will be mounted during the time of creation.