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

You issue the following command in Oracle: CREATE TABLESPACE

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

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

第1题：

You are creating a recovery catalog for use with RMAN. You have issued these commands： SQL> CREATE TABLESPACE rman_ts DATAFILE  ’/DISK1/rman_ts01.dbf’ 2> SIZE 20M 3> DEFAULT STORAGE （initial 100K next 100K pctincrease 0）； SQL> CREATE USER rman_db01 IDENTIFIED BY rman_db01 2> DEFAULT TABLESPACE rman_ts 3> QUOTA unlimited ON rman_ts；  Which command should you issue next？（）

  • A、RESYNC CATALOG；
  • B、REGISTER DATABASE；
  • C、CREATE CATALOG TABLESPACE rman_ts；
  • D、GRANT recovery_catalog_owner TO rman_db01；

正确答案:C

第2题：

View this parameter setting in your database：   DB_CREATE_FILE_DEST=’D:// /oracle/product/10.2.0/oradata/oracle’  You created a tablespace by using this command：   CREATE TABLESPACE USERS；  Which two statements are true about the USERS tablespace？（）

  • A、The tablespace has two data files.
  • B、An error is reported and tablespace creation fails.
  • C、Data files are created with names generated by the instance.
  • D、The tablespace can be extended without specifying the data file.
  • E、Data files belonging to the USERS tablespace cannot be renamed.

正确答案:C,D

第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 want to drop the TBS1 tablespace from your database.  You also want to delete the corresponding data files automatically， and not have to do it manually.  What should you do？（）
A

Use the DROP DATAFILE command.

B

Use the DROP TABLESPACE command.

C

Ensure that all database files are Oracle Managed Files before using the DROP TABLESPACE command.

D

Ensure that the DB_FILE_CREATE_DEST initialization parameter is set before using the DROP TABLESPACE command.


正确答案： D
解析： 暂无解析

第5题：

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

第6题：

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

第7题：

You issue the following statement：   SQL> SELECT FIRSTNAME， LASTNAME FROM HR.EMPLOYEE；  You receive the following error：         01578： ORACLE data block corrupted （file# 6， block # 54）        ORA-01110 ： data file 6： ’u01/oracle/oradata/data1.dbf’   How will you resolve this problem of data block corruption by reducing the mean time to recover （MTTR）？（）

  • A、 by using the DBMS_REPAIR package
  • B、 by using the DBVERIFY utility
  • C、 by using Block Media Recovery
  • D、 by issuing the ANALYZE TABLE HR.EMPLOYEES VALIDATE STRUCTURE command

正确答案:C

第8题：

Your multitenant container database (CDB) contains a pluggable database, HR_PDB. The default permanent tablespace in HR_PDB is USERDATA. The container database (CDB) is open and you connect RMAN.You want to issue the following RMAN command:RMAN > BACKUP TABLESPACE hr_pdb:userdata;Which task should you perform before issuing the command?（）

A. Place the root container in ARHCHIVELOG mode.

B. Take the user data tablespace offline.

C. Place the root container in the nomount stage.

D. Ensure that HR_PDB is open.


参考答案：D

第9题：

单选题
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
解析： 暂无解析

第10题：

单选题
Your multitenant container database (CDB) contains a pluggable database, HR_PDB. The default permanent tablespace in HR_PDB is USERDATA. The container database (CDB) is open and you connect RMAN. You want to issue the following RMAN command: RMAN > BACKUP TABLESPACE hr_pdb:userdata; Which task should you perform before issuing the command?（）
A

Place the root container in ARHCHIVELOG mode.

B

Take the user data tablespace offline.

C

Place the root container in the nomount stage.

D

Ensure that HR_PDB is open.


正确答案： A
解析： 暂无解析

更多相关问题
相关内容