Oracle071-136题.pdf
5墨值下载
1. Examine the description of the EMPLOYEES table:
Which query is valid?
A) SELECT dept_id, join_date, SUM (salary) FROM employees GROUP BY dept_id, join_date;
B) SELECT dept_id, join_date, SUM (salary) FROM employees GROUP BY
dept_id;
C) SELECT dept_id, MAX (AVG (Salary)) FROM employees GROUP BY dept_id
D) SELECT dept_id, AVG (MAX (salary)) FROM employees GROUP BY dept_id,
答案:A
2. Which three are true about the CREATE TABLE command?
A) It can include the CREATE..INDEX statement for creating an index to enforce the primary
key constraint.
B) The owner of the table should have space quotas available on the tablespace where the
table is defined.
C) It implicitly executes a commit.
D) It implicitly rolls back any pending transactions.
E) A user must have the CREATE
ANY
TABLE privilege to create tables.
F) The owner of the table must have the UNLIMITED TABLESPACE System privilege.
答案:ABC
3.
The customers table has a CUST_CREDIT_LIMIT column of data type NUMBER.
Which two
queries execute successfully?
A.
SELECT TO_CHAR
(NVL
(CUST_CREDIT_LIMIT
* .15, ‘NOT AVAILABLE’)) FROM
CUSTOMERS;
B. SELECT NVL2 (CUST_CREDIT_LIMIT * .15, ‘NOT AVAILABLE’) FROM CUSTOMERS
C. SELECT NVL (CUST_CREDIT_LIMIT * .15,
‘NOT AVAILABLE’) FROM
CUSTOMERS
D. SELECT NVL (TO_CHAR (CUST_CREDIT_LIMIT * .15), ‘NOT AVAILABLE’) FROM
CUSTOMERS
E. SELECT NVL2 (CUST_CREDIT_LIMIT, TO_CHAR (CUST_CREDIT_LIMIT * .15), ‘NOT
AVAILABLE’) FROM CUSTOMERS
答案:DE
4. Examine the description of the PRODUCT_DETAILS table:
Which two statements are true?
A) PRODUCT_ID can be assigned the PRTMARY REY constraint:
B) EXPTRY_DATE cannot be used in arithmetic expressions.
C) EXPTRY_DATE contains the SYSDATE by default if no date is assigned to it.
D) PRODUCT_ PRICE can be used
in an arithmetic expression even if it has no value stored
in it.
E) PRODUCT_ PRICE contains the value zero by default if no value is assigned to it
F)
PRODUCT_ NAME
cannot contain duplicate values
答案:AD
5.
The customers table has a CUST_LAST_NAME column
of data type varchar2
The table has two rows whose CUST_LAST_NAME values are Anderson and Ausson.
Which query produces output for CUST_LAST_NAME containing
Oder for the first row
and Aus for the second?
A.SELECT REPLACE (REPLACE
(CUST_LAST_NAME,’son’,’’),’AN’,’O’) FROM
CUSTOMERS
B.SELECT REPLACE (TRIM (TRAILING ’son’ FROM CUST_LAST_NAME), ’AN’,’O’)
FROM CUSTOMERS
C.SELECT INITCAP (REPLACE (TRIM (‘SON’FROM CUST_LAST_NAME), ’AN’,’O’))
FROM CUSTOMERS
D.SELECT REPLACE (SUBSTR (CUST_LAST_NAME,
-3), ’AN’, ’O’)) FROM CUSTOMERS
答案:A
6. Which three statements are true about indexes and their administration in an oracle
database?
A) An INVISIBLE index is not maintained when Data Manipulation Language (DML) is
performed on its
underlying table.
B) An index can be created as part of a CREATE TABLE statement
C) A DROP INDEX statement always prevents updates to the table during the drop
operation.
D) A UNIOUE and non-unique index
can be created on the same table column.
E) A descending index is a type of function-based index
F) It a query filters on an indexed column then it will always be used during execution of the
query
答案:BCE
7. Which three are true about granting object privilege on tables, views, and sequences?
A) UPDATE can
be granted only on tables and views.
of 44
5墨值下载
【版权声明】本文为墨天轮用户原创内容，转载时必须标注文档的来源（墨天轮），文档链接，文档作者等基本信息，否则作者和墨天轮有权追究责任。如果您发现墨天轮中有涉嫌抄袭或者侵权的内容，欢迎发送邮件至：contact@modb.pro进行举报，并提供相关证据，一经查实，墨天轮将立刻删除相关内容。
下载排行榜
评论