Oracle 第12题和第13题判断的不知道对不对，还有其他题不知道做错了没有

Question

1. You query the database with this command:
   使用以下命令查询数据库：

SELECT id_number, (quantity-100/0.15-35+ 20)
FROM inventory;

Which expression is evaluated first?
首先计算哪个表达式？
A quantity+ 100
B.0.15-35
C.35+20
D.100/0.15

---

12 Which command would you use to remove all the rows from the isotope table and not allow rollback?
您将使用哪个命令从同位素表中删除所有行并且不允许回滚？
A .DROP TABLE isotope;
B .DELETE isotope
C. TRUNCATE TABLE isotope;
D. There is no way to remove all rows and not allow rollback(无法删除所有行并且不允许回滚)

---

1. When can an index be placed on a view?
   A. When you only SELECT from the view
   B. When you only DELETE from the view
   C .When there is a WITH CHECK OPTION used to create the view
   D .When you can UPDATE using the view
   E .Never

何时可以在视图上放置索引？
A.仅从视图中选择时
B仅从视图中删除时
C.使用WITH CHECK选项创建视图时
D.何时可以使用视图更新
E.永远不会

---

1. Examine the queries below carefully.
   Which one will return only the first 100 rows in the EMP table?
2. 仔细检查以下问题。
   哪一个只返回EMP表中的前100行？
   A SELECT TOP 100 EMPNO, ENAME FROM EMP WHERE STATE='FL'
   B SELECT FIRST 100 EMPNO, ENAME FROM EMP WHERE STATE='FL'
   C SELECT EMPNO, ENAME FROM EMP WHERE ROWID <=100
   D SELECT EMPNO, ENAME FROM EMP WHERE ROWNUM <=100,

---

1. On Monday, June 26, 2037, at 10: 30 at night, you issue the following statement against an Oracle database:
2. 2037年6月26日星期一晚上10:30，您针对Oracle数据库发出以下声明：
   ALTER SESSION SET NLS DATE FORMAT DAY MONTH DD, YYYY: HH: MIAM

Then, you issue the following statement
然后，你发表以下声明

SELECT SYSDATE FROM DUAL;

What will Oracle return?

A.26-JUN-37
B.June26,2037,22:30
C.26-JUN-2037
D MONDAY JUNE 26, 2037: 10: 30PM

---

1. The PRodUCT table contains these columns (PRodUCT表包含以下列)

ID NUMBER(7) PK
SALE PRICE NUMBER(7, 2)
Evaluate these two SQL statements

SELECT MAX(sale_price), MIN(sale_price), AVG(sale_price) FROM product;

SELECT ROUND(MAX(sale_ price), 2)
ROUND(MIN(sale_price), 2), ROUND(AVG(sale _price), 2)
FROM product GROUP BY sale_price;
How will the results differ

A. One of the statements will generate an error.
B Statement 2 will only display one row of result; ststement1 could display more than one
C Statement 1 will display three values; statement 2 will display three values for each sale price
D Statement 1 will display a result for each sale price; statement 2 will display a result for each product.
A.其中一条语句将生成错误。
B语句2只显示一行结果；ststement1可以显示多个
C语句1将显示三个值；语句2将为每个销售价格显示三个值
D报表1将显示每个销售价格的结果；语句2将显示每个产品的结果。

---

18.Examine the description of the STUDENTS table 检查STUDENTS表的描述

STD_ID NUMBER(4)
COURSE_ID VARCHAR2(10)
START_DATE DATE
END_DATE DATE

Which two aggregate functions are valid on the START DATE column?
在“开始日期”列中，哪两个聚合函数有效？

A .SUM(start_ date)
B .AVG(start_date)
C .AVG(start_date, end_date)
D .MIN(start_ date)
E .MAXIMUM(start date)

11题 D
12题 D
13题 A
14题 C
15题 D
17题 A
18题 CD