单选题You are designing an application for a telecom company and you have been asked to design a database table to facilitate monthly bill generation. The bill would include details of customer calls， listed in chronological order.  Which method would you fo

题目
单选题
You are designing an application for a telecom company and you have been asked to design a database table to facilitate monthly bill generation. The bill would include details of customer calls， listed in chronological order.  Which method would you follow to achieve this objective without increasing the overhead of sorting the rows？（）
A

create a hash cluster to store the data

B

create an index cluster to store the data

C

create a partitioned table to store the data

D

create a sorted hash cluster to store the data

E

create a heap table with rowid to store the data

相似考题

1.While designing your database， you have created the EMPLOYEES table as an index/x7forganized table （IOT）. You want to create a bitmap index on the JOB_ID column to make queries faster. Which task must have been completed so that you are able to create the bitmap index？（）A、A primary key must have been created.B、A mapping table must have been created.C、An overflow tablespace must have been specified.D、The PCTTHRESHOLD option must have been specified.

2.While designing your database， you have created the EMPLOYEES table as an index-organized table （IOT）. You want to create a bitmap index on the JOB_ID column to make queries faster. Which task must have been completed so that you are able to create the bitmap index？（） A、A primary key must have been created.B、A mapping table must have been created.C、An overflow tablespace must have been specified.D、The PCTTHRESHOLD option must have been specified.

3. In your test database， you have created the ORDERS table as an index/x7forganized table （IOT）. To facilitate faster querying， you have created a mapping table and a bitmap index on the ORDER_FILLED column. You observe that the query performance degrades when users perform a large volume of transactions.  While investigating the reason， you find that the mapping table segment is fragmented， leading to poor performance. Which option would you use to defragment the mapping table without affecting the original table data？（）A、export and import the mapping tableB、drop and re­create the mapping tableC、truncate the mapping table and reinsert the valuesD、use the ALTER TABLE .. REBUILD command to defragment the mapping table

4. You are designing an application for a telecom company and you have been asked to design a database table to facilitate monthly bill generation. The bill would include details of customer calls， listed in chronological order.  Which method would you follow to achieve this objective without increasing the overhead of sorting the rows？（）A、create a hash cluster to store the dataB、create an index cluster to store the dataC、create a partitioned table to store the dataD、create a sorted hash cluster to store the dataE、create a heap table with rowid to store the data

