网友您好, 请在下方输入框内输入要搜索的题目:

题目内容 (请给出正确答案)
单选题
You are trying to alter the initial segment size given to a table in a dictionary-managed tablespace. Which of the following keywords would be used as part of this process?()
A

DROP TABLE 

B

ALTER TABLE 

C

RESIZE 

D

COALESCE


参考答案

参考解析
解析: 暂无解析
更多 “单选题You are trying to alter the initial segment size given to a table in a dictionary-managed tablespace. Which of the following keywords would be used as part of this process?()A DROP TABLE B ALTER TABLE C RESIZE D COALESCE” 相关考题
考题 You need to write a code segment that transfers the contents of a byte array named dataToSendby using a NetworkStream object named netStream.You need to use a cache of size 8,192 bytes.Which code segment should you use?()A.B.C.D.

考题 You use Microsoft .NET Framework 4 to create a Windows Forms client application.You write the following code segment.The application contains a form of type Form1 that contains a FormSettings object named frmSettings1.You need to maintain the user‘s form size preference each time the user executes the application.Which code segment should you use? ()A.B.C.D.

考题 You observe that a database performance has degraded over a period of time. While investigating the reason, you find that the size of the database buffer cache is not large enough to cache all the needed data blocks. Which advisory component would you refer to, in order to determine that required size of the database buffer cache? ()A、 Memory AdvisorB、 Segment AdvisorC、 SQL Tuning AdvisorD、 SQL Access AdvisorE、 Automatic Database Diagnostic Monitor (ADDM)

考题 You are shrinking the SCOTT.EMP table by executing the ALTER TABLE SCOTT.EMP SHRINK SPACE CASCADE statement. What is a prerequisite for shrinking the SCOTT.EMP table?()A、 You must enable the block change tracking feature.B、 You must have enable the flashback feature.C、 You must use the OMF in your database.D、 You must define the tablespace of the SCOTT.EMP table for automatic segment space management.

考题 You are trying to alter the initial segment size given to a table in a dictionary-managed tablespace. Which of the following keywords would be used as part of this process?()A、DROP TABLE B、ALTER TABLE C、RESIZE D、COALESCE

考题 In one of your online transaction processing (OLTP) applications, users are manipulating and querying a database table simultaneously. From the Segment Advisor, you find that one of the tables is highly fragmented and you want to shrink the table immediately without affecting the currently active queries. Which option would you use with the ALTER TABLE command to achieve this objective?()A、 REBUILDB、 CASCADEC、 TRUNCATED、 ROW MOVEMENTE、 SHRINK SPACE COMPACTF、 SHRINK SPACE CASCADE

考题 You have a long-running process you want to assign to a specific UNDO segment brought online for that express purpose. You are not using automatic UNDO management. What statement can be used for this task? ()A、ALTER DATABASE B、SET TRANSACTION C、ALTER ROLLBACK SEGMENT D、ALTER TABLE

考题 You work as a database administrator for Supportcenter.cn. Because of space constraints, you decided to manually shrink the table. You executed the ALTER TABLE ....SHRINK SPACE statement to shrink the space and you receive an error as follows:   ERROR at Line 1:   ORA-10635: Invalid segment or tablespace type   What could be the reason? ()A、The table is partitionedB、The table name is wrong.C、It is an index-Organized table (IOT)D、The table is stored in locally managedtablespace.E、The table is stored in atablespacewhere segment space is managed manually.

考题 Your database is 5GB and contain satable named Sales History. Sales informationis frequently inserted and updated. You discover that excessive page splitting is occurring. You need to reduce the occurr enceof page splitting in the Sales History table. Which code segment should you use?()A、ALTER DATABASE Sales  MODIFY FILE(NAME = Sales dat3, SIZE = 10GB)B、ALTER INDEXALL ON Sales.Sales History REBUILD WITH (FILLFACTOR = 60)C、EXEC sys.sp_configure 'fill factor (%)', '60'D、UPDATE STATISTICS Sales.Sales History(Products)  WITH FULLSCAN, NORECOMPUTE

