单选题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?（）AIt will create the tablespace TEMP1 in group G1BIt will create the tablespace TEMP1 in group G3 CIt will not add the tablespace TEMP1 to any groupDIt will create the tablespace TEMP1 in the default groupEIt will throw an error with message 'specified group is not availableFIt will create a new group with a system-generated name and add the tablespace TEMP1 to it.
单选题
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.
参考解析
解析：
暂无解析
相关考题：
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 spaceC. The new table name is the same as the table name in the recycle binD. The temporary tablespace that is assigned to you does not have sufficient free space
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.
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.
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.
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 logsB、Control fileC、The latest backup of only the damaged data fileD、The latest backup of all the data file in the USERS tablespaceE、Temporary files of temporary tablespaceF、Archive Logs since the latest backup to point of failure
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 databaseB、import the temporary tablespace from the last exportC、restore all the data files and temporary files from the last full database backup and perform a recoveryD、not perform a recovery， but create a new temporary tablespace， make it the default temporary tablespace and then drop the old tablespace
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 logsB、 control fileC、 temporary files of temporary tablespaceD、 the latest backup of only the damaged data fileE、 the latest backup of all the data files In the USERS tablespace
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.
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
Your database contains two temporary tablespaces named TEMP and TEMP1. The TEMP tablespace is the default temporary tablespace for the database， and the TEMP1 tablespace was created at database creation. You want to increase the size of the tempfile for the TEMP tablespace and drop the TEMP1 tablespace from the database. The database is not using Oracle-Managed Files （OMF）. Which statement must you use to ensure that when you drop the TEMP1 tablespace from the database， its corresponding operating system file is also deleted？（）A、 DROP TABLESPACE temp1；B、 DROP TABLESPACE temp1 INCLUDING CONTENTS；C、 DROP TABLESPACE temp1 INCLUDING CONTENTS AND DATAFILES；D、 DROP TABLESPACE temp1 INCLUDING CONTENTS CASCADE CONSTRAINTS；
Which three statements are correct about temporary tables？（）A、Indexes and views can be created on temporary tables.B、Both the data and the structure of temporary tables can be exported.C、Temporary tables are always created in a user’s temporary tablespace.D、The data inserted into a temporary table in a session is available to other sessions.E、Data manipulation language （DML） locks are never acquired on the data of temporary tables.
While setting up the database for your production environment， you want to create a user with following requirements. 1.The objects created by the user must be stored in a tablespace， TBS1， if the TABLESPACE option is not defined during the object creation. 2.The user should be able to use 10MB of space in the tablespace TBS1. 3.The user must change the password immediately after logging in for the first time. Which three options of the CREATE USER command would you use to achieve this objective？（）A、profileB、account lockC、account unlockD、password expireE、quota 10MB on TBS1F、password never expireG、default tablespace TBS1H、quota unlimited on TBS1I、temporary tablespace TEMPJ、temporary tablespace SYSTEM
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， including domain controllers， have Windows Server 2012 R2 installed.ABC.com has a server， named ABC-SR15， which is configured as a file server. You have received instructions to make sure that a user， named Mia Hamm， has the ability to generate a complete backup of ABC-SR15 via Windows Server Backup. Which of the following actions should you take？（）A、You should consider making use of Computer Management to configure the local groups.B、You should consider making use of Computer Management to configure the domain local groups.C、You should consider making use of Computer Management to configure the global groups.D、You should consider making use of Computer Management to configure the administrator groups.
单选题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， including domain controllers， have Windows Server 2012 R2 installed.ABC.com has a server， named ABC-SR15， which is configured as a file server. You have received instructions to make sure that a user， named Mia Hamm， has the ability to generate a complete backup of ABC-SR15 via Windows Server Backup. Which of the following actions should you take？（）AYou should consider making use of Computer Management to configure the local groups.BYou should consider making use of Computer Management to configure the domain local groups.CYou should consider making use of Computer Management to configure the global groups.DYou should consider making use of Computer Management to configure the administrator groups.
单选题You work as a database administrator for Supportcenter.cn. Your database is in NOARCHIVELOG mode. The database has been configured with three redo logs groups， and there have been five log switches. You lost one non-system-critical data file from your database. Which method would you use to recover the data file？（）ARestore all the data files and open the databaseBCreate the data file and perform tablespace recoveryCNo need to restore any file， just recover the databaseDRestore only the system data file and recover the databaseERestore only lost date file and performtablespacerecovery
单选题While creating a database using Database Configuration Assistant tool， you created a database default temporary tablespace. Which activity would cause the default temporary tablespace of the database to be used？（）Athe CREATE TABLE .. commandBsorting of the SYSTEM tablespace’s dataCsorting of data required by recursive SQL statementsDthe CREATE TABLE .. ORGANIZATION EXTERNAL .. commandEsorting of data if the users have not been allocated temporary tablespace explicitlyFsorting of data if the users have been allocated temporary tablespace explicitly
单选题You have been asked to create three users， PUB1， PUB2 and PUB3， for three newly hired employees and to allocate unlimited quota on their default tablespace PUBLISHER_TBS with no other privileges. After creating the users， which method can you use for granting the required privileges？（）Agrant CONNECT role to all of the three usersBgrant RESOURCE role to all of the three usersCgrant both CONNECT and RESOURCE role to all of the three usersDexecute ALTER USER .. QUOTA UNLIMITED ON publisher_tbs command for all of the three usersEcreate role with UNLIMITED TABLESPACE system privilege and assign the role to all of the three users
多选题Which three statements are correct about temporary tables？（）AIndexes and views can be created on temporary tables.BBoth the data and the structure of temporary tables can be exported.CTemporary tables are always created in a user’s temporary tablespace.DThe data inserted into a temporary table in a session is available to other sessions.EData manipulation language （DML） locks are never acquired on the data of temporary tables.
单选题You are a DBA of your company. You created a database named SALES on an Oracle 10g instance. You have defined an index named INDEX1 on the database table named INVENTORY. Users are complaining that queries accessing the INVENTORY table are running slow. Upon investigation you determine that the tablespace where the index is located is experiencing high I/O and you decide to relocate the index to another tablespace. Which of these will be the best way to accomplish this objective？（）A Rebuild the index.B Coalesce the index.C Drop and re-create the index in the new tablespace.D Relocate the index using the ALTER INDEX...MOVE statement.
单选题Your database is set in NOARCHIVELOG mode and is backed up every night. There are 10 redo log groups on the database， each with three members， making a total of 30 redo log files. At lunchtime the server unexpectedly gets shut down. Upon restarting you notice that the data file belonging to the SYSTEM tablespace has become corrupted. You also notice that there have been 15 log switches during the day. Which solution should you use to recover as much committed data as possible？（）ARestore the data file for the SYSTEM tablespace then open the database. BRestore all redo logs form last night's backup, then restart the database. CPerform a complete restore of all files from last night's backup. Data entered into the database today must be reentered. DMount the instance, take the SYSTEM tablespace offline, open the database, and then restore the data file, recover it, and bring the tablespace online.
单选题You issued the following command on the temporary tablespace LMTEMP in your database: SQLALTER TABLESPACE lmtemp SHRINK SPACE KEEP 20M; Which requirement must be fulfilled for this command to succeed?（）AThe tablespace must be locally managed.BThe tablespace must have only one temp file.CThe tablespace must be made nondefault and offline.DThe tablespace can remain as the default but must have no active sort operations.
单选题You issued the following command on the temporary tablespace LMTEMP in your database： SQLALTER TABLESPACE lmtemp SHRINK SPACE KEEP 20M； Which requirement must be fulfilled for this command to succeed？（）A The tablespace must be locally managed.B The tablespace must have only one temp file.C The tablespace must be made nondefault and offline.D The tablespace can remain as the default but must have no active sort operations.
单选题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?（）AIt will create the tablespace TEMP1 in group G1.BIt will create the tablespace TEMP1 in group G3.CIt will not add the tablespace TEMP1 to any group.DIt will create the tablespace TEMP1 in the default group.
单选题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?（）AIt will create the tablespace TEMP1 in group G1BIt will create the tablespace TEMP1 in group G3 CIt will not add the tablespace TEMP1 to any groupDIt will create the tablespace TEMP1 in the default groupEIt will throw an error with message 'specified group is not availableFIt will create a new group with a system-generated name and add the tablespace TEMP1 to it.
单选题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.
多选题You issued the following command： CREATE GLOBAL TEMPORARY TABLE admin_work_area （startdate DATE， enddate DATE， class CHAR（20）） ON COMMIT DELETE ROWS TABLESPACE tbs_t1； 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？（）AIt stores only the temporary table but not its indexes.BIt stores both the temporary table as well as its indexes.CIt must be a nondefault temporary tablespace for the database.DIt can be a default or nondefault temporary tablespace for the database.EIt must be the default temporary tablespace of the user who issues the command.
单选题Your database contains two temporary tablespaces named TEMP and TEMP1. The TEMP tablespace is the default temporary tablespace for the database， and the TEMP1 tablespace was created at database creation. You want to increase the size of the tempfile for the TEMP tablespace and drop the TEMP1 tablespace from the database. The database is not using Oracle-Managed Files （OMF）. Which statement must you use to ensure that when you drop the TEMP1 tablespace from the database， its corresponding operating system file is also deleted？（）A DROP TABLESPACE temp1；B DROP TABLESPACE temp1 INCLUDING CONTENTS；C DROP TABLESPACE temp1 INCLUDING CONTENTS AND DATAFILES；D DROP TABLESPACE temp1 INCLUDING CONTENTS CASCADE CONSTRAINTS；