多选题在以下的工作中,哪一个不能使用ALTER INDEX命令来完成? A.合并一个索引的碎片 B.重建一个联机的索引 C.将一个索引移动到一个不同的表空间 D.使用RESIZE关键字改变一个现有索引的大小
多选题请问SQL*Plus命令“SET LINESIZE 68”将完成以下的哪项工作? A.将每页所输出行数指定为68 B.将LONG值的最大显示宽度设置为68 C.将报告的每行设置为68个字符 D.将一个查询所返回的最大记录数设置为68
多选题为了恢复数据库,需要用到以下哪一类文件(该文件存储了数据库中所做的所有修改)? A.数据文件 B.控制文件 C.重做目志文件 D.参数文件
多选题见下表SERVICE,如果使用如下的SQL语句对数据库进行查询,这个语句在执行时将会失败。要如何修改语句才能纠正这一问题?SELECTmachine_id"Machine",technician_id"Technician",service_date"LastServiceDate"FROMserviceWHERE"Machine">700000ORDERBY"Technician";A.在ORDERBY子句中必须指定ASC或DESC的排序顺序B.从WHERE子句中去掉列的别名而使用真正的列名C.从ORDERBY子句中去掉列的别名而使用真正的列名D.将所有括住的列别名的双引号全部改成单引号
多选题Given the proper imports, and given:
17. public void go() {
18. NumberFormat nf, nf2;
19. Number n;
20. Locale[] la = NumberFormat.getAvailableLocales();
21. for(int x=0; x < 10; x++) {
22. nf = NumberFormat.getCurrencyInstance(la[x]);
23. System.out.println(nf.format(123.456f));
24. }
25. nf2 = NumberFormat.getInstance();
26. n = nf2.parse("123.456f");
27. System.out.println(n);
28. }
Given that line 20 is legal, which are true? (Choose all that apply.)
多选题Given:
3. class Bonds {
4. Bonds force() {return new Bonds(); }
5. }
6. public class Covalent extends Bonds {
7. Covalent force() {return new Covalent(); }
8. public static void main(String[] args) {
9. new Covalent() .go(new Covalent());
10. }
11. void go(Covalent c) {
12. go2(new Bonds() .force(), c.force());
13. }
14. void go2(Bonds b, Covalent c) {
15. Covalent c2 = (Covalent)b;
16. Bonds b2 = (Bonds)c;
17. } }
What is the result? (Choose all that apply.)
多选题superdog数据库的初始化参数remote_login_passwordfile被设置为了EXCLUSIVE,如要确定被授予了SYSDBA或SYSOPER权限的用户,应该查询哪一个数据字典? A.V$DATABASE B.V$INSTANCE C.V$PARAMETER D.V$PWFILE_USERS
多选题以下的哪个字符可以在表名中使用? A.% B.* C.@ D.#
多选题Given:
2. public class Contact {
3. private String name;
4. private String city;
5. String getName() {return name; }
6. void setName(String n) {name = n; }
7. void setCity(String c) {
8. if(c == null) throw new NullPointerException();
9. city = c;
10. }
11. String getCity() {return city; }
12. }
Which are true? (Choose all that apply.)
多选题使用分组函数可完成以下的哪个操作?
多选题下列关于本地角色和公共角色的哪个陈述是不正确的?
多选题Given:
2. import java.util.regex.*;
3. public class Decaf {
4. public static void main(String[] args)
5. Pattern p = Pattern.compile(args[0]);
6. Matcher m = p.matcher(args[1]);
7. while (m.find())
8. System.out.print(re.group() + " ");
9. } }
And the three command-line invocations:
Ⅰ. java Decaf "0([0-7])?" "1012 0208 430"
Ⅱ. java Decaf "0([0-7])*" "1012 0208 430"
Ⅲ. java Decaf "0([0-7])+" "1012 0208 430"
Which are true? (Choose all that apply.)
多选题在以下有关Oracle约束的陈述中,哪4个是正确的?
多选题Given:
2. class Noodle {
3. String name;
4. Noodle(String n) {name = n; }
5. }
6. class AsianNoodle extends Noodle {
7. public boolean equals(Object o) {
8. AsianNoodle n = (AsianNoodle)o;
9. if (name.equals(n.name)) return true;
10. return false;
11. }
12. public int hashCode() {return name.length(); }
13. AsianNoodle(String s) {super(s); }
14. }
15. public class Soba extends AsianNoodle {
16. public static void main(String[] args) {
17. Noodle n1 = new Noodle ("bob"); Noodle n2 = new Noodle ("bob");
18. AsianNoodle a1 = new AsianNoodle("fred");
19. AsianNoodle a2 = new AsianNoodle("fred");
20. Soba s1 = new Soba("ji11"); Soba s2 = new Soba("ji11");
21. System.out.print(n1.equals(n2) + " " + (n1 == n2) + " | "
22. System.out.print(a1.equals(a2) + " " + (a1 == a2) + " | "
23. System.out.println(s1.equals(s2) + " " + (s1 == s2));
24. }
25. Soba(String s) {super(s); }
26. }
What is the result?
多选题Given:
3. import java.io.*;
4. class ElectronicDevice {ElectronicDevice() {System.out.print("ed "); }}
5. class Mp3player extends ElectronicDevice implements Serializable {
6. Mp3player() {System.out.print("mp "); }
7. }
8. class MiniPlayer extends Mp3player {
9. MiniPlayer() {System.out.print("mini "); }
10. public static void main(String[] args) {
11. MiniPlayer m = new MiniPlayer();
12. try {
13. FileOutputStream fos = new FileOutputStream("dev.txt");
14. ObjectOutputStream os = new ObjectOutputStream(fos);
15. os.writeObject(m); os.close();
16. FileInputStream fis = new FileInputStream("dev.txt");
17. ObjectInputStream is = new ObjectInputStream(fis);
18. MiniPlayer m2 = (MiniPlayer) is.readObject(); is.close();
19. } catch (Exception x) {System.out.print("x "); }
20. } }
What is the result?
多选题Given:
3. public class Fortran {
4. static int bump(int i) {return i + 2; }
5. public static void main(String[] args)
6. for(int x = 0; x < 5; bump(x))
7. System.out.print(x + " ");
8. } }
What is the result?
多选题以下是产品(PRODUCT)表中的数据:
PRODUCT
ID NUMBER
DESCRIPTION
MANUFACTURER ID
QUANTITY
COST
215
AAA 6pk-battery
NF10032
546
3.00
140
AA 2pk-battery
EL7968
2000
603
D 2pk-battery
OT456
318
1.10
725
C 2pk-battery
OT456
239
.75
218
AAA 6pk-battery
OT456
980
3.25
220
AAA 8pk-battery
NF10032
4.20
126
AA 2pk-battery
NF10032
2513
751
C 2pk-battery
EL7968
84
100
SELECT description, quantity, cost
FROM product
WHERE manufacturer_id LIKE "NF10032"
AND NVL(cost, 0)<5.00
ORDER BY quantity DESC, cost;
以上的查询语句将产生如下的哪个结果?
多选题下列命令中,哪个是SQL*Plus命令? A.UPDATE B.CHANGE C.SELECT D.ALTER TABLE
多选题Given:
2. public class Wacky {
3. public static void main(String[] args) {
4. int x = 5;
5. int y = (x < 6) ? 7 : 8;
6. System.out.print(y + " ");
7. boolean b = (x < 6) ? false : true;
8. System. out .println (b + " ");
9. assert(x < 6) : "bob";
10. assert( ((x < 6) ? false : true) ) : "fred";
11. } }
And, if the code compiles, the invocation:
java -ea Wacky
Which will be contained in the output? (Choose all that apply.)
多选题对于一个CHAR类型的列,以下哪个是它的默认长度? A.1 B.8 C.38 D.128 E.250 F.2000