考题 You are the network administrator for Company.com.  Your Windows 2000 Professional computer has 128 MB of RAM and two physical hard disks. Each hard disk has a single partition configured as drive C and D. Each partition has more than 500 MB of free disk space. Windows 2000 Professional and all applications are installed on drive C. You frequently run two or more memory-intensive graphics applications simultaneously. You notice that access to drive C is much slower when you are using the graphics applications. You want to maximize overall disk performance for your computer.   What should you do?()A、Configure the paging file to reside on drive C onlyB、Configure the paging file to reside on drive D onlyC、Configure the initial size of the paging file and the maximum size of paging file to 64 MBD、Configure the initial size of the paging file and the maximum size of the paging file to 128 MBE、Configure the initial size of the paging file and the maximum size of the paging file to 256 MB

考题 You need to improve the performance of the tempdb database on SQL1.Which two actions should you perform?()A、Move tempdb onto a faster disk volume.B、Increase the initial size of tempdb to 1.5 GBC、Increase the size of the data files in the Tracking database.D、Decrease the file growth increment for tempdb to 25 MBE、Use more local temporary tables and fewer global temporary tables in the Tracking database.

考题 单选题You have executed this command to change the size of the database buffer cache: SQL ALTER SYSTEM SET DB_CACHE_SIZE=2516582; System altered. To verify the change in size, you executed this command:SQL SHOW PARAMETER DB_CACHE_SIZENAME TYPE VALUE ------------------- ----------- ------------------ db_cache_size big integer 4194304 Why is the value set to 4194304 and not to 2516582()A Because 4194304 is the granule sizeB Because 4194304 is the standard block sizeC Because 4194304 is the largest nonstandard block size defined in the databaseD Because 4194304 is the total size of data already available in the database buffer cache

考题 单选题You work as a database administrator for Supportcenter.cn. Because of space constraints, you decided to manually shrink the table. You executed the ALTER TABLE ....SHRINK SPACE statement to shrink the space and you receive an error as follows:   ERROR at Line 1:   ORA-10635: Invalid segment or tablespace type   What could be the reason? ()A The table is partitionedB The table name is wrong.C It is an index-Organized table (IOT)D The table is stored in locally managedtablespace.E The table is stored in atablespacewhere segment space is managed manually.

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

考题 单选题View the Exhibit. You want to create a tablespace to contain objects with block size 16 KB. But while configuring the storage you find that the block size that you can provide is only 8 KB.  Which configuration couldhave enabled the block selection of 16 KB()A Choosing the extent allocation type to uniformB Choosing the Segment Space Management option to manualC Setting autoextension on for the data file mentioned for the tablespaceD Setting the DB_16K_CACHE_SIZE parameter for the database instance to a nonzero value

考题 单选题You have executed this command to change the size of the database buffer cache: SQL ALTER SYSTEM SET DB_CACHE_SIZE=2516582; System altered. To verify the change in size, you executed this command:SQL SHOW PARAMETER DB_CACHE_SIZENAME TYPE VALUE ------------------- ----------- ------------------ db_cache_size big integer 4194304 Why is the value set to 4194304 and not to 2516582()A Because 4194304 is the granule sizeB Because 4194304 is the standard block sizeC Because 4194304 is the largest nonstandard block size defined in the databaseD Because 4194304 is the total size of data already available in the database buffer cache

考题 单选题You have executed this command to change the size of the database buffer cache: SQL ALTER SYSTEM SET DB_CACHE_SIZE=2516582; System altered.  To verify the change in size, you executed this command: SQL SHOW PARAMETER DB_CACHE_SIZE NAME TYPE VALUE  ------------------- ----------- ------------------  db_cache_size big integer 4194304  (4M)  Why is the value set to 4194304 and not to 2516582()A because 4194304 is the granule sizeB because 4194304 is the standard block sizeC because 4194304 is the largest nonstandard block size defined in the databaseD because 4194304 is the total size of data already available in the database buffer cache

考题 单选题You observe that a database performance has degraded over a period of time. While investigating the reason, you find that the size of the database buffer cache is not large enough to cache all the needed data blocks. Which advisory component would you refer to, in order to determine that required size of the database buffer cache? ()A  Memory AdvisorB  Segment AdvisorC  SQL Tuning AdvisorD  SQL Access AdvisorE  Automatic Database Diagnostic Monitor (ADDM)

