killtest 分享1z0-051题库资料下载

考试号：1Z0-051
认证名称：Oracle Database: SQL Fundamentals I
题目总数：155道
现在分享一下题库里面的部分题目，需要参加考试的可以看看。
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.)
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.
Answer: CD
以上只是部分的题库资料分享，如果需要下载更多的资料，你可以登录www.killtest.cn进行下载。在这里祝你考试早日通过。