搜题
用户您好， 请在下方输入框内搜索其它题目：
搜题
题目内容 （请给出正确答案）
提问人：网友 发布时间：
【单选题】

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?（）”相关的问题
第1题
[多选题] User Scott has updated the salary of one of the employees in the EMPLOYEES table and has not committed the transaction. What are the two types of locks that this scenario would lead to？（）

A、null lock on the row being updated  B、null lock on the table containing the row  C、ROW SHARE lock for the row being updated  D、ROW EXCLUSIVE lock for the row being updated  E、shared row-exclusive lock for the row being updated  F、a shareable table lock for the table containing the row  H、exclusive table-level lock for the table containing the row  

点击查看答案
第2题
[] Which statement describes the effect on an index， when the indexed column for the rows is updatedin the base table（）

A、A.An update in a leaf row takes place.  B、B.The index becomes invalid after the update.  C、C.The leaf block containing the row to be updated is marked as invalid.  D、D.A row in the leaf block of the index for the key value is logically deleted and a new leaf row is inserted  

点击查看答案
第3题
[单选题] The SCOTT user has an index on the ITEM_DESC column of the ITEM table. As part of the year-ending task， SCOTT updates the ITEM_DESC column for most of the rows in the ITEM table. How does this change to the table affect the index？（）

A、An update in a leaf row takes place.  B、The index becomes invalid after the update.  C、The leaf block containing the row to be updated is marked as invalid.  D、A row in the leaf block of the index for the key value is deleted and inserted.  

点击查看答案
第4题
[单选题] The record group in the EMP form is populated using a SELECT statement that is constructed programmatically at runtime. Five employee records are displayed at one time, and a user chooses item two from the record group. Which built-in would you use to determine which rows were flagged in the record group?（）

A、GET_GROUP_ROW_COUNT   B、GET_GROUP_SELECTION_COUNT   C、GET_GROUP_SELECTION   D、FIND_GROUP   E、FIND_COLUMN   F、ADD_GROUP_ROW   

点击查看答案
第5题
[单选题] As a result of performance analysis， you created an index on the prod_name column of the prod_det table， which contains about ten thousand rows. Later， you updated a product name in the table. How does this change affect the index？（）

A、A leaf will be marked as invalid.  B、An update in a leaf row takes place.  C、The index will be updated automatically at commit.  D、A leaf row in the index will be deleted and inserted.  E、The index becomes invalid when you make any updates.  

点击查看答案
第6题
[] 36 You are creating a report wizard to create a matrix report. The query build, you select the patient_name column from the patient table; the doctor_name from the doctors table; and the doctor_ID, patient_ID and ID columns from the procedure table. In the report wizard you select patient_name as the row value, doctor_ID as the column values and the count as the cell values. You need to add a total for each doctors column. In the wizard report which tab will allow you to create theQ

A、A.Rows   B、B.Totals   C、C.Columns   D、D.Cells   E、E.Data  

点击查看答案
第7题
[单选题] You are responsible for a data warehouse application that uses records from an external table to update one of the dimension tables periodically. The records in the external table may contain data for new rows in the dimension table， or for updates to its existing rows. Which type of SQL command would you use to transfer the data from the external table to the dimension table as efficiently as possible？（）

A、MERGE  B、SELECT …CROSS JOIN  C、INSERT ALL …SELECT  D、CREATE VIEW …CONSTRAINT  

点击查看答案
第8题
[单选题] Which event of the GridView class occurs when the Edit button of a row is clicked， but before the GridView control enters edit mode？（）

A、RowEntered  B、RowEdited  C、RowEntering  D、RowEditing  

点击查看答案
第9题
[] Identify two situations in which the block header grows in a data block. （）

A、A.when row directories need more row entries  B、B.when there is row migration in the data block  C、C.when there is an increase in the PCTFREE value for the data block  D、D.when more transaction slots are required than are initially configured  

点击查看答案
第10题
[多选题] You work as a database administrator for Certkiller .com. One of the database users accidentally deleted all the rows of a critical table and committed the delete at 1：30 p.m. You senior database administrator， Certkiller， asks you to retrieve the lost data. Which two actions would you use to ensure that there is no impact on other connected users while retrieving the deleted rows？（）

A、Use a flashback query to retrieve the rows that were deleted  B、Useconventialincremental export and then import the affected object  C、Shutdown the database inNORMALmode and restart the database instance  D、Use DBMS_META package to reconstruct the object using undo segments  E、UseTablespacePoint in Time Recovery （TSPITR） method to recover the table and the data  F、Use Oracle DataPumptwithflashback_timeoption toentableflashback export and then import the affected object.  

点击查看答案
账号：
答题记录 我的收藏 我的题库
客服
TOP

请使用微信扫码支付

订单号：
遇到问题请联系在线客服