多选题如要更改一个视图但是不想重新授予已经授予该视图的对象权限,请问使用如下的哪个命令?
多选题Given:
2. import java.util.*;
3. public class VLA implements Comparator<VLA> {
4. int dishSize;
5. public static void main(String[] args) {
6. VLA[] va = {new VLA(40), new VLA(200), new VLA(60)};
7.
8. for(VLA v: va) System.out.print(v.dishSize + " ");
9. int index = Arrays.binarySearch(va, new VLA(60), va[0]);
10. System.out.print(index + " ");
11. Arrays. sort (va);
12. for(VLA v: va) System.out.print(v.dishSize + " ");
13. index = Arrays.binarySearch(va, new VLA(60), va[0]);
14. System.out.println (index);
15. }
16. public int compare(VLA a, VLA b) {
17. return a.dishSize - b.dishSize;
18. }
19. VLA(int d) {dishSize = d; }
20. }
Which result is most likely?
多选题使用哪个字符函数来返回一个值中字符的个数? A.NVL B.SUBSTR C.LENGTH D.CONCAT E.INITCAP
多选题在以下的语句中,哪一个将移除一个主键和依赖于这个主键的所有约束? A.ALTER TABLE table DROP PRIMARY KEY CASECADE; B.ALTER TABLE table REMOVE CONSTRAINT PRIMARY KEY CASCADE; C.ALTER TABLE table DISABLE CONSTRAINT PRIMARY KEY CASCADE; D.一个主键不能被移除
多选题在一个使用了“<>”操作符的子查询中可以返回多少个值?
多选题要从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.)