单选题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（）A1-c，2-b，3-d，4-aB1-c，2-b，3-c，4-aC1-a，2-b，3-c，4-dD1-a，2-b，3-d，4-c
单选题
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
参考解析
解析：
暂无解析
相关考题：
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.
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
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.
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.
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.
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.
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.
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.
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
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.
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.
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 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-aB、1-b， 2-c， 3-d， 4-aC、1-a， 2-b， 3-c， 4-dD、1-a， 2-b， 3-d， 4-c
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.
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-aB、1-c，2-b，3-c，4-aC、1-a，2-b，3-c，4-dD、1-a，2-b，3-d，4-c
Consider the following statement： SQL EXECUTE DBMS_STATS.GATHER_SHEMA_STATS （- 2 ownname = ‘OE’， - 3 estimate_percent = DBMS_STATS.AUTO_SAMPLE_SIZE， - 4 method opt = ‘for all columns size AUTO’）； What is the effect of ‘for all columns size AUTO’ of the METHOD_OPT option？（）A、The Oracle server creates a new histogram based on existing histogram definitions for all table, column, and index statistics for the OE schema. B、The Oracle server creates a histogram based on data distribution regardless of how the application uses the column/s for all table, column, and index statistics for the OE schema.C、The Oracle server creates a histogram based on data and application usage of the column/s for all table, column, and index statistics for the OE schema. D、The Oracle server creates a histogram based on application usage, regardless of data distribution, for all table, column, and index statistics for the OE schema.
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
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 2B、2 and 5C、1，3，and 4D、3，4，and 5E、1，2，3，and 4
单选题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.
单选题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（）A1-c，2-b，3-d，4-aB1-c，2-b，3-c，4-aC1-a，2-b，3-c，4-dD1-a，2-b，3-d，4-c
单选题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（）A1-c， 2-b， 3-d， 4-aB1-b， 2-c， 3-d， 4-aC1-a， 2-b， 3-c， 4-dD1-a， 2-b， 3-d， 4-c
单选题Which component of the SGA stores parsed SQL statements is used for process sharing?（）ABuffer cache BRedo log buffer CPrivate SQL area DLibrary cache ERow cache
单选题Which statement correctly describes SQL and /SQL*Plus?（）ABoth 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.
单选题Which statement is true regarding the INTERSECT operator?（）AIt ignores NULL values BReversing the order of the intersected tables alters the result CThe names of columns in all SELECT statements must be identical DThe number of columns and data types must be identical for all SELECT statements in the query
单选题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（）A1 and 2B2 and 5C1，3，and 4D3，4，and 5E1，2，3，and 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
单选题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?（）AColumn definitions cannot be altered to add DEFAULT values.BA change to the DEFAULT value affects only subsequent insertions to the table.CColumn definitions cannot be altered at add DEFAULT values for columns with a NUMBER data type.DAll the rows that have a NULL value for the SALARY column will be updated with the value 5000.
单选题Which of the following identifies and creates an index to minimize the DB time for a particular SQL statement?（）AThe SGA Tuning AdvisorBThe SQL Access AdvisorCThe SQL Tuning AdvisorDThe Memory Advisor