多选题考虑下列声明,那些是不合法的:()ADECLAREv_name,v_deptVARCHAR2(14);BDECLAREv_testNUMBER(5);CDECLAREV_MAXSALARYNUMBER(7,2)=5000;DDECLAREV_JOINDATEBOOLEAN:=SYSDATE;
多选题
考虑下列声明,那些是不合法的:()
A
DECLAREv_name,v_deptVARCHAR2(14);
B
DECLAREv_testNUMBER(5);
C
DECLAREV_MAXSALARYNUMBER(7,2)=5000;
D
DECLAREV_JOINDATEBOOLEAN:=SYSDATE;
参考解析
解析:
暂无解析
相关考题:
下列符号常量的声明中,不合法的是A.Const a As Single=1.1B.Const a=”0K”C.Const a As Double=Sin(1)D.Const a As Integer=“12”
下列符号常量的声明中,( )是不合法的。A.Consta As Single=1.1B.Consta As Integer="12"C.Consta As Double=Sin(1)D.Consta="OK"
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;
为“仓库”表增加一个“面积”字段,类型为数值型,宽度是7,小数位数为2,正确的命令是( )。A.CREATE TABLE 仓库 ADD 面积 N(7,2)B.CREATE TABLE 仓库 ALTER 面积 N(7,2)C.ALTER TABLE 仓库 ADD 面积 N(7,2)D.ALTER TABLE 仓库 ALTER 面积 N(7,2)
下列符号常量的声明中,______ 是不合法的。A.Const a As Single =1.1B.Const d As Integer =“12”C.Const b As Double = Sin(1)D.Const c As String = “OK”
显示本月月末的日期() A.select last_date(sysdate) from dual;B.select finally_day(sysdate) from dual;C.select last_day(sysdate) from dual;D.select tail_day(sysdate) from dual;
考虑下列声明,那些是不合法的:() A.DECLAREv_name,v_deptVARCHAR2(14);B.DECLAREv_testNUMBER(5);C.DECLAREV_MAXSALARYNUMBER(7,2)=5000;D.DECLAREV_JOINDATEBOOLEAN:=SYSDATE;
下列符号常量的声明中,()是不合法的。A、Const a As Single = 1.1B、Const a As Integer = “12”C、Const a As Double = Sin(1)D、Const a =”OK”
下列关于变量的说法不正确的是()。A、局部变量在声明它的过程执行完毕后就被释放了B、局部变量的作用域仅限于声明它的过程C、静态局部变量是在过程中用Static语句声明的D、局部变量是指那些在过程中用Dim语句或Static语句声明的变量
下列命令用于显示1988年及其以前出生的职工记录,其中正确的是()。A、LISTFORYEAR(出生日期)="1988"B、LISTFORSUBSTR(DTOC(出生日期),7,2)="88"C、LISTFORLEFT(DTOC(出生日期),7,2)="88"D、LISTFORRIGHT(DTOC(出生日期),7,2)="88"
显示本月月末的日期()A、select last_date(sysdate) from dual;B、select finally_day(sysdate) from dual;C、select last_day(sysdate) from dual;D、select tail_day(sysdate) from dual;
Which SELECT statement should you use to extract the year from the system date and display it in the format "1998"?()A、SELECT TO_CHAR(SYSDATE,'yyyy') FROM dual;B、SELECT TO_DATE(SYSDATE,'yyyy') FROM dual;C、SELECT DECODE(SUBSTR(SYSDATE, 8), 'YYYY') FROM dual;D、SELECT DECODE(SUBSTR(SYSDATE, 8), 'year') FROM dual;E、SELECT TO_CHAR(SUBSTR(SYSDATE, 8,2),'yyyy') FROM dual;
如何显示今天是星期几(周一到周日,分别用1~7表示)()A、select to_char(sysdate,'D') from dual;B、select to_char(sysdate,'W') from dual;C、select to_char(sysdate,'D')-1 from dual;D、select to_char(sysdate-1,'D') from dual;E、select to_char(sysdate-1,'W') from dual;
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(SYSDATE, 'FMDAY, DD Month, YYYY') FROM dual;B、SELECT TO_CHAR(SYSDATE, 'FMDD, DY Month, 'YYYY') FROM dual;C、SELECT TO_CHAR(SYSDATE, 'FMDay, DD Month, YYYY') FROM dual;D、SELECT TO_CHAR(SYSDATE, 'FMDY, DDD Month, YYYY') FROM dual;E、SELECT TO_DATE(SYSDATE, 'FMDY, DDD Month, YYYY') FROM dual;
The EMP table has these columns: ENAME VARCHAR2(35) SALARY NUMBER(8,2) HIRE_DATE DATE Management 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;
单选题下列符号常量的声明中,()是不合法的。AConst a As Single = 1.1BConst a As Integer = “12”CConst a As Double = Sin(1)DConst a =”OK”
单选题下列命令用于显示1988年及其以前出生的职工记录,其中正确的是()。ALISTFORYEAR(出生日期)=1988BLISTFORSUBSTR(DTOC(出生日期),7,2)=88CLISTFORLEFT(DTOC(出生日期),7,2)=88DLISTFORRIGHT(DTOC(出生日期),7,2)=88
单选题李某由于小说连载,下列应缴纳的个人所得税的列式中,正确的是( )。A5000×(1-20%)×20%+(3000-800)×3×14%B5000×20%+(3000-800)×3×14%C(5000+3000×3)×14%D(5000+3000×3)×(1-20%)×14%
多选题下列有关数组的声明中,正确的是哪项?()Aint s[10];Bint[10] s;Cint[5] s={l,2,3,4,5};Dint s[];