多选题ACCOUNT表包括了如下的列:
ACCOUNT_ID NUMBER(12)
NEW_BALANCE NUMBER(7, 2)
PREV_BALANCE NUMBER(7, 2)
FINANCE_CHARGE NUMBER(7, 2)
如果要用最简单的方法显示ACCOUNT表中所有的记录,则应该使用以下哪个查询语句?
多选题Given:
3. public class Fiji {
4. static Fiji base;
5. Fiji f;
6. public static void main(String[] args) {
7. new Fiji() .go();
8. // do more stuff
9. }
10. void go() {
11. Fiji f1 = new Fiji();
12. base = f1;
13. Fiji f2 = new Fiji();
14. f1.f = f2;
15. Fiji f3 = f1.f;
16. f2.f = f1;
17. base = null; f1 = null; f2 = null;
18. // do stuff
19. } }
Which are true? (Choose all that apply.)
多选题Given:
3. public class BigData {
4. static BigData bd;
5. public static void main(String[] args) {
6. new BigData().doStuff();
7. // do lots of memory intensive stuff
... // JVM finds an eligible BigData object for GC
... // JVM invokes finalize()
... // do more stuff
48. }
49. void doStuff() { }
50. // insert code here
51. bd = this;
52. }
53. }
54. class MyException extends Exception { }
and the following four fragments:
Ⅰ. protected void finalize() throws Throwable {
Ⅱ. protected void finalize() {
Ⅲ. protected void finalize() throws MyException {
Ⅳ. void finalize() {
If the fragments are inserted, independently, at line 50, which are true? (Choose all that apply.)
多选题以下的哪些数据字典视图包含一系列使用Flashback Data Archive的表?
多选题Given:
1. public class Networking {
2. public static void main(String[] args) {
3. List<Integer> i = new LinkedList<Integer>();
4. i.add(4); i.add(2); i.add(5);
5. int r = i;
6. doStuff(r);
7. System.out.println(i.get(r));
8. }
9. static int doStuff(int x) {
10. return ++x;
11. } }
What is the result?
多选题以下有关不等连接(Non-equijoin)查询语句的陈述中哪个是正确的(true)? A.不需要使用表的别名来说明有可能混淆的列名 B.在不相等连接查询语句的连接条件中使用的不是等于操作符 C.可以使用不等连接来获取通常不满足连接条件的数据行 D.WHEERE子句说明一个表中的某一列如何直接对应于第2个表中的一列
多选题要使用块介质恢复功能,需要满足以下哪些先决条件?
多选题如果发了DROP TABLE inventory; 这样一个语句,而并未显式地发COMMIT(提交)语句,怎样才能反转这一操作并恢复inventory表中的数据? A.发一个ROLLBACK语句 B.关闭(shut down)数据库 C.终止当前的会话 D.不能反转这一操作
多选题如下哪两类操作系统文件是属于Oracle数据库的? A.数据文件 B.控制文件 C.口令文件 D.参数文件 E.归档日志文件
多选题Given:
3. public class Race {
4. public static void main(String[] args)
5. Horse h = new Horse();
6. Thread t1 = new Thread(h, "Andi");
7. Thread t2 = new Thread(h, "Eyra");
8. new Race() .go(t2);
9. t1.start();
10. t2.start();
11. }
12. void go(Thread t) {t.start(); }
13. }
14. class Horse implements Runnable {
15. public void run() {
16. System.out.print(Thread.currentThread() .getName() + " ");
17. } }
What is the result? (Choose all that apply.)
多选题Given:
14. FileWriter fw1 =
new FileWriter(new File("f1.txt"));
15. FileWriter fw2 =
new FileWriter(new BufferedWriter(new PrintWriter("f2.txt")));
16. PrintWriter pw1 =
new PrintWriter(new BufferedWriter(new FileWriter("f3.txt")));
17. PrintWriter pw2 =
new PrintWriter(new FileWriter(new File("f4.txt")));
And given the proper imports and error handling, what is the result?
多选题Concerning Java"s Garbage Collector (GC), which are true? (Choose all that apply.)
多选题对于命令:
TRUNCATE TABLE inventory;
以下哪两个陈述是正确的?
多选题Given:
2. import java.io.*;
3. interface Risky {
4. String doStuff() throws Exception;
5. Risky doCrazy();
6. void doInsane();
7. }
8. class Bungee implements Risky {
9. public String doStuff() throws IOException {
10. throw new IOException();
11. }
12. public Bungee doCrazy() {return new Bungee(); }
13. public void doInsane() throws NullPointerException
14. throw new NullPointerException();
15. } }
What is the result? (Choose all that apply.)
多选题在以下有关概要文件的叙述中,哪两个是正确的? A.可以为模式管理创建概要文件 B.可以创建概要文件以确保用户在指定的时间间隔内不会重用一个密码 C.概要文件可以被赋予用户、角色和其他的概要文件 D.当创建新用户时,必须将默认概要文件显式地赋予这个用户 E.概要文件的赋予只影响后续的会话
多选题可以使用哪条RMAN命令来了解需要再备份哪些数据文件来满足保留策略?
多选题Given:
2. import java.util.*;
3. public class Salt {
4. public static void main(String[] args) {
5. Set s1 = new HashSet();
6. s1.add(0);
7. s1.add("1");
8. doStuff(s1);
9. }
10. static void doStuff(Set<Number> s) {
11. do2(s);
12. Iterator i = s.iterator();
13. while(i.hasNext()) System.out.print(i.next() + " ");
14. Object[] oa = s.toArray();
15. for(int x = 0; x < oa.length; x++)
16. System.out.print(oa[x] + " ");
17. System.out.println(s.contains(1));
18. }
19. static void do2(Set s2) {System.out.print(s2.size() + " ");
20. }
What is the most likely result?
多选题一个用户需要创建名为CAT的数据库,他必须具有以下所列出的哪个条件? A.一个控制文件(control file) B.系统表空间(SYSTEM tablespace) C.CAT用户中的一个用户名 D.一个具有全部权限的操作系统合法用户
多选题以下是课程(CLASS)表和教师(INSTRUCTOR)表中的数据: CLASS CLASS_ID CLASS_NAME HOURS_CREDIT INSTRUCTOR_ID 1 Introduction to Accounting 3 4 2 Computer Basics 3 1 3 Tax Accounting Principles 3 4 4 American History 3 2 5 Basic Engineering 3 INSTRUCTOR INSTRUCTOR_ID LAST_NAME FIRST_NAME 1 Chao Ling 2 Vanderbilt Herbert 3 Wigley Martha 4 Page Albert 要生成一个包括每个教师所教课程的报表,该报表必须包括所有的教师,即使那些目前没有任课的教师也要包括在报表中。请问,应使用以下查询语句中的哪两个? A.SELECT i.last_name, i.first_name, c.class_name FROM instructor i, class c; B.SELECT i.last name, i.first_name,c.class_name FROM class c LEFT OUTER JOIN instructor I ON (i.instructor_id=c.instructor_id) ORDER BY i.instructor_id; C.SELECT i.last_name, i.first_name, c.class_name FROM instructor i, class c WHERE i.instructor_id=c.instructor_id (+) ORDER BY i.instructor_id; D.SELECT i.last_name, i.first_name, c.class_name FROM instructor i LEFT OUTER JOIN class c ON (i.instructor id=c.instructor_id) ORDER BY i.instructor_id; E.SELECT i.last_name, i.first_name, c.class_name FROM instructor i, class c WHERE i.instructor_id (+)=c.instructor_id ORDER BY i.instructor_id; F.SELECT i.last_name, i.first_name, c.class_name FROM instructor i NATURAL JOIN class c ON (i.instructor_id=c.instructor_id);
多选题Which are true about the classes and interfaces in j ava.util? (Choose all that apply.)
