网友您好, 请在下方输入框内输入要搜索的题目:

题目内容 (请给出正确答案)
单选题
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” 相关考题
考题 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.

考题 What setting in JUNOS software forces a bgp speaker to wait for a bgp neighbor to initiate a bgp session?()A、waitB、holdC、passiveD、authenticate

考题 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.

考题 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()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.

考题 单选题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 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 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()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.

考题 单选题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.

考题 单选题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?()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?()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.

考题 多选题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?()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.

考题 单选题What setting in JUNOS software forces a bgp speaker to wait for a bgp neighbor to initiate a bgp session?()A waitB holdC passiveD authenticate