分类：
2010-02-19 10:54:25
春节之后需要考1z0-051的看过来，killtest提供最新的题库下载，希望需要通过考试的有空去看看。
这里我就笑笑地分享一下里面的题目：
1. Which two statements are true regarding savepoints? (Choose two.)
A.Savepoints are effective only for COMMIT.
B.Savepoints may be used to ROLLBACK.
C.Savepoints can be used for only DML statements.
D.Savepoints are effective for both COMMIT and ROLLBACK.
E.Savepoints can be used for both DML and DDL statements.
Answer: BC
2. View the Exhibit to examine the description for the SALES table.
Which views can have all DML operations performed on it? (Choose all that apply.)
A.CREATE VIEW v3
B.CREATE VIEW v1
C.CREATE VIEW v2
D.CREATE VIEW v4
Answer: AB
3. You need to extract details of those products in the SALES table where the PROD_ID column contains
the string '_D123'.
Which WHERE clause could be used in the SELECT statement to get the required output?
A.WHERE prod_id LIKE '%_D123%' ESCAPE '_'
B.WHERE prod_id LIKE '%\_D123%' ESCAPE '\'
C.WHERE prod_id LIKE '%_D123%' ESCAPE '%_'
D.WHERE prod_id LIKE '%\_D123%' ESCAPE '\_'
Answer: B
4. Which two statements are true regarding single row functions? (Choose two.)
The safer , easier way to help you pass any IT exams.
3 / 8
A.They accept only a single argument.
B.They can be nested only to two levels.
C.Arguments can only be column values or constants.
D.They always return a single result row for every row of a queried table.
E.They can return a data type value different from the one that is referenced.
Answer: DE
5. Which SQL statements would display the value 1890.55 as $1,890.55? (Choose three.)
A.SELECT TO_CHAR(1890.55,'$0G000D00')
B.SELECT TO_CHAR(1890.55,'$9,999V99')
C.SELECT TO_CHAR(1890.55,'$99,999D99')
D.SELECT TO_CHAR(1890.55,'$99G999D00')
E.SELECT TO_CHAR(1890.55,'$99G999D99')
Answer: ADE
6. Which statement is true regarding transactions? (Choose all that apply.)
A.A transaction can consist only of a set of DML and DDL statements.
B.A part or an entire transaction can be undone by using ROLLBACK command.
C.A transaction consists of a set of DML or DCL statements.
D.A part or an entire transaction can be made permanent with a COMMIT.
E.A transaction can consist of only a set of queries or DML or DDL statements.
Answer: BC
7. Which two statements are true regarding the USING and ON clauses in table joins? (Choose two.)
A.Both USING and ON clauses can be used for equijoins and nonequijoins.
B.A maximum of one pair of columns can be joined between two tables using the ON clause.
C.The ON clause can be used to join tables on columns that have different names but compatible data
types.
D.The WHERE clause can be used to apply additional conditions in SELECT statements containing the
ON or the USING clause.
想下载更多的题库资料，您可以登录 进行下载。
