多选题RMAN SWITCH命令与哪个SQL命令相等?
多选题使用如下的SQL语句查询数据库:
SELECT bonus
FROM salary
WHERE bonus BETWEEN 1 AND 250
OR (bonus IN (190, 500, 600)
AND bonus BETWEEN 250 AND 500);
请问这个SQL语句将返回如下的哪个值?
多选题你已经创建了虚拟专用目录,以便使多名DBA分担20个不同数据库的RMAN管理职责。只有将哪个角色授予每个虚拟目录所有者,才能使所有者访问已经注册的数据库?
多选题Given:
3. class Wanderer implements Runnable {
4. public void run() {
5. for(int i = 0; i < 2; i++)
6. System.out.print(Thread.currentThread() .getName() + " ");
7. } }
8. public class Wander {
9. public static void main(String[] args) {
10. Wanderer w = new Wanderer();
11. Thread t1 = new Thread();
12. Thread t2 = new Thread(w);
13. Thread t3 = new Thread(w, "fred");
14. t1.start(); t2.start(); t3.start();
15. } }
Which are true? (Choose all that apply.)
多选题创建容器数据库时,必须在CREATE DATABASE命令中使用下面的哪些子句?
多选题找出语法上不正确的RMAN DUPLICATE命令。
多选题Given:
2. public class Coyote {
3. public static void main(String[] args)
4. int x = 4;
5. int y = 4;
6. while((x = jump(x)) < 8)
7. do {
8. System.out.print(x + " ");
9. } while ((y = jump(y)) < 6);
10. }
11. static int jump(int x) {return ++x; }
12. }
What is the result?
多选题以下是视图EMP_HIST_V的结构:
EMP_HIST_V
Name Type
------------------- ------------
EMPLOYEE_ID NUMBER(6)
NAME VARCHAR2(15)
JOB VARCHAR2(9)
MANAGER NUMBER(4)
DATE_HIRED DATE
SALARY NUMBER(7, 2)
BONUS NUMBER(7, 2)
DEPARTMENT_ID NUMBER(2)
在以下的SQL语句中,哪两个不能成功地查询视图EMP_HIST_V?
多选题为了恢复操作,Oracle服务器会将变化的数据记录到以下什么地方? A.数据文件 B.追踪文件 C.控制文件 D.重做日志文件 E.参数文件
多选题Given:
2. class Dog {
3. void makeNoise() { System.out.print,("bark ") ; }
4. static void play() { System.out.print("catching ");
5. }
6. class Bloodhound extends Dog {
7. void makeNoise() {System.out.print("howl "); }
8. public static void main(String[] args) {
9. new Bloodhound() .go();
10. super.play();
11. super.makeNoise();
12. }
13. void go() {
14. super.play();
15. makeNoise();
16. super.makeNoise();
17. } }
What is the result? (Choose all that apply.)
多选题有关控制文件的配置,Oracle所推荐的最低要求是什么? A.一个控制文件 B.两个控制文件放在同一个硬盘上 C.两个控制文件放在不同的硬盘上 D.3个控制文件放在同一个硬盘上 E.3个控制文件分别放在不同的硬盘上
多选题Given:
2. public class Errrrr {
3. static String a = null;
4. static String s = "";
5. public static void main(String[] args) {
6. try {
7. a = args[0];
8. System.out.print(a);
9. s += "t1 ";
10. }
11. catch (RuntimeException re) {s += "c1 "; }
12. finally {s += "f1 "; }
13. System.out.println(" " + s);
14. } }
And two command-line invocations:
java Errrrr
java Errrrr x
What is the result?
多选题如果查询数据字典V$LOGFILE并发现GROUP 3中的log3a.log成员的STATUS(列的)是空白的,请问在以下有关这一文件(成员)的陈述中,哪一个是正确的? A.它正在使用 B.它是不完整的 C.它是不可访问的 D.对于恢复来说,它已经不再需要了
多选题Given:
2. public class Incomplete {
3. public static void main(String[] args) { // change code here?
4. // insert code here?
5. new Incomplete() .doStuff();
6. // insert code here?
…
10. }
11. static void doStuff() throws Exception
12. throw new Exception();
13. }
Which are true? (Choose all that apply.)
多选题以下是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 要删除没有指派教师(INSTRUCTOR)的课程(CLASS),在如下的DELETE语句中,哪一个将获取所希望的结果? A.DELETE class_id, class_name, hours_credit, instructor_id FROM class WHERE instructor_id IS NULL; B.DELETE FROM class WHERE instructor_id NOT IN (SELECT instructor_id FROM class); C.DELETE FROM instructor NATURAL JOIN class WHERE instructor_id IS NOT NULL; D.DELETE FROM class WHERE instructor_id IS NULL;
多选题Given:
2. class RainCatcher {
3. static StringBuffer s;
4. public static void main(String[] args)
5. Integer i = new Integer(42);
6. for(int j = 40; j < i; i--)
7. switch(i) {
8. case 41: s.append("41 ");
9. default: s.append("def ");
10. case 42: s.append("42 ");
11. }
12. System.out.println(s);
13. } }
What is the result?
多选题以下是学生(STUDENT)表所包含的全部列的定义:
ID NUMBER(9) PK
LAST_NAME VARCHAR2(25)
FIRST_NAME VARCHAR2(25)
ENROLL_DATE DATE
请看如下的SQL脚本(语句),应该怎样修改才可以使它运行?
ACCEPT id "Please enter the student id: "
SELECT id, last_name, first_name, enroll_date
FROM student
WHERE id=&id
/
多选题Given:
1. import java.util.*;
2. public class Analyzer {
3. static List<Exception> me;
4. Exception myEx;
5. public static void main(String[] args) {
6. Analyzer[] aa = {new Analyzer(), new Analyzer()};
7. me = new ArrayList<Exception>();
8. for(int i = 0; i < 2; i++) {
9. try {
10. if(i == 0) throw new Exception();
11. if(i == i) throw new MyException();
12. }
13. catch (Exception e) {
14. me.add(e);
15. aa[i] .myEx = e;
16. }
17. }
18. System.out.println(aa.length + " " + me.size());
19. aa = null; me = null;
20. // do more stuff
21. } }
22. class MyException extends Exception { }
When line 20 is reached, how many objects are eligible for garbage collection?
多选题在以下有关更改一个视图结构的语句中,哪一个是正确的?
多选题在以下有关数据库写进程(DBWn)的陈述中,哪4个是正确的? A.DBWn每三秒写一次磁盘 B.每当时间间隔到时DBWn写盘 C.每当校验点发生时DBWn写盘 D.每当事务提交时DBWn写盘 E.每当一个表空间被设置为只读模式时DBWn写盘 F.每当脏数据缓冲区达到限定的阈值时DBWn写盘