多选题在如下的语句中,哪两个造成事务的隐式提交?
多选题Given:
2. public class Sunny extends Weather {
3. public static void main(String[] args) {
4. try {
5. new Sunny() .do1();
6. new Sunny() .do2();
7. new Sunny() .do3();
8. }
9. catch(Throwable t) {System.out.print("exc "); }
10. } }
11. class Weather {
12. void do1() {System.out.print("do1 "); }
13. private void do2() {System.out.print("do2 "); }
14. protected void do3() {System.out.print("do3 "); }
15. }
What is the result?
多选题请看SQL语句"SELECT name, status FROM v$controlfile; ",这一语句将显示以下哪个结果? A.显示MAXDATAFILE的值 B.确定最后一个检查点所发生的时间 C.显示所有数据文件的名字和状态 D.显示所有控制文件的个数、名字、状态和位置
多选题下面哪些语句给出了将数据库备份还原到新主机的真实原因?
多选题在读写块时,Oracle会执行以下哪些基本一致性检查操作?
多选题当使用VALUES子句时,在以下有关INSERT INTO语句的陈述中,哪一个是正确的? A.当使用VALUES子句时,每次只能插入一行数据 B.在VALUES子句中的数值必须用单引号括起来 C.当使用VALUES子句时,在INSERT子句中需要一个列的列表 D.当在INSERT INTO语句中使用VALUES子句时会产生用法错误
多选题Given:
2. interface Clickable {void click(); }
3. // insert code here
Which code, inserted independently at line 3, will compile? (Choose all that apply.)
多选题Given two files:
1. package com;
2. public class Extramuros {
3. public static void howdy() {System.out.print("howdy "); }
4. public static final Extramuros ex = new Extramuros();
5. public int instVar = 42;
6. public enum avout {OROLO, JAD};
7. }
1. // insert code here
…
6. public class Theorics {
7. public static void main(String[] args) {
8. Extramuros.howdy();
9. System.out.print(Extramuros.avout.OROLO + " ");
10. howdy();
11. System.out.print(ex.instVar + " ");
12. }}
Which are the minimum line(s) of code to add at "insert code here" for the files to compile? (Choose all that apply.)
多选题用户wuda给您发了一封电子邮件,他投诉说他无法连接到数据库上。他说每次他发SQL*Plus命令时都收到了如下的错误信息: ERROR: ORA-28000: the account is locked Warning: You are no longer connected to Oracle 请问,之前数据库管理员可能发了哪一个语句产生了这一问题? A.DROP USER wuda; B.DROP USER wuda CASCADE; C.ALTER USER wuda ACCOUNT LOCK; D.ALTER USER wuda QUOTA 0 ON dog_data; E.ALTER USER wuda QUOTA unlimited ON dog_data;
多选题Given:
3. import java.io.*;
4. public class Kesey {
5. public static void main(String[] args) throws Exception {
6. File file = new File("bigData.txt");
7. FileWriter w = new FileWriter(file);
8. w.println("lots o" data");
9. w.flush();
10. w.close();
11. } }
What is the result? (Choose all that apply.)
多选题以下是EMPLOYEE表结构的详细内容,其中也包括了所使用的约束类型。 EMPLOYEE Column Name EMPLOYEE_ID NAME JOB MANAGER DATE_HIRED SALARY BONUS DEPIARTMENT_ID Key-Type PK Nulls/Unique NN,U NN NN FK Table FK Column Datatype HUM VARCHAR2 VARCHAR2 NUM DATE NUM HUM NUM Length 6 20 9 6 7, 2 7, 2 2 创建了EMPLOYEE_V视图,该视图从EMPLOYEE表中选取属于第10号部门(department_10)并且在1997年12月31日之前雇用的所有员工的全部信息(所有的行和列),为了达到这一目的,在创建视图的语句中使用了CHECK OPTION命令。请问,以下的哪个语句将成功地执行? A.INSERT INTO employee_v (employee_id, name, job, manageger, date_hired, department_id) VALUES (2009, 'LITTLE', 'TYPIST', 788, '30-MAY-1996', 10); B.INSERT INTO employee_v (employee_id, name, job, manager, date_hired, salary, department_id) VALUES (2009,'LITTLE', 'TYPIST', 788, '30-MAY-1996', 2000, 40); C.INSERT INTO employee_v (employee_id, name, job, date_hired, salary, bonus, department_id) VALUES (2009, 'LITTLE', 'TYPIST', '30-MAY-1998', 2000, 300, 10); D.INSERT INTO employee_v (name, job, manager, date_hired, salary, bonus, department_id) VALUES ('LITTLE', 'TYPIST', 788, '30-MAY-1996', 2000, 300, 10); E.INSERT INTO employee_v (employee_id, name, job, manager, date_hired, salary, bonus) VALUES (2009, 'LITTLE', 'TYPIST', 788, '30-MAY-1996', 2000, 300);
多选题使用UPDATE语句修改girldogs表中的所有记录。接下来,查询girldogs表来显示在girldogs表中的所有修改过的记录。为了保险起见,请同事童铁蛋查询girldogs表以确保修改记录的正确性。不过童铁蛋并未看到对girldogs表所做的修改。请问这表明了什么? A.插入恢复(insert recovery) B.读一致性(read consistency) C.事务恢复(transaction recovery) D.事务回滚(transaction rollback)
多选题以下有关不等连接(Non-equijoin)查询语句的陈述中哪个是正确的(true)?
多选题下列脚本(SQL语句)中哪个会将23-MAY-00显示为01-JAN-00? A.SELECT ROUND(order_date, 'DAY') FROM inventory; B.SELECT ROUND(order_date, 'YEAR') FROM inventory; C.SELECT ROUND(order_date, 'MONTH') FROM inventory; D.SELECT ROUND(TO_CHAR(order_date, 'YYYY')) FROM inventory;
多选题作为DBA,运行了创建VERIFY_FUNCTION函数的脚本,并且这个脚本修改了默认的概要文件。如果用户KIMJ被赋予了默认概要文件,她当前的密码是TIME_2_GO,请问以下的哪一个密码是可以接受的? A.KIM B.KIMJ C.KIM_J D.ITS4_ME E.TIME_3_GO F.TIME_2_GO
多选题以下是产品(PRODUCT)表中的数据: PRODUCT ID NUMBER DESCRIPTION MANUFACTURER ID QUANTITY COST 215 AAA 6pk-battery NF10032 546 3.00 140 AA 2pk-battery EL7968 2000 603 D 2pk-battery OT456 318 1.10 725 C 2pk-battery OT456 239 .75 218 AAA 6pk-battery OT456 980 3.25 220 AAA 8pk-battery NF10032 4.20 126 AA 2pk-battery NF10032 2513 751 C 2pk-battery EL7968 84 100 SELECT description, quantity, cost FROM product WHERE manufacturer_id LIKE 'NF10032' AND NVL(cost, 0)<5.00 ORDER BY quantity DESC, cost; 以上的查询语句将产生如下的哪个结果? A.DESCRIPTION QUANTITY COST ----------------- --------- ------ AA 2pk-battery 2513 AAA 6pk-battery 546 3 B.DESCRIPTION QUANTITY COST ----------------- --------- ------ AAA 8pk-battery 4.2 AA 2pk-battery 2513 AAA 6pk-battery 546 3 C.DESCRIPTION QUANTITY COST ----------------- --------- ------ AAA 6pk-battery 546 3 AAA 8pk-battery 4.2 AA 2pk-battery 2513 D.DESCRIPTION QUANTITY COST ----------------- --------- ------ AA 2pk-battery 2513 AAA 6pk-battery 546 3 AAA 8pk-battery 4.2
多选题评估这个命令:ACCEPT v_price CHAR PROMPT "Price amount",它将完成以下哪个任务?
多选题如要基于daji用户的PIONEER表创建一个视图以便所有用户在查询他的模式中的这个表时不再需要在PIONEER表之前冠以用户名daji了。请问在以下的DDL语句中,应该使用哪一个?
多选题在以下有关角色的叙述中,哪一个是正确的? A.每一个用户只可以有一个默认的角色 B.当一个用户登录时这个用户的默认角色被激活 C.DEFAULT ROLE NONE选项将移除一个用户的所有角色 D.通过回收角色中的所有权限来临时地收回一个用户的角色
多选题Given:
42. void go() {
43. int cows = 0;
44. int[] twisters = {1,2,3};
45. for(int i = 0; i < 4; i++)
46. switch(twisters[i]) {
47. case 2: cows++;
48. case 1: cows += 10;
49. case 0: go();
50. }
51. System.out.println(cows);
52. }
What is the result?
