多选题在一个使用了“<>”操作符的子查询中可以返回多少个值?
多选题要从TRX表中移除一年以上的事务,请问如下的哪一类型的语句可以完成这一操作? A.DCL B.DDL C.DML D.DRL E.TCL
多选题如果发出如下的SQL语句,请问该语句将完成以下的哪个任务?
CREATE PUBLIC SYNONYM parts
FOR daji.inventory;
多选题Given:
4. public static void main(String[] args) {
5. try {
6. if(args.length == 0) throw new Exception();
7. }
8. catch (Exception e) {
9. System.out .print ("done ");
10. doStuff(); // assume this method compiles
11. }
12. finally {
13. System.out.println("finally ");
14. }
15. }
Which are possible outputs? (Choose all that apply.)
多选题Given the proper imports, and given:
24. Date d1 = new Date();
25. Date d2 = d1;
26. System.out.println(d1);
27. d2.setTime(d1.getTime() + (7 * 24 * 60 * 60));
28. System.out.println(d2);
Which are true? (Choose all that apply.)
多选题使用如下的SQL语句将完成哪一种类型的连接? SELECT i.id_number, m.manufacturer_id FROM inventory i, inventory m WHERE i.manufacturerl_id=m.region_id_number; A.自连接(SelfJoin) B.外连接(Outer Join) C.相等连接(Equi Join) D.不相等连接(Non-equijoin)
多选题在基于运行实例复制数据库时,关于源数据库和辅助数据库实例的状态,哪个说法是正确的?
多选题要创建一个报表,这个报表将显示那些信用限额大于所有客户平均信用限额的客户,应使用如下的哪个查询语句?
多选题请看如下的SQL语句,执行这个语句时将失败,请问怎样修改可以解决这一问题?
SELECT c.customer_id, o.order_id, o.order_date, p.product_name
FROM customer c, curr_order o, product p
WHERE customer.customer_id=curr_order.customer_id
AND oproduct_id=p.product_id
ORDER BY o.ordei_amount;
多选题当事务的一部分不能再供撤消表空间使用时,FLASHBACK_TRANSACTION_QUERY中的行会发生什么情况?
多选题SPFILE包含以下参数值:
LOG_ARCHIVE_DEST_1="LOCATION=/u01/app/oracle/arch"
LOG_ARCHIVE_DEST_2=
"LOCATION=/u03/app/oracle/arch MANDATORY"
LOG_RCHIVE_DEST_3="SERVICE=STNDBY_CLEVELAND MANDATORY"
LOG_ARCHIVE_MIN_SUCCEED_DEST=1
此处并没有使用快速恢复区。包含/u03/app/oracle/arch目录的磁盘驱动器失败。归档进程和数据库会发生什么情况?
多选题使用如下的SQL语句查询数据库:
SELECT CONCAT (UPPER (SUBSTR (location, 1, 3) ), dept_number) "Department Location"
FROM department;
最后一个求值的函数是哪一个?
多选题Given:
2. class Chilis {
3. Chilis(String c, int h) {color = c; hotness = h; }
4. String color;
5. private int hotness;
6. public boolean equals(Object o) {
7. Chilis c = (Chilis)o;
8. if(color.equals(c.color)
9. return false;
10. }
11. // insert code here
12. }
Which, inserted independently at line 11, fulfill the equals() and hashCode() contract for Chilis? (Choose all that apply.)
多选题可以基于以下的哪两个对象创建一个视图? A.视图 B.查询 C.表 D.命令 E.事务(transaction)
多选题Given the proper import(s), and given:
13. class NameCompare implements Comparator<Stuff> {
14. public int compare(Stuff a, Stuff b) {
15. return b.name.compareTo(a.name);
16. } }
18. class ValueCompare implements Comparator<Stuff> {
19. public int compare(Stuff a, Stuff b) {
20. return (a.value - b.value);
21. } }
Which are true? (Choose all that apply.)
多选题Given:
2. import rt.utils.Remote;
3. public class Controller{
4. public static void main(String[] args) {
5. Remote remote = new Remote();
6. } }
And rt.utils.Remote class is properly bundled into a JAR file called rtutils.jar.
And given the following steps:
P. Place rtutils.jar in the $ROOT directory.
Q. Extract rtutils.jar and put rt directory with its subdirectories in the $ROOT directory.
R. Extract rtutils.jar and place Remote.class in the $ROOT directory.
S. Place rtutils.jar in the $JAVA HOME/jre/lib/ext directory.
X. Compile using: javac -cp rtutils.jar Controller.java
Y. Compile using: javac Controller.java
Z. Compile using: javac -cp. Controller.java
If Controller.java resides in the $ROOT directory, which set(s) of steps will compile the Controller class? (Choose all that apply.)
多选题Given the proper import(s), and this code in a method:
4. List<String> x = new LinkedList<String>();
5. Set<String> hs = new HashSet<String>();
6. String[] v = {"a", "b", "c", "b", "a"};
7. for(String s: v) {
8. x.add(s); hs.add(s);
9. }
10. System.out.print(hs.size() + " " + x.size() + " ");
11. HashSet hs2 = new HashSet(x);
12. LinkedList x2 = new LinkedList(hs);
13. System.out.println(hs2.size() + " " + x2.size());
What is the result?
多选题Given:
2. public class Salmon extends Thread {
3. public static long id;
4. public void run() {
5. for(int i = 0; i<4; i++) {
6. // insert code here
7. new Thread(new Salmon()) .start();
8. throw new Error();
9. }
10. System.out.print (i +" ");
11. } }
12. public static void main(String[] args) {
13. Thread t1 = new Salmon();
14. id = t1.getId();
15. t1.start ();
16. } }
And the two code fragments:
Ⅰ. if(i == 2 && id == Thread.currentThread().getId()) {
Ⅱ. if(i == 2) {
When inserting either fragment, independently at line 6, which are true? (Choose all that apply.)
多选题下列哪些数据库对象总会在系统容器内的所有PDB之间共享?
多选题Given:
1. class MyException extends RuntimeException { }
2. public class Houdini {
3. public static void main(String[] args) throws Exception
4. throw new MyException();
5. System.out.println("success");
6. } }
Which are true? (Choose all that apply.)
