多选题假设丢失了所有联机控制文件。请指出以下任务的正确顺序：
1．从备份还原控制文件，或者运行CREATE CONTROLFILE
2．开始恢复数据库，并指定关键字BACKUP CONTROLFILE
3．在MOUNT模式下启动数据库
4．使用RESETLOGS打开数据库
5．关闭数据库
多选题请评估以下这个SQL*Plus命令：
START supercat. sql
下列SQL*Plus命令中的哪个将与上述命令获取相同的结果?
多选题Given:
3. public class States {
4. static String s;
5. static Boolean b;
6. static Boolean t1() {return new Boolean("howdy");
7. static boolean t2() {return new Boolean(s); }
8. public static void main(String[] args) {
9. if(t1()) System.out.print("t1 ");
10. if(!t2()) System.out.print("t2 ");
11. if(t1() != t2()) System.out.print("!= ");
12. }
13. }
Which are true? (Choose all that apply.)
多选题Given:
2. import java.util.*;
3. public class AndOver {
4. public static void main(String[] args) {
5. List g = new ArrayList();
6. g.add(new Gaited("Eyra"));
7. g.add(new Gaited("Vafi"));
8. g.add(new Gaited("Andi"));
9. Iterator i2 = g.iterator();
10. while(i2.hasNext()) {
11. System.out.print(i2.next().name + " ");
12. } } }
13. class Gaited {
14. public String name;
15. Gaited(String n) {name = n; }
16. }
What is the result?
多选题Given:
1. import java.io.*;
2. import java.util.*;
3. import static java.lang. Short.*;
4. import static java.lang. Long.*;
5. public class MathBoy {
6. public static void main(String[] args) {
7. long x = 123456789;
8. short y = 22766; // maximum value of a short is 32767
9. System.out.printf("%1$+10d %2$010d ", x, MAX VALUE - y);
10. System.out.println(new Date());
11. }
12. }
Which are true? (Choose all that apply.)
多选题Given two files:
1. package com. wickedlysmart;
2. import com.wickedlysmart2.*;
3. public class Launcher {
4. public static void main(String[] args) {
5. Utils u = new Utils();
6. u.do1();
7. u.do2();
8. u.do3();
9. } }
and the correctly compiled and located:
1. package com.wickedlysmart2;
2. class Utils {
3. void do1() {System.out.print("dol "); }
4. protected void do2() {System.out.print("do2 ");
5. public void do3() {System.out.print("do3 "); }
6. }
What is the result for Launcher? (Choose all that apply.)
多选题请看如下的创建视图PARTS_VIEW的DDL语句：
CREATE OR REPLACE parts_view
AS
SELECT manufacturer_id, COUNT (part_id) TOTAL_PARTS
FROM parts
GROUP BY manufacturer_id;
基于以上PARTS_VIEW视图，可以使用如下哪个SQL语句?
多选题如果LGWR经常因为检查点没有完成而等待一个重做日志组，应该采取以下的哪一个措施? A．添加一个重做日志组 B．添加一个重做日志成员 C．减少一个重做日志成员 D．清除当前的重做日志组 E．将数据库置为非归档模式
多选题在以下的SQL语句中，哪一个将显示目前无效的(invalid)所有位图索引的名字? A．SELECT index_name, tablespace_name, index_type, status FROM dba_ind_columns WHERE status='INVALID'; B．SELECT index_name, tablespace_name, index_type, status FROM dba_indexes WHERE status='INVALID' AND index_type='BITMAP'; C．SELECT index_name, tabtespace_name, index_type, staus FROM dba_indexes WHERE status='INVALID'; D．SELECT tablespace_name, index_type, status FROM dba_indexes WHERE status='INVALID' AND index_type='BITMAP';
多选题Given:
2. import java.text.*;
3. public class Gazillion {
4. public static void main(String[] args) throws Exception {
5. String s = "123.456xyz";
6. NumberFormat nf = NumberFormat.getInstance();
7. System.out.println (nf.parse(s));
8. nf.setMaximumFractionDigits(2);
9. System.out.println (nf.format(s));
10. }
11. }
Which are true? (Choose all that apply.)
多选题Given a partial API:
Final class Items implements no interfaces and has one constructor:
Items (String name, int value)
And given that you want to make collections of Items objects and sort them (using classes and interfaces in java.lang or java.util), sometimes by name, and sometimes by value, which are true? (Choose all that apply.)
多选题Given:
2. class Mosey implements Runnable {
3. public void run() {
4. for(int i=0; i＜1000; i++) {
5. System.out.print(Thread.currentThread() .getId() +"-"+i+" ");
6. } } }
7. public class Stroll {
8. public static void main(String[] args) throws Exception {
9. Thread t1=new Thread(new Mosey());
10. //insert code here
11. }
12. }
Which of the following code fragments, inserted independently at line 10, will probably run most (or all) of the main thread"s run() method invocation before running most of the t1 thread"s run() method invocation? (Choose all that apply.)
多选题如果要在CAT数据库上创建一个用户并且调整DOG数据库，请问可以使用以下哪个图形工具来管理这两个数据库? A．SQL*Plus B．Oracle Enterprise Manager (EM) C．Oracle Universal Installer D．Oracle Database Configuration Assistant (DBCA)
多选题Given the proper import(s), and given:
4. public static void main(String[] args) {
5. List＜Integer＞ x = new ArrayList＜Integer＞();
6. x.add(new Integer(3));
7. doStuff (x);
8. for(Integer i: x)
9. System.out.print (i + " ");
10. }
11. static void doStuff(List y) {
12. y.add(new Integer(4));
13. y.add(new Float(3.14f));
14. }
What is the result? (Choose all that apply.)
多选题Given:
2. class Engine {
3. public class Piston {
4. static int count = 0;
5. void go() {System.out.print(" pump " + ++count); }
6. }
7. public Piston getPiston() {return new Piston(); }
8. }
9. public class Auto {
10. public static void main(String[] args) {
11. Engine e = new Engine();
12. // Engine.Piston p = e.getPiston();
13. e.Piston p = e.getPiston();
14. p.go(); p.go();
15. } }
In order for the code to compile and produce the output" pump 1 pump 2", which are true? (Choose all that apply.)
多选题运行以下命令创建完整数据库备份：
RMAN＞backup as copy database spfile plus archiVelog delete input;
其中的DELETE INPUT子句有什么作用?
多选题初始化参数DIAGNOSTIC_DEST的值是NULL，环境变量ORACLE_HOME被设置为/u01/app/oracle/product/12.1.0/db_1，环境变量ORACLE_BASE的值被设置为/u01/app/oracle。在启动时，Oracle会为DIAGNOSTIC_DEST指定什么值?
多选题如果在学生(STUDENT)表中的全部六列上都创建索引，将可能发生以下哪种情况? A．修改操作的速度可能提高 B．带有WHERE子句的查询可能会更慢 C．表上的修改操作可能更慢 D．基于这个表的所有查询语句可能更快
多选题Given:
2. public class Jail {
3. private int x=4;
4. public static void main (String[] args) {
5. protected int x=6;
6. new Jail() .new Cell() .slam();
7. }
8. class Cell {
9. void slam() {System.out.println ("throw away key" + x); }
10. }
11. }
Which are true? (Choose all that apply.)
多选题在以下有关只读表空间的语句中，哪一个是正确的? A．一个只读表空间中的对象是可以删除的 B．只读表空间不可以存储在CD-ROMs上 C．在每一次备份操作中必须包括只读表空间 D．可以使用ALTER DATABASE语句将一个表空间改为只读的