违法和不良信息举报 联系客服
免费注册 登录

Examine the statement：   SQL> CREATE TABLESPACE user_data  2

题目
多选题
Examine the statement：   SQL> CREATE TABLESPACE user_data  2> EXTENT MANAGEMENT LOCAL  3> SEGMENT SPACE MANAGEMENT AUTO；   Which twp assumptions must be true for this statement to execute successfully？（）
A

Oracle Managed Files are used for this instance.

B

The USER_DATA tablespace is managed using FET$/UET$ tables.

C

The COMPATIBLE initialization parameter must be 9.0.0 or higher.

D

Space within segments in the USER_DATA tablespace is managed with freelists.

如果没有搜索结果或未解决您的问题，请直接 联系老师 获取答案。
相似问题和答案

第1题：

Examine the structure of the STUDENTS table:You need to create a report of the 10 students who achieved the highest ranking in the course INT SQL and who completed the course in the year 1999.Which SQL statement accomplishes this task?（）

A.

B.

C.

D.


参考答案：D

第2题：

Examine the command that is used to create a table： SQL> CREATE TABLE orders（oid NUMBER（6） PRIMARY KEY， odate DATE， ccode NUMBER （6）， oamtNUMBER（10，2）） TABLESPACE users； Which two statements are true about the effect of the above command（）

  • A、A CHECK constraint is created on the OID column.
  • B、A NOT NULL constraint is created on the OID column.
  • C、The ORDERS table is the only object created in the USERS tablespace.
  • D、The ORDERS table and a unique index are created in the USERS tablespace.
  • E、The ORDERS table is created in the USERS tablespace and a unique index is created on the OID columnin the SYSTEM tablespace.

正确答案:B,D

第3题：

View the Exhibit to examine the Automatic SQL Tuning result details.Which action would you suggest for the selected SQL statement in the Exhibit?()

A. Accept the recommended SQL profile.

B.Collect statistics for the related objects.

C. Run the Access Advisor for the SQL statement.

D. Run the Segment Advisor for recommendations.


参考答案：C

第4题：

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

第5题：

You lost the index tablespace in your database. You decided to re-create the index tablespace and the indexes in the tablespace. What methods can you use to re-create the indexes？（）

  • A、 SQL scripts
  • B、 Recovery Manager （RMAN） script
  • C、 Data Pump
  • D、 SQL*Loader
  • E、 Flashback database

正确答案:A,C

第6题：

Examine the structure of the EMPLOYEES and DEPARTMENTS tables:Evaluate this SQL statement:Which SQL statement is equivalent to the above SQL statement?()

A.

B.

C.

D.


参考答案：C

第7题：

You issue this statement：ALTER DATABASE BACKUP CONTROLFILE TO TRACE；  What does the statement generate？（）

  • A、A text copy of the control file.
  • B、A binary copy of the control file.
  • C、A file containing a SQL statement which will re-create the database.
  • D、A file containing a SQL statement which will re-create the control file.

正确答案:D

第8题：

USER_DATA is a nonencrypted tablespace that contains a set of tables with data. You want to convert all existing data in the USER_DATA tablespace and the new data into the encrypted format.Which methodswould you use to achieve this?（）

A. Use Data Pump to transfer the existing data to a new encrypted tablespace

B. Use ALTER TABLE MOVE to transfer the existing data to a new encrypted tablespace

C. Use CREATE TABLE AS SELECT to transfer the existing data to a new encrypted tablespace

D. Enable row movement for each table to be encrypted and then use ALTER TABLESPACE to encrypt the tablespace

E. Encrypt the USER_DATA tablespace using the ALTER TABLESPACE statement so that all the data in the tablespace is automatically encrypted


参考答案：A, B, C

第9题：

Which statement will NOT create a tablespace？（）

  • A、 CREATE TABLESPACE DATA1 DATAFILE ’+grp1/abc（datafile）’；
  • B、 CREATE TABLESPACE DATA1 DATAFILE ’+grp1’；
  • C、 CREATE TABLESPACE DATA1 DATAFILE ’+data1（tempfile）’；
  • D、 CREATE TABLESPACE DATA1 DATAFILE ’+grp1.256.34359’；

正确答案:D

第10题：

You find pockets of empty space in the USER_DATA tablespace due to a lot of DML operations on the objects in the USER_DATAtablespace. The pockets of empty spaces are too small to be reused individually. This is leading to wastage of space. You decide to perform the shrink operation to reclaim the wasted space. Which advisor will you use to determine the objects in the USER_DATA tablespace that are good candidates for the shrink operation？（）

  • A、 SQL Tuning Advisor
  • B、 SQL Access Advisor
  • C、 Undo Advisor
  • D、 Segment Advisor

正确答案:D

更多相关问题
相关内容