网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
单选题
You are shrinking the SCOTT.EMP table by executing the ALTER TABLE SCOTT.EMP SHRINK SPACE CASCADE statement. What is a prerequisite for shrinking the SCOTT.EMP table？（）
A
You must enable the block change tracking feature.
B
You must have enable the flashback feature.
C
You must use the OMF in your database.
D
You must define the tablespace of the SCOTT.EMP table for automatic segment space management.
参考答案
参考解析
解析：
暂无解析
更多 “单选题You are shrinking the SCOTT.EMP table by executing the ALTER TABLE SCOTT.EMP SHRINK SPACE CASCADE statement. What is a prerequisite for shrinking the SCOTT.EMP table？（）A You must enable the block change tracking feature.B You must have enable the flashback feature.C You must use the OMF in your database.D You must define the tablespace of the SCOTT.EMP table for automatic segment space management.” 相关考题
考题
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 need to modify the STUDENTS table to add a primary key on the STUDENT_ID column. The table is currently empty. Which statement accomplishes this task?()
A. ALTER TABLE students ADD PRIMARY KEY _ id;B. ALTER TABLE students ADD CONSTRAINT PRIMARY KEY (student_id);C. ALTER TABLE students ADD CONSTRAINT stud_id_pk PRIMARY KEY student_id;D. ALTER TABLE students ADD CONSTRAINT stud_id_pk PRIMARY KEY (student_id);E. ALTER TABLE students MODIFY CONSTRAINT stud_id_pk PRIMARY KEY (student_id);
考题
Consider the following statement on a RANGE partitioned table: ALTER TABLE orders DROP PARTITION p1, p3;What is the outcome of executing the above statement?()
A.A syntax error will result as you cannot specify more than one partition in the same statementB.All data in p1 and p3 partitions are removed and the table definition is changedC.All data in p1 and p3 partitions are removed, but the table definition remains unchangedD.Only the first partition (p1) will be dropped as only one can be dropped at any time
考题
Which two partitioned table maintenance operations support asynchronous Global Index Maintenance inOracle database 12c?()
A. ALTER TABLE SPLIT PARTITIONB. ALTER TABLE MERGE PARTITIONC. ALTER TABLE TRUNCATE PARTITIOND. ALTER TABLE ADD PARTITIONE. ALTER TABLE DROP PARTITIONF. ALTER TABLE MOVE PARTITION
考题
You need to change the definition of an existing table. The COMMERCIALS table needs its DESCRIPTION column changed to hold varying length characters up to 1000 bytes. The column can currently hold 500 bytes per value. The table contains 20000 rows. Which statement is valid?（）A、ALTER TABLE commercials MODIFY (description CHAR2(1000));B、ALTER TABLE commercials CHANGE (description CHAR2(1000));C、ALTER TABLE commercials CHANGE (description VARCHAR2(1000));D、ALTER TABLE commercials MODIFY (description VARCHAR2(1000));E、You cannot increase the size of a column if the table has rows.
考题
Your database is running in ARCHIVELOG mode. The SCOTT.EMP table belongs to the DATA1 tablespace. The junior DBA erroneously runs a script that executes the following statement： SQL DROP TABLE SCOTT.EMP PURGE； After one hour， you are performing the user managed incomplete recovery. Which datafiles will you restore from the last full backup？（）A、 the datafiles associated with the SYSTEM tablespaceB、 the datafiles associated to the DATA1 tablespaceC、 the datafiles associated to the SYSTEM and DATA1 tablespacesD、 all the datafiles in the database
考题
You are shrinking the SCOTT.EMP table by executing the ALTER TABLE SCOTT.EMP SHRINK SPACE CASCADE statement. What is a prerequisite for shrinking the SCOTT.EMP table？（）A、 You must enable the block change tracking feature.B、 You must have enable the flashback feature.C、 You must use the OMF in your database.D、 You must define the tablespace of the SCOTT.EMP table for automatic segment space management.
考题
Which two partitioned table maintenance operations support asynchronous Global Index Maintenance inOracle database 12c?（）A、ALTER TABLE SPLIT PARTITIONB、ALTER TABLE MERGE PARTITIONC、ALTER TABLE TRUNCATE PARTITIOND、ALTER TABLE ADD PARTITIONE、ALTER TABLE DROP PARTITIONF、ALTER TABLE MOVE PARTITION
考题
You just issued the following statement: ALTER TABLE SALES DROP COLUMN PROFIT. Which of the following choices identifies when the column will actually be removed from Oracle?（）A、Immediately following statement execution B、After the ALTER TABLE DROP UNUSED COLUMNS command is issued C、After the ALTER TABLE SET UNUSED COLUMN command is issued D、After the ALTER TABLE MODIFY command is issued
考题
For which two SQL statements can you use the Flashback Table feature to revert a table to its previous state？（）A、UPDATE TABLEB、CREATE CLUSTERC、TRUNCATE TABLED、ALTER TABLE MOVEE、INSERT INTO···VALUESF、ALTER TABLE···DROP COLUMNG、ALTER TABLE···DROP PARTITION
考题
You need to modify the STUDENTS table to add a primary key on the STUDENT_ID column. The table is currently empty.Which statement accomplishes this task?（）A、ALTER TABLE students ADD PRIMARY KEY student_id;B、ALTER TABLE students ADD CONSTRAINT PRIMARY KEY (student _ id);C、ALTER TABLE students ADD CONSTRAINT stud _ id _pk PRIMARY KEY (student _ id);D、ALTER TABLE students MODIFY CONSTRAINT stud _ id _pk PRIMARY KEY (student _ id);
考题
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.
考题
When shrinking a table segment， you choose to shrink all the indexes for that table using the SHRINK SPACE command. Which clause should you use？（）A、 INCLUDING DEPENDENCIESB、 INCLUDING DEPENDENCIES CASCADEC、 COMPACTD、 CASCADEE、 None of the above
考题
You issued the following command to analyze the SCOTT.EMP table for block corruption： ANALYZE TABLE SCOTT.EMP VALIDATE STRUCTURE； You received the following error： ORA-01578： ORACLE data block corrupted （file # %s， block # %s） How will you resolve the block corruption problem？（）A、 by using the DBMS_REPAIR packageB、 by using the DB_BLOCK_CHECKING parameterC、 by using the DBVERIFY utilityD、 will not be completely resolved until the hardware fault is corrected
考题
You are trying to alter the initial segment size given to a table in a dictionary-managed tablespace. Which of the following keywords would be used as part of this process?（）A、DROP TABLE B、ALTER TABLE C、RESIZE D、COALESCE
考题
You have a long-running process you want to assign to a specific UNDO segment brought online for that express purpose. You are not using automatic UNDO management. What statement can be used for this task? （）A、ALTER DATABASE B、SET TRANSACTION C、ALTER ROLLBACK SEGMENT D、ALTER TABLE
考题
You need to modify the STUDENTS table to add a primary key on the STUDENT_ID column. The table is currently empty.Which statement accomplishes this task?（）A、ALTER TABLE students ADD PRIMARY KEY student_id;B、ALTER TABLE students ADD CONSTRAINT PRIMARY KEY (student_id);C、ALTER TABLE students ADD CONSTRAINT stud_id_pk PRIMARY KEY student_id;D、ALTER TABLE students ADD CONSTRAINT stud_id_pk PRIMARY KEY (student_id);E、ALTER TABLE students MODIFY CONSTRAINT stud_id_pk PRIMARY KEY (student_id);
考题
You work in a company which uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 instance. There is a database named DB1 in the instance. In the Services schema， There is a table named Service.Table. The Services.Table has to be moved from the Sales schema to a new schema named Costs. In the options below， which Transact-SQL statement should you execute？（）A、ALTER TABLE Service.Table SWITCH TO Costs.Table1; B、ALTER SCHEMA CostsTRANSFER Service.Table; C、ALTER USER Service WITH DEFAULT_SCHEMA = Costs; D、ALTER AUTHORIZATION ON Service.Table1 TO Costs;
考题
单选题When shrinking a table segment， you choose to shrink all the indexes for that table using the SHRINK SPACE command. Which clause should you use？（）A
INCLUDING DEPENDENCIESB
INCLUDING DEPENDENCIES CASCADEC
COMPACTD
CASCADEE
None of the above
考题
单选题You issued the following command： ALTER TABLE SCOTT.EMP SHRINK SPACE； The SCOTT.EMP table is stored in the DATA1 tablespace that has the following properties： DATA1 is a read/write tablespace. DATA1 is not autoextensible to an unlimited size. DATA1 is online. Segment space management for the DATA1 tablespace is manual. You issued the ALTER TABLE SCOTT.EMP SHRINK SPACE； command that generates the following error： ORA-10635： Invalid segment or tablespace type What could be the reason for the failure of the command？（）A
The tablespace， DATA1， is not read-only.B
The tablespace， DATA1， is not autoextensible.C
The tablespace， DATA1， is not offline.D
The segment space management for the tablespace， DATA1， is manual.
考题
单选题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 issued the following command to analyze the SCOTT.EMP table for block corruption： ANALYZE TABLE SCOTT.EMP VALIDATE STRUCTURE； You received the following error： ORA-01578： ORACLE data block corrupted （file # %s， block # %s） How will you resolve the block corruption problem？（）A
by using the DBMS_REPAIR packageB
by using the DB_BLOCK_CHECKING parameterC
by using the DBVERIFY utilityD
will not be completely resolved until the hardware fault is corrected
考题
单选题One of the users in the PROD database， Adams， complains that his update on the table， TRANS， is taking an unusually long time to complete. You find that the table gets locked by another database user before Adams starts his transactions， and you are unable to contact the user holding the table lock. As Adams is updating some crucial rows in the table， he should get the highest priority. Which method would you use to overcome this problem？（）A
execute the command， ALTER SESSION KILL ..， to kill the blocking sessionB
execute the DBMS_SESSION.KILL_SESSION procedure to kill the blocking sessionC
execute the command， ALTER SYSTEM KILL SESSION ..， to kill the blocking sessionD
execute the command， ALTER SESSION UNLOCK ..， to release the lock for the blocking sessionE
execute the command， ALTER SYSTEM UNLOCK SESSION ..， to release the lock for the blocking session
考题
单选题You execute the following command in your Certkiller .com production database to change the width of the CUST_NAME column of the CUSTOMERS table： ALTER TABLE customers MODIFY （cust_nameVARCHAR2 （40）） / When you execute the command， it displays the following error message： ERROR at line 1： ORA-00054： resource busy and acquire with NOWAIT specified What could be the reason for the error message？（）A
The database instance is not available.B
The ALTER TABLE command does not have WAIT optionC
The table or a row in the table is currently locked by another user session.D
The database instance is busy processing other user sessions commands.E
The CUSTOMERS table has no long running query active at the time when this request is made.F
The server process executing the ALTER TABLE command is busy with another command execution
考题
单选题You are shrinking the SCOTT.EMP table by executing the ALTER TABLE SCOTT.EMP SHRINK SPACE CASCADE statement. What is a prerequisite for shrinking the SCOTT.EMP table？（）A
You must enable the block change tracking feature.B
You must have enable the flashback feature.C
You must use the OMF in your database.D
You must define the tablespace of the SCOTT.EMP table for automatic segment space management.
考题
单选题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.
考题
单选题Consider the following statement on a RANGE partitioned table: ALTER TABLE orders DROP PARTITION p1, p3; What is the outcome of executing the above statement?（）A
A syntax error will result as you cannot specify more than one partition in the same statementB
All data in p1 and p3 partitions are removed and the table definition is changedC
All data in p1 and p3 partitions are removed, but the table definition remains unchangedD
Only the first partition (p1) will be dropped as only one can be dropped at any time
考题
多选题Your database is running in the ARCHIVELOG mode. You have configured RMAN for backup and recovery operations. You execute the following command from the RMAN prompt： RMAN CONFIGURE CONTROLFILE AUTOBACKUP ON； After executing this command， in which of the following cases will RMAN make an auto-backup of the control file？ （）Awhen you change the name of a datafileBwhen you drop a table from the databaseCwhen you take an export of the databaseDwhen you back up the database using OS utilitiesEwhen you issue an ALTER SYSTEM SWITCH LOGFILE statementFwhen you issue a BACKUP command from inside the RMAN run block
热门标签
最新试卷