违法和不良信息举报 联系客服
免费注册 登录

Select the two correctstatements from the list below that de

题目
多选题
Select the two correctstatements from the list below that describe DES and 3DES： （）
A

3DES is muchmore secure than DES.

B

Both DES and 3DES are stream ciphers.

C

DES uses 64 bitkeys， although the effective key lengthis only 56bits.

D

The decryption operation for both DES and 3DES is the same as the encryption operation.

E

DES can only be used for encryption， whereas 3DES can also be used for authentication.

如果没有搜索结果或未解决您的问题，请直接 联系老师 获取答案。
相似问题和答案

第1题：

The EMP table has these columns:ENAME VARCHAR2(35)SALARY NUMBER(8,2)HIRE_DATE DATEManagement wants a list of names of employees who have been with the company for more than five years. Which SQL statement displays the required results? （）

A. SELECT ENAME FROM EMP WHERE SYSDATE-HIRE_DATE >5;

B. SELECT ENAME FROM EMP WHERE HIRE_DATE-SYSDATE >5;

C. SELECT ENAME FROM EMP WHERE (SYSDATE_HIRE_DATE)/365 >5;

D. SELECT ENAME FROM EMP WHERE (SYSDATE_HIRE_DATE)*/365 >5;


参考答案：C

第2题：

查询所有目前年龄是22岁的学生信息：学号，姓名和年龄，正确的命令组是( )。

A．CREATE VIEW AGE LIST AS； SELECT 学号，姓名，YEAR(DATE())-YEAR(出生日期)年龄FROM学生； SELECT 学号，姓名，年龄FROM AGE LIST WHERE年龄=22

B．CREATE VIEW AGE LIST AS； SELECT 学号，姓名，YEAR(出生日期) FROM 学生； SELECT 学号，姓名，年龄FROM AGE LIST WHERE YEAR(出生日期)=22

C．CREATE VIEW AGE LIST AS； SELECT 学号，姓名，YEAR(DATE())-YEAR(出生日期)年龄FROM学生； SELECT 学号，姓名，年龄FROM学生WHEREYEAR(出生日期)=22

D．CREATE VIEW AGE LIST AS STUDENT； SELECT学号，姓名，YEAR(DATE())-YEAR(出生日期)年龄FROM学生； SELECT学号，姓名，年龄FROM STUDENT WHERE年龄=22


正确答案：A
解析：选项B和选项C是从建立的AGE LIST视图中查询数据，但AGE LIST视图中没有出生日期字段。选项D是从STUDENT表或视图中查询数据，但是STUDENT表或视图不存在。选项A是正确答案。

第3题：

