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 SCOT
E: 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 SCOTEMP table for automatic segment space management.
- 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： A: The table is partitioned B: 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.
- 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: A INCLUDING DEPENDENCIES B: B INCLUDING DEPENDENCIES CASCADE C: C COMPACT D: D CASCADE E: E None of the above
- 以下语句错误的是( ) A: alter table emp delete column addcolumn; B: alter table emp modify column addcolumn char(10); C: alter table emp change addcolumn addcolumn int; D: alter table emp add column addcolumn int;
- 查询scott用户的emp表中的总记录数,可以使用下列哪个语句?() A: SELECT MAX(empno) FROM scott.emp; B: SELECT<br/>COUNT(empno) FROM scott.emp; C: SELECT COUNT(comm) FROM scott.emp; D: SELECT COUNT(*) FROM scott.emp;
内容
- 0
If you are travelling north, you must change at Leeds. __________ ___________, you must change at Leeds
- 1
Which describes the default behavior when you create a table? () A. The table is accessible to all users. B. Tables are created in the public schema. C. Tables are created in your schema. D. Tables are created in the DBA schema. E. You must specify the schema when the table is created.
- 2
2. In what ways will the table manners help you? The table manners will help you _________________ with your American friends.
- 3
If you move，you must inform us _____ the change of your address ．
- 4
Which of the following sentences expresses "probability" A: You must have your hair cut by ten o"clock. B: You must be in the office tomorrow. C: You must complete the work tonight. D: You must be feeling better now.