-
When configuring an interface using SMIT and Further Configuration with an IP address and netmask， which of the following outcomes indicates how the routing tables will be affected？（）
A . A subnet route is automatically added
B . A default route is automatically added
C . All other routes are automatically added
D . The routing table is not affected
-
Given the following two tables: TAB1 C1 C2 A 11 B 12 C 13 TAB2 CX CY A 21 C 22 D 23 The following results are desired: C1 C2 CX CY A 11 A 21 C 13 C 22 -- --D 23 Which of the following queries will yield the desired results?（）
A . SELECT * FROM tab1 INNER JOIN tab2 ON c1=cx
B . SELECT * FROM tab1 LEFT OUTER JOIN tab2 ON c1=cx
C . SELECT * FROM tab1 FULL OUTER JOIN tab2 ON c1=cx
D . SELECT * FROM tab1 RIGHT OUTER JOIN tab2 ON c1=cx
-
You are configuring the data source for an Oracle database. You will need to specify a test table for WebLogic to test the status of the database. Which option should you choose?（）
A . a table name which has 100s of records
B . a table name which has 10s of records
C . a table name which has empty records
D . a table name which has 1000s of records
E . never use a table name
-
Given the following two tables: TAB1 C1 C2 1 Antarctica 2 Africa 3 Asia 4 Australia TAB2 CX CY 5 Europe 6 North America 7 South America Which of the following SQL statements will insert all rows found in table TAB2 into table TAB1?（）
A . INSERT INTO tab1 SELECT cx, cy FROM tab2
B . INSERT INTO tab1 VALUES (tab2.cx, tab2.cy)
C . INSERT INTO tab1 VALUES (SELECT cx, cy FROM tab2)
D . INSERT INTO tab1 (c1, c2) VALUES (SELECT cx, cy FROM tab2)
-
You have a server that has very limited memory but has a very large table. You will use mysqldump to back up this table. Which option will ensure mysqldump will process a row at a time instead of buffering a set of rows?（）
A . — quick
B . — skip-buffer
C . — single-transaction
D . — ta
-
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
-
Which of the following will be a consequence of defining the column IDCOL2 in TABLE2 as a foreign key referencing the primary key (IDCOL1) of TABLE1?（）
A . DB2 will no longer allow updating the value of IDCOL1 in TABLE1.
B . When inserting a row in TABLE2, the only values that DB2 will allow for IDCOL2 are the existing values of IDCOL1.
C . When inserting a row in TABLE2, DB2 will only allow foreign values for IDCOL2, that is values which do not exist in IDCOL1.
D . When a SELECT statement joins TABLE1 with TABLE2, DB2 will automatically add the condition TABLE1.IDCOL1=TABLE2.IDCOL2 if not specified in the statement.
-
Which of the following will DELETE all of the rows from table T03?（）
A . DELETE * FROM TABLE T03
B . DELETE ALL FROM T03
C . DELETE * FROM T03
D . DELETE FROM T03
-
Given that tables T1 and T2 contain the following rows: Table T1: C1 C2 1 4 1 3 1 2 Table T2: C1 C2 1 1 1 2 1 3 Which of the following queries will return only those rows that exist in both T1 and T2?（）
A . SELECT * FROM t1 UNION SELECT * FROM t2
B . SELECT * FROM t1 UNION DISTINCT SELECT * FROM t2
C . SELECT * FROM t1 INTERSECT SELECT * FROM t2
D . SELECT * FROM t1 WHERE (c1,c2)= (SELECT c1,c2 FROM t2)
-
Which of the following scenarios will ensure that the value of the NEXT_STEPNO column in a given row of table TABLEX exists as a value of column STEPNO (usually in another row) in the same table?（）
A . Define a UNIQUE constraint on the columns NEXT_STEPNO and STEPNO.
B . Define a CHECK constraint on the NEXT_STEPNO column (NEXT_STEPNO = STEPNO).
C . Define column STEPNO as the primary key of TABLEX and column NEXT_STEPNO as a foreign key referencing column STEPNO of the same table.
D . Define column NEXT_STEPNO as the primary key of TABLEX and column STEPNO as a foreign key referencing column NEXT_STEPNO in the same table.
-
A redaction policy was added to the SAL column of the SCOTT.EMP table: All users have their default set of system privileges. For which three situations will data not be redacted?（）
A . SYS sessions, regardless of the roles that are set in the session
B . SYSTEM sessions, regardless of the roles that are set in the session
C . SCOTT sessions, only if the MGR role is set in the session
D . SCOTT sessions, only if the MGR role is granted to SCOTT
E . SCOTT sessions, because he is the owner of the table
F . SYSTEM session, only if the MGR role is set in the sessio
-
After the show ip route command has been entered,the follwing routes are displayed.Which route will not be entered into the routing table of a neighboring router?（）
A . R 192.168.8.0/24 [120/1] via 192.168.2.2, 00:00:10, Serial0
B . R 192.168.11.0/24 [120/7] via 192.168.9.1, 00:00:03, Serial1
C . C 192.168.1.0/24 is directly connected, Ethernet 0
D . R 192.168.5.0/24 [120/15] via 192.168.2.2,00:00:10,Serial0
-
Which of the following commands will remove all dynamic entries for a router’s NAT table？（）
A . clear nat translations
B . clear ip nat translations*
C . clear ip nat statistics
D . clear ip nat transactions*
E . clear ip nat translations
F . clear ip nat translations all
-
Which of the following commands will enable you to see the contents of the IP routing table andsend the output to a TFTP server at the same time？（）
A . show ip route ∣ to tftp：//192.168.1.1/route.txt
B . show ip route ∣ tee tftp：//192.168.1.1/route.txt
C . show ip route ∣ include tftp：//192.168.1.1/route.txt
D . show ip route ft include tJtp：//19Z168.1.1/route.txt
E . show ip route ∣ redirect tftp：//192.168.1.1/route.txt
-
what kind of message in GLBP will inform other membership of GLBP learn virtual mac-address.
-
Given that tables T1 and T2 contain the following rows: Table T1: C1 C2 5 4 5 2 5 5 Table T2: C1 C2 5 1 5 2 5 3 Which of the following queries will return only those rows that exist in T1 and not in T2?（）
A . SELECT * FROM T1 MINUS SELECT * FROM T2
B . SELECT * FROM T1 EXCEPT SELECT * FROM T2
C . SELECT * FROM T2 UNION EXCEPT SELECT * FROM T1
D . SELECT * FROM T1 NOT EXISTS SELECT * FROM T2
-
Which kind of Word does Michael use?
-
This new payment system will save a lot of resources and is a kind of low carbon living style which will benefit our environment.
-
Which kind of ball is one of the three main kinds of balls?
-
Which kind of animal is not the executive of Australia（）
A．Emu
B．Kiwi
C．Duck-billed platypus
D．Kangaroo
-
What kind of charges will the police put against Potters daughter？
A．Damaging public property.
B．Running away to avoid arrest.
C．Reckless driving without a license.
D．Endangering passengers" life.
-
The initial cost of your project is $25,000, which will save the company $6,000 per year for the next four years. Using the above table If your company wants a 12% ROI, what is the NPV of the project？
A.-$1,000
B._$6,772
C.+$1,758
D.+$6,772
-
Refer to the exhibit. EIGRP is configured with the default configuration on all routers. Auto summariz ation is enabled on routers R2 and R3, but it is disabled on router R1.Which two EIGRP routes will be seen in the routing table of router R3？（）
<img src='https://img2.soutiyun.com/ask/uploadfile/2019-03-27/c0432bed5e96b27cf201162a3a16be20.png' />
A. 10.0.0.0/8
B. 172.16.10.0/24
C. 172.16.0.0/24
D. 10.10.10.0/24
E. 172.16.0.0/16
F. 10.10.0.0/16
-
What kind of human being will the future spaceman be？
Will he need bones of steel and powerful muscles to resist rocket thrust，the lungs of a glass blower，a mighty heart，the calmness of an acrobat，unconscious death urges，or a schizophrenic(患精神分裂症的)drove toward isolation？ Popular ideas of a spaceman tend to be funny composites of fiction and fact.
A more realistic portrait emerges from the young science of bioastronautics，the newest and strangest of medical disciplines.The astronaut may be described as a young man of high intelligence who is normal to an abnormal degree.On earth he may well have been a high diver，high jumper，pole vaulter，or acrobat.He must be highly motivated，carefully trained，and he must want to come back.
His heart and lungs must be healthy but need not be exceptionally developed，for his cabin will be pressurized.Huge muscles may actually be disadvantageous，for he will have almost no way to get exercise，and he will find that the strength of a year old child is adequate in the weightlessness of space.A firm body and a short， strong neck will help him to withstand(抗拒;经得起……)the tremendous forces encountered at take off.Most important physically，his digestive system must be one that will not be upset by weightlessness;he must not be subject to motion sickness.
() 41.All the following are popular beliefs about the future spaceman EXCEPT that .
A.faced with isolation，he is brave enough and not liable to go mad
B.he needs to have a strong death complex
C.he must have strong bones and powerful muscles
D.he must be cool headed
() 42.Which of the following is NOT be considered by the author as a more realistic image of the future spaceman？
A.He must have superior intelligence.
B.He is young.
C.He should have a strong desire to survive.
D.He doesn’t get upset easily.
43.Bioastronautics is mostly related to .()
A.literature
B.the science of medicine
C.biology
D.disciplines and regulations
44.“normal to an abnormal degree”(Para.3)means .()
A.seemingly normal but actually abnormal
B.so ordinary that he is undistinguished in every way
C.extremely healthy，and there is nothing abnormal with him
D.so normal that no one believes it is true
45.To the future spaceman，what is most physically important is that .()
A.his vital capacity must be as great as a glass blowers
B.he must have a short and firm neck
C.his heart must be comparatively large
D.his digestive system should not be upset by weightlessness
