SELECT name,status FROM V$datafile
SELECT name,status FROM V$userfile
SELECT name,status FROM V$DBA
SELECT name,status FROM V$ctrlfile
第1题:
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:CUST_ID NUMBER(4) NOT NULLCUST_NAME VARCHAR2(100) NOT NULLCUST_ADDRESS VARCHAR2(150)CUST_PHONE VARCHAR2(20)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;
第2题:
A.SELECT * FROM V$LOGFILE
B.SELECT * FROM V$LOG
C.SELECT * FROM V$LOGHISTORY
D.SELECT * FROM V$DBA
第3题:
关于group by 以下语句正确的是( )
A.SELECT store_name FROM Store_Information GROUP BY store_name
B. SELECT SUM(sales) FROM Store_Information GROUP BY sales
C.SELECT store_name, price SUM(sales) FROM Store_Information GROUP BY store_name,price
D.SELECT store_name, SUM(sales) FROM Store_Information GROUP BY store_name
第4题:
数据库中有一张表名称为Student,有列Name,Age,IDCard,Sex。要求写SQL语句查询出表中所有的数据,下列哪个SQL语句是正确的()
第5题:
要查询book表中所有书名以“电子商务”开头的书籍作者,可用(61)语句。
A.SELECT author FROM booK WHERE book _name=‘电子商务*’
B.SELECT author FROM booK WHERE book _name LIKE‘电子商务*’
C.SELECT author FROM booK WHERE book_ name=‘电子商务%’
D.SELECT author FROM booK WHERE book_name LIKE‘电子商务%’
第6题:
要从学生成绩表(stu_ grade)中查询出学号(stu_ no)等于109的学生姓名(name)和成绩(grade),(13)可以实现这一功能。
A.select *from stu_ grade
B.select* from stu_ grade where stu_ no='109'
C.select name, grade from stu_ grade
D.select name,grade from stu_ grade where stu_ no='109'
第7题:
A.SELECT name FROM V$CONTROLFILE
B.SELECT name FROM V$CTRLLFILE
C.SELECT name FROM V$USERFILES
D.SELECT name FROM V$DBAFILE
第8题:
哪些是正确的 like 运算表达式?
A.select * from net_46 where s_name like ’晓’
B.select * from net_46 where s_name like ’&晓&’
C.select * from net_46 where s_name like ’$晓$’
D.select * from net_46 where s_name like ’%晓%’
第9题:
下列哪个语句查出雇员表(employees)里的雇员名字(ename)是‘SMITH’的信息,并且给雇员名字(ename)列定义一个别名Name()。
第10题:
要查询st_info表中姓"王"且单名的学生情况,可用()命令。