Saturday, August 24, 2013

www.it-exams.com,test dumps, practice test, pdf 1Z0-047 Oracle it-exams

www.it-exams.com,test dumps, practice test, pdf 1Z0-047 Oracle it-exams www.it-exams.com,test dumps, practice test, pdf 1Z0-047 Oracle it-exams IT Exam,IT Certification,braindump,original questions, question pool,document, braindump, test questions, test question, dumps, test answers, it-exams.com, preparation, pdf, certification questions, answers Certification, certification test, practice test, exam dumps, certification training, answers real questions
1Z0-047 Oracle Database SQL Expert We believe in helping our customers achieve their goals. For this reason, we take great care while preparing our Questions and Answers , Core Administration. Our practice tests Administration are prepared with the help of highly professional people from the industry, so we benefit from their vast experience and knowledge. www.it-exams.com,test dumps, practice test, pdf 1Z0-047 Oracle it-exams 1.Which two statements are true regarding the types of table joins available in Oracle Database 10g? (Choose two.) A.You can use the JOIN clause to join only two tables. B.You can explicitly provide the join condition with a NATURAL JOIN. C.You can use the USING clause to join tables on more than one column. D.You can use the ON clause to specify multiple conditions while joining tables. Correct:C D 2.Which two statements are true regarding subqueries? (Choose two.) A.The ORDER BY clause can be used in the subquery. B.A subquery can be used in the FROM clause of a SELECT statement. C.If the subquery returns NULL, the main query may still return result rows. D.A subquery can be placed in a WHERE clause, GROUP BY clause, or a HAVING clause. E.Logical operators, such as AND, OR and NOT, cannot be used in the WHERE clause of a subquery. Correct:A B 3.Evaluate the following SQL statements in the given order: DROP TABLE dept; CREATE TABLE dept (deptno NUMBER(3) PRIMARY KEY, deptname VARCHAR2(10)); DROP TABLE dept; FLASHBACK TABLE dept TO BEFORE DROP; Which statement is true regarding the above FLASHBACK operation? A.It recovers only the first DEPT table. B.It recovers only the second DEPT table. C.It does not recover any of the tables because FLASHBACK is not possible in this case. D.It recovers both the tables but the names would be changed to the ones assigned in the RECYCLEBIN. Correct:B 4.Given below is a list of functions and their purpose in random order. Function Purpose 1)NVL a) Used for evaluating NOT NULL and NULL values 2)NULLIF b) Used to return the first non- null values in a list of expressions 3)COALESCE c) Used to compare two expressions. If both are same, it returns NULL; otherwise, it returns only the first expression. 4)NVL2 d) Used to convert NULL values to actual values Identify the correct combination of functions and their usage. A.1-a, 2-c, 3-b, 4-d B.1-d, 2-c, 3-b, 4-a C.1-b, 2-c, 3-d, 4-a D.1-d, 2-b, 3-c, 4-a Correct:B www.it-exams.com,test dumps, practice test, pdf 1Z0-047 Oracle it-exams www.it-exams.com,test dumps, practice test, pdf 1Z0-047 Oracle it-exams www.it-exams.com,test dumps, practice test, pdf 1Z0-047 Oracle it-exams IT Exam,IT Certification,braindump,original questions, question pool,document, braindump, test questions, test question, dumps, test answers, it-exams.com, preparation, pdf, certification questions, answers Certification, certification test, practice test, exam dumps, certification training, answers real questions
1Z0-047 Oracle Database SQL Expert We believe in helping our customers achieve their goals. For this reason, we take great care while preparing our Questions and Answers , Core Administration. Our practice tests Administration are prepared with the help of highly professional people from the industry, so we benefit from their vast experience and knowledge. www.it-exams.com,test dumps, practice test, pdf 1Z0-047 Oracle it-exams 1.Which two statements are true regarding the types of table joins available in Oracle Database 10g? (Choose two.) A.You can use the JOIN clause to join only two tables. B.You can explicitly provide the join condition with a NATURAL JOIN. C.You can use the USING clause to join tables on more than one column. D.You can use the ON clause to specify multiple conditions while joining tables. Correct:C D 2.Which two statements are true regarding subqueries? (Choose two.) A.The ORDER BY clause can be used in the subquery. B.A subquery can be used in the FROM clause of a SELECT statement. C.If the subquery returns NULL, the main query may still return result rows. D.A subquery can be placed in a WHERE clause, GROUP BY clause, or a HAVING clause. E.Logical operators, such as AND, OR and NOT, cannot be used in the WHERE clause of a subquery. Correct:A B 3.Evaluate the following SQL statements in the given order: DROP TABLE dept; CREATE TABLE dept (deptno NUMBER(3) PRIMARY KEY, deptname VARCHAR2(10)); DROP TABLE dept; FLASHBACK TABLE dept TO BEFORE DROP; Which statement is true regarding the above FLASHBACK operation? A.It recovers only the first DEPT table. B.It recovers only the second DEPT table. C.It does not recover any of the tables because FLASHBACK is not possible in this case. D.It recovers both the tables but the names would be changed to the ones assigned in the RECYCLEBIN. Correct:B 4.Given below is a list of functions and their purpose in random order. Function Purpose 1)NVL a) Used for evaluating NOT NULL and NULL values 2)NULLIF b) Used to return the first non- null values in a list of expressions 3)COALESCE c) Used to compare two expressions. If both are same, it returns NULL; otherwise, it returns only the first expression. 4)NVL2 d) Used to convert NULL values to actual values Identify the correct combination of functions and their usage. A.1-a, 2-c, 3-b, 4-d B.1-d, 2-c, 3-b, 4-a C.1-b, 2-c, 3-d, 4-a D.1-d, 2-b, 3-c, 4-a Correct:B www.it-exams.com,test dumps, practice test, pdf 1Z0-047 Oracle it-exams
Posted by at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)