在Oracle中，有一个名为seq的序列对象，假定此时查看seq序列当前值显示为7，那么执行下面的sql insert into stu（id， name） values（seq.NEXTVAL，’tom’ ）；很不幸，这个insert没有执行成功，随后马上执行rollback，问：此时查看seq序列当前值显示为（）A、 6B、8C、7D、不能确定
在Oracle中，有一个名为seq的序列对象，假定此时查看seq序列当前值显示为7，那么执行下面的sql insert into stu（id， name） values（seq.NEXTVAL，’tom’ ）；很不幸，这个insert没有执行成功，随后马上执行rollback，问：此时查看seq序列当前值显示为（）
- A、 6
- B、8
- C、7
- D、不能确定
相关考题：
设有关系模式：student(sno, sname, age, dept)，现利用命令： CREATE VIEW stu AS SELECT *FROM student WHERE dept="cs"WITH CHECK OPTION 创建了一个视图。则以下SQl命令中能正确执行的是A．UPDATE stu SET dept="maths"B．UPDATE stu SET dept="maths"WHERE age＞=20C．INSERT INTO stu VALUES ("2004001", "John", 30, "cs")D．INSERT INTO stu VALUES ("2004001", "John", 50, "maths")
在Oracle中,用以下SQL命令创建了一个序列:CREATE SEQUENCEmy_seq START WITH 394 INCREMENT BY 12 NOMINVALUE NOMAXVALUE NOCYCLENOCACHE;用户执行包含my_seq.NEXTVAL的SQL语句三次,然后执行包含my_seq.CURRVAL的SQL语句四次,请问序列my_seq的当前值是() A.406B.418C.430D.442
有如下关系：课程表C，主键为c-id (char (4))。若用如下语句建立成绩表SC： CREATE TABLE SC(s-id char(6)NOT NULL，c-id char(4)NOT NULL，score Inteeer)， 其中s-id为主键，c-id为外键(是C表的主键)。当执行如下语句肘，( )语句不能执行。A．INSERT SC VALUES('990101'，'NULL'，75)B．INSERT SC VALUES('990203'，'C601'，80)C．INSERT SC VALUES(NULL，'C602'，93)D．INSERT SC VALUES('990202'，'C604'，NULL)
oracle关联查询题目1数据库中有3 个表 teacher 表，student 表，tea_stu 关系表。teacher 表 teaID name agestudent 表 stuID name ageteacher_student 表 teaID stuID要求用一条sql 查询出这样的结果1.显示的字段要有老师name, age 每个老师所带的学生人数2 只列出老师age 为40 以下学生age 为12 以上的记录预备知识：1.sql 语句是对每一条记录依次处理，条件为真则执行动作（select,insert,delete,update）2.只要是迪卡尔积，就会产生“垃圾”信息，所以，只要迪卡尔积了，我们首先就要想到清除“垃圾”信息实验准备：drop table if exists tea_stu;drop table if exists teacher;drop table if exists student;create table teacher(teaID int primary key,name varchar(50),age int);create table student(stuID int primary key,name varchar(50),age int);create table tea_stu(teaID int references teacher(teaID),stuID int references student(stuID));insert into teacher values(1,'zxx',45), (2,'lhm',25) , (3,'wzg',26) , (4,'tg',27);insert into student values(1,'wy',11), (2,'dh',25) , (3,'ysq',26) , (4,'mxc',27);insert into tea_stu values(1,1), (1,2), (1,3);insert into tea_stu values(2,2), (2,3), (2,4);insert into tea_stu values(3,3), (3,4), (3,1);insert into tea_stu values(4,4), (4,1), (4,2) , (4,3);结果：2_3,3_2,4_3
有如下关系：课程表C，主键为c-id(char(4))。c-id c-name若用如下语句建立成绩表SC： CREATE TABLE SC(s-id char(6)NOT NULL，c-id char(4)NOT NULL，score Integer)，其中s-id为主键，c-id为外键(是C表的主键)。当执行如下语句时，哪个语句不能执行? ( )。A．INSERT SC VALUES('990101'，'NULL'，75)B．INSERT SC VALUES('990203'，'C601'，80)C．INSERT SC VALUES(NULL，'C602'，93)D．INSERT SC VALUES('990202'，'C604'，NULL)
主机甲向主机乙发送一个TCP报文段，SYN字段为1，序列号字段的值为2000，若主机乙同意建立连接，则发送给主机甲的报文段可能为（ ），若主机乙不同意建立连接，则（ ）字段置1A. (SYN=1，ACK=1， seq=2001 ack=2001)B. (SYN=1 ，ACK=0，seq=2000 ack=2000)C (SYN=1，CK=0， seq=2001 ack=2001)C. (SYN=0，ACK=1， seq=2000 ack=2000)A. URG B. RST C. PSH D. FIN
设有关系模式：student(sno，sname，age，dept)，现利用命令： CREATE VIEW stu AS SELECT * FROM student WHERE dept="cs"WITH CHECK OPTION创建了一个视图。则以下SQL命令中能正确执行的是( )。A．UPDATE stu SET dept="maths"B．UPDATE stu SET dept="maths"WHERE age＞=20C．INSERT INTO stu VALUES("2004001"，"John"，30，"CS")D．INSERT INTO stu VALUES("200400l","John"，50，"maths")
当需要删除某个序列seq_customer_id,可以使用如下()方式。 A.DROP SEQ_CUSTOMER_IDB.DELETE SEQUENCE SEQ_CUSTOMER_IDC.DROP SEQUENCE SEQ_CUSTOMER_IDD.DELETE SEQ_CUSTOMER_ID
主机甲向主机乙发送一个TCP报文段，SYN字段为“1”，序列号字段的值为2000， 若主机乙同意建立连接，则发送给主机甲的报文段可能为。A.（SYN=1，ACK=1， seq=2001 ack=2001）B.（SYN=1 ，ACK=0，seq=2000 ack=2000）C.（SYN=1，ACK=0， seq=2001 ack=2001）D.（SYN=0，ACK=1， seq=2000 ack=2000）
涉及到的表结构如下：Teacher（TNO，Tname，Tsex，Tnation，Tjobtitle，TID），各字段的含义依次是教师编号，姓名，性别，民族，职称，身份证号；Courses（CNO，Cname），各字段含义为课程号，课程名；Allocate（ID，TNO，CNO，Ctime），各字段含义为教师编号，课程号，课时数。创建序列ex_seq，要求初始值为100，序列增量为5，最大值为1000，可以循环；修改该序列使其最大值为800。
INSERT INTO TEST VALUES（‘ID’，‘NAME’）； 语句在执行时将（）A、编译错：提示变量未定义B、运行错：提示不能识别符号C、将值ID和NAME插入到表中D、提示用户输入ID和NAME的值，再将输入值插入表中
如下所示，首先使用序列INVNOS插入一条记录，然后回滚这个插入操作SQLinsert into invoices values（inv_nos.nextbal，1，sysdate，150）；1 row created；SQLrollback；Rollback complete在这个事务之前，序列的值为10，序列给出的下一个值是（）。A、10B、11C、12D、取决于序列的创建方式
在Oracle中，有一个名为seq的序列对象，以下语句能返回序列值但不会引起序列值增加的是（）A、select seq.ROWNUM from dualB、select seq.ROWID from dualC、select seq.CURRVAL from dualD、select seq.NEXTVAL from dual
已知seq为长度大于10的列表，并且已导入random模块，那么[random.choice（seq）for i in range（10）]和random.sample（seq，10）等价。
Oracle中，有一个名为seq的序列对象，以下语句能返回序列值但不会引起序列值增加的是（）。A、selectseq.ROWNUM from dualB、selectseq.ROWID from dualC、selectseq.CURRVAL from dualD、selectseq.NEXTVAL from dual
Examine the structure of the EMPLOYEES table: EMPLOYEE_ID NUMBER Primary Key FIRST_NAME VARCHAR2(25) LAST_NAME VARCHAR2(25) Which three statements inserts a row into the table? （）A、INSERT INTO employees VALUES (NULL, 'JOHN','Smith');B、INSERT INTO employees( first_name, last_name) VALUES ('JOHN','Smith');C、INSERT INTO employees VALUES ('1000','JOHN','NULL');D、INSERT INTO employees(first_name,last_name, employee_id) VALUES ('1000, 'john','Smith');E、INSERT INTO employees (employee_id) VALUES (1000);F、INSERT INTO employees (employee_id, first_name, last_name) VALUES ( 1000, 'john',");
Which three statements inserts a row into the table?（）A、INSERT INTO employees VALUES ( NULL, ‘John’,‘Smith’);B、INSERT INTO employees( first_name, last_name) VALUES(‘John’,‘Smith’);C、INSERT INTO employees VALUES (‘1000’,‘John’,NULL);D、INSERT INTO employees(first_name,last_name, employee_id) VALUES ( 1000, ‘John’,‘Smith’);E、INSERT INTO employees (employee_id) VALUES (1000);F、INSERT INTO employees (employee_id, first_name, last_name) VALUES ( 1000, ‘John’,‘’);
Examine the structure of the EMPLOYEES table: EMPLOYEE_ID NUMBER NOT NULL, Primary Key EMP_NAME VARCHAR2(30) JOB_ID NUMBER/ SAL NUMBER MGR_ID NUMBER References EMPLOYEE_ID column DEPARTMENT_ID NUMBER Foreign key to DEPARTMENT_ID column of the DEPARTMENTS table You created a sequence called EMP_ID_SEQ in orderto populate sequential values for the EMPLOYEE_ID column of the EMPLOYEES table. Which two statements regarding the EMP_ID_SEQ sequence are true? （）A、You cannot use the EMP_ID_SEQ sequence to populate the JOB_ID column.B、The EMP_ID_SEQ sequence is invalidated when you modify the EMPLOYEE_ID column.C、The EMP_ID_SEQ sequence is not affected by modifications to the EMPLOYEES table.D、Any other column of NUMBER data type in your schema can use the EMP_ID_SEQ sequence.E、The EMP_ID_SEQ sequence is dropped automatically when you drop the EMPLOYEES table.F、The EMP_ID_SEQ sequence is dropped automatically when you drop the EMPLOYEE_ID column.
Examine the structure of the EMPLOYEES table: EMPLOYEE_ID NUMBER Primary Key FIRST_NAME VARCHAR2(25) LAST_NAME VARCHAR2(25) Which three statements insert a row into the table? （）A、INSERT INTO employees VALUES (NULL, 'John', 'smith');B、INSERT INTO employees (first_name, last_name) VALUES ('John', 'smith');C、INSERT INTO employees VALUES ('1000, 'John', 'smith');D、INSERT INTO employees (first_name, last_name, employee_id) VALUES (1000, 'John', 'smith');E、INSERT INTO employees (employee_id) VALUES (1000);F、INSERT INTO employees ( employee_id, first_name, last_name, ) VALUES (1000, 'John','');
Examine the structure of the EMPLOYEES table: EMPLOYEE_ID NUMBER NOT NULL EMP_NAME VARCHAR2(30) JOB_ID VARCHAR2(20) SAL NUMBER MGR_ID NUMBER DEPARTMENT_ID NUMBER You want to create a SQL script file that contains an INSERT statement. When the script is run, the INSERT statement should insert a row with the specified values into the EMPLOYEES table. The INSERT statement should pass values to the table columns as specified below: EMPLOYEE_ID: Next value from the sequence EMP_ID_SEQ EMP_NAME and JOB_ID: As specified by the user during run time, throughsubstitution variables SAL: 2000 MGR_ID: No value DEPARTMENT_ID: Supplied by the user during run time through substitution variable. The INSERT statement should fail if the user supplies a value other than 20 or 50. Which INSERT statement meets the above requirements?（）A、INSERT INTO employees VALUES (emp_id_seq.NEXTVAL, 'ename', 'jobid', 2000, NULL, did);B、INSERT INTO employees VALUES (emp_id_seq.NEXTVAL, 'ename', 'jobid', 2000, NULL, did IN (20,50));C、INSERT INTO (SELECT * FROM employees WHERE department_id IN (20,50)) VALUES (emp_id_seq.NEXTVAL, 'ename', 'jobid', 2000, NULL, did);D、INSERT INTO (SELECT * FROM employees WHERE department_id IN (20,50) WITH CHECK OPTION) VALUES (emp_id_seq.NEXTVAL, 'ename', 'jobid', 2000, NULL, did);E、INSERT INTO (SELECT * FROM employees WHERE (department_id = 20 AND department_id = 50) WITH CHECK OPTION ) VALUES (emp_id_seq.NEXTVAL, 'ename', 'jobid', 2000, NULL, did);
当需要删除某个序列seq_customer_id，可以使用如下（）方式。A、DROP SEQ_CUSTOMER_IDB、DELETE SEQUENCE SEQ_CUSTOMER_IDC、DROP SEQUENCE SEQ_CUSTOMER_IDD、DELETE SEQ_CUSTOMER_ID
Examine the structure of the EMPLOYEES table: EMPLOYEE_ID NUMBER NOT NULL EMP_NAME VARCHAR2(30) JOB_ID VARCHAR2(20) SAL NUMBER MGR_ID NUMBER DEPARTMENT_ID NUMBER You want to create a SQL script file that contains an INSERT statement. When the script is run, the INSERT statement should insert a row with the specified values into the EMPLOYEES table. The INSERT statement should pass values to the table columns as specified below: EMPLOYEE_ID: Next value from the sequence EMP_ID_SEQEMP_NAME and JOB_ID: As specified by the user during run time, through substitution variables SAL: 2000 MGR_ID: No value DEPARTMENT_ID: Supplied by the user during run time through substitution variable. The INSERT statement should fail if the user supplies a value other than 20 or 50. Which INSERT statement meets the above requirements?（）A、INSERT INTO employees VALUES (emp_id_seq.NEXTVAL, ename','jobid', 2000, NULL, did);B、INSERT INTO employees VALUES (emp_id_seq.NEXTVAL, 'ename', 'jobid', 2000, NULL, did IN (20,50));C、INSERT INTO (SELECT * FROM employees WHERE department_id IN (20,50)) VALUES (emp_id_seq.NEXTVAL, ename','jobid', 2000, NULL, did);D、INSERT INTO (SELECT * FROM employees WHERE department_id IN (20,50) WITH CHECK OPTION) VALUES (emp_id_seq.NEXTVAL, ename','jobid', 2000, NULL, did);E、INSERT INTO (SELECT * FROM employees WHERE (department_id = 20 AND department_id = 50) WITH CHECK OPTION ) VALUES (emp_id_seq.NEXTVAL, ename','jobid', 2000, NULL, did);
单选题Examine the structure of the EMPLOYEES table: EMPLOYEE_ID NUMBER NOT NULL EMP_NAME VARCHAR2(30) JOB_ID VARCHAR2(20) SAL NUMBER MGR_ID NUMBER DEPARTMENT_ID NUMBER You want to create a SQL script file that contains an INSERT statement. When the script is run, the INSERT statement should insert a row with the specified values into the EMPLOYEES table. The INSERT statement should pass values to the table columns as specified below: EMPLOYEE_ID: Next value from the sequence EMP_ID_SEQEMP_NAME and JOB_ID: As specified by the user during run time, through substitution variables SAL: 2000 MGR_ID: No value DEPARTMENT_ID: Supplied by the user during run time through substitution variable. The INSERT statement should fail if the user supplies a value other than 20 or 50. Which INSERT statement meets the above requirements?（）AINSERT INTO employees VALUES (emp_id_seq.NEXTVAL, ename','jobid', 2000, NULL, did);BINSERT INTO employees VALUES (emp_id_seq.NEXTVAL, 'ename', 'jobid', 2000, NULL, did IN (20,50));CINSERT INTO (SELECT * FROM employees WHERE department_id IN (20,50)) VALUES (emp_id_seq.NEXTVAL, ename','jobid', 2000, NULL, did);DINSERT INTO (SELECT * FROM employees WHERE department_id IN (20,50) WITH CHECK OPTION) VALUES (emp_id_seq.NEXTVAL, ename','jobid', 2000, NULL, did);EINSERT INTO (SELECT * FROM employees WHERE (department_id = 20 AND department_id = 50) WITH CHECK OPTION ) VALUES (emp_id_seq.NEXTVAL, ename','jobid', 2000, NULL, did);
单选题Examine the structure of the EMPLOYEES table: EMPLOYEE_ID NUMBER NOT NULL EMP_NAME VARCHAR2(30) JOB_ID VARCHAR2(20) SAL NUMBER MGR_ID NUMBER DEPARTMENT_ID NUMBER You want to create a SQL script file that contains an INSERT statement. When the script is run, the INSERT statement should insert a row with the specified values into the EMPLOYEES table. The INSERT statement should pass values to the table columns as specified below: EMPLOYEE_ID: Next value from the sequence EMP_ID_SEQ EMP_NAME and JOB_ID: As specified by the user during run time, throughsubstitution variables SAL: 2000 MGR_ID: No value DEPARTMENT_ID: Supplied by the user during run time through substitution variable. The INSERT statement should fail if the user supplies a value other than 20 or 50. Which INSERT statement meets the above requirements?（）AINSERT INTO employees VALUES (emp_id_seq.NEXTVAL, 'ename', 'jobid', 2000, NULL, did);BINSERT INTO employees VALUES (emp_id_seq.NEXTVAL, 'ename', 'jobid', 2000, NULL, did IN (20,50));CINSERT INTO (SELECT * FROM employees WHERE department_id IN (20,50)) VALUES (emp_id_seq.NEXTVAL, 'ename', 'jobid', 2000, NULL, did);DINSERT INTO (SELECT * FROM employees WHERE department_id IN (20,50) WITH CHECK OPTION) VALUES (emp_id_seq.NEXTVAL, 'ename', 'jobid', 2000, NULL, did);EINSERT INTO (SELECT * FROM employees WHERE (department_id = 20 AND department_id = 50) WITH CHECK OPTION ) VALUES (emp_id_seq.NEXTVAL, 'ename', 'jobid', 2000, NULL, did);