单选题You executed the following SQL statement to shrink the EMPLOYEES table segment stored in the EXAMPLE tablespace: ALTER TABLE employees SHRINK SPACE CASCADE; Which statement is correct in this scenario?()AThe data in the segment will be compacted but the high water mark will not be adjusted BThe EMPLOYEES table will be changed to read-only mode during the shrink operation CThe indexes created on the EMPLOYEES table will need to be rebuilt after the shrink operation is overDThe shrink behavior will be cascaded to all dependent segments of the table that support a shrink operation EData manipulation language (DML) operations will not be possible on the EMPLOYEES table during the COMPACTION phase of the shrink operation

单选题
You executed the following SQL statement to shrink the EMPLOYEES table segment stored in the EXAMPLE tablespace: ALTER TABLE employees SHRINK SPACE CASCADE; Which statement is correct in this scenario?()
A

The data in the segment will be compacted but the high water mark will not be adjusted 

B

The EMPLOYEES table will be changed to read-only mode during the shrink operation 

C

The indexes created on the EMPLOYEES table will need to be rebuilt after the shrink operation is over

D

The shrink behavior will be cascaded to all dependent segments of the table that support a shrink operation 

E

Data manipulation language (DML) operations will not be possible on the EMPLOYEES table during the COMPACTION phase of the shrink operation


参考解析

解析: 暂无解析

相关考题:

View the exhibit and examine the TRANS table‘s storage information.After a massive delete operation, you executed the following statement to shrink the TRANS table:SQL ALTER TABLE trans SHRINK SPACE CASCADE;Which statement describes the outcome of the command?()A. An error is produced.B. The table and all related objects are compacted and the position of the high-water mark (HWM) for the table is adjustedC. The table and related indexes are compacted but the position of the high-water mark (HWM) for the table remains unchangedD. The unused space in the table is reclaimed and returned to the tablespace and the data manipulation language (DML) triggers on the table are fired during the shrinking process

You want to analyze a SQL Tuning Set (STS) using SQL Performance Analyzer in a test database. Which two statements are true regarding the activities performed during the test execution of SQLs in a SQL Tuning Set?()A.Every SQL statement in the STS is considered only once for executionB.The SQL statements in the STS are executed concurrently to produce the execution plan and execution statisticsC.The execution plan and execution statistics are computed for each SQL statement in the STSD.The effects of DDL and DML are considered to produce the execution plan and execution statistics

You installed Oracle Database 11g and are performing a manual upgrade of the Oracle9i database. As a part of the upgrade process, you execute the following script:SQL@utlu111i.sqlWhich statement about the execution of this script is true?()A. It must be executed from the Oracle Database 11g environment.B. It must be executed only after the SYSAUX tablespace has been created.C. It must be executed from the environment of the database that is being upgraded.D. It must be executed only after AUTOEXTEND is set to ON for all existing tablespaces.E. It must be executed from both the Oracle Database 11g and Oracle Database 9i environments.

Consider the following table called EMPLOYEES: ID FIRSTNAME LASTNAME JOB LEVELCLERK 3If the following SQL statement is executed, how many rows will be deleted? DELETE FROM employees WHERE 1 = 1() A.0B.1C.3D.6

You are the Database Administrator (DBA) of your company. You execute the following statement on an Oracle 10g instance:   SQL ALTER SYSTEM SWITCH LOGFILE;   Which two tasks are performed when the statement is executed? ()A、 The DBWn process writes to the datafile.B、 Changes in the background process are recorded.C、 The log file is updated with the current SCN number.D、 The System Change Number (SCN) is recorded in the control file.E、 The changes to the listener configuration in the listener.ora file are recorded.

When does a transaction complete?()A、when a DELETE statement is executed B、when a ROLLBACK command is executed C、when a PL/SQL anonymous block is executed D、when a data definition language (DDL) statement is executed E、when a TRUNCATE statement is executed after the pending transact ion

