Consider the following command to create a tablespace in you

题目
单选题
Consider the following command to create a tablespace in your production database (which is using an Automatic Storage Management [ASM] instance to manage the database files): CREATE TABLESPACE user_tbsp DATAFILE ’+dgroup3 (usder_temp) /user_files/user_tbsp’ SIZE 200M; What would be the result of this command?()
A

 It would result in an error because the template cannot be used along with the disk group.

B

 It would result in an error because the path cannot be specified while creating a tablespace in a disk group.

C

 It would create a tablespace with a data file that has an alias, and its attributes are set by the user-defined template.

D

 It would create a tablespace with a data file that does not have an alias, and its attributes are set by the user-defined template.

参考答案和解析
正确答案: C
解析: 暂无解析
如果没有搜索结果或未解决您的问题,请直接 联系老师 获取答案。
相似问题和答案

第1题:

You work as an administrator at ABC.com. The ABC.com network consists of a single domain named ABC.com. All servers in the ABC.com domain have Windows Server 2012 R2 installed. You have logged on to a server, named ABC-SR07, and would like to obtain the IP configurations of a server, named ABC-SR13.Which of the following actions should you take?()

  • A、You should consider making use of the Winrs.exe command.
  • B、You should consider making use of the Winsat.exe command.
  • C、You should consider making use of the Winpop.exe command.
  • D、You should consider making use of the Dsrm.exe command.

正确答案:A

第2题:

Consider the following command to create a tablespace in your production database (which is using an Automatic Storage Management [ASM] instance to manage the database files):  CREATE TABLESPACE user_tbsp  DATAFILE ’+dgroup3(user_temp)/user_files/user_tbsp’ SIZE 200M;  What would be the result of this command?()

  • A、It would result in an error because the template cannot be used along with the disk group.
  • B、It would result in an error because the path cannot be specified while creating a tablespace in a disk group.
  • C、It would create a tablespace with a data file that has an alias, and its attributes are set by the user-defined template.
  • D、It would create a tablespace with a data file that does not have an alias, and its attributes are set by the user-defined template.

正确答案:C

第3题:

You opened the encryption wallet and then issued the following command:Then you closed the wallet. Later, you issued the following command to create the EMPLOYEES table in the SECURESPACE tablespace and you use the NO SALT option for the EMPID column.What is the outcome?()

A. It creates the table and encrypts the data in it.

B. It generates an error because the wallet is closed.

C. It creates the table but does not encrypt the data in it.

D. It generates an error because the NO SALT option cannot be used with the ENCRYPT option.


参考答案:B

第4题:

You issue the following command in Oracle: CREATE TABLESPACE DAT_TBS DATAFILE "dat_tbs.dbf" SIZE 2M;. Later queries against the database reveal that the tablespace is located in the /u01/oradata/oracle directory. Which of the following choices identifies how Oracle likely determined what directory to place dat_tbs.dbf file in?()

  • A、DB_CREATE_FILE_DEST 
  • B、DB_CREATE_ONLINE_LOG_1 
  • C、DB_CREATE_ONLINE_LOG_2
  • D、The directory is an operating system-specific default value in Oracle that can neigher be specified manually nor changed

正确答案:A

第5题:

Examine the following commands executed in your database: SQL> ALTER SESSION RECYCLEBIN=ON; Session altered  SQL > CREATE TABLE emp TABLESPACE tbsfd AS SELECT * FROM hr.employees;  Table created.  Further, you executed the following command to drop the table:  SQL> DROP TABLE emp;Table dropped.  What happens in this scenario?()

  • A、The table is moved to the SYSAUX tablespace.
  • B、The table is moved to the SYSTEM tablespace.
  • C、The table is removed from the database permanently.
  • D、The table is renamed and remains in the TBSFD tablespace.

正确答案:D

第6题:

You work as an administrator at ABC.com.The ABC.com network consists of a single domain named ABC.com.Subsequent to deploying a Server Core Installation of Windows Server 2012 R2 on a new ABC.com server,you are instructed to add a graphical user interface (GUI) to the server.  You want to achieve this goal from the command prompt. Which of the following actions should you take?()

  • A、You should consider making use of the dism.exe command.
  • B、You should consider making use of the dsquery.exe command.
  • C、You should consider making use of the dsadd.exe command.
  • D、You should consider making use of the dsrm.exe command.

正确答案:A

第7题:

You have created a locally managed tablespace by issuing the following command:        CREATE TABLESPACE data1   DATAFILE ’data1_file1.dbf’ SIZE 10M AUTOEXTEND ON MAXSIZE        UNLIMITED;   For the DATA1 tablespace, you have set the warning level alert limit to 70 percent.  In which situation will a warning level alert be generated?()  

  • A、 when 700 KB is used
  • B、 when 700 KB is left as free space
  • C、 when 7MB is used
  • D、 when 7MB is left as free space
  • E、 no alert will be generated because an autoextensible datafile is included in the tablespace

正确答案:C

第8题:

You executed the following command in Recovery Manager (RMAN) to perform a backup of the DETTBS tablespace:  RMAN> BACKUP TABLESPACE DETTBS;  Under which conditions would this command execute successfully? ()

  • A、The database is in NOMOUNT state.
  • B、The database is in ARCHIVELOG mode and the tablespace is online.
  • C、The database is in ARCHIVELOG mode and the tablespace is offline.
  • D、The database is in NOARCHIVELOG mode and the tablespace is online.
  • E、The database is in NOARCHIVELOG mode and the tablespace is offline.

正确答案:B,C,E

第9题:

You executed the following command to create a tablespace called SALES_DATA: SQL> CREATE TABLESPACE sales_data DATAFILE SIZE 100M SEGMENT SPACE MANAGEMENT AUTO; Which two statements are true about the SALES_DATA tablespace()

  • A、The database automatically determines the extent-sizing policy for the tablespace.
  • B、The segments are automatically shrunk when the contents are removed from them.
  • C、The allocation of extents within the tablespace is managed through the dictionary tables.
  • D、The space utilization description of the data blocks in segments is recorded in bitmap blocks.
  • E、The space utilization description of the data blocks in segments is managed through free lists.

正确答案:A,D

第10题:

You work as an administrator at ENSUREPASS.com. The ENSUREPASS.com network consists of a single domain named ENSUREPASS.com.Subsequent to deploying a Server Core Installation of Windows Server 2012 on a new ENSUREPASS.com server, you are instructed to add a graphical user interface (GUI) to the server.You want to achieve this goal from the command prompt. Which of the following actions should you take?()

  • A、You should consider making use of the dism.exe command.
  • B、You should consider making use of the dsquery.exe command
  • C、You should consider making use of the dsadd.exe command
  • D、You should consider making use of the dsrm.exe command

正确答案:A

更多相关问题