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

第1题：

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.

第2题：

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.

第3题：

第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 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.

第5题：

What setting in JUNOS software forces a bgp speaker to wait for a bgp neighbor to initiate a bgp session？（）

• A、wait
• B、hold
• C、passive
• D、authenticate

第6题：

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.

第7题：

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.

第8题：

第9题：

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.

第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.