You installed Oracle Database 11g and are performing a manual upgrade of the Oracle9i database. As a part of the upgrade process,you execute the following script:   SQL@utlu111i.sql   Which statement about the execution of this script is true?()A、 It must be executed from the Oracle Database 11g environment.B、 It must be executed only after the SYSAUX tablespace has been created.C、 It must be executed from the environment of the database that is being upgraded.D、 It must be executed only after AUTOEXTEND is set to ON for all existing tablespaces.E、 It must be executed from both the Oracle Database 11g and Oracle Database 9i environments.

You created the DEPT table by using the following command:   CREATE TABLE scott.dept   (deptno NUMBER(3),   dname VARCHAR2(15),   loc VARCHAR2(15) )   STORAGE (INITIAL 100K NEXT 50K  MAXEXTENTS 10 PCTINCREASE 5  FREELIST GROUPS 6 FREELISTS 4);You are required to shrink the DEPT table. While performing the shrink operation, you want to ensure that the recovered space is returned to the tablespace in which the DEPT table is stored. You do not want to shrink the indexes created on the DEPT table. What will you do to shrink the SCOTT.EMP table?()A、 Issue the ALTER TABLE SCOTT.DEPT SHRINK SPACE COMPACT; statement.B、 Issue the ALTER TABLE SCOTT.DEPT SHRINK SPACE; statement.C、 Issue the ALTER TABLE SCOTT.DEPT SHRINK SPACE CASCADE; statement.D、 You cannot shrink the SCOTT.EMP table.

Examine the following commands executed in your database: SQL ALTER SESSION RECYCLEBIN=ON; Session altered  SQL  CREATE TABLE emp TABLESPACE tbsfd AS SELECT * FROM hr.employees;  Table created.  Further, you executed the following command to drop the table:  SQL DROP TABLE emp;Table dropped.  What happens in this scenario?()A、The table is moved to the SYSAUX tablespace.B、The table is moved to the SYSTEM tablespace.C、The table is removed from the database permanently.D、The table is renamed and remains in the TBSFD tablespace.

You work as a database administrator for Supportcenter.cn. Because of space constraints, you decided to manually shrink the table. You executed the ALTER TABLE ....SHRINK SPACE statement to shrink the space and you receive an error as follows:   ERROR at Line 1:   ORA-10635: Invalid segment or tablespace type   What could be the reason? ()A、The table is partitionedB、The table name is wrong.C、It is an index-Organized table (IOT)D、The table is stored in locally managedtablespace.E、The table is stored in atablespacewhere segment space is managed manually.

单选题Consider the following table called EMPLOYEES: ID FIRSTNAME LASTNAME JOB LEVEL CLERK 3 If the following SQL statement is executed, how many rows will be deleted? DELETE FROM employees WHERE 1 = 1()A 0B 1C 3D 6

单选题To make audit information more productive, the DBA executes the following command before startingan audit operation:  SQL ALTER SYSTEM SET AUDIT_TRAIL=DB,EXTENDED SCOPE=SPFILE;  Which statement is true regarding the audit record generated when auditing starts after restarting thedatabase()AIt contains only the plan for the SQL statement executed by the user.BIt contains the SQL text executed by the user and the bind variables used with it.CIt contains the plan and statistics associated with the SQL statement executed by the user.DIt contains the plan for the SQL statement executed by the user and the bind variables used with it.

单选题Your Oracle10g database contains a table with a TIMESTAMP TO LOCAL TIME ZONE column. There are about two hundred column values for the column. You issued the following statement:   SQL ALTER DATABASE SET TIME_ZONE =’Europe/London’;   What will be the result of issuing the above statement?()A The statement will be executed successfully, and a new time zone will be set for the database.B The statement will be executed successfully, but a new time zone will not be set for the database.C The statement will not be executed successfully because the SET TIME_ZONE clause can be used only with the ALTER SESSION statement.D The statement will not be executed successfully because the ALTER DATABASE SET TIME_ZONE statement is used only when the database contains no table with the TIMESTAMP TO LOCAL TIME ZONE column.

