网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
单选题
During tablespace creation， which filename format is NOT used for creating datafiles associated with a tablespace？（）
A
incomplete names
B
incomplete names with templates
C
alias with template names
D
numeric names
参考答案
参考解析
解析：
暂无解析
更多 “单选题During tablespace creation， which filename format is NOT used for creating datafiles associated with a tablespace？（）A incomplete namesB incomplete names with templatesC alias with template namesD numeric names” 相关考题
考题
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 tablespaceB. Use ALTER TABLE MOVE to transfer the existing data to a new encrypted tablespaceC. Use CREATE TABLE AS SELECT to transfer the existing data to a new encrypted tablespaceD. Enable row movement for each table to be encrypted and then use ALTER TABLESPACE to encrypt the tablespaceE. Encrypt the USER_DATA tablespace using the ALTER TABLESPACE statement so that all the data in the tablespace is automatically encrypted
考题
Which two statements are true about the use of the procedures listed in the vsysaux_occupants.move_procedure column?()
A. The procedure may be used for some components to relocate component data to the SYSAUX tablespace from its current tablespace.B. The procedure may be used for some components to relocate component data from the SYSAUX tablespace to another tablespace.C. All the components may be moved into SYSAUX tablespace.D. All the components may be moved from the SYSAUX tablespace.
考题
You have an Ethernet network. Which of the conditions below can lead to increased congestion on your network?()
A. The use of Full-Duplex Mode.B. The Creation on New Collision Domains.C. The Creation on New Broadcast Domains.D. The Addition of Hubs to the Network.E. The use of switches in the Network.F. The Amount of ARP or IPX SAP Traffic.
考题
Which statement about WSA access logs that are to be processed by sawmill for cisco ironport istrue？（） A、 the default log format can be usedB、 the fields"%XC%X n" must be appended to the default access log formatC、 any log format can beused ， but all WSAs must use the same formatD、 any log format can be used. And different WSAs may use different formats
考题
Which of the following contribute to congestion on an Ethernet network?（）A、Use of full duplex mode.B、Creation of new collision domain.C、Creation of new broadcast domain.D、Addition of hub to the network.E、Use of switches in the network.F、Amount of ARP or IPX SAP traffic.
考题
You have an Ethernet network. Which of the conditions below can lead to increased congestion on your network?（）A、The use of Full-Duplex Mode.B、The Creation on New Collision Domains.C、The Creation on New Broadcast Domains.D、The Addition of Hubs to the Network.E、The use of switches in the Network.F、The Amount of ARP or IPX SAP Traffic.
考题
To reference existing ASM files， you need to use a fully qualified ASM filename. Your development database has a disk group named DG2A， the database name is DEV19， and the ASM file that you want to reference is a datafile for the USERS02 tablespace. Which of the following is a valid ASM filename for this ASM file？（）A、 dev19/+DG2A/datafile/users02.701.2B、 +DG2A/dev19/datafile/users02.701.2C、 +DG2A/dev19/users02/datafile.701.2D、 +DG2A·701.2E、 +DG2A/datafile/dev19.users.02.701.2
考题
During tablespace creation， which filename format is NOT used for creating datafiles associated with a tablespace？（）A、 incomplete namesB、 incomplete names with templatesC、 alias with template namesD、 numeric names
考题
You want the size of the tablespace to increase when it is full. Which option would you use？（）A、use automatic extent allocationB、disable threshold for the tablespaceC、use freelists to manage the free spaceD、use automatic segment space managementE、create the tablespace as a bigfile tablespaceF、use the RESIZE clause while creating the tablespaceG、enable AUTOEXTEND for at least one of the data files in the tablespace
考题
Your database instance is running with full workload after database creation. You have decided to useafixed-sizeundo tablespace. You want to use the Undo Advisor to estimate the capacity of the undotablespace. Which two factors must you consider before using the Undo Advisor to estimate the capacity of the undotablespace（）A、the retention period to support flashbackB、the expected length of the longest-running queryC、the number of undo tablespaces in the databaseD、the size of the Flash Recovery Area for the database instance
考题
A technician needs to change an existing drive formatted in FAT32 to a NTFS format, whileretaining the data. Which of the following is the BEST way to make this change?（）A、Use Device Manager to disable the drive, then format it as NTFS.B、Use Disk Management to change the format type.C、Use Task Manager to start the CHKNTFS command.D、Run the CONVERT command from the command prompt
考题
Which command can a system administrator use to verify that a tape is in backup format and is readable by the system？（）A、tarB、tctlC、tcopyD、restore
考题
Your database instance is running with full workload after database creation. You have decided to use a fixed-size undo tablespace. You want to use the Undo Advisor to estimate the capacity of the undo tablespace. Which two factors must you consider before using the Undo Advisor to estimate the capacity of the undotablespace（）A、The retention period to support flashbackB、The expected length of the longest-running queryC、The number of undo tablespaces in the databaseD、The size of the Flash Recovery Area for the database instance
考题
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.
考题
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；
考题
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
考题
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 tablespaceB、Use ALTER TABLE MOVE to transfer the existing data to a new encrypted tablespaceC、Use CREATE TABLE AS SELECT to transfer the existing data to a new encrypted tablespaceD、Enable row movement for each table to be encrypted and then use ALTER TABLESPACE to encrypt the tablespaceE、Encrypt the USER_DATA tablespace using the ALTER TABLESPACE statement so that all the data in the tablespace is automatically encrypted
考题
多选题You have an Ethernet network. Which of the conditions below can lead to increased congestion on your network?（）AThe use of Full-Duplex Mode.BThe Creation on New Collision Domains.CThe Creation on New Broadcast Domains.DThe Addition of Hubs to the Network.EThe use of switches in the Network.FThe Amount of ARP or IPX SAP Traffic.
考题
单选题You want the size of the tablespace to increase when it is full. Which option would you use？（）A
use automatic extent allocationB
disable threshold for the tablespaceC
use freelists to manage the free spaceD
use automatic segment space managementE
create the tablespace as a bigfile tablespaceF
use the RESIZE clause while creating the tablespaceG
enable AUTOEXTEND for at least one of the data files in the tablespace
考题
单选题You want to be notified when the space usage of an existing critical tablespace has reached 75% of the allocated space. Which option would you use to achieve this？（）A
run a procedure to check the tablespace space usageB
define the warning threshold for the tablespace at 75% in Database ControlC
create a trigger to be executed when tablespace space usage reaches 75%D
submit a job by using DBMS_JOB package to check the free space in the tablespace at regular intervalsE
define the warning threshold to be 75% for the tablespace by ALTER TABLESPACE .. ADD THRESHOLD command
考题
多选题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？（）AprofileBaccount lockCaccount unlockDpassword expireEquota 10MB on TBS1Fpassword never expireGdefault tablespace TBS1Hquota unlimited on TBS1Itemporary tablespace TEMPJtemporary tablespace SYSTEM
考题
多选题Your database instance is running with full workload after database creation. You have decided to use a fixed-size undo tablespace. You want to use the Undo Advisor to estimate the capacity of the undo tablespace. Which two factors must you consider before using the Undo Advisor to estimate the capacity of the undotablespace（）AThe retention period to support flashbackBThe expected length of the longest-running queryCThe number of undo tablespaces in the databaseDThe size of the Flash Recovery Area for the database instance
考题
单选题Which statement about WSA access logs that are to be processed by sawmill for cisco ironport istrue？（）A
the default log format can be usedB
the fields%XC%X n must be appended to the default access log formatC
any log format can beused ， but all WSAs must use the same formatD
any log format can be used. And different WSAs may use different formats
考题
多选题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？（）AThe tablespace has two data files.BAn error is reported and tablespace creation fails.CData files are created with names generated by the instance.DThe tablespace can be extended without specifying the data file.EData files belonging to the USERS tablespace cannot be renamed.
考题
多选题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?（）AUse Data Pump to transfer the existing data to a new encrypted tablespaceBUse ALTER TABLE MOVE to transfer the existing data to a new encrypted tablespaceCUse CREATE TABLE AS SELECT to transfer the existing data to a new encrypted tablespaceDEnable row movement for each table to be encrypted and then use ALTER TABLESPACE to encrypt the tablespaceEEncrypt the USER_DATA tablespace using the ALTER TABLESPACE statement so that all the data in the tablespace is automatically encrypted
考题
单选题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；
热门标签
最新试卷
