网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
单选题
The rows inside three Oracle tables supporting a customer order entry system are frequently accessed together by means of a table join. Because data is always being added to the tables, you leave a lot of extra space inside each block to accommodate growth. Which of the following types of tables would be useful for storing the data in this context?（）
A
Temporary tables
B
Index-organized tables
C
Cluster tables
D
Standard Oracle tables
参考答案
参考解析
解析：
暂无解析
更多 “单选题The rows inside three Oracle tables supporting a customer order entry system are frequently accessed together by means of a table join. Because data is always being added to the tables, you leave a lot of extra space inside each block to accommodate growth. Which of the following types of tables would be useful for storing the data in this context?（）A Temporary tables B Index-organized tables C Cluster tables D Standard Oracle tables ” 相关考题
考题
A SELECT statement can be used to perform these three functions:1. Choose rows from a table.2. Choose columns from a table3. Bring together data that is stored in different tables by creating a link between them. Which set of keywords describes these capabilities? （）A. difference, projection, joinB. selection, projection, joinC. selection, intersection, joinD. intersection, projection, joinE. difference, projection, product
考题
You use the segment advisor to help determine objects for which space may be reclaimed.Which three statements are true about the advisor given by the segment advisor?()
A. It may advise the use of online table redefinition for tables in dictionary managed tablespace.B. It may advise the use of segment shrink for tables in dictionary managed tablespaces it the no chained rows.C. It may advise the use of online table redefinition for tables in locally managed tablespacesD. It will detect and advise about chained rows.E. It may advise the use of segment shrink for free list managed tables.
考题
Which three are true about the large pool for an Oracle database instance that supports shared serverconnections?()
A. Allocates memory for RMAN backup and restore operationsB. Allocates memory for shared and private SQL areasC. Contains a cursor area for storing runtime information about cursorsD. Contains stack spaceE. Contains a hash area performing hash joins of tables
考题
Which three best describe the partner benefits of the Cisco Lifecycle Services approach？（）A、Improve customer satisfaction ratesB、Improve the skill sets of their staff membersC、Increase their staff productivityD、Reduce the risk involved with deploying and supporting new and complex technologiesE、Improve response times for network outagesF、Help ensure that suppliers are meeting metrics
考题
A SELECT statement can be used to perform these three functions: 1. Choose rows from a table. 2. Choose columns from a table 3. Bring together data that is stored in different tables by creating a link between them. Which set of keywords describes these capabilities?（）A、difference, projection, joinB、selection, projection, joinC、selection, intersection, joinD、intersection, projection, joinE、difference, projection, product
考题
已知：DataSet data=new DataSet（）；则删除数据集data中person数据表的第5行数据的方法为（）A、 data.Tables["person "].Rows[5].Delete（）；B、 data.Tables["person "].Rows.Delete（5）；C、 data.Tables["person "].Rows[4].Delete（）；D、 data.Tables["person "].Rows[].Delete（4）；
考题
A customer is looking at an Oracle eBusiness solution. They would like to know what hardware they will need for the solution. They have some preliminary information from Oracle, including hardware requirements and specifics for their environment. Which of the following should be done next?（）A、Configure a 2 node x3950 X5 B、Customer needs a System p server to support Oracle applications C、Download the Oracle eBusiness sizing questionnaire from IBM, fill out with customer and submit to IBM for System x sizing D、Configure a system that meets the minimum requirements
考题
Identify three features of shared entities.（） (Choose three.)A、enable one-time definition of objectsB、are referenced by several Oracle Application modulesC、are defined in each Oracle Application module separatelyD、are owned by a single Oracle Application module for table purposes onlyE、are owned by a single Oracle Application module to designate the primary user or decision maker
考题
Which three are true about the large pool for an Oracle database instance that supports shared serverconnections?（）A、Allocates memory for RMAN backup and restore operationsB、Allocates memory for shared and private SQL areasC、Contains a cursor area for storing runtime information about cursorsD、Contains stack spaceE、Contains a hash area performing hash joins of tables
考题
In which scenario will you create a sorted hash cluster？ （）A、 if the application uses queries joining tables only occasionallyB、 if the full table scan is executed often on only one table of the clustered tablesC、 if the data for all the rows of a cluster key value exceeds one or two Oracle blocksD、 when you want the data to be returned automatically in the chronological order
考题
Which four are true regarding the Workspace Manager in Oracle9i？ （）A、Automatically versions all tables.B、Automatically installed with Oracle9i.C、Merges changes with parent rows or discard changes.D、Provides mechanism to identify and resolve conflicts.E、Allows for version enabling tables by use of a packages procedure.
考题
多选题Identify three features of shared entities.（） (Choose three.)Aenable one-time definition of objectsBare referenced by several Oracle Application modulesCare defined in each Oracle Application module separatelyDare owned by a single Oracle Application module for table purposes onlyEare owned by a single Oracle Application module to designate the primary user or decision maker
考题
多选题You use the segment advisor to help determine objects for which space may be reclaimed. Which three statements are true about the advisor given by the segment advisor?（）AIt may advise the use of online table redefinition for tables in dictionary managed tablespace.BIt may advise the use of segment shrink for tables in dictionary managed tablespaces it the no chained rows.CIt may advise the use of online table redefinition for tables in locally managed tablespacesDIt will detect and advise about chained rows.EIt may advise the use of segment shrink for free list managed tables.
考题
多选题Identify three unique integration features of Spring and WebLogic Server.（）Aability to automatically convert Spring application to JavaEE 6 frameworkBability to export the WebLogic Container feature to another Spring enabled JavaEE serverCability to extend the WebLogic Server console with some Spring-related pagesDofficial support of Spring apps inside WebLogic by Oracle SupportEsupport for injection of WebLogic MBeans and Resources into Spring applications
考题
多选题Which three best describe the partner benefits of the Cisco Lifecycle Services approach？（）AImprove customer satisfaction ratesBImprove the skill sets of their staff membersCIncrease their staff productivityDReduce the risk involved with deploying and supporting new and complex technologiesEImprove response times for network outagesFHelp ensure that suppliers are meeting metrics
考题
单选题假设需要导出某个表table1，只导出表结构，不导出数据，可以使用如下（）命令。A
EXP user/pwd tables=（name,table1）file=export.dmp Rows=yB
EXP user1/pwd table table1 file=extable1.dmpC
EXP user/pwd tables=（name,table1）file=export.dmp Rows=nD
EXP user1/pwd table=table1 file=extable1.dmp Rows=n
考题
单选题The rows inside three Oracle tables supporting a customer order entry system are frequently accessed together by means of a table join. Because data is always being added to the tables, you leave a lot of extra space inside each block to accommodate growth. Which of the following types of tables would be useful for storing the data in this context?（）A
Temporary tables B
Index-organized tables C
Cluster tables D
Standard Oracle tables
考题
多选题You plan to use the In Database Archiving feature of Oracle Database 12c, and store rows that are inactive for over three months, in Hybrid Columnar Compressed (HCC) format. Which three storage options support the use of HCC?（）AASM disk groups with ASM disks consisting of Exadata Grid Disks.BASM disk groups with ASM disks consisting of LUNS on any Storage Area Network arrayCASM disk groups with ASM disks consisting of any zero padded NFS-mounted filesDDatabase files stored in ZFS and accessed using conventional NFS mounts.EDatabase files stored in ZFS and accessed using the Oracle Direct NFS featureFDatabase files stored in any file system and accessed using the Oracle Direct NFS featureGASM disk groups with ASM disks consisting of LUNs on Pillar Axiom Storage arrays
考题
单选题已知：DataSet data=new DataSet（）；则删除数据集data中person数据表的第5行数据的方法为（）A
data.Tables[person ].Rows[5].Delete（）；B
data.Tables[person ].Rows.Delete（5）；C
data.Tables[person ].Rows[4].Delete（）；D
data.Tables[person ].Rows[].Delete（4）；
考题
单选题What criterion does Oracle9i use to determine whether a database file is an Oracle Managed File？（）A
The filename format. B
Information stored inside a data dictionary table. C
Information stored in the ALERT.LOG file for the corresponding instance. D
Information stored inside the corresponding initialization parameter file for the instance.
考题
多选题A warehouse fact table in your Oracle 12c Database is range-partitioned by month and accessed frequently with queries that span multiple partitions The table has a local prefixed, range partitioned index. Some of these queries access very few rows in some partitions and all the rows in other partitions, but these queries still perform a full scan for all accessed partitions. This commonly occurs when the range of dates begins at the end of a month or ends close to the start of a month. You want an execution plan to be generated that uses indexed access when only a few rows are accessed from a segment, while still allowing full scans for segments where many rows are returned. Which three methods could transparently help to achieve this result?（）AUsing a partial local Index on the warehouse fact table month column with indexing disabled to the table partitions that return most of their rows to the queries.BUsing a partial local Index on the warehouse fact table month column with indexing disabled for the table partitions that return a few rows to the queries.CUsing a partitioned view that does a UNION ALL query on the partitions of the warehouse fact table, which retains the existing local partitioned column.DConverting the partitioned table to a partitioned view that does a UNION ALL query on the monthly tables, which retains the existing local partitioned columnEUsing a partial global index on the warehouse fact table month column with indexing disabling for the table partitions that return most of their rows to the queries.FUsing a partial global index on the warehouse fact table month column with indexing disabled for the table partitions that return a few rows to the queries.
考题
单选题In which scenario will you create a sorted hash cluster？ （）A
if the application uses queries joining tables only occasionallyB
if the full table scan is executed often on only one table of the clustered tablesC
if the data for all the rows of a cluster key value exceeds one or two Oracle blocksD
when you want the data to be returned automatically in the chronological order
考题
单选题A SELECT statement can be used to perform these three functions: 1.Choose rows from a table. 2.Choose columns from a table. 3.Bring together data that is stored in different tables by creating a link between them. Which set of keywords describes these capabilities?（）A
difference, projection, joinB
selection, projection, joinC
selection, intersection, joinD
intersection, projection, joinE
difference, projection, product
考题
多选题Which four are true regarding the Workspace Manager in Oracle9i？ （）AAutomatically versions all tables.BAutomatically installed with Oracle9i.CMerges changes with parent rows or discard changes.DProvides mechanism to identify and resolve conflicts.EAllows for version enabling tables by use of a packages procedure.
考题
单选题You find this query being used in your Oracle 12c database: Which method a used by the optimizer to limit the rows being returned?（）A
A filter is added to the table query dynamically using ROWNUM to limit the rows to 20 percent of the total rowsB
All the rows are returned to the client or middle tier but only the first 20 percent are returned to the screen or the application.C
A view is created during execution and a filter on the view limits the rows to 20 percent of the total rows.D
A TOP-N query is created to limit the rows to 20 percent of the total rows
考题
多选题Which three are true about the large pool for an Oracle database instance that supports shared serverconnections?（）AAllocates memory for RMAN backup and restore operationsBAllocates memory for shared and private SQL areasCContains a cursor area for storing runtime information about cursorsDContains stack spaceEContains a hash area performing hash joins of tables
热门标签
最新试卷