更多“单选题You are designing an application for a telecom company and you have been asked to design a database table to facilitate monthly bill generation. The bill would include details of customer calls， listed in chronological order.  Which method would you fo”相关问题

  • 第1题：

    By mistake， you ran the batch job （for updating the BILL_DETAILS table） twice. You are not sure which rows in the BILL_DETAILS table were affected. You need to identify：  a） a list of changes made along with the transaction identifier of each change  b） the necessary SQL statements to undo the erroneous changes  Which option would you choose？（）

    • A、RMAN only
    • B、Flashback Table only
    • C、Flashback Versions Query only
    • D、Flashback Database and Flashback Transaction Query
    • E、Flashback Versions Query and Flashback Transaction Query

    正确答案:E

  • 第2题：

    You are using flat files as the data source for one of your data warehousing applications. You plan to move the data from the flat file structures to an Oracle database to optimize the application performance. In your database you have clustered tables. While migrating the data， you want to have minimal impact on the database performance and optimize the data load operation. Which method would you use to load data into Oracle database？（）

    • A、use the external table population
    • B、use the Oracle Data Pump export and import utility
    • C、use the conventional path data load of SQL*Loader utility
    • D、use the direct path data load of Oracle export and import utility

    正确答案:C

  • 第3题：

    The production database has been functional for the last seven days. Because of application requirements， some of the initialization parameters were changed during run time without any comments. You have been asked to find out the value of the parameters when the instance was started. Which source would you use to locate this information？（）

    • A、fixed views
    • B、the alert log file
    • C、the parameter file
    • D、the server parameter file
    • E、dynamic performance views

    正确答案:B

  • 第4题：

    In your Oracle 10g database ， you have scheduled a job to update the optimizer statistics at 05：00 pm every Friday. The job has successfully completed. Which three pieces of information would you check to confirm that the statistics have been collected？（）

    • A、average row size
    • B、last analyzed date
    • C、size of table in bytes
    • D、size of table in database blocks
    • E、number of free blocks in the free list
    • F、number of extents present in the table

    正确答案:A,B,D

  • 第5题：

    You are designing an application for Certkiller .com and you have been asked to design a database table to facilitate monthly bill generation. The bill would include details of customer calls， listed in chronological order.Which method would you follow to achieve this objective without increasing the overhead of sorting the rows？（）

    • A、 create a hash cluster to store the data
    • B、 create an index cluster to store the data
    • C、 create a partitioned table to store the data
    • D、 create a sorted hash cluster to store the data
    • E、 create a heap table with rowid to store the data

    正确答案:D

  • 第6题：

    单选题
    You are designing an application for a telecom company and you have been asked to design a database table to facilitate monthly bill generation. The bill would include details of customer calls， listed in chronological order.  Which method would you follow to achieve this objective without increasing the overhead of sorting the rows？（）
    A

    create a hash cluster to store the data

    B

    create an index cluster to store the data

    C

    create a partitioned table to store the data

    D

    create a sorted hash cluster to store the data

    E

    create a heap table with rowid to store the data


    正确答案： D
    解析： 暂无解析

  • 第7题：

    单选题
    You work as a database administrator for Supportcenter.cn. You have been asked to use a centralized administrative tool to administer your database servers and application servers. In order to achieve the objective， which component would you configure on each database server？（）
    A

    Database Control

    B

    Management Server

    C

    Management Repository

    D

    Application Server Control

    E

    Oracle Management Agent


    正确答案： E
    解析： 暂无解析

  • 第8题：

    单选题
    You work in a company which uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 instance. There is a database named named Dworks in the instance. The Dworks database has a table named Bills which contains several indexes and a great amount of rows. An enterprise Web environment is supported by the database. Onthe Bills table 28% of the indexes have been fragmented. You have to defragment the indexes， making sure that you reduce the effect on database availability to the least.  In the ALTER INDEX statement， which option should be included？（）
    A

    Sort in tempdb 

    B

    Online 

    C

    Fill factor 

    D

    Pad index 


    正确答案： C
    解析： 暂无解析

  • 第9题：

    单选题
    By mistake， you ran the batch job （for updating the BILL_DETAILS table） twice. You are not sure which rows in the BILL_DETAILS table were affected. You need to identify：  a） a list of changes made along with the transaction identifier of each change  b） the necessary SQL statements to undo the erroneous changes  Which option would you choose？（）
    A

    RMAN only

    B

    Flashback Table only

    C

    Flashback Versions Query only

    D

    Flashback Database and Flashback Transaction Query

    E

    Flashback Versions Query and Flashback Transaction Query


    正确答案： C
    解析： 暂无解析

  • 第10题：

    单选题
    You are designing an application for Certkiller .com and you have been asked to design a database table to facilitate monthly bill generation. The bill would include details of customer calls， listed in chronological order.Which method would you follow to achieve this objective without increasing the overhead of sorting the rows？（）
    A

     create a hash cluster to store the data

    B

     create an index cluster to store the data

    C

     create a partitioned table to store the data

    D

     create a sorted hash cluster to store the data

    E

     create a heap table with rowid to store the data


    正确答案： D
    解析： 暂无解析

  • 第11题：

    单选题
    While designing your database， you have created the EMPLOYEES table as an index-organized table （IOT）. You want to create a bitmap index on the JOB_ID column to make queries faster. Which task must have been completed so that you are able to create the bitmap index？（）
    A

    A primary key must have been created.

    B

    A mapping table must have been created.

    C

    An overflow tablespace must have been specified.

    D

    The PCTTHRESHOLD option must have been specified.


    正确答案： D
    解析： 暂无解析

  • 第12题：

    单选题
    By mistake， you ran the batch job （for updating the BILL_DETAILS table） twice. You are not sure which rows in the BILL_DETAILS table were affected. You need to identify：  a） A list of changes made along with the transaction identifier of each change.  b） The necessary SQL statements to undo the erroneous changes.  Which option would you choose？（）
    A

     RMAN only.

    B

     Flashback Table only.

    C

     Flashback Version Query only.

    D

     Flashback Database and Flashback Transaction Query.

    E

     Flashback Version Query and Flashback Transaction Query.


    正确答案： C
    解析： 暂无解析

  • 第13题：

    You work as a database administrator for Certkiller .com. In your transaction application， you have scheduled a job to update the optimizer statistics at05：00 pm every Friday. The job has successfully completed. Which three pieces of information would you check to confirm that the statistics have been collected？（）

    • A、Average row size
    • B、Last analyzed date
    • C、Size of table in bytes
    • D、Size of table in database blocks
    • E、Number of free blocks in the free list
    • F、Number of extents present in the table.

    正确答案:A,B,D

  • 第14题：

    You work as a database administrator for Supportcenter.cn. You suspect that in one of your applications the customer table is being accessed by some unauthorized users. Which option would you use to monitor the queries being executed on the customer table？（）

    • A、Monitor thealert.logfile
    • B、Enable server-side SQL tracing for user sessions
    • C、Enable fine-grained auditing for the customer table
    • D、Enable Fine-Grained Access Control （FGAC） for the customer table
    • E、Write a database trigger on the customer table on the SELECT event

    正确答案:D

  • 第15题：

    By mistake， you ran the batch job （for updating the BILL_DETAILS table） twice. You are not sure which rows in the BILL_DETAILS table were affected. You need to identify：  a） A list of changes made along with the transaction identifier of each change.  b） The necessary SQL statements to undo the erroneous changes.  Which option would you choose？（）

    • A、 RMAN only.
    • B、 Flashback Table only.
    • C、 Flashback Version Query only.
    • D、 Flashback Database and Flashback Transaction Query.
    • E、 Flashback Version Query and Flashback Transaction Query.

    正确答案:E

  • 第16题：

    You work as a database administrator for Certkiller .com. You have been asked to use a centralized administrative tool to administer your database servers and application servers. In order to achieve the objective， which component would you configure on each database server？（）

    • A、Database Control
    • B、Management Server
    • C、Management Repository
    • D、Application Server Control
    • E、Oracle Management Agent

    正确答案:E

  • 第17题：

    You work in a company which uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 instance. There is a database named named Dworks in the instance. The Dworks database has a table named Bills which contains several indexes and a great amount of rows. An enterprise Web environment is supported by the database. Onthe Bills table 28% of the indexes have been fragmented. You have to defragment the indexes， making sure that you reduce the effect on database availability to the least.  In the ALTER INDEX statement， which option should be included？（）

    • A、Sort in tempdb 
    • B、Online 
    • C、Fill factor 
    • D、Pad index 

    正确答案:B

  • 第18题：

    单选题
    In your test database， you have created the ORDERS table as an index-organized table （IOT）. To facilitate faster querying， you have created a mapping table and a bitmap index on the ORDER_FILLED column. You observe that the query performance degrades when users perform a large volume of transactions.  While investigating the reason， you find that the mapping table segment is fragmented， leading to poor performance.   Which option would you use to defragment the mapping table without affecting the original table data？（）
    A

    export and import the mapping table

    B

    drop and re-create the mapping table

    C

    truncate the mapping table and reinsert the values

    D

    use the ALTER TABLE···REBUILD command to defragment the mapping table


    正确答案： B
    解析： 暂无解析

  • 第19题：

    单选题
    You work as a database administrator for Certkiller .com. You suspect that in one of your applications the customer table is being accessed by some unauthorized users. Which option would you use to monitor the queries being executed on the customer table？（）
    A

    Monitor thealert.logfile

    B

    Enable server-side SQL tracing for user sessions

    C

    Enable fine-grained auditing for the customer table

    D

    Enable Fine-Grained Access Control （FGAC） for the customer table

    E

    Write a database trigger on the customer table on the SELECT event


    正确答案： E
    解析： 暂无解析

  • 第20题：

    单选题
    The production database has been functional for the last seven days. Because of application requirements， some of the initialization parameters were changed during run time without any comments. You have asked to find out the value of the parameters when the instance was started.Which source would you use to locate this information？（）
    A

     Fixed views

    B

     The alert log file

    C

     The parameter file

    D

     The server parameter file

    E

     Dynamic performance views


    正确答案： B
    解析： 暂无解析

  • 第21题：

    单选题
    You are using flat files as the data source for one of your data warehousing applications. You plan to move the data from the flat file structures to an Oracle database to optimize the application performance. In your database you have clustered tables.  While migrating the data， you want to have minimal impact on the database performance and optimize the data load operation. Which method would you use to load data into Oracle database？（）
    A

    use the external table population

    B

    use the Oracle Data Pump export and import utility

    C

    use the conventional path data load of SQL*Loader utility

    D

    use the direct path data load of Oracle export and import utility


    正确答案： A
    解析： 暂无解析

  • 第22题：

    多选题
    You work as a database administrator for Certkiller .com. In your transaction application， you have scheduled a job to update the optimizer statistics at05：00 pm every Friday. The job has successfully completed. Which three pieces of information would you check to confirm that the statistics have been collected？（）
    A

    Average row size

    B

    Last analyzed date

    C

    Size of table in bytes

    D

    Size of table in database blocks

    E

    Number of free blocks in the free list

    F

    Number of extents present in the table.


    正确答案： A,D
    解析： 暂无解析

  • 第23题：

    问答题
    Practice 7　　● Your company has planned three training courses：Foreign Language Development, Changes in Technology, Management Skills.　　● You have been asked to write a report, recommending the course you think would be most useful for people who do the same kind of job as you.　　● Write the report, saying which course you have chosen.　　● Explain why you feel it would be the most useful and why the others are not so suitable.　　● Write 200-250 words on your Answer Sheet．

    正确答案： 【参考范文】
    To: Mr. Walker, Human Resources Director
    From: Zhang Gao, Translating Coordinator
    Date: May 16, 2012
    Subject: Management Skills Most Suitable for Foreign Language Translators
    The Company has planned three training courses for all foreign language translators for the next three months and I have been required to recommend one course as being the most suitable.
    The three courses from which a choice may be made are as follows:
    (i)English Language Development; (ii) Changes in Technology; (iii) Management Skills.
    All translators in the Company have college degrees in English Language and a lot of colleagues in our field have postgraduate qualifications in Translation or Linguistics. Since English Language Training Course of the Company is only to Diploma level and contains nothing new to us, it is not useful for us and is best left to other colleagues.
    Two months ago all Company’s translators finished an excellent “Changes in Technology” course, which brought us up-to-date information on use of machine translating and personal computers. Obviously, there is no need for us to attend the “Changes in Technology” course again.
    Undoubtedly the “Management Skills” course is the best choice for the Company’s translators. Recently it has been announced that next year our department will be divided into four sections, each of which will serve a specific division of a much-expanded Company. We will recruit twenty new English Language graduates as new translators, five to each section. We four existing translators will be promoted as Heads of Section.
    All four of us are shortage of management skills and, when we manage our own sections, such skills will be indispensable. As a result, I will recommend without hesitation that all translators be enrolled for the “Management Skills” training course.
    解析： 暂无解析

  • 第24题：

    单选题
    The production database has been functional for the last seven days. Because of application requirements， some of the initialization parameters were changed during run time without any comments. You have been asked to find out the value of the parameters when the instance was started. Which source would you use to locate this information？（）
    A

    fixed views

    B

    the alert log file

    C

    the parameter file

    D

    the server parameter file

    E

    dynamic performance views


    正确答案： B
    解析： 暂无解析

相关内容