[A]reduce [B]narrow [C]dwarf [D]shrink
第1题:
In order to reduce your wake in a narrow channel you should ______.
A.apply enough rudder to counter the effect of the current
B.change your course to a zigzag course
C.reduce your speed
D.shift the weight to the stern
第2题:
While using the smit install_remove menus to remove some filesets the system administrator notices the /usr filesystem is now unnecessarily large. Which of the following actions will reduce the size of the /usr filesystem?()
第3题:
Companycom would like the ability to shrink filesystems. They currently have JFS filesystems. Which of the following is necessary to shrink the filesystems?()
第4题:
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?()
第5题:
apply enough rudder to counter the effect of the current
change your course to a zigzag course
reduce your speed
shift the weight to the stern
第6题:
REBUILD
CASCADE
TRUNCATE
ROW MOVEMENT
SHRINK SPACE COMPACT
SHRINK SPACE CASCADE
第7题:
Copy the existing filesystems to JFS2
Defragment the filesystem, then reduce its size
Change the file system attribute allow_shrink=yes on the existing filesystems
Modify the logical volume attribute allow_shrink=yes on the existing logical volumes
第8题:
Backup, unmount, remove, recreate and restore the filesystem.
Boot from mksysb tape and select Shrink filesystems on restore.
Unmount, run defragfs /usr and the reducefs -size XXX /usr commands.
Update /etc/filesystems with the desired size for /usr and reboot the system.
第9题:
The shrink operation touches every block in the BOOKING table
The high-water mark (HWM) for the BOOKING table is shifted from its original position
The progress of the shrink operation is saved in the bitmap blocks of the BOOKING table
The data manipulation language (DML) triggers on the BOOKING table are executed because the shrink operation is internally handled by the INSERT/DELETE operation
第10题:
The data in the segment will be compacted but the high water mark will not be adjusted
The EMPLOYEES table will be changed to read-only mode during the shrink operation
The indexes created on the EMPLOYEES table will need to be rebuilt after the shrink operation is over
The shrink behavior will be cascaded to all dependent segments of the table that support a shrink operation
Data manipulation language (DML) operations will not be possible on the EMPLOYEES table during the COMPACTION phase of the shrink operation
第11题:
The extra increase in benefit rates for families with young children is more important than other issues.
To reduce poverty, the most important thing is to lower unemployment.
To narrow the gap between rich and poor, the benefit rates should be raised higher than inflation rate.
The government’s welfare reform programme has met strong criticism and opposition.
第12题:
the same size as the planet Mercury
thousands of times smaller than it is today
around 35 million miles in diameter
cold and dark
第13题:
You need to increase the size of a paging file. What should you do? ()
第14题:
While using the smit install_remove menus to remove some filesets on an AIX 5.3 server, a system administrator notices the /usr filesystem is now unnecessarily large. Which of the following actions will reduce the size of the /usr filesystem ()
第15题:
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?()
第16题:
In one of your online transaction processing (OLTP) applications, users are manipulating and querying a database table simultaneously. From the Segment Advisor, you find that one of the tables is highly fragmented and you want to shrink the table immediately without affecting the currently active queries. Which option would you use with the ALTER TABLE command to achieve this objective?()
第17题:
INCLUDING DEPENDENCIES
INCLUDING DEPENDENCIES CASCADE
COMPACT
CASCADE
None of the above
第18题:
The EMPLOYEES table will be changed to read-only mode during the shrink operation.
The indexes created on the EMPLOYEES table will need to be rebuilt after the shrink operation is over.
The shrink behavior will be cascaded to all dependent segments of the table that support a shrink operation.
Data manipulation language (DML) operations will not be possible on the EMPLOYEES table during the COMPACTION phase of the shrink operation.
第19题:
The shrink operation touches every block in the BOOKING table
The high-water mark (HWM) for the BOOKING table is shifted from its original position
The progress of the shrink operation is saved in the bitmap blocks of the BOOKING table
The data manipulation language (DML) triggers on the BOOKING table are executed because the shrink operation is internally handled by the INSERT/DELETE operation
第20题:
Issue the ALTER TABLE SCOTT.DEPT SHRINK SPACE COMPACT; statement.
Issue the ALTER TABLE SCOTT.DEPT SHRINK SPACE; statement.
Issue the ALTER TABLE SCOTT.DEPT SHRINK SPACE CASCADE; statement.
You cannot shrink the SCOTT.EMP table.
第21题:
receiving of wide metrics only
sending of narrow metrics only
receiving of narrow metrics only
sending and receiving of narrow and wide metrics
第22题:
Yellow dwarf, white dwarf, red giant, black giant.
Red giant, white dwarf, red dwarf, nova explosion.
Yellow dwarf, red giant, white dwarf, black dwarf.
White dwarf, red giant, black dwarf, yellow dwarf.
第23题:
Faint dwarf stars.
The evolution cycle of the Sun.
The Sun's fuel problem.
The dangers of invisible radiation.