Given the following DDL and INSERT statements:<br /> CREATE VIEW v1 AS SELECT col1 FROM t1 WHERE col1 > 10; CREATE VIEW v2 AS SELECT col1 FROM v1 WITH CASCADED CHECK OPTION; CREATE VIEW v3 AS SELECT col1 FROM v2 WHERE col1 < 100; INSERT INTO v1 VALUES(5); INSERT INTO v2 VALUES(5); INSERT INTO v3 VALUES(20); INSERT INTO v3 VALUES(100);<br /> How many of these INSERT statements will be successful?（）..

第1题

[] A new company has been given one public IP address. The company employs 200 users requiring Internet access from the headquarters. Which of the following can be implemented to provide Internet access for all the employees?（） A new company has been given one public IP address. The company employs 200 users requiring Internet access from the headquarters. Which of the following can be implemented to provide Internet access for all the employees?（）

A、A. Multicasting B、B. Proxy server C、C. NAT D、D. Subnetting

点击查看答案

第2题

[] Given the following MPLS L2 configuration command: mpls-relay 10.1.1.1 4 Which two statements true? （）(Choose two.) Given the following MPLS L2 configuration command: mpls-relay 10.1.1.1 4 Which two statements true? （）(Choose two.)

A、A. This command is applied to the core router facing interface. B、B. This command is applied to the customer facing interface. C、C. The 4 is locally significant and identifies the layer 2 circuit. D、D. The 4 must match exactly on the peer router configuration on the remote end.

点击查看答案

第3题

[] Given the following tables: CONTINENTS ID NAME COUNTRIES 1 Antarctica 0 2 Africa 53 3 Asia 47 4 Australia 14 5 Europe 43 6 North America 23 7 South America 12 REGION ID LOCATION 1 East 2 West How many rows would be returned using the following statement? SELECT location FROM continents, region（） Given the following tables: CONTINENTS ID NAME COUNTRIES 1 Antarctica 0 2 Africa 53 3 Asia 47 4 Australia 14 5 Europe 43 6 North America 23 7 South America 12 REGION ID LOCATION 1 East 2 West How many rows would be returned using the following statement? SELECT location FROM continents, region（）

A、A.2 B、B.7 C、C.9 D、D.14

点击查看答案

第4题

[单选题] A technician is troubleshooting a network connectivity issue. Given the following abbreviated trace route output: Which of the following is MOST likely occurring?（）

A、Switching loop B、Broadcast storm C、IP conflict D、Routing loop

点击查看答案

第5题

[] Given that the current directory is empty, and that the user has read and write privileges to the current, and the following: Which statement is true?（） Given that the current directory is empty, and that the user has read and write privileges to the current, and the following: Which statement is true?（）

A、A.Compilation fails. B、B.Nothing is added to the file system. C、C.Only a new file is created on the file system. D、D.Only a new directory is created on the file system. E、E.Both a new file and a new directory are created on the file system.

点击查看答案

第6题

[单选题] Exhibit Given the information provided in the Exhibit, which of the following procedures will successfully resolve the problem before rebooting in normal mode?（）

A、Increase the size of rootvg. B、Delete unnecessary files in the / (root) file system. C、Edit /etc/inittab and correct any erroneous entries. D、Run fsck on the rootvg and recreate the log device with the following command: /usr/sbin/logform /dev/hd8.

点击查看答案

第7题

[单选题] Given the following policy, what happens when the 1.1/17 route is evaluated?（）

A、The route does not match this policy. B、The route is accepted. C、The route is rejected. D、The route is accepted with a metric of 6.

点击查看答案

第8题

[单选题] An administrator is trying to extend an existing volume group with a new hard disk, but the extendvg command returns the following error. 0516-1162 /usr/sbin/extendvg. Warning, The Physical Partition Size of 64 requires the creation of 8924 partitions for hdisk11. The limitation for volume group datavg is 1016 physical partitions per physical volume. Use chvg command with -t option to attempt to change the maximum Physical Partitions per Physical volume for this volume group. The chvg -t may or may not allow the extendvg command to succeed. What is the implication of using this option?（）

A、It reduces the maximum file size allowed within the given volume group. B、It reduces the maximum number of files allowed within the given volume group. C、It reduces the maximum number of logical volumes allowed within the given volume group. D、It reduces the maximum number of physical volumes allowed within the given volume group.

点击查看答案

第9题

[] 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?（） 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、A.SELECT * FROM T1 MINUS SELECT * FROM T2 B、B.SELECT * FROM T1 EXCEPT SELECT * FROM T2 C、C.SELECT * FROM T2 UNION EXCEPT SELECT * FROM T1 D、D.SELECT * FROM T1 NOT EXISTS SELECT * FROM T2

点击查看答案

第10题

[单选题] Given the following router output,which configuration file will the router use at its next reload?（）

A、config B、clientqos.cnf C、startup-config D、running-configuration

点击查看答案

请使用微信扫码支付