OCP-1Z0-052-V8 02-145题

港控/mmm° 2022-03-20 06:13 131阅读 0赞

145. Examine the commands executed in a DBA session:

SQL> CREATE BIGFILE TABLESPACE MRKT

2 DATAFILE '/u01/app/oracle/oradata/orcl/mrkt.dbf' size 10M LOGGING

3 EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO;

Tablespace created.

SQL> ALTER DATABASE DEFAULT TABLESPACE MRKT;

Database altered.

Which two statements are true regarding the MRKT tablespace? (Choose two.)

A.No more data files can be added to the tablespace.

B.Segment space is managed by free lists in the tablespace.

C.A user created without being assigned a default tablespace uses this tablespace.

D.The tablespace can be dropped with the current setting with segments present in it.

Answer: AC

答案解析：

1、BIGFILE只能有一个数据文件。A对

2、ALTER DATABASE DEFAULT TABLESPACE MRKT;设置默认表空间，以后用户创建的数据都会放在这个表空间里。C对。

3、创建BIGFILE时，oracle自动创建本地管理表空间和自动段空间管理（ASSM）。B错

Oracle Database automatically creates a locally managed tablespace with automatic segment space management.

4、正在使用的默认表空间不能被drop。 D错。

实验验证：

sys@TEST1107> alter database default tablespace TESTTBS;

Database altered.

sys@TEST1107> select PROPERTY\_NAME,PROPERTY\_VALUE from database\_properties;

PROPERTY\_NAME PROPERTY\_VALUE

\------------------------------ --------------------------------------------------

DICT.BASE 2

DEFAULT\_TEMP\_TABLESPACE TEMP

**DEFAULT\_PERMANENT\_TABLESPACE TESTTBS**

DEFAULT\_EDITION ORA$BASE

Flashback Timestamp TimeZone GMT

TDE\_MASTER\_KEY\_ID

DST\_UPGRADE\_STATE NONE

DST\_PRIMARY\_TT\_VERSION 14

DST\_SECONDARY\_TT\_VERSION 0

DEFAULT\_TBS\_TYPE SMALLFILE

NLS\_LANGUAGE AMERICAN

NLS\_TERRITORY AMERICA

NLS\_CURRENCY $

NLS\_ISO\_CURRENCY AMERICA

NLS\_NUMERIC\_CHARACTERS .,

NLS\_CHARACTERSET AL32UTF8

NLS\_CALENDAR GREGORIAN

NLS\_DATE\_FORMAT DD-MON-RR

NLS\_DATE\_LANGUAGE AMERICAN

NLS\_SORT BINARY

NLS\_TIME\_FORMAT HH.MI.SSXFF AM

NLS\_TIMESTAMP\_FORMAT DD-MON-RR HH.MI.SSXFF AM

NLS\_TIME\_TZ\_FORMAT HH.MI.SSXFF AM TZR

NLS\_TIMESTAMP\_TZ\_FORMAT DD-MON-RR HH.MI.SSXFF AM TZR

NLS\_DUAL\_CURRENCY $

NLS\_COMP BINARY

NLS\_LENGTH\_SEMANTICS BYTE

NLS\_NCHAR\_CONV\_EXCP FALSE

NLS\_NCHAR\_CHARACTERSET AL16UTF16

NLS\_RDBMS\_VERSION 11.2.0.3.0

GLOBAL\_DB\_NAME TEST1107

EXPORT\_VIEWS\_VERSION 8

WORKLOAD\_CAPTURE\_MODE

WORKLOAD\_REPLAY\_MODE

NO\_USERID\_VERIFIER\_SALT 75282D7EC73B5C40AFF387B2BF5692A0

DBTIMEZONE 00:00

36 rows selected.

sys@TEST1107> drop tablespace TESTTBS;

drop tablespace TESTTBS

ERROR at line 1:

ORA-12919: Can not drop the default permanent tablespace

#### reating a Bigfile Tablespace ####

To create a bigfile tablespace, specify the `BIGFILE` keyword of the `CREATE` `TABLESPACE` statement (`CREATE` `BIGFILE` `TABLESPACE` ...). Oracle Database automatically creates a locally managed tablespace with automatic segment space management. You can, but need not, specify `EXTENT` `MANAGEMENT` `LOCAL` and `SEGMENT` `SPACE``MANAGEMENT` `AUTO` in this statement. However, the database returns an error if you specify `EXTENT` `MANAGEMENT` `DICTIONARY` or `SEGMENT` `SPACE` `MANAGEMENT` `MANUAL`. The remaining syntax of the statement is the same as for the `CREATE TABLESPACE` statement, but you can only specify one data file. For example:

CREATE BIGFILE TABLESPACE bigtbs

DATAFILE '/u02/oracle/data/bigtbs01.dbf' SIZE 50G

...

You can specify `SIZE` in kilobytes (K), megabytes (M), gigabytes (G), or terabytes (T).

If the default tablespace type was set to `BIGFILE` at database creation, you need not specify the keyword `BIGFILE` in the `CREATE TABLESPACE` statement. A bigfile tablespace is created by default.

If the default tablespace type was set to `BIGFILE` at database creation, but you want to create a traditional (smallfile) tablespace, then specify a `CREATE``SMALLFILE` `TABLESPACE` statement to override the default tablespace type for the tablespace that you are creating.

官方参考：[http://docs.oracle.com/cd/E11882\_01/server.112/e25494/tspaces.htm\#sthref1527][http_docs.oracle.com_cd_E11882_01_server.112_e25494_tspaces.htm_sthref1527]

再分享一下我老师大神的人工智能教程吧。零基础！通俗易懂！风趣幽默！还带黄段子！希望你也加入到我们人工智能的队伍中来！[https://blog.csdn.net/jiangjunshow][https_blog.csdn.net_jiangjunshow]

[http_docs.oracle.com_cd_E11882_01_server.112_e25494_tspaces.htm_sthref1527]: http://docs.oracle.com/cd/E11882_01/server.112/e25494/tspaces.htm#sthref1527
[https_blog.csdn.net_jiangjunshow]: https://blog.csdn.net/jiangjunshow/article/details/77338485