多选题Given:
2. class Feline { }
3. public class BarnCat2 extends Feline {
4. public static void main (String[] args) {
5. Feline ff=new Feline();
6. BarnCat2 b=new BarnCat2 ();
7. // insert code here
8. }
9. }
Which, inserted independently at line 7, compile? (Choose all that apply.)
多选题在星期一使用主键索引创建了VAC_SCHED表；创建表后紧接的SCN是5680123。于星期三删除了索引。在星期四无意间删除了数据库中的大部分行。在星期五执行以下命令：
SQL＞FLASHBACK TABLE VAC_SCHED TO SCN 5680123;
已经将担保撤消保留期限设置为一个星期。运行此命令会有什么结果?
多选题Given:
3. public class Limits {
4. private int x = 2;
5. protected int y = 3;
6. private static int m1 = 4;
7. protected static int m2 = 5;
8. public static void main(String[] args) {
9. int x = 6; int y = 7;
10. int m1 = 8; int m2 = 9;
11. new Limits().new Secret().go();
12. }
13. class Secret {
14. void go() { System.out.println(x + " " + y + " " + m1 + " " + m2);}
15. } }
What is the result?
多选题创建副本数据库时，给下面的步骤指定正确的顺序：
1．以NOMOUNT模式启动辅助实例
2．在必要时分配辅助通道
3．运行RMAN DUPLICATE命令
4．为辅助实例创建口令文件
5．确保辅助实例的网络连接
6．打开辅助实例
7．在MOUNT或OPEN模式下启动源数据库
8．为辅助实例创建一个初始化参数文件
9．创建备份，或者将现有的备份和归档日志文件复制到辅助实例可以访问的公共位置
多选题Given:
3. class A { }
4. class B extends A { }
5. class C extends B { }
6. public class Carpet＜V extends B＞ {
7. public ＜X extends V＞ Carpet＜? extends V＞ method(Carpet＜? super X＞ e) {
8. // insert code here
9. } }
Which, inserted independently at line 8, will compile? (Choose all that apply.)
多选题Given that IllegalArgumentException extends RuntimeException, and given:
11. static String s = "";
12. public static void main(String[] args) {
13. try {doStuff(); }
14. catch (Exception ex) {s += "c1 "; }
15. System.out.println(s);
16. }
17. static void doStuff() throws RuntimeException {
18. try {
19. s += "t1 ";
20. throw new IllegalArgumentException();
21. }
22. catch (IllegalArgumentException ie) {s += "c2 ";
23. throw new IllegalArgumentException();
24. }
What is the result?
多选题学生(STUDENT)表包括了如下的列定义：
ID NUMBER(9) PK
LAST_NAME VARCHAR2(25)
FIRST_NAME VARCHAR2(25)
SUBJECT_ID NUMBER(9)
比较以下的两个SQL语句，其结果将有哪些不同?
(1)SELECT DISTINCT subject_id, last_name, first_name
FROM student
ORDER BY 1;
(2)SELECT id, last_name, first_name, subject_id
FROM student
ORDER BY subject_id;
多选题Given:
2. public class Humping {
3. public static void main(String[] args)
4. String r = "-";
5. char[] c = {"a", "b", "c", "z"};
6. for(char c1: c)
7. switch (c1) {
8. case "a": r += "a";
9. case "b": r += "b"; break;
10. default: r += "X";
11. case "z": r+= "z";
12. }
13. System. out.println(r);
14. } }
What is the result?
多选题Given:
2. class Super {
3. static String os = "";
4. void doStuff() {os += "super ";}
5. }
6. public class PolyTest extends Super {
7. public static void main(String[] args) {new PolyTest().go(); }
8. void go() {
9. Super s = new PolyTest();
10. PolyTest p = (PolyTest)s;
11. p.doStuff();
12. s.doStuff();
13. p.doPoly();
14. s.doPoly();
15. System.out.println(os);
16. }
17. void doStuff() {os += "over "; }
18. void doPoly() {os += "poly "; }
19. }
What is the result?
多选题Mary创建了一个名为SCHEDULE的表，结构如下： ID NUMBER(9) PK NAME VARCHAR2(25) CLASS_DATE DATE 她将这个表的INSERT权限赋予了您。随后，您向SCHEDULE表中插入了三行数据，但是并未发提交命令。此时Maiy发了如下的命令： SELECT * FROM schedule; 请问在以下的陈述中，哪3个是正确的? A．Mary将能够访问SCHEDULE表 B．Mary将不能访问SCHEDULE表 C．Mary将能够向SCHEDULE表中插入相同的记录 D．Maiy将能够看到您在SCHEDULE表中插入三个记录 E．Mary将不能看到您在SCHEDULE表中插入三个记录 F．Mary将不能向SCHEDULE表中插入相同的记录
多选题在运行RMAN RESTORE CONTROLFILE命令时，RMAN在何处放置旧版控制文件?
多选题Given:
2. import java.util.*;
3. public class MyFriends {
4. String name;
5. MyFriends(String s) {name = s; }
6. public static void main(String[] args) {
7. Set＜MyFriends＞ ms = new HashSet＜MyFriends＞();
8. ms.add(new MyFriends("Bob"));
9. System.out.print(ms + " ");
10. ms.add(new MyFriends("Bob"));
11. System.out.print(ms + " ");
12. ms.add(new MyFriends("Eden"));
13. System.out.print(ms + " ");
14. }
15. public String toString() {return name; }
16. }
What is the most likely result?
多选题Given this code in a method:
4. Integer[] [] la = {{1,2}, {3,4,5}};
5. Number[] na = la[1];
6. Number[] na2 = (Number[])la[0];
7. Object o = na2;
8. la[1] = (Number[])o;
9. la[0] = (Integer[])o;
What is the result? (Choose all that apply.)
多选题数据库的BI_HR表空间所在的磁盘受到损坏，但是闪回恢复区中包含映像副本和所有需要的重做日志文件。请按正确顺序排列以下RMAN命令，以便成功地恢复BI_HR表空间：
1．recover tablespace bi_hr;
2．sql "alter tablespace bi_hr online";
3．switch tablespace bi_hr to copy;
4．sql "alter tablespace bi_hr offline immediate";
多选题请看如下的SQL语句： SELECT line_item_id, orderid, product_id FROM line_item; 使用以下的哪个WHERE子句能测试出quantity列是否包含空值(NULL)? A．WHERE quantity=NULL; B．WHERE quantity＜＞NULL; C．WHERE quantity!=NULL; D．WHERE quantity IS NULL;
多选题Given:
3. public class Honcho {
4. static boolean b1 = false;
5. static int z = 7;
6. static Long y;
7. public static void main(String[] args)
8. for(int i = 0; i ＜ 4; i++)
9. go(i);
10. }
11. static void go(int x) {
12. try {
13. if((x == 0)
14. if(x ＜ 2 ^ x ＜ 10) System.out.print("1 ");
15. if((x == 2)
16. if(z ＜= (x + 4)) System.out.print("3 ");
17. }
18. catch (Exception e) {System.out.print("e "); }
19. } }
What is the result?
多选题Given:
3. class Sport {
4. Sport play() {System.out.print("play "); return new Sport(); }
5. Sport play(int x) {System.out.print ("play x "); return new Sport(); }
6. }
7. class Baseball extends Sport {
8. Baseball play() {System.out.print("baseball "); return new Baseball(); }
9. Sport play(int x) {System.out.print("sport "); return new Sport(); }
10.
11. public static void main(String[] args)
12. new Baseball() .play();
13. new Baseball() .play(7);
14. super.play (7);
15. new Sport().play();
16. Sport s = new Baseball();
17. s.play();
18. }}
What is the result?
多选题完全备份和完整数据库备份有什么区别?
多选题Given:
1. public class Endless {
2. public static void main(String[] args) {
3. int i = 0;
4. short s = 0;
5. for(int j = 0, k = 0; j ＜ 3; j++);
6. for(int j = 0; j ＜ 3; counter(j));
7. for(int j = 0, int k = 0; j ＜ 3; j++);
8. for(; i ＜ 5; counter(5), i++);
9. for(i = 0; i ＜ 3; i++, System.out.print("howdy "));
10. }
11. static int counter(int y) {return y + i; }
12. }
What is the result? (Choose all that apply.)
多选题RMAN被配置为自动备份控制文件和SPFILE。使用下面的RMAN命令执行了完整PDB备份：
RMAN＞connect target /
RMAN＞backup pluggable database ccrepos;
之后不久，丢失了控制文件的所有副本。有什么选项可恢复控制文件?