单选题You work as a database administrator for Supportcenter.cn. Because of space constraints, you decided to manually shrink the table. You executed the ALTER TABLE ....SHRINK SPACE statement to shrink the space and you receive an error as follows:   ERROR at Line 1:   ORA-10635: Invalid segment or tablespace type   What could be the reason? ()AThe table is partitionedBThe table name is wrong.CIt is an index-Organized table (IOT)DThe table is stored in locally managedtablespace.EThe table is stored in atablespacewhere segment space is managed manually.

单选题You installed Oracle Database 11g and are performing a manual upgrade of the Oracle9i database. As a part of the upgrade process, you execute the following script: SQL@utlu111i.sql Which statement about the execution of this script is true?()AIt must be executed from the Oracle Database 11g environment.BIt must be executed only after the SYSAUX tablespace has been created.CIt must be executed from the environment of the database that is being upgraded.DIt must be executed only after AUTOEXTEND is set to ON for all existing tablespaces.EIt must be executed from both the Oracle Database 11g and Oracle Database 9i environments.

多选题You want to analyze a SQL Tuning Set (STS) using SQL Performance Analyzer in a test database. Which two statements are true regarding the activities performed during the test execution of SQLs in a SQL Tuning Set?()AEvery SQL statement in the STS is considered only once for executionBThe SQL statements in the STS are executed concurrently to produce the execution plan and execution statisticsCThe execution plan and execution statistics are computed for each SQL statement in the STSDThe effects of DDL and DML are considered to produce the execution plan and execution statistics

单选题To make audit information more productive, the DBA executes the following command before starting an auditoperation: SQL ALTER SYSTEM SET AUDIT_TRAIL=DB,EXTENDED SCOPE=SPFILE; Which statement is true regarding the audit record generated when auditing starts after restarting Thedatabase()AIt contains only the plan for the SQL statement executed by the user.BIt contains the SQL text executed by the user and the bind variables used with it.CIt contains the plan and statistics associated with the SQL statement executed by the user.DIt contains the plan for the SQL statement executed by the user and the bind variables used with it

单选题You executed the following SQL statement to shrink the EMPLOYEES table segment stored in the EXAMPLE tablespace: ALTER TABLE employees SHRINK SPACE CASCADE; Which statement is correct in this scenario?()AThe EMPLOYEES table will be changed to read-only mode during the shrink operation.BThe indexes created on the EMPLOYEES table will need to be rebuilt after the shrink operation is over.CThe shrink behavior will be cascaded to all dependent segments of the table that support a shrink operation.DData manipulation language (DML) operations will not be possible on the EMPLOYEES table during the COMPACTION phase of the shrink operation.

多选题You are the Database Administrator (DBA) of your company. You execute the following statement on an Oracle 10g instance:   SQL ALTER SYSTEM SWITCH LOGFILE;   Which two tasks are performed when the statement is executed? ()AThe DBWn process writes to the datafile.BChanges in the background process are recorded.CThe log file is updated with the current SCN number.DThe System Change Number (SCN) is recorded in the control file.EThe changes to the listener configuration in the listener.ora file are recorded.

单选题Examine the following command: SQL ALTER TABLE booking SHRINK SPACE COMPACT; Which activity is performed when the preceding command is executed?()AThe shrink operation touches every block in the BOOKING tableBThe high-water mark (HWM) for the BOOKING table is shifted from its original positionCThe progress of the shrink operation is saved in the bitmap blocks of the BOOKING tableDThe data manipulation language (DML) triggers on the BOOKING table are executed because the shrink operation is internally handled by the INSERT/DELETE operation

单选题You are performing the shrink operation on the SCOTT.EMP table. You want to perform the same operation on all dependent objects of the SCOTT.EMP table. What is NOT a prerequisite for the operation?()A You must enable the row movement on the SCOTT.EMP table.B You must define the tablespace of the SCOTT.EMP table for automatic segment space management.C You must use the CASCADE clause in the ALTER TABLE SHRINK SPACE statement.D You must use the COMPACT clause in the ALTER TABLE SHRINK SPACE statement.

