black

1z0-043

登录

单项选择题

While designing the database for one of your online transaction processing (OLTP) applications, you want to achieve the following: 
a) high availability of data 
b) faster primary key access to the table data 
c) compact storage for the table 
Which type of tables would you use to achieve these objectives?()

A.heap tables
B.object tables
C.partitioned tables
D.index­organized tables (IOTs)

相关考题

多项选择题 View the Exhibit and examine the properties of the USERS tablespace.  You execute the following statement to shrink the TRANS table existing on the USERS tablespace:  SQL> ALTER TABLE trans SHRINK SPACE CASCADE  Which objects would be affected by this command? ()

单项选择题 View the Exhibit and examine the properties of the TT tablespace.  Using Database Control, you have scheduled a job to shrink the TRANS table residing on the TT tablespace. The job would run at 5:00 p.m. every Friday.  When you examine the space usage of the table after the completion of the job, you find that the table has not been shrunk.  What could have been the reason for this?()

单项选择题 Youhavespecifiedthewarningandcriticalthresholdvaluesofanapplicationtablespacetobe60%and70%,respectively.Fromthetablespacespaceusagemetrics,youfindthattheactualspaceusagehasreachedthespecifiedwarningthresholdvalue,butnoalertshavebeengenerated.Whatcouldbethereasonforthis?()

All Rights Reserved 版权所有©考试题库网(kstiku.com)

备案号:湘ICP备14005140号-3

经营许可证号:湘B2-20140064