高考知识网 时间:2023-08-17 22:59:51
1)description of the students table:
sid_id number
start_date date
end_date date
which two function are valid on the start_date column?_________。
a. sum(start_date)
b. avg(start_date)
c. count(start_date)
d. avg(start_date,end_date)
e. min(start_date)
f. maximum(start_date)
2)which statement shows the maximum salary paid in each job category of each department?_______
a. select dept_id, job_cat,max(salary) from employees where salary > max(salary);
b. select dept_id, job_cat,max(salary) from employees group by dept_id,job_cat;
c. select dept_id, job_cat,max(salary) from employees;
d. select dept_id, job_cat,max(salary) from employees group by dept_id;
e. select dept_id, job_cat,max(salary) from employees group by dept_id,job_cat,salary;
3)for which two constraints does the oracle server implicitly create a unique index?______。
a. not null
b. primary
c. foreign key
d. check
e. unique
4)in a select statement that includes a where clause,where is the group by clause placed in the select statement?______。
a. immediately after the select clause
b. before the where clause
c. before the from clause
d. after the order by clause
e. after the where clause
5)in a select statement that includes a where clause,where is the order by clause placed in the select statement?______.
a.immediately after the select clause
b.before the where clause
c.after all clause
d.after the where clause
e.before the from clause
6)evaluate there two sql statements______.
select last_name,salary from employees order by salary;
select last_name,salary from employees order by 2 asc;
a.the same result b.different result c.the second statement returns a syntax error
7) you would like to display the system date in the format“20051110 14:44:17”。which select statement should you use?______。
a. select to_date(sydate,’yearmmdd hh:mm:ss’)from dual;
b. select to_char(sydate,’yearmonthday hh:mi:ss’)from dual;
c. select to_date(sydate,’yyyymmdd hh24:mi:ss’)from dual;
d. select to_char(sydate,’yyyymmdd hh24:mi:ss’)from dual;
e. select to_char(sydate,’yy-mm-dd hh24:mi:ss’)from dual;
8)which select statement will the result ‘ello world’from the string‘hello world’?______.
a. select substr(‘hello world’,1)from dual;
b. select substr(trim(‘hello world’,1,1))from dual;
c. select lower(substr(‘hello world’,1))from dual;
d. select lower(trim(‘h’from‘hello world’))from dual;
9)which are dml statements(choose all that apply)______.
a.commit b.merge c.update d.delete e.creat f.drop
10)select 语句中用来连接字符串的符号是___c___.
a. “+” b. “&” c.“||” d.“|”
问答题: 什么是聚集索引,什么是非聚集索引,什么又是主键?
中国点击率最高的一篇文章 !
2023-08-13 03:45:29山东大学在福建高考招生计划人数和专业代码(参考)
2024-06-08 08:59:56广州华南商贸职业学院在福建高考招生计划人数和专业代码(参考)
2024-06-08 08:56:34陕西高考610至620分左右理科可以上什么大学
2024-06-08 08:53:10湖南上东北师范大学多少分 分数线及排名
2024-06-08 08:49:38天津艺术职业学院对比安徽国防科技职业学院哪个好 附分数线排名
2024-06-08 08:46:04保定学院网络与新媒体专业怎么样?录取分数线多少分
2024-06-08 08:42:14河北新闻网两学一做知识竞赛(试题+答案完整版)
2023-08-13 23:55:25河北新闻网两学一做知识竞赛活动试题答案
2023-08-14 04:06:25两学一做学习教育知识竞赛活动10篇
2023-08-21 12:22:13金山软件C++笔试目
2023-08-20 16:22:502018搜狗校招技术类笔试题和面试题答案
2023-08-13 01:08:06奇虎360软件测试工程师笔试题和面试题答案
2023-08-17 09:55:54