网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
单选题
Which of the following is a typical data warehouse query?（）
A
What is this customers address?
B
Does this customer have any unpaid bills?
C
What is the balance in this customers account?
D
What are the total sales for each of the last 6 months?
参考答案
参考解析
解析：
暂无解析
更多 “单选题Which of the following is a typical data warehouse query?（）A What is this customers address?B Does this customer have any unpaid bills?C What is the balance in this customers account?D What are the total sales for each of the last 6 months?” 相关考题
考题
Which of the following is typical of northern cuisine?A.roast duckB.DimsumC.salted duckD.Mapo Doufu
考题
Observe the structure of the table employees:The table contains 8475 records.One of the employees wants to know the names of all employees of the company. For this, he fires the following query:SELECT * FROM EMPLOYEES ORDER BY emp_fname;Since the operation performed on executing the query cannot fit into memory, it requires disk space to complete the operation.Which of the following types of segments will Oracle allocate to complete the operation and to provide the required result?（）A. Rollback segmentB. Temporary segmentC. Data segmentD. Index segment
考题
A general purpose MySQL instance is configured with the following options:—log-slow-queries—long-query-time=,0001—log-slow-admin-queries—general-log—log-bin—binlog-format=STATEMENT—innodb-flush-log-at-trx-commit=1Which three statements are true（）。A.The General Query Log records more data than the Binary LogB.The binary Log records more data than the General Query LogC.The Slow Query Log records more data than the General Query LogD.The General Query Log records more data than the Slow Query LogE.The Slow Query Log records more data than the Binary LogF.The Binary Log records more data than the Slow Query Log
考题
For which of the following is a data warehouse optimized?()
A.Backup and recoveryB.TransactionsC.SecurityD.Queries
考题
（）is a collection of data sets,which is so large and complet that is because difficult to process using on hand database management tools or traditional data peocessing applicationsA.big dataB.clusterC.parallel computingD.data warehouse
考题
A data warehouse is a subject-oriented data set used for reporting and analusis. Data warehouses can be subdivided into ( ). Which store subsets of data from a warehouse.A.OLTPsB.transactionsC.data sartsD.OLAPs
考题
（ ） is a collection of data sets, which is so large and complex that is becomes difficult to process using on-hand database management tools or traditional data processing applications.A.Big data
B.Cluster
C.Parallel computing
D.Data warehouse
考题
A data warehouse is a subject-oriented data set used for reporting and analusis. Data warehouses can be subdivided into （ ） . Which store subsets of data from a warehouse. A.OLTPs
B.transactions
C.datA.sarts
D.OLAPs
考题
（ ） is a collection of data sets，which is so large and complex that is becomes difficult to process using on-hand database management tools or traditional data processing applications. A.Big data
B.Cluster
C.Parallel computing
D.DatA.warehouse
考题
（ ）is a collection of data sets, which is so large and complex that it becomes difficult to process using on-hand database management tools or traditional data processing applications.A、Big dataB、ClusterC、Parallel computingD、Data warehouse
考题
A data warehouse is a subject-oriented data set used for reporting and analusis. Data warehouses can be subdivided into ( ). Which store subsets of data from a warehouse. A、OLTPsB、transactionsC、data sartsD、OLAPs
考题
Which of the following statements best describes Flashback Versions Query？（） A、 Flashback Versions Query is used to make changes to multiple versions of data that existed between two points in time.B、 Flashback Versions Query is used to view all version changes on rows that existed between the time the query was executed and a point in time in the past.C、 Flashback Versions Query is used to view version changes and the SQL to undo those changes on rows that existed between two points in time.D、 Flashback Versions Query is used to view all version changes on rows that existed between two points in time.
考题
Which three statements are true regarding subqueries?（）A、Subqueries can contain GROUP BY and ORDER BY clauses B、Main query and subquery can get data from different tables C、Main query and subquery must get data from the same tables D、Subqueries can contain ORDER BY but not the GROUP BY clause E、Only one column or expression can be compared between the main query and subqueryF、 Multiple columns or expressions can be compared between the main query and subquery
考题
In a typical PDA， which of the following is the primary input tool？（）A、voice navigationB、stylusC、scroll wheelD、keyboard
考题
Which of the following is the typical recommended temperature range for a data center？（）A、64°F to 77°F（18°C to 25°C）B、78°F to 85°F（26°C to 29°C）C、41°F to 55°F（5°C to 12°C）D、56°F to 63°F（13°C to 17°C）
考题
Which of the following is a typical data warehouse query?（）A、What is this customers address?B、Does this customer have any unpaid bills?C、What is the balance in this customers account?D、What are the total sales for each of the last 6 months?
考题
Which three data components are needed for point-in-time recovery?（）A、The error logB、The backup logC、The general query logD、Binary logsE、The data backupF、Configuration files
考题
单选题Which of the following views must you query to identify any corrupt data file blocks that have been detected during backup set creation？（）A
V$COPY_CORRUPTB
V$COPY_CORRUPTIONC
V$BACKUP_CORRUPTD
V$BACKUP_CORRUPTION
考题
单选题You are creating the DEPT_SAL data block from the PAYHIST form. Users should be able to enter a valid department ID number, which will then display the employee salary information for that department. This data block could potentially retrieve a large number of records. Since users will probably only view a small number of these records, only 10 records should be fetched at one time. How would you create the data block?（）A
Select The Data Blocks node in the Object Navigator and click the Create button. Choose to build the data block manually, enter the procedure name in the Query Data Source Columns property, and the procedure code in the Query Data Source Arguments property. B
Choose Tools - Data Block Wizard, select Table as the data source type, and base the block on the columns from the tables. C
Choose Tools - Data Block Wizard, select, View as the data source type, and base the block on the columns from the tables. D
Select the Data Blocks node in the Object Navigator and click the Create button. Choose to build the data block manually, alter the Query Data Source Type property to 'FROM clause query', and enter the SELECT statement in the Query Data Source Name property. E
Select the Data Block node in the Object Navigator and click the Create button. Alter the Query Data Source Type, Query Data Source Name, Query Data Sources Columns, and Query Data Source Arguments properties to create a stored procedure that uses a red cursor.
考题
单选题You need to create a data block for DML operations in the NEW_EMPLOYEE form module. Which data source can you use for this block?（）A
REF cursor query. B
Stored function. C
From clause query. D
Transactional trigger.
考题
多选题A general purpose MySQL instance is configured with the following options: —log-slow-queries —long-query-time=,0001 —log-slow-admin-queries —general-log —log-bin —binlog-format=STATEMENT —innodb-flush-log-at-trx-commit=1 Which three statements are true（）。AThe General Query Log records more data than the Binary LogBThe binary Log records more data than the General Query LogCThe Slow Query Log records more data than the General Query LogDThe General Query Log records more data than the Slow Query LogEThe Slow Query Log records more data than the Binary LogFThe Binary Log records more data than the Slow Query Log
考题
单选题For which of the following is a data warehouse optimized?（）A
Backup and recoveryB
TransactionsC
SecurityD
Queries
考题
单选题Which of the following statements best describes Flashback Versions Query？（）A
Flashback Versions Query is used to make changes to multiple versions of data that existed between two points in time.B
Flashback Versions Query is used to view all version changes on rows that existed between the time the query was executed and a point in time in the past.C
Flashback Versions Query is used to view version changes and the SQL to undo those changes on rows that existed between two points in time.D
Flashback Versions Query is used to view all version changes on rows that existed between two points in time.
考题
多选题Which three data components are needed for point-in-time recovery?（）AThe error logBThe backup logCThe general query logDBinary logsEThe data backupFConfiguration files
考题
单选题You are creating the SAL_INFO data block on the EMP_QUERY form. The SALARY field should only be populated if the logged-on user is a manager. Since this query could potentially return a large amount of records, you have created a stored procedure which uses a ref cursor on which to base the data block. How would you create the data block?（）A
Click the Data Blocks node in the Object Navigator and click the create button. Choose to build the data block manually. Enter the procedure name in the Query Data Source Columns property and the procedure code in the Query Data Source Arguments property. B
Choose Tools - Data Block Wizard, select Table as the data source type, and base the data block on the columns included in the procedure. C
Select the Data Blocks node in the Object Navigator and click the Create button. Choose to build the data block manually, alter the Query Data Source Type property to 'Ref cursor', and enter the name of the procedure in the Query Data Source Name property. D
Select the Data Blocks node in the Object Navigator and click the Create button. Alter the Query Data Source Name, Query Data Source Columns, and Query Data Source Arguments properties to create a stored procedure that uses a ref cursor. E
Launch the Data Block Wizard, select Stored Procedures as the data source type, and base the block on the procedure.
考题
多选题Which three statements are true regarding subqueries?（）ASubqueries can contain GROUP BY and ORDER BY clausesBMain query and subquery can get data from different tablesCMain query and subquery must get data from the same tablesDSubqueries can contain ORDER BY but not the GROUP BY clauseEOnly one column or expression can be compared between the main query and subqueryFMultiple columns or expressions can be compared between the main query and subquery
考题
单选题A data warehouse is a subject-oriented data set used for reporting and analusis. Data warehouses can be subdivided into ( ). Which store subsets of data from a warehouse.A
OLTPsB
transactionsC
data sartsD
OLAPs
考题
多选题Which of the following is included in the typical laser printer maintenance kit?（）APrint headBTonerCFuserDMain drive assemblyEPickup rollers
热门标签
最新试卷