违法和不良信息举报 联系客服
免费注册 登录

单选题Observe the information in the columns：  1： The SGA     a. Text and parsed forms of all SQL statements  2： The cursor state   b. Run-time memory values for the SQL statement， such as rows retrieved  3： User-session data   c. Security and resource usage

题目
单选题
Observe the information in the columns：  1： The SGA     a. Text and parsed forms of all SQL statements  2： The cursor state   b. Run-time memory values for the SQL statement， such as rows retrieved  3： User-session data   c. Security and resource usage information  4：The stack space   d. Local variables for the process  Which option has the correct match between the memory areas and their contents（）
A

1-c，2-b，3-d，4-a

B

1-c，2-b，3-c，4-a

C

1-a，2-b，3-c，4-d

D

1-a，2-b，3-d，4-c

参考答案和解析
正确答案： C
解析： 暂无解析
如果没有搜索结果或未解决您的问题，请直接 联系老师 获取答案。
相似问题和答案

第1题：

Evaluate the SQL statement DROP TABLE DEPT: Which four statements are true of the SQL statement? ()

A. You cannot roll back this statement.

B. All pending transactions are committed.

C. All views based on the DEPT table are deleted.

D. All indexes based on the DEPT table are dropped.

E. All data in the table is deleted, and the table structure is also deleted.

F. All data in the table is deleted, but the structure of the table is retained.

G. All synonyms based on the DEPT table are deleted.


参考答案：A, B, D, E

第2题：

The EMPLOYEES table has these columns:Management wants to add a default value to the SALARY column. You plan to alter the table by using this SQL statement:What is true about your ALTER statement?()

A. Column definitions cannot be altered to add DEFAULT values.

B. A change to the DEFAULT value affects only subsequent insertions to the table.

C. Column definitions cannot be altered at add DEFAULT values for columns with a NUMBER data type.

D. All the rows that have a NULL value for the SALARY column will be updated with the value 5000.


参考答案：B

第3题：

Which statement correctly describes SQL and ／SQL*Plus? ()

A. Both SQL and /SQL*plus allow manipulation of values in the database.

B. /SQL* Plus recognizes SQL satement and sends them to the server; SQL is the Oracle proprietary interface for executing SQL statements.

C. /SQL* Plus language for communicating with the Oracle server to access data; SQL recognizes SQL statements and sends them to the server.

D. /SQL manipulates data and table definition in the database; /SQL* Plus does not allow manipulation of values in the database.


参考答案：A

第4题：

Which statement is true regarding the INTERSECT operator?（）

  • A、It ignores NULL values 
  • B、Reversing the order of the intersected tables alters the result 
  • C、The names of columns in all SELECT statements must be identical 
  • D、The number of columns and data types must be identical for all SELECT statements in the query 

正确答案:D

第5题：

Which of the following is NOT true about XML columns?()

A.Data can be retrieved by SQL.

B.Data can be retrieved by XQuery.

C.XML columns must be altered to accommodate additional parent and child relationships.

D.Access to any portion of an XML document can be direct, without reading the whole document.


参考答案：C

第6题：

The EMPLOYEES table has these columns:LAST NAME VARCHAR2(35)SALARY NUMBER(8,2)HIRE_DATE DATEManagement wants to add a default value to the SALARY column. You plan to alter the table by using this SQL statement:ALTER TABLE EMPLOYEESMODIFY ( SALARY DEFAULT 5000);What is true about your ALTER statement?（）

A. Column definitions cannot be altered to add DEFAULT values.

B. A change to the DEFAULT value affects only subsequent insertions to the table.

C. Column definitions cannot be altered at add DEFAULT values for columns with a NUMBER data type.

D. All the rows that have a NULL value for the SALARY column will be updated with the value 5000.


参考答案：B

第7题：

You are the administrator of a SQL Server 2000 computer. The server contains a database that stores financial data. You want to use Data Transformation Services packages to import numeric data from other SQL server computers. The precision and scale values of this data are not defined consistently on the other servers.