(34）查询所有目前年龄是22岁的学生信息：学号，姓名和年龄，正确的命令组是A）CREATE VIEW AGE LIST AS; SELECT学号，姓名,YEAR(DATEQ)-YEAR(出生日期）年龄FROM学生； SELECT学号，姓名，年龄FROM AGE LIST WHERE年龄=22B）CREATE VIEW AGE LIST AS； SELECT学号，姓名，YEAR（出生日期）FROM学生；SELECT学号，姓名，年龄FROM AGE -L IST WHERE YEAR（出生日期）=22C）CREATE VIEW AGE LIST AS； SELECT学号，姓名,YEAR(DATEQ)-YEAR(出生日期）年龄FROM学生； SELECT学号，姓名，年龄FROM学生WHERE YEAR(出生日期)=22D）CREATE VIEW AGE LIST AS STUDENT； SELECT学号，姓名，YEAR(DATE（））-YEAR(出生日期）年龄FROM学生；SELECT学号，姓名，年龄FROM STUDENT WHERE年龄=22


正确答案：A
本题考查SQL中复杂查询语句的书写，四个选项中只有选项A是正确的。选项B和选项C是从建立的AGE_LIST视图中查询数据，但AGE_LIST视图中没有出生日期字段。选项D是从STUDENT表或视图中查询数据，但是STUDENT表或视图不存在。故选项A是正确答案。

第4题：

Click the Exhibit button and examine the data from the ORDERS and CUSTOMERS tables.Evaluate the SQL statement:SELECT *FROM ordersWHERE cust_id = (SELECT cust_idFROM customersWHERE cust_name = ‘Smith‘);What is the result when the query is executed?（）

A.A

B.B

C.C

D.D

E.E


参考答案：A

第5题：

In which of the following situations should correlation names be used?()

A.A table referenced in the FROM clause has no indexed column.

B.The table referenced in the FROM clause has more than 200 columns.

C.Two or more tables in the FROM clause have identical column names.

D.The FROM clause contains two or more tables in the SELECT statement.


参考答案：C

第6题：

Exhibit:Examine the data in the EMPLOYEES table.Examine the subquery:SELECT last_nameFROM employeesWHERE salary IN (SELECT MAX(salary)FROM employeesGROUP BY department_id);Which statement is true?()

A. The SELECT statement is syntactically accurate.

B. The SELECT statement does not work because there is no HAVING clause.

C. The SELECT statement does not work because the column specified in the GROUP BY clause is not in the SELECT list.

D. The SELECT statement does not work because the GROUP BY clause should be in the main query and not in the subquery.


参考答案：A

第7题：

An outside vendor is eligible for the guest role and the contractor role when accessing your network, that is secured with the Junos Pulse Access Control Service.What is the default role-mapping behavior?（）

A. The vendor must select a role from a list of eligible roles.

B. The vendor must select a rule from a list of eligible rules.

C. The vendor is automatically mapped to the first configured role

D. The vendor is automatically granted a merged role.


参考答案：D

第8题：

Which two of the addresses below are available for host addresses on the Ezonexam subnet 192.168.15.19/28? (Select two answer choices)

A. 192.168.15.17

B. 192.168.15.14

C. 192.168.15.29

D. 192.168.15.16

E. 192.168.15.31

F. None of the above


正确答案：AC
A,C 解析：Explanation:
The network uses a 28bit subnet (255.255.255.240). This means that 4 bits are used for the networks and 4 bits for the hosts. This allows for 14 networks and 14 hosts (2n-2). The last bit used to make 240 is the 4th bit (16) therefore the first network will be 192.168.15.16.

The network will have 16 addresses (but remember that the first address is the network address and the last address is the broadcast address). In other words, the networks will be in increments of 16 beginning at 192.168.15.16/28. The IP address we are given is 192.168.15.19. Therefore the other host addresses must also be on this network. Valid IP addresses for hosts on this network are: 192.168.15.17-192.168.15.30.

Incorrect Answers:
B. This is not a valid address for this particular 28 bit subnet mask. The first network address should be 192.168.15.16.

D. This is the network address.

E. This is the broadcast address for this particular subnet.

第9题：

查询所有目前年龄是22岁的学生信息：学号，姓名和年龄，正确的命令组是

A．CREATE VIEW AGE_LIST AS； SELECT学号，姓名，YEAR(DATE())-YEAR(出生日期)年龄FROM学生； SELECT学号，姓名，年龄FROM AGE_LIST WHERE年龄=22

B．CREATE VIEW AGE_LIST AS； SELECT学号，姓名，YEAR(出生日期)FROM学生： SELECT学号，姓名，年龄FROM AGE_LIST WHERE YEAR(出生日期)=22

C．CREATE VIEW AGE_LIST AS； SELECT学号，姓名，YEAR(DATE())-YEAR(出生日期)年龄FROM学生； SELECT学号，姓名，年龄FROM学生WHERE YEAR(出生日期)=22

D．CREATE VIEW AGE_LIST AS STUDENT； SELECT学号，姓名，YEAR(DATE())．YEAR(出生日期)年龄FROM学生； SELECT学号，姓名，年龄FROM STUDENT WHERE年龄=22


正确答案：A
解析：本题考查SOL中复杂查询语句的书写，四个选项中只有选项A是正确的。选项B和选项C是从建立的AGE_LIST视图中查询数据，但AGE_LIST视图中没有出生日期字段。选项D是从STUDENT表或视图中查询数据，但是 STUDENT表或视图不存在。故选项A是正确答案。

第10题：

Simon de Montfort summoned in（）the Great Council to meet at Westminster,together with two knights from each county and two citizens from each town.

A1242

B1258

C1265

D1266


C
略

更多相关问题
相关内容