取得当前用户的全部数据对象的语句可以是()
A: Select
* from tabs;
B: Select
* from tab;
C: Select
* from table;
D: Select
object_name from dba_objects where owner='SCOTT' and
object_type='TABLE';
A: Select
* from tabs;
B: Select
* from tab;
C: Select
* from table;
D: Select
object_name from dba_objects where owner='SCOTT' and
object_type='TABLE';
举一反三
- 将查询和修改Student表的权限授给用户U4的SQL语句是(<br/>)。 A: GRANT<br/>SELECT, UPDATE ON TABLE Student TO U4 B: REVOKE<br/>SELECT, UPDATE ON TABLE Student FROM U4 C: GRANT<br/>SELECT ON TABLE Student TO U4 D: REVOKE<br/>UPDATE ON TABLE Student FROM U4
- 查询姓王的学生信息,最准确的SQL语句是(<br/>)。 A: SELECT<br/>* FROM students WHERE s_name='王' B: SELECT<br/>* FROM students WHERE s_name='王%' C: SELECT<br/>* FROM students WHERE s_name LIKE '王' D: SELECT<br/>* FROM students WHERE s_name LIKE '王%'
- 查询被借阅过的图书,语句 SELECT name from book where( ) 的条件,下列哪[br][/br]一个不能实现. A: no =all (select bno from borrow) B: no =any (select bno from borrow) C: no in (select bno from borrow) D: exists (select * from borrow where bno=book.bno)
- 列出所有员工的姓名、部门名称和工资。正确的SQL语句有________。 A: SELECT a.ename <br> ,(SELECT b.dname FROM dept b) AS dname <br> ,sal <br>FROM emp a B: SELECT a.ename <br> ,(SELECT b.dname FROM dept b WHERE b.deptno=a.deptno) AS dname <br> ,sal <br>FROM emp a; C: SELECT a.ename,b.dname,sal <br>FROM emp a,dept D: SELECT a.ename,b.dname,sal <br>FROM emp a,dept b <br>WHERE a.deptno=b.deptno
- 下面哪条语句可以查询姓“张”并且年龄等于20岁的用户，请问用哪条语句？ A: Select * From table Where name like "%张%" And intAge=20 B: Select * From table Where name like "张%" And intAge=20 C: Select * From table Where name like "张%" And intAge="20" D: Select * From table Where name="张" And intAge=20