网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
单选题
当需要返回当前用户的名字，可以执行如下（）SQL语句。
A
SELECT user FROM V$DBA
B
SELECT user FROM dual
C
SELECT name FROM dual
D
SELECT name FROM V$DBA
参考答案
参考解析
解析：
暂无解析
更多 “单选题当需要返回当前用户的名字，可以执行如下（）SQL语句。A SELECT user FROM V$DBAB SELECT user FROM dualC SELECT name FROM dualD SELECT name FROM V$DBA” 相关考题
考题
下列哪个语句查出雇员表(employees)里的雇员名字(ename)是‘SMITH’的信息,并且给雇员名字(ename)列定义一个别名Name()。
A.select employeesno，ename Name，job from employees where ename=‘SMITH’B.select employeesno，ename ‘Name’，job from employees where ename=SMITHC.select employeesno，ename “Name”，job from employees where ename=‘SMITH’D.select employeesno，ename ‘Name’，job frome mployees wheree name=‘SMITH’
考题
关于group by 以下语句正确的是( )A.SELECT store_name FROM Store_Information GROUP BY store_nameB. SELECT SUM(sales) FROM Store_Information GROUP BY salesC.SELECT store_name, price SUM(sales) FROM Store_Information GROUP BY store_name，priceD.SELECT store_name, SUM(sales) FROM Store_Information GROUP BY store_name
考题
有SQL语句：SELECT * FROM 教师 WHERE NOT(工资3000 OR 工资2000)与如下语句等价的SQL语句是A）SELECT*FROM 教师 WHERE 工资 BETWEEN 2000 AND 3000B) SELECT*FROM 教师 WHERE 工资2000 AND 工资3000C）SELECT*FROM 教师 WHERE 工资2000 OR 工资3000D) SELECT*FROM 教师 WHERE 工资=2000 AND 工资3000
考题
当需要查询日志文件所有组及其成员的名称和文件位置,可以使用()方式。
A.SELECT * FROM V$LOGFILEB.SELECT * FROM V$LOGC.SELECT * FROM V$LOGHISTORYD.SELECT * FROM V$DBA
考题
当需要查询Oracle的控制文件的名称、位置和状态时,可以使用()语句。
A.SELECT name FROM V$CONTROLFILEB.SELECT name FROM V$CTRLLFILEC.SELECT name FROM V$USERFILESD.SELECT name FROM V$DBAFILE
考题
下列哪个语句查出雇员表（employees）里的雇员名字（ename）是‘SMITH’的信息，并且给雇员名字（ename）列定义一个别名Name（）。A、select employeesno，ename Name，job from employees where ename=‘SMITH’B、select employeesno，ename ‘Name’，job from employees where ename=SMITHC、select employeesno，ename “Name”，job from employees where ename=‘SMITH’D、select employeesno，ename ‘Name’，job frome mployees wheree name=‘SMITH’
考题
在Oracle中，有一个名为seq的序列对象，以下语句能返回序列值但不会引起序列值增加的是（）A、select seq.ROWNUM from dualB、select seq.ROWID from dualC、select seq.CURRVAL from dualD、select seq.NEXTVAL from dual
考题
数据库中有一张表名称为Student，有列Name，Age，IDCard，Sex。要求写SQL语句查询出表中所有的数据，下列哪个SQL语句是正确的（）A、Select* From StudentB、Select Name From StudentC、Select Name，Age，IDCard From StudentD、Select Name，Age，IDCard，Sex From Student
考题
Mysql能成功查询User表中第20行到第30行记录的是？（）A、SELECT * FROM USER WHERE ROWNUM20 AND ROWNUM30 B、SELECT * FROM USER WHERE ROWID 20 AND ROWNUM30 C、SELECT * FROM USER LIMIT 20，30； D、SELECT * FROM USER LIMIT 20，10；
考题
以下（）语句从表TABLE_NAME中提取前10条记录。A、select * from TABLE_NAME where rowcount=10B、select TOP 10 * from TABLE_NAMEC、select TOP of 10 * from TABLE_NAMED、select * from TABLE_NAME where rowcount=10
考题
变量v_time=’23-MAY-00’， 如下那条语句返回值为’01-JAN-00’？（）A、select round（v_time，’DAY’） from dualB、select round（v_time，’YEAR’） from dualC、select round（v_time，’MONTH’） from dualD、A select round（to_char（v_time，’yyyy’）） from dual
考题
V5.x系统中，用SQL语句查询Sybase版本的语句是（）A、select ##versionB、select ##version from masterC、select @@version from masterD、select @@version
考题
有如下SQL语句：下列哪条命令与该SQL语句等价（） SELECT姓名FROM学生表WHERE学号IN； （SELECT学号FROM成绩表WHERE成绩＞90）A、SELECT姓名FROM学生表WHEREEXISTS；（SELECT学号FROM成绩表WHERE成绩＞90）B、SELECT姓名FROM学生表WHEREEXISTS；（SELECT学号FROM成绩表WHERE学号=学生表．学号AND成绩＞90）C、SELECT姓名FROM学生表WHERE学号EXISTS；（SELECT学号FROM成绩表WHERE学号=学生表．学号AND成绩＞90）D、SELECT姓名FROM学生表WHERE学号=；（SELECT学号FROM成绩表WHERE成绩＞90）
考题
现有表Employee，字段：id（int）、firstname（varchar）、lastname（varchar）；以下sql语句错误的是（）A、select firstname+’.’+lastnameas’name’from employeeB、select firstname+’.’+lastname=’name’from employeeC、select’name’=firstname+’.’+lastnamefrom employeeD、select firstname，lastname from employee
考题
在Transact-SQL语法中，以下SELECT语句正确的是（）。A、SELECT * FROM studentB、SELECT * FROM student WHERE GETDATE（）C、SELECT * FROM student ORDER st_idD、SELECT * FROM student BY St_name
考题
当需要查询Oracle的控制文件的名称、位置和状态时，可以使用（）语句。A、SELECT name FROM V$CONTROLFILEB、SELECT name FROM V$CTRLLFILEC、SELECT name FROM V$USERFILESD、SELECT name FROM V$DBAFILE
考题
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%'
考题
SGA是一块巨大的共享内存区域，被看成是Oracle数据库的一个大缓冲池，如果需要查看SGA的大小信息，可以使用如下（）语句。A、SELECT SGA FROM V$DBAB、SELECT * FROM V$DBAC、SELECT * FROM V$SGAD、SELECT size FROM V%DBA
考题
当需要查询日志文件所有组及其成员的名称和文件位置，可以使用（）方式。A、SELECT * FROM V$LOGFILEB、SELECT * FROM V$LOGC、SELECT * FROM V$LOGHISTORYD、SELECT * FROM V$DBA
考题
Which SQL statement accepts user input for the columns to be displayed, the table name, and WHERE condition? （）A、SELECT 1, "2" FROM 3 WHERE last_name = '8';B、SELECT 1, '2' FROM 3 WHERE ' last_name = '8';C、SELECT 1, 2 FROM 3 WHERE last_name = '8';D、SELECT 1, '2' FROM EMP WHERE last_name = '8';
考题
A database user SMITH tries to query the V$SESSION view and fails to access it as follows： SQL connect smith/smith Connected. SQL SELECT * FROM v$session； SELECT * FROM v$session * ERROR at line 1： ORA-00942： table or view does not exist Which are the two possible solutions to enable SMITH to query the data in V$SESSION（）A、granting SELECT privilege to SMITH on V$SESSIONB、granting SELECT privilege to SMITH on V_$SESSIONC、asking the user SMITH to run the catalog.sql scriptD、granting SELECT privilege to SMITH on V$FIXED_TABLESE、setting the O7_DICTIONARY_ACCESSIBILITY parameter to TRUEF、creating a view based on V$SESSION and granting SELECT privilege to SMITH on the view that was created
考题
当需要返回当前用户的名字，可以执行如下（）SQL语句。A、SELECT user FROM V$DBAB、SELECT user FROM dualC、SELECT name FROM dualD、SELECT name FROM V$DBA
考题
假设需要查询Oracle数据文件的文件名和存储位置，可以使用如下（）方式。A、SELECT name，status FROM V$datafileB、SELECT name，statusFROM V$userfileC、SELECT name，status FROM V$DBAD、SELECT name，status FROM V$ctrlfile
考题
下列哪些SQL语句可以查询出User表中name为张三的记录（）。A、SELECT * FROM User WHERE name = ’张三’B、SELECT * FROM User WHERE name = ’张三’ LIMIT 0，1C、SELECT * FROM User WHERE name LIKE ’张三’D、SELECT * FROM User WHERE name LIKE ’%张三%’
考题
单选题You need to produce a report for mailing labels for all customers. The mailing label must have only the customer name and address. The CUSTOMERS table has these columns: Which SELECT statement accomplishes this task?（）A
SELECT* FROM customers;B
SELECT name, address FROM customers;C
SELECT id, name, address, phone FROM customers;D
SELECT cust_name, cust_address FROM customers;E
SELECT cust_id, cust_name, cust_address, cust_phone FROM customers;
热门标签
最新试卷