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？（）

相似题目

• 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 EMPLOYEES table will be changed to read-only mode during the shrink operation. B . The indexes created on the EMPLOYEES table will need to be rebuilt after the shrink operation is over. C . The shrink behavior will be cascaded to all dependent segments of the table that support a shrink operation. D . Data manipulation language (DML) operations will not be possible on the EMPLOYEES table during the COMPACTION phase of the shrink operation.

  查看最佳答案

• You are designing the placement of the global catalog servers. You want to use the minimum number of global catalog servers that are required. Which design should you use?（）

  A . One global catalog server in New York. B . Two global catalog servers in New York. C . One global catalog server in Chicago and one global catalog server in New York. D . Two global catalog servers in Chicago and two global catalog servers in New York. E . One global catalog server in Chicago, one global catalog server in New York, and one global catalog server in Boston.

  查看最佳答案

• You are designing the placement of the global catalog servers. You want to use the minimum number of global catalog servers that are required.  Which design should you use？（）

  A .  One global catalog server in New York. B .  Two global catalog servers in New York. C .  One global catalog server in Chicago and one global catalog server in New York. D .  Two global catalog servers in Chicago and two global catalog servers in New York. E .  One global catalog server in Chicago， one global catalog server in New York， and one global catalog server in Boston.

  查看最佳答案

• You have 100 segments in the USERS tablespace. You get an alert that the USERS tablespace is running low on space. You decide to shrink some segments. Which option would you use to determine which segments to shrink?（）

  A . Segment Advisor  B . SQL Tuning Advisor  C . SQL Access Advisor  D . Segment Resource Estimation  E . Automatic Database Diagnostic Monitor (ADDM)

  查看最佳答案

• You are handling a mooring line and are instructed to Check the line.What should you do（）.

  A . Ensure the bight is not fouled by taking up slack B . Pay out the line smartly and keep it free for running C . Secure the line by adding more turns D . Surge the line so it maintains a strain without parting

  查看最佳答案

• You issued the following command on the temporary tablespace LMTEMP in your database: SQL>ALTER TABLESPACE lmtemp SHRINK SPACE KEEP 20M; Which requirement must be fulfilled for this command to succeed?（）

  A . The tablespace must be locally managed. B . The tablespace must have only one temp file. C . The tablespace must be made nondefault and offline. D . The tablespace can remain as the default but must have no active sort operations.

  查看最佳答案

• You are mooring to a buoy．You should approach the buoy with the current from（）.

  A . ahead B . broad on the bow C . abeam D . aster

  查看最佳答案

• 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.

  查看最佳答案

• For which of the following can you use Segment Shrink？（）

  A .  Heap tables B .  Tables with function-based indexes C .  Indexes D .  Partitions and subpartitions E .  None of the above

  查看最佳答案

• 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 operatio

  查看最佳答案

• We are pleased to say that we are（）to supply you（）the goods you want.

  A . of a position，── B . at a position，── C . in a position，with D . at a position，with

  查看最佳答案

• You issued the following command on the temporary tablespace LMTEMP in your database：   SQL>ALTER TABLESPACE lmtemp SHRINK SPACE KEEP 20M；   Which requirement must be fulfilled for this command to succeed？（）  

  A .  The tablespace must be locally managed. B .  The tablespace must have only one temp file. C .  The tablespace must be made nondefault and offline. D .  The tablespace can remain as the default but must have no active sort operations.

  查看最佳答案

• If you are nervous on the stage, you can just look at the top of the heads or imaging your audience are vegetables.

  查看最佳答案

• Place your napkin on the lap as soon as you are seated when you are having the western dinner.

  查看最佳答案

• To say you are sorry and admit wrongdoing may make the injured partybelieve you. To say you are sorry and admit wrongdoing may make the injured partybelieve you. To say you are sorry and admit wrongdoing may make the injured party believe you.

  查看最佳答案

• People are reluctant to show you the rope s when they know you are new.

  查看最佳答案

• If you are satisfied with the service, you can give the waiter a＿＿＿＿

  查看最佳答案

• You cn ______ your muscles more powerfully by linking up your brething to the exercise.You cn ______ your muscles more powerfully by linking up your brething to the exercise.condense B．compress C．contrct D．shrink

  A．condense B．compress C．contract D．shrink

  查看最佳答案

• Researching the duties of the job you are applying for will help you get promotion.（

  Researching the duties of the job you are applying for will help you get promotion.(英译中)

  查看最佳答案

• You are just the same______you were the day when I first met you.

  A．that B．as C．like D．so

  查看最佳答案

• Woman: Hi, Michael. I can hardly recognize you. Why are you dressed up today？ Are you going to the theatre？

  Man: No. Actually, I just had an interview at a photo studio this morning. Question: What do we learn about Michael from this conversation？ A．He's going to visit a photo studio. B．He's just had his picture taken. C．He's on the way to the theatre. D．He's just returned from a job interview.

  查看最佳答案

• You are the network administrator for All servers run Windows Server 2003.You are creating a backup schedule for the main file server.You need to create a schedule so that backup jobs are completed in the shortestamount of time possible.What should you do？（）

  A. Schedule a normal backup every Sunday. Schedule incremental backups every Monday through Saturday. B. Schedule a normal backup every Sunday. Schedule differential backups every Monday through Saturday. C. Schedule a copy backup every day. D. Schedule a normal backup every day.

  查看最佳答案

• You are buying from the market when you_____（）

  A．borrow a book from a library B．look after your children C．drive to the seaside for a holiday D．treat a friend to dinner at a restaurant

  查看最佳答案

• You are the administrator on a Linux network.You have created and are ready to impleme

  A．Chmod-M30 B．Chgrp-d30 C．Chage-M30 D．Useradd-D30

  查看最佳答案