CMS专题

单选题You have three temporary tablespace groups named G1, G2, and G3 in your database. You are creating a new temporary tablespace as follows: CREATE TEMPORARY TABLESPACE TEMP1 TEMPFILE /u1/data/temp1.dbf SIZE 10M TABLESPACE GROUP ;Which statement regarding

题目
单选题
You have three temporary tablespace groups named G1, G2, and G3 in your database. You are creating a new temporary tablespace as follows: CREATE TEMPORARY TABLESPACE TEMP1 TEMPFILE /u1/data/temp1.dbf SIZE 10M TABLESPACE GROUP ;Which statement regarding the above command is correct?（）
A

It will create the tablespace TEMP1 in group G1

B

It will create the tablespace TEMP1 in group G3 

C

It will not add the tablespace TEMP1 to any group

D

It will create the tablespace TEMP1 in the default group

E

It will throw an error with message 'specified group is not available

F

It will create a new group with a system-generated name and add the tablespace TEMP1 to it.

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

第1题：

细胞增殖周期的顺序依次是( )

A、G1→M→G2→S

B、G1→S→G2→M

C、M→G1→G2→S

D、S→G1→M→G2

E、G1→G2→M→S


参考答案：B

第2题：

The user HR receives the following error while inserting data into the TTK table： ERROR at line 1：  ORA-01653： unable to extend table HR.TTK by 128 in tablespace SMDUpon  investigation， you find that SMD is a small file tablespace.  Which three action would allow the user to insert data（）

  • A、Add a data file to the SMD tablespace.
  • B、Add a data file to the temporary tablespace associated with the user HR.
  • C、Resize the data file associated with the SMD tablespace to make it larger.
  • D、Alter the data file associated with the SMD tablespace to grow automatically.
  • E、Change the segment space management for the SMD tablespace to automatic. n segments is managed through free lists.

正确答案:A,C,D

第3题：

You executed the following commands in a database session:What could have caused the recycle bin to clean up?()

A. There is demand for space from the new table从

B. The undo tablespace does not have sufficient free space

C. The new table name is the same as the table name in the recycle bin

D. The temporary tablespace that is assigned to you does not have sufficient free space


参考答案：A

第4题：

Which of the following restrictions are not true with respect to tablespace point-in-time recovery？（）

  • A、 The target database must be in NOARCHIVELOG mode.
  • B、 No backup is required of the database before you perform a TSPITR.
  • C、 You must have all archived redo logs generated since the last backup up to the point to which you want to restore the transport set.
  • D、 If you rename a tablespace， you can not perform a TSPITR to any point in time before that rename operation occurred.
  • E、 If you have tables in tablespace_1 that have associated constraints in tablespace_2，then you must transport both tablespaces.

正确答案:A,B

第5题：

You lost a temporary file that belongs to the default temporary tablespace in your database. From the options provided， which approach would you take to solve the problem？ （）

  • A、flash back the database
  • B、import the temporary tablespace from the last export
  • C、restore all the data files and temporary files from the last full database backup and perform a recovery
  • D、not perform a recovery， but create a new temporary tablespace， make it the default temporary tablespace and then drop the old tablespace

正确答案:D

第6题：

You are the network administrator for . All network servers run Windows Server 2003. A server named TestKing6 functions as a file server. All client computers run Windows XP Professional and are members of the domain. TestKing.com periodically hires temporary employees. You need to prepare a custom user profile for all temporary employees. You log on to a client computer as an administrator, and you configure the desktop settings. You copy the profile to a folder named //TestKing6/Profiles/Temp_profile. You rename the Ntuser.dat file in the //TestKing6/Profiles/Temp_profile folder to Ntuser.man. You create three new user accounts for the temporary employees. The user accounts are named temp_user1, temp_user2, and temp_user3. You need to configure the temporary user accounts to receive the new desktop settings that you created on TestKing6. The temporary employees must not be allowed to retain customized desktop settings? What should you do?（）

  • A、Specify a user profile path of //TestKing6/Profiles/username for each of the three user accounts.
  • B、Specify a user profile path of //TestKing6/Profiles/username.man for each of the three user accounts.
  • C、Specify a home folder path of //TestKing6/Profiles/username for each of the three user accounts.
  • D、Specify a user profile path of //TestKing6/Profiles/Temp_profile for each of the three user accounts.
  • E、Specify a user profile path of //TestKing6/Profiles/Temp_profile.man for each of the three user accounts.

正确答案:D

第7题：

Your database is running in ARCHIVELOG mode. One of the data files, USERDATA01.dbf, in the USERS tablespace is damaged and you need to recover the file until the point of failure. The backup for the datafile is available. Which three files would be used in the user-managed recovery process performed by the database administrator （）(DBA)? (Choose Three)

  • A、Redo logs
  • B、Control file
  • C、The latest backup of only the damaged data file
  • D、The latest backup of all the data file in the USERS tablespace
  • E、Temporary files of temporary tablespace
  • F、Archive Logs since the latest backup to point of failure

正确答案:A,C,F

第8题：

You issued the following command:An index is then created on the ADMIN_WORK_AREA temporary table. Which two statements are true regarding the TBS_T1 tablespace in the above command? ()

A. It stores only the temporary table but not its indexes.

B. It stores both the temporary table as well as its indexes.

C. It must be a nondefault temporary tablespace for the database.

D. It can be a default or nondefault temporary tablespace for the database.

E. It must be the default temporary tablespace of the user who issues the command.


参考答案：B, D

第9题：

Your database is running In ARCIIIVELOG mode. One of the data files， USBRDATAOI. DBF， in the users tablespace is damaged and you need to recover the file until the point of failure. The backup for the data file is available.  Which three files would be used in the user-managed recovery process performed by the database administrator （DBA）？（） 

  • A、 redo logs
  • B、 control file
  • C、 temporary files of temporary tablespace
  • D、 the latest backup of only the damaged data file
  • E、 the latest backup of all the data files In the USERS tablespace

正确答案:A,B,D

第10题：

The user HR receives the following error while inserting data into the TTK table：ERROR at line 1： ORA-01653： unable to extend table HR.TTK by 128 in tablespace SMD Upon investigation， you find that SMDis a small file tablespace. Which three action would allow the user to insert data（）

  • A、Add a data file to the SMD tablespace.
  • B、Add a data file to the temporary tablespace associated with the user HR.
  • C、Resize the data file associated with the SMD tablespace to make it larger.
  • D、Alter the data file associated with the SMD tablespace to grow automatically.
  • E、Change the segment space management for the SMD tablespace to automatic

正确答案:A,C,D

更多相关问题
相关内容