-
如果对关系emp(eno,ename,salary)成功执行下面的SQL语句: CREATE CLUSTER INDEX name_index ON emp(salary) 对此结果的正确描述是()。
A . 在emp表上按salary升序创建了一个唯一索引
B . 在emp表上按salary降序创建了一个唯一索引
C . 在emp表上按salary升序创建了一个聚簇索引
D . 在emp表上按salary降序创建了一个聚簇索引
-
You need to create a view EMP_VU. The view should allow the users to manipulate the records of only the employees that are working for departments 10 or 20. Which SQL statement would you use to create the view EMP_VU? ()
A . CREATE VIEW emp_vu AS SELECT * FROM employees WHERE department _ id IN (10,20);
B . CREATE VIEW emp_vu AS SELECT * FROM employees WHERE department_id IN (10,20) WITH READ ONLY;
C . CREATE VIEW emp_vu AS SELECT * FROM employees WHERE department_id IN (10,20) WITH CHECK OPTION;
D . CREATE FORCE VIEW emp_vu AS SELECT * FROM employees WITH department_id IN (10,20);
E . CREATE FORCE VIEW emp_vu AS SELECT * FROM employees WHERE department_id IN (10,20) NO UPDATE
-
设在SC(Sno,Cno,Grade)表上定义了触发器: CREATE TRIGGER tri1 ON SC AFTER INSERT … 当执行语句:INSERT INTO SC VALUES(’s001’, ’c01’,90) 会引发该触发器执行。下列关于触发器执行时表中数据的说法,正确的是()。
A . SC表和INSERTED表中均包含新插入的数据
B . SC表和INSERTED表中均不包含新插入的数据
C . SC表中包含新插入的数据,INSERTED表中不包含新插入的数据
D . SC表中不包含新插入的数据,INSERTED表中包含新插入的数据
-
SELECT语句执行的结果是()
A、数据项
B、元组
C、表
D、数据库
-
You need to create a view EMP_VU. The view should allow the users to manipulate the records of only the employees that are working for departments 10 or 20. Which SQL statement would you use to create the view EMP_VU?()
A . CREATE VIEW emp_vu AS SELECT * FROM employees WHERE department_id IN (10,20);
B . CREATE VIEW emp_vu AS SELECT * FROM employees WHERE department_id IN (10,20) WITH READ ONLY;
C . CREATE VIEW emp_vu AS SELECT * FROM employees WHERE department_id IN (10,20) WITH CHECK OPTION;
D . CREATE FORCE VIEW emp_vu AS SELECT * FROM employees WHERE department_id IN (10,20);
E . CREATE FORCE VIEW emp_vu AS SELECT * FROM employees WHERE department_id IN (10,20) NO UPDATE
-
使用(),可以将某个SQL语句的执行依赖于另一个查询语句的执行结果。
A . 内连接查询
B . 子查询
C . 外连接查询
D . 合并查询
-
一条没有指明去向的SQL-SELECT语句执行之后,会把查询结果显示在屏幕上,要退出这个查询窗口,应该按()键。
A . Alt
B . Delete
C . Esc
D . Retur
-
Do循环语句的2种结构只是语句结构上不同,执行过程完全相同
A . 正确
B . 错误
-
设有Teachers表,该表的定义如下: CREATE TABLE Teachers( Tno CHAR(8) PRIMARY KEY, Tname VARCHAR(10) NOT NULL, Age TINYINT CHECK(Age BETWEEN 25 AND 65) ) 下列插入语句中,不能正确执行的是()。
A . INSERT INTO Teachers VALUES(’T100’,’张宏’,NULL)
B . INSERT INTO Teachers(Tno,Tname,Age) VALUES(’T100’,’张宏’,30)
C . INSERT INTO Teachers(Tno,Tname) VALUES(’T100’,’张宏’)
D . INSERT INTO Teachers VALUES(’T100’,’张宏’)
-
You are granted the CREATE VIEW privilege. What does this allow you to do? ()
A . Create a table view.
B . Create a view in any schema.
C . Create a view in your schema.
D . Create a sequence view in any schema.
E . Create a view that is accessible by everyone.
F . Create a view only of it is based on tables that you created.
-
管理员在执行create database benet usebenet create table benet01(column1int,column2int)语句时,发生了错误,如何修改()
A . 分别执行每一句
B . 将各个语句使用go分开再执行
C . 不能将表格命名为benet01
D . 不能将数据库命名为benet
-
SELECT语句执行的结果是( )。
-
SQL中创建视图应使用CREATE VIEW语句。
-
对由SELECT--FROM—WHERE—GROUP--ORDER组成的SQL语句,其在被DBMS处理时,各子句的执行次序为( )。
-
( )CREATE
VIEW 只是把视图的定义存入数据字典,并不执行其中的SELECT语句。
-
如果要创建视图,使用的命令是create view
-
下列语句执行后的结果是()
A.19
B.7
C.15
D.12
-
CREATE VIEW语句用于在SQL中建立视图。如果要求对视图更新时,必须满足子查询中的条件表达式,应当在该语句中使用短语()。
A.WITH UPDATE
B.WITH INSERT
C.WITH DELETE
D.WITH CHECK OPTION
-
View the Exhibit and examine the steps that you executed to create a database resource plan.Subsequently, you execute the following procedure which results in an error:SQL> EXECUTE dbms_resources_manager.validate_pending_area ();What could be the reason?()
<img src='https://img2.soutiyun.com/shangxueba/ask/17133001-17136000/17135247/2c9611256b04bdd5ba39c52e4e7dd450.png' />
A. The pending area is automatically submitted after the plan creation
B. The procedure must be executed before creating the resources plan directive
C. The SYS_GROUP resource consumer group is not included in the resource plan directive
D. The OTHER_GROUPS resources consumer group is not included in the resource plan directive
-
下列语句执行的结果是?'hello' - 'world'
A.helloworld
B.hello world
C.52473
D.程序出错
-
【判断题】补间动画只是改变了View对象绘制的位置,而没有改变View对象本身。
A.Y.是
B.N.否
-
对于下面一段程序,当语句4执行出错后,应该执行哪条语句______。 exec sql whenever sqlerror continue; //语句1 exec sql whenever sqlerror goto s2; //语句2 exec sql whenever sqlerror goto handle_error; //语句3 … … Exec sql create table custs //语句4 (cids char(4) not null, cname varchar(13), … …); if (strcmp(SQLSTATE, “82100”) == 0) //语句5 <处理82100错误的程序> … s2:… … //语句6 … handle_error:… … //语句7 …
A.执行语句2
B.执行语句3
C.执行语句5
D.执行语句6
-
语句selectday('2004-4-6')的执行结果是:()
-
13、如果学生表st是使用以下SQL语句创建的:CREATE TABLE st (sno CHAR(4) not null,sn CHAR(8),sex CHAR(2),age INT);下面的SQL语句中可以正确执行的是()
A.INSERT INTO st(sno,sex,age) VALUES (″s9″,″男″,17)
B.INSERT INTO st(sn,sex,age) VALUES(″李安齐″,″男″,20)
C.INSERT INTO st(sex,age)VALUES(″男″,20)
D.INSERT INTO st(sno,sn)VALUES(″s9″,″安齐″,16)