网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
表 g 和x或c,连接关键字是 :
g_q(date), g_z(date), g_c(char) ,g_k(char)
c_q(date), c_z(date), c_c(char) ,c_k(char)
条件是 日期g_q为2004年1月1日
筛选内容
g_q ,g_z ,g_c ,g_k ,c_k
参考答案
更多 “ 表 g 和x或c,连接关键字是 :g_q(date), g_z(date), g_c(char) ,g_k(char)c_q(date), c_z(date), c_c(char) ,c_k(char)条件是 日期g_q为2004年1月1日筛选内容g_q ,g_z ,g_c ,g_k ,c_k ” 相关考题
考题
用以下SQL语句创建了表名为学生的关系表。create table 学生(学号 char(9) primary key,身份证号 char(18),姓名 varchar(8),性别 char(2),所属学院 varchar(20),专业 varchar (20),届次 char(4),出生日期 date,宿舍 int,简历 image);请写出查询全体学生的姓名及其年龄的SQL语句。
考题
在Oracle中,语句()将ORDER_DATE日期值’2000年3月18日’显示为‘2000年1月1日’。
A.SELECTROUND(order_date,’day’)FROMinventoryB.SELECTROUND(order_date,’YEAR’)FROMinventoryC.SELECTROUND(order_date,’month’)FROMinventoryD.SELECTROUND(to_char(order_date,’yyyy’))FROMinventory
考题
设有以下说明和定义：typedef union {long i; int k[5]; char c;} DATE;struct data { int cat; DATE cow; double dog;} too;DATE max;则语句 printf("%d",sizeof(struct date)+sizeof(max));的执行结果是：___52____
考题
设有以下说明和定义:includeVoid main() {typedef union{long i; int k[5]; char
设有以下说明和定义：#include＜iostream. h＞Void main() {typedef union{long i; int k[5]; char c;}DATE;struct date{iNt cat; DATE cow; double. dog;}too;DATE max;则下列语句的执行结果是( )。cout＜＜(sizeof(struct date)+sizeof(max))＜＜end1;}A．26B．52C．18D．8
考题
设有以下说明和定义:includeVoid main() {typedef union{long i; int k[5]; char
设有以下说明和定义： #include＜iostream. h＞ Void main() { typedef union { long i; int k[5]; char c; } DATE; struct date {int cat; DATE cow; double dog; }too; DATE max; cout＜＜(sizeof(struct date)+sizeof(max))＜＜end1;}A．26B．52C．18D．8
考题
设有以下说明和定义：typedef union{ long i；int k[5]；char c； } DATE；struct date{ int cat；DATE cow；double dog； }too；DATE max；则下列语句的执行结果是______。printf("%d"，sizeof (struct date) +sizeof(max));A．26B．30C．18D．8
考题
设有以下定义： typedef union {long i；int k[5]；char c，}DATE, struct date {int cat；DATE cow；double dog;}too； DATE max； 则下列语句的执行结果是( ) printf("%d"，stzeof(struct date)+sizeof(max))；A．25B．30C．18D．8
考题
建立一个用品信息表goods_inf，要求它由用品号gno，用品名gname，用品数量gnum，用品入库时间gtime，4个属性组成，其用品号属性惟一，用品名、用品号字段不能为空。下列语句正确的是A．CREATE TABLE goods inf (gno char(5) NOT NULL gaame char(8) NOTNULL gnum int gtime DATE)：B．CREATE TABLE goods inf (gno char(5) NOT NULL UNIQUE gaame char(8) gnum int gtime DATE)：C．CREATE TABLE (gno char(5) NOT NULL UNIQUE gname char(8) NOT NULL gnum int gtime DATE)；D．CREATE TABLE goods inf (gno char(5) NOT NULL UNIQUE gname char(8) NOT NULL gnum int gtime DAT
考题
设有以下定义： typedef union { longi; int k[5]；char c；}DATE； srtuct date { int cat；DATEcow；double dog；} too； DATE max； 则下语句的执行结果是 ( ) printf("%d，"sizeof(struct date))+size of(max))；A．25B．30C．18D．8
考题
某C语言结构体的定义如下。 struct date { int year, month, day; }; struct worklist { char name[20]; char sex; struct date birthday; }person; 若对变量person的出生年份进行赋值，正确的赋值语句是(33)。A．year=1976B．birthday. year=1976C．person. year=1976D．person. birthday. year=1976
考题
查询出EMP表中1982年及以后入职的员工信息（）（注：字段hiredate为入职日期，数据类型为DATE型）A、select * from emp where hiredate='19820101';B、select * from emp where hiredate=to_char('19820101','YYYYMMDD');C、select * from emp where to_date(hiredate,'YYYYMMDD')='19820101';D、select * from emp where to_char(hiredate,'YYYYMMDD')='19820101';
考题
要在Oracle中使用日期信息的格式掩码。下列（）情形不适合这个格式掩码。A、to_date（）B、to_char（）C、altersessionsetnls_date_formatD、to_number（）
考题
下列关于ORACLE的to_date函数和to_char函数，描述正确的是（）。A、to_char函数是将字符串数据转换为日期数据B、to_date函数是将字符串数据转换为日期数据C、to_char函数是将日期数据转换为字符数据D、to_date函数是将日期数据转换为字符数
考题
Which SQL statement displays the date March 19, 2001 in a format that appears as "Nineteenth of March 2001 12:00:00 AM"?（）A、SELECT TO_CHAR(TO_DATE('19-Mar-2001', 'DD-Mon-YYYY'), 'fmDdspth "of" Month YYYY fmHH:MI:SS AM') NEW_DATE FROM dual;B、SELECT TO_CHAR(TO_DATE('19-Mar-2001', 'DD-Mon-YYYY'), 'Ddspth "of" Month YYYY fmHH:MI:SS AM') NEW_DATE HH:MI:SS AM') NEW _ DATE FROM dual;C、SELECT TO_CHAR(TO_DATE('19-Mar-2001', 'DD-Mon-YYYY'), 'fmDdspth "of" Month YYYY NEW _ DATE FROM dual;D、SELECT TO_CHAR(TO_DATE('19-Mar-2001', 'DD-Mon-YYYY), 'fmDdspth "of" Month YYYYfmtHH:HI:SS AM')NEW_DATE 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;
考题
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;
考题
Which SQL statement displays the date March 19, 2001 in a format that appears as "Nineteenth of March 2001 12:00:00 AM"?（）A、SELECT TO_CHAR(TO_DATE('19-Mar-2001', 'DD-Mon-YYYY'), 'fmDdspth "of" Month YYYY fmHH:MI:SS AM') NEW_DATE FROM dual;B、SELECT TO_CHAR(TO_DATE('19-Mar-2001', 'DD-Mon-YYYY'), 'Ddspth "of" Month YYYY fmHH:MI:SS AM') NEW_DATE FROM dual;C、SELECT TO_CHAR(TO_DATE('19-Mar-2001', 'DD-Mon-YYYY'), 'fmDdspth "of" Month YYYY HH:MI:SS AM') NEW_DATE FROM dual;D、SELECT TO_CHAR(TO_DATE('19-Mar-2001', 'DD-Mon-YYYY'), 'fmtDdspth "of" Month YYYY fmtHH:MI:SS AM') NEW_DATE FROM dual;
考题
多选题Which two tasks can you perform using only the TO_CHAR function? （）Aconvert 10 to 'TEN'Bconvert '10' to 10Cconvert 10 to '10'Dconvert 'TEN' to 10Econvert a date to a character expressionFconvert a character expression to a date
考题
多选题Which two tasks can your perform by using the TO_CHAR function? （）AConvert 10 to 'TEN'BConvert '10' to 10CConvert '10' to '10'DConvert 'TEN' to 10EConvert a date to a character expressionFConvert a character expression to a date
考题
单选题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, 'YYY') 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;
考题
单选题Which SQL statement displays the date March 19, 2001 in a format that appears as "Nineteenth of March 2001 12:00:00 AM"?（）A
SELECT TO_CHAR(TO_DATE('19-Mar-2001', 'DD-Mon-YYYY'), 'fmDdspth of Month YYYY fmHH:MI:SS AM') NEW_DATE FROM dual;B
SELECT TO_CHAR(TO_DATE('19-Mar-2001', 'DD-Mon-YYYY'), 'Ddspth of Month YYYY fmHH:MI:SS AM') NEW_DATE HH:MI:SS AM') NEW _ DATE FROM dual;C
SELECT TO_CHAR(TO_DATE('19-Mar-2001', 'DD-Mon-YYYY'), 'fmDdspth of Month YYYY NEW _ DATE FROM dual;D
SELECT TO_CHAR(TO_DATE('19-Mar-2001', 'DD-Mon-YYYY), 'fmDdspth of Month YYYYfmtHH:HI:SS AM')NEW_DATE FROM dual;
考题
单选题查询出EMP表中1982年及以后入职的员工信息（）（注：字段hiredate为入职日期，数据类型为DATE型）A
select * from emp where hiredate='19820101';B
select * from emp where hiredate=to_char('19820101','YYYYMMDD');C
select * from emp where to_date(hiredate,'YYYYMMDD')='19820101';D
select * from emp where to_char(hiredate,'YYYYMMDD')='19820101';
考题
单选题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;
考题
单选题Which SQL statement displays the date March 19, 2001 in a format that appears as "Nineteenth of March 2001 12:00:00 AM"?（）A
SELECT TO_CHAR(TO_DATE('19-Mar-2001', 'DD-Mon-YYYY'), 'fmDdspth of Month YYYY fmHH:MI:SS AM') NEW_DATE FROM dual;B
SELECT TO_CHAR(TO_DATE('19-Mar-2001', 'DD-Mon-YYYY'), 'Ddspth of Month YYYY fmHH:MI:SS AM') NEW_DATE FROM dual;C
SELECT TO_CHAR(TO_DATE('19-Mar-2001', 'DD-Mon-YYYY'), 'fmDdspth of Month YYYY HH:MI:SS AM') NEW_DATE FROM dual;D
SELECT TO_CHAR(TO_DATE('19-Mar-2001', 'DD-Mon-YYYY'), 'fmtDdspth of Month YYYY fmtHH:MI:SS AM') NEW_DATE FROM dual;
考题
多选题下列关于ORACLE的to_date函数和to_char函数，描述正确的是（）。Ato_char函数是将字符串数据转换为日期数据Bto_date函数是将字符串数据转换为日期数据Cto_char函数是将日期数据转换为字符数据Dto_date函数是将日期数据转换为字符数
热门标签
最新试卷