多选题为了获取以下的哪些信息您才会访问一个用户的追踪文件? A.追踪SQL语句的统计信息 B.最后一次日志切换的信息 C.所有非默认初始化参数的列表 D.由LGWR产生的错误信息
多选题客户(CUSTOMER)表包括如下的列: CUSTOMER_D NUMBER(9) LAST_NAME VARCHAR2(20) FIRST_NAME VARCHAR2(20) STREET_ADDRESS VARCHAR2(30) CITY VARCHAR2(20) STATE VARCHAR2(15) POSTAL_CODE VARCHAR2(9) 请问有关下列两个SQL语句的陈述哪一个是正确的? (1)SELECT CONCAT(INITCAP(first_name), INITCAP(last_name)) FROM customer; (2)SELECT INITCAP(first_name)‖INITCAP(last_name) FROM customer; A.这两个SQL语句将显示相同的输出结果 B.这两个SQL语句将不显示相同的数据 C.这两个SQL语句查询到的数据是相同的,但是显示将是不同的 D.其中一个语句将执行失败,因为有语法错误
多选题以下单行函数中的哪一个可以用于VARCHAR2列?
多选题Given:
2. class Paratrooper implements Runnable {
3. public void run() {
4. System.out.print (Thread. currentThread() .getName() +" ");
5. } }
6. public class Jump {
7. static Paratrooper p;
8. static {p = new Paratrooper(); }
9. {Thread t1 = new Thread(p, "bob"); t1.start(); }
10. public static void main(String[] args) {
11. new Jump();
12. new Thread(new Runnable() {public void run()
{; } }, "carol").start();
13. new Thread(new Paratrooper(), "alice").start();
14. }
15. Jump() {Thread t2 = new Thread(p, "ted"); t2.start();}
16. }
Which are true? (Choose all that apply.)
多选题Given:
4. public class Stone implements Runnable {
5. static int id = i;
6. public void run() {
7. try {
8. id = 1 - id;
9. if(id == 0) {pick(); } else {release(); }
10. } catch (Exception e) { }
11. }
12. private static synchronized void pick() throws Exception {
13. System.out.print ("P "); System.out.print("Q ");
14. }
15. private synchronized void release() throws Exception {
16. System.out.print("R "); System.out.print("S ");
17. }
18. public static void main(String[] args) {
19. Stone st = new Stone();
20. new Thread(st) .start();
21. new Thread(st) .start();
22. } }
Which are true? (Choose all that apply.)
多选题下面的哪些后台进程同时存在于ASM实例和RDBMS实例中,并且同时支持ASM磁盘组?
多选题Given:
2. class Robot { }
3. interface Animal { }
4. class Feline implements Animal { }
5. public class BarnCat extends Feline {
6. public static void main(String[] args) {
7. Animal af = new Feline();
8. Feline ff = new Feline();
9. BarnCat b = new BarnCat();
10. Robot r = new Robot();
11. if(af instanceof Animal) System.out.print("1 ");
12. if(af instanceof BarnCat) System.out.print("2 ");
13. if(b instanceof Animal) System.out.print("3 ");
14. if(ff instanceof BarnCat) System.out.print ("4 ");
15. if(r instanceof Animal) System.out .print ("5 ");
16. }
17. }
What is the result?
多选题使用DBM_RESOURCE_MANAGER创建一个新的CDB资源管理器计划时,UPDATE_CDB_DEFAULT_DIRECTIVE与UPDATE_CDB_AUTOTASK_DIRECTIVE过程之间有什么区别?
多选题要获取一个用户当前激活的所有角色的列表,应该查询以下哪个数据字典视图? A.DBA_ROLES B.SESSION_ROLES C.DBA_ROLE_PRIVS D.DBA_TAB_PRIVS
多选题Given:
1. public class LaSelva extends Beach {
2. LaSelva() {s = "LaSelva"; }
3. public static void main(String[] args) {new LaSelva().go(); }
4. void go() {
5. Beach[] ba= {newBeach(), newLaSelva(), (Beach) newLaSelva() };
6. for(Beach b: ba) System.out.print(b.getBeach().s + " ");
7. }
8. LaSelva getBeach() {return this; }
9. }
10. class Beach {
11. String s;
12. Beach() {s = "Beach"; }
13. Beach getBeach() {return this; }
14. }
What is the result?
多选题Given:
2. class Big {
3. void doStuff(int x) { }
4. }
5. class Heavy extends Big {
6. // void doStuff(byte b) { }
7. // protected void doStuff(int x) throws Exception { }
8. }
9. public class Weighty extends Heavy {
10. // void doStuff(int x) { }
11. // String doStuff(int x) {return "hi"; }
12. // public int doStuff(int x) {return 7; }
13. // private int doStuff(char c) throws Error {return 1; }
14. }
Which method(s), ifuncommented independently, compile? (Choose all that apply.)
多选题Given the following from the java.io.File API:
Field Summary: static String separator
Method Summary: static File[] listRoots()
And given:
2. // insert code here
3. // insert code here
4. public class Eieio {
5. public static void main(String[] args) {
6. try {
7. String s = "subdir" + separator + "myFile.txt";
8. java.io. File f = new java.io. File(s);
9. java.io. FileReader fr = new java.io. FileReader(f);
10. java.io. File[] r = listRoots();
11. fr.close();
12. }
13. catch (Exception e) { }
14. } }
And the following four fragments:
Ⅰ. import java.io.*;
Ⅱ. import static java.io.File.*;
Ⅲ. import static java.io.File.separator;
Ⅳ. import static java.io.File.listRoots;
Which set(s) of fragments, inserted independently on lines 2 and/or 3, will compile?(Choose all that apply.)
多选题在如下的数据字典中,查询哪一个可以列出只有自己拥有的视图?
多选题以下是表INVENTORY中的内容:如果使用如下的SQL语句查询这个库存(INVENTORY)表,哪一个值会第一个显示?SELECTid_numberFROMinventoryWHEREpriceBETWEEN5.00AND15.00ORDERBYdescription,manufacturer_id;
多选题Given:
1. import java.util.*;
2. class Priorities {
3. public static void main(String[] args) {
4. PriorityQueue toDo = new PriorityQueue();
5. toDo.add("dishes");
6. toDo.add("laundry");
7. toDo.add("bills");
8. toDo.offer("bills");
9. System.out.print(toDo.size() + " " + toDo.poll());
10. System.out.print(" " + toDo.peek() + " " + toDo.poll());
11. System.out.println(" " + toDo.poll() + " " + toDo.poll());
12. } }
What is the result?
多选题以下是PATIENT、PHYSICIAN和ADMISSION表的结果:
PATIENT
PATIENT_ID
NUMBER
NOT NULL, Primary Key
LAST_NAME
VARCHAR2(30)
NOT NULL
FIRST_NAME
VARCHAR2(25)
NOT NULL
DOB
DATE
INS_CODE
NUMBER
PHYSICIAN
PHYSICIAN_ID
NUMBER
NOT NULL, Primary Key
LAST_NAME
VARCHAR2(30)
NOT NULL
FIRST_NAME
VARCHAR2(25)
NOT NULL
LICENSE_NO
NUMBER(7)
NOT NULL
HIRE_DATE
DATE
ADHISSION
PATIENT_ID
NUMBER
NOT NULL, Primary Key, References PATIENT_ID column of
the PATIENT table
PHYSICIAN_ID
NUMBER
NOT NULL, Primary Key, References PHYSICIAN_ID column
of the PHYSICIAN table
ADMIT_DATE
DATE
DISCHG_DATE
DATE
ROOH_ID
NUHBER
Foreign key to ROOM_ID of the ROOM table
如果想提取在某个理疗师(physician)被雇佣之后所有注册的病人(patient),应使用如下的哪种结构?
多选题在执行备份时,下面哪个属性或特征通过RMAN传递给OSB?假设RMAN客户已经用OSB注册。
多选题假设正在写一个ALTER PROFILE语句来修改默认概要文件的参数值。其要求是:如果一个用户试着登录了三次以上并都失败了,用户在试图再次登录之前需要等待一分钟。以下就是所需的ALTER PROFILE语句: (1)ALFER PROFILE default LIMIT (2)PASSWORD_LIFE_TIME 60 (3)PASSWORD_GRACE_TIME 10 (4)PASSWORD_REUSE_TIME 1800 (5)PASSWORD_REUSE_MAX UNLIMITED (6)FAILED_LOGIN_ATTEMPTS 3 (7)PASSWORD_LOCK_TIME ______ (8)PASSWORD_VERIFY_FUNCTION verify_function; 请问,应该在ALFER PROFILE的第7行中使用以下的哪一个值? A.1 B.60 C.24 D.1/1440
多选题Given:
3. public class BirdHouse {
4. public static void main(String[] args)
5. String r = "0";
6. int x = -1, y = -5;
7. if(x < 5)
8. if(y > 0)
9. if(x > y)
10. r += "1";
11. else r += "2";
12. else r += "3";
13. else r += "4";
14. System.out.println(r);
15. } }
What is the result?
多选题Given:
2. class Ball {
3. static String s = "";
4. void doStuff() {s += "bounce "; }
5. }
6. class Basketball extends Ball {
7. void doStuff() {s += "swish "; }
8. }
9. public class Golfball extends Ball {
10. public static void main(String[] args) {
11. Ball b = new Golfball();
12. Basketball bb = (Basketball)b;
13. b.doStuff();
14. bb.doStuff();
15. System.out.println(s);
16. }
17. void doStuff() {s += "fore "; }
18. }
What is the result?