单选题You created the DEPT table by using the following command:   CREATE TABLE scott.dept   (deptno NUMBER(3),   dname VARCHAR2(15),   loc VARCHAR2(15) )   STORAGE (INITIAL 100K NEXT 50K  MAXEXTENTS 10 PCTINCREASE 5  FREELIST GROUPS 6 FREELISTS 4);You are required to shrink the DEPT table. While performing the shrink operation, you want to ensure that the recovered space is returned to the tablespace in which the DEPT table is stored. You do not want to shrink the indexes created on the DEPT table. What will you do to shrink the SCOTT.EMP table?()A Issue the ALTER TABLE SCOTT.DEPT SHRINK SPACE COMPACT; statement.B Issue the ALTER TABLE SCOTT.DEPT SHRINK SPACE; statement.C Issue the ALTER TABLE SCOTT.DEPT SHRINK SPACE CASCADE; statement.D You cannot shrink the SCOTT.EMP table.

单选题Examine the following command:   SQL ALTER TABLE booking SHRINK SPACE COMPACT;   Which activity is performed when the preceding command is executed?()A The shrink operation touches every block in the BOOKING tableB The high-water mark (HWM) for the BOOKING table is shifted from its original positionC The progress of the shrink operation is saved in the bitmap blocks of the BOOKING tableD The data manipulation language (DML) triggers on the BOOKING table are executed because the shrink operation is internally handled by the INSERT/DELETE operation

单选题You created the ORDERS table in your database by using the following code:   SQL CREATE TABLE ORDERS (ORDER_DATE TIMESTAMP(0) WITH TIME ZONE);   Then, you inserted data in the ORDERS table and saved it by issuing the following statements:SQL INSERT INTO ORDERS VALUES(’18-AUG-00 10:26:44 PM America/New_York’);   SQL INSERT INTO ORDERS VALUES(’23-AUG-02 12:46:34 PM America/New_York’);   SQL COMMIT;   Next, you issued the following statement to change the time zone for the database:   SQL ALTER DATABASE SET TIME_ZONE=’Europe/London’;   What will be the result of executing the above statement?()A The statement will fail.B The statement will be executed successfully, and the new time zone will be set for the database.C The statement will be executed successfully, but the new time zone will be set for the current session.DThe statement will be executed successfully, but the new time zone will neither be set for the database nor for a specific session.

单选题A view is created with the following statement:CREATE VIEW v1 AS SELECT col1, col2, col3 FROM t1 WHERE col4 1000 ; When will DB2 access the data from table T1 for view V1?()AWhen view V1 is createdBEach time the REFRESH VIEW v1 statement is executedCEach time an SQL statement is executed against view V1DOnly the first time an SQL statement is executed against view V1

单选题You installed Oracle Database 11g and are performing a manual upgrade of the Oracle9i database. As a part of the upgrade process,you execute the following script:   SQL@utlu111i.sql   Which statement about the execution of this script is true?()A It must be executed from the Oracle Database 11g environment.B It must be executed only after the SYSAUX tablespace has been created.C It must be executed from the environment of the database that is being upgraded.D It must be executed only after AUTOEXTEND is set to ON for all existing tablespaces.E It must be executed from both the Oracle Database 11g and Oracle Database 9i environments.

多选题You want to analyze a SQL Tuning Set (STS) using SQL Performance Analyzer in a test database. Which two statements are true regarding the activities performed during the test execution of SQLs in a SQL Tuning Set?()AEvery SQL statement in the STS is considered only once for execution.BThe SQL statements in the STS are executed concurrently to produce the execution plan and execution statistics.CThe execution plan and execution statistics are computed for each SQL statement in the STS.DThe effects of DDL and DML are considered to produce the execution plan and execution statistics.