考题 多选题You need to improve the performance of the tempdb database on SQL1.Which two actions should you perform?()AMove tempdb onto a faster disk volume.BIncrease the initial size of tempdb to 1.5 GBCIncrease the size of the data files in the Tracking database.DDecrease the file growth increment for tempdb to 25 MBEUse more local temporary tables and fewer global temporary tables in the Tracking database.

考题 单选题You issued the following command:   ALTER TABLE SCOTT.EMP SHRINK SPACE;   The SCOTT.EMP table is stored in the DATA1 tablespace that has the following properties:   DATA1 is a read/write tablespace.   DATA1 is not autoextensible to an unlimited size.  DATA1 is online.   Segment space management for the DATA1 tablespace is manual.   You issued the ALTER TABLE SCOTT.EMP SHRINK SPACE; command that generates the following error:   ORA-10635: Invalid segment or tablespace type    What could be the reason for the failure of the command?()A  The tablespace, DATA1, is not read-only.B  The tablespace, DATA1, is not autoextensible.C  The tablespace, DATA1, is not offline.D  The segment space management for the tablespace, DATA1, is manual.

考题 单选题You are performing the shrink operation on the SCOTT.EMP table. You want to perform the same operation on all dependent objects of the SCOTT.EMP table. What is NOT a prerequisite for the operation?()A  You must enable the row movement on the SCOTT.EMP table.B  You must define the tablespace of the SCOTT.EMP table for automatic segment space management.C  You must use the CASCADE clause in the ALTER TABLE SHRINK SPACE statement.D  You must use the COMPACT clause in the ALTER TABLE SHRINK SPACE statement.

考题 单选题AUM has been retaining about 15 minutes worth of undo. You want to double the retentionperiod, but not at the expense of new transactions failing. You decide to alter the system to set the parameter UNDO_RETENTION=18000. However, AUM still retains only about 15 minutes worth of undo.  What is the problem? ()A  You need to alter the undo tablespace to add the RETENTION GUARANTEE setting.B  You need to increase the size of the undo tablespace.C  The undo tablespace is not set to auto-extend.D  You need to alter the Recycle Bin to add the RETENTION GUARANTEE setting.

考题 单选题In one of your online transaction processing (OLTP) applications, users are manipulating and querying a database table simultaneously. From the Segment Advisor, you find that one of the tables is highly fragmented and you want to shrink the table immediately without affecting the currently active queries.  Which option would you use with the ALTER TABLE command to achieve this objective?()A REBUILDB CASCADEC TRUNCATED ROW MOVEMENTE SHRINK SPACE COMPACTF SHRINK SPACE CASCADE

考题 多选题You are the network administrator for Company.com.  Your Windows 2000 Professional computer has 128 MB of RAM and two physical hard disks. Each hard disk has a single partition configured as drive C and D. Each partition has more than 500 MB of free disk space. Windows 2000 Professional and all applications are installed on drive C. You frequently run two or more memory-intensive graphics applications simultaneously. You notice that access to drive C is much slower when you are using the graphics applications. You want to maximize overall disk performance for your computer.   What should you do?()AConfigure the paging file to reside on drive C onlyBConfigure the paging file to reside on drive D onlyCConfigure the initial size of the paging file and the maximum size of paging file to 64 MBDConfigure the initial size of the paging file and the maximum size of the paging file to 128 MBEConfigure the initial size of the paging file and the maximum size of the paging file to 256 MB

考题 单选题Your database performance has degraded due to frequent checkpointing. What would you do in this scenario?()A make redo log files smallerB increase the size of the checkpoint fileC make the changes as per the advice given by MTTR AdvisorD make the changes as per the advice given by Checkpoint Advisor

考题 多选题What are the three steps you should take to tune a JDBC Connection pool in WebLogic from the  initial settings in a production environment?()AEnsure the maximum size is increased to an appropriate setting.BSet the minimum and maximum size of the connection pool to the same value.CIncrease the statement cache size.DAdd more heap to the JVM.EAdd more nodes to the cluster.

考题 单选题If you issue the command shutdown abort prior to trying to put the database in ARCHIVELOG mode, what will be the result when you issue the command alter database archivelog?()A  The alter database archivelog command will failB  The alter database archivelog inconsistent command must be used to put the database in ARCHIVELOG modeC  The alter database archivelog command will succeedD  The alter database archivelog command will ask if you want to make the database consistent firstE  There is no alter database archivelog command. The correct command is alter database alterlogging