单选题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 

题目
单选题
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-b， 2-c， 3-d， 4-a

C

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

D

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

相似考题

1.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.

2.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.

3.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.

4.Which of the following identifies and creates an index to minimize the DB time for a particular SQL statement?()A. The SGA Tuning AdvisorB. The SQL Access AdvisorC. The SQL Tuning AdvisorD. The Memory Advisor

更多“单选题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 ”相关问题

  • 第1题：

    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

  • 第2题：

    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.

  • 第3题：

    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

  • 第4题：

    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

  • 第5题：

    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

  • 第6题：

    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

  • 第7题：

    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

  • 第8题：

    These are points that describe the contents of different memory components:  1: Descriptive information or metadata about schema objects that are queried by using SQL statements  2: The run-time area for data manipulation language (DML) or data definition language (DDL) statements  3: Results of SQL queries and PL/SQL functions  4: Executable forms of SQL cursors, PL/SQL programs, and Java classes  5: The information necessary to reconstruct changes made to the database by a transaction  Which of these will be stored in theShared Poolif the necessary configurations are done（）

    • A、1 and 2
    • B、2 and 5
    • C、1，3，and 4
    • D、3，4，and 5
    • E、1，2，3，and 4

    正确答案:C

  • 第9题：

    单选题
    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


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

  • 第10题：

    单选题
    Which component of the SGA stores parsed SQL statements is used for process sharing?（）
    A

    Buffer cache 

    B

    Redo log buffer 

    C

    Private SQL area 

    D

    Library cache 

    E

    Row cache 


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

  • 第11题：

    单选题
    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
    解析： 暂无解析

  • 第12题：

    单选题
    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


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

  • 第13题：

    In which two scenarios do you use SQL* Loader to load data?()

    A. Transform the data while it is being loaded into the database.

    B. Use transparent parallel processing without having to split the external data first.

    C. Load data into multiple tables during the same load statement.

    D. Generate unique sequential key values in specified columns.


    参考答案：A, D

  • 第14题：

    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

  • 第15题：

    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

  • 第16题：

    The EMPLOYEES table has these columns: LAST NAME VARCHAR2(35) SALARY NUMBER(8,2) HIRE_DATE DATE Management wants to add a default value to the SALARY column. You plan to alter the table by using this SQL statement: ALTER TABLE EMPLOYEES MODIFY ( 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

  • 第17题：

    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-b， 2-c， 3-d， 4-a
    • C、1-a， 2-b， 3-c， 4-d
    • D、1-a， 2-b， 3-d， 4-c

    正确答案:C

  • 第18题：

    Evaluate the following command：   SQL> CREATE TABLE design_data （id NUMBER， doc CLOB）  LOB（doc） STORE AS SECUREFILE（DEDUPLICATE）；   Which statement is true regarding the above command？（）  

    • A、 The LOB values are automatically compressed.
    • B、 The LOB values are cached by default in the buffer cache.
    • C、 The LOB values are automatically stored in encrypted mode.
    • D、 All LOB data that is identical in two or more rows in a LOB column share the same data blocks.

    正确答案:D

  • 第19题：

    Which component of the SGA stores parsed SQL statements is used for process sharing?（）

    • A、Buffer cache 
    • B、Redo log buffer 
    • C、Private SQL area 
    • D、Library cache 
    • E、Row cache 

    正确答案:C

  • 第20题：

    单选题
    Evaluate the following command：   SQL> CREATE TABLE design_data （id NUMBER， doc CLOB）  LOB（doc） STORE AS SECUREFILE（DEDUPLICATE）；   Which statement is true regarding the above command？（）
    A

     The LOB values are automatically compressed.

    B

     The LOB values are cached by default in the buffer cache.

    C

     The LOB values are automatically stored in encrypted mode.

    D

     All LOB data that is identical in two or more rows in a LOB column share the same data blocks.


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

  • 第21题：

    单选题
    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-b， 2-c， 3-d， 4-a

    C

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

    D

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


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

  • 第22题：

    单选题
    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.


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

  • 第23题：

    单选题
    These are points that describe the contents of different memory components:  1: Descriptive information or metadata about schema objects that are queried by using SQL statements  2: The run-time area for data manipulation language (DML) or data definition language (DDL) statements  3: Results of SQL queries and PL/SQL functions  4: Executable forms of SQL cursors, PL/SQL programs, and Java classes  5: The information necessary to reconstruct changes made to the database by a transaction  Which of these will be stored in theShared Poolif the necessary configurations are done（）
    A

    1 and 2

    B

    2 and 5

    C

    1，3，and 4

    D

    3，4，and 5

    E

    1，2，3，and 4


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

  • 第24题：

    单选题
    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
    解析： 暂无解析

相关内容