问题

You need to display the last names of

You need to display the last names of those employees who have the letter "A" as the second character in their names. Which SQL statement displays the required results? （）

A SELECT last_name FROM EMP WHERE last_ name LIKE '_A%';
B SELECT last_name FROM EMP WHERE last name ='*A%'
C SELECT last_name FROM EMP WHERE last name ='_A%';
D SELECT last_name FROM EMP WHERE last name LIKE '*A%'

参考答案

参考解析：

分类：1Z0-007题库

You need to calculate the total of all salaries in the accounting department. Which group function should you use? （）A MAXB MINC SUMD COUNTE TOTALF LARGEST

2、You want to display the titles of boo

You want to display the titles of books that meet these criteria:1. Purchased before January 21, 20012. Price is less then $500 or greater th...

3、You would like to display the system d

You would like to display the system date in the format "Monday, 01 June, 2001".Which SELECT statement should you use?（）A SELECT TO_DATE(SYSDA...

4、You need to create a table named ORDE

You need to create a table named ORDERS that contain four columns:1. an ORDER_ID column of number data type2. aCUSTOMER_ID column of number da...

5、You need to change the definition of a

You need to change the definition of an existing table. The COMMERCIALS table needs its DESCRIPTION column changed to hold varying length chara...

6、You need to change the definition of a

You need to change the definition of an existing table. The COMMERCIALS table needs its DESCRIPTION column changed to hold varying length chara...

编辑推荐

大汶口位于下面哪一省（）。..

患者男性，33岁。高血压病史10年，伴有体位性低血压。近来常.....

关于供热管网清（吹）洗规定的说法，正确的有（）。..

栀子具有的功效是（）..

驾驶出租汽车在高速公路遇施工路段时，驾驶员应该（）。..

会计电算化方式下，试算平衡可以依靠电脑完成，但是登记账簿.....