网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
单选题
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
参考答案
参考解析
解析：
暂无解析
更多 “单选题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” 相关考题
考题
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.
考题
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.
考题
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 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.
考题
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
考题
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（）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
考题
单选题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
考题
单选题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
考题
单选题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 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
考题
单选题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
考题
单选题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
考题
单选题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
热门标签
最新试卷