You want to prevent any loss of data during the import operations. What should you do?

A．Use the ALTER COLUMN clause of the ALTER TABLE statement to change data types in the source tables. Change the data types so that they will use the lowest precision and scale values of the data that will be transferred.

B．Use the ALTER COLUMN clause of the ALTER TABLE statement to change data types in the destination tables. Change the data types to reflect the highest precision and scale values involved in data transfer.

C．Set a flag on each DTS transformation to require an exact match between source and destination columns.

D．Set the maximum error count for each DTS transformation task equal to the number of rows of data you are importing. Use an exception file to store any rows of data that generate errors.

E．Write Microsoft ActiveX script. for each DTS transformation. Use the script. to recast data types to the destinations precision and scale values.


正确答案：B
解析：Explanation: The ALTER COLUMN clause of the ALTER TABLE statement can be used to change the definition of a column and can be used to alter the precision and scale values of the data types. The destination precision should be changed so no data would be lost. The transformation to a data type with higher precision is automatic and would not require any coding.

Note: The precision of the data type refers to the number of digits in a number while the scale is the number of digits to the right of the decimal point in a number. Thus the number 702.85 has a precision of 5 and a scale of 2. The default maximum precision of numeric and decimal data types is 38.

Incorrect Answers:
A: The ALTER COLUMN clause of the ALTER TABLE statement can be used to change the definition of a column and can be used to alter the precision and scale values of the data types. However, we want to prevent any loss of data therefore we need to ensure that the data being imported correlates with the definition of the destination column. If it does not, any constraint that might exist on the destination column will prevent the data from being inserted.

C: Setting DTS transformation to require an exact match between source and destination columns refers to the data in the columns.

D: When the a maximum error count value for a DTS transformation task specifies the sum of row-level errors detected by the Transform. Data task and batch failures. When the Max error count value is exceeded, DTS task execution is terminated. Because rows containing errors detected by the DTS transformation task are discarded before batch submission, these errors do not trigger nor count as batch failures. Errors caught at the destination will fail the batch and add one to the error count regardless of how many rows are in the batch.

E: Recasting data types to the destinations precision could result in loss of data. The destination precision should be changed so no data would be lost.

Note: The capabilities of a Data Transformation Service package can be extended by using
Microsoft ActiveX scripts that implement the objects, properties, methods, and collections of the DTS object model. With ActiveX scripts the data can be formatted and transformed as it is copied from its source to the destination location.

An ActiveX script. transformation applies to tasks that work on the source data on a row-by-row basis and can be used to replace a two-digit state code in the source data with the legal abbreviation of the state in the destination data; set columns to a default of spaces, validate important columns in the source data and skip records that contain invalid data to prevent them from being copied to the destination, and alter the precision and scale values of data as the data copied from the source to the destination.

第8题：

Which of the following identifies and creates an index to minimize the DB time for a particular SQL statement?()

A. The SGA Tuning Advisor

B. The SQL Access Advisor

C. The SQL Tuning Advisor

D. The Memory Advisor


参考答案：C

第9题：

Which of the following is NOT true about XML columns?（）

  • A、Data can be retrieved by SQL.
  • B、Data can be retrieved by XQuery.
  • C、XML columns must be altered to accommodate additional parent and child relationships.
  • D、Access to any portion of an XML document can be direct, without reading the whole document.

正确答案:C

第10题：

Which statement correctly describes SQL and /SQL*Plus?（）

  • A、Both SQL and /SQL*plus allow manipulation of values in the database.
  • B、/SQL* Plus recognizes SQL satement and sends them to the server; SQL is the Oracle proprietary interface for executing SQL statements.
  • C、/SQL* Plus language for communicating with the Oracle server to access data; SQL recognizes SQL statements and sends them to the server.
  • D、/SQL manipulates data and table definition in the database; /SQL* Plus does not allow manipulation of values in the database.

正确答案:A

更多相关问题
相关内容