Date: 2010-10-29 16:53 Author: pass4line Click: 73
$ 28.50 1Z0-051 Exam
Oracle Database: SQL Fundamentals I
Exam Number/Code : 1Z0-051
Exam Name : Oracle Database: SQL Fundamentals I
Questions and Answers : 175 Q&As
Update Time: 2010-10-29
Exam4test 1z0-051 Exam Description
If you use our Exam4test Oracle 1z0-051 dumps and fail the corresponding 1Z0-051 exam once within 90 days of purchase or within 90 days of receipt of the 1z0-051 product, which ever occurs latter. Contact Exam4test to claim this 1z0-051 guarantee, then the 1z0-051 dumps can be returned for a full refund.
Each 1z0-051 resource available from Exam4test has been hand crafted by our team of practicing 1z0-051 IT Professionals. Exam4test is certain that your Oracle 1Z0-051 Practice Exams, and Oracle 1z0-051 braindumps are the highest quality, and customized to make the Exam4test learning experience the best choice you can make in preparing for your 1z0-051 Certification.
Exam4test 1z0-051 is written to coincide with the real test by the experienced IT experts and specialists. With the complete collection of Exam4test 1Z0-051 Questions and Answers, Exam4test Oracle 1z0-051 exam is high enough to help the candidates to pass this 1z0-051 exam easily without any other study materials and no need to attend the expensive training.
With the Exam4test 1z0-051 practice exam you not only get 1z0-051 questions and answers, but you will also get qualified and accurate explanations so that you get a firm grasp of the Oracle 1z0-051 exam information.
Our 1z0-051 exam resources are constantly being revised and updated for relevance and accuracy. Prepare for your Oracle certification 1z0-051 exam today. Select the braindump you want to begin your training with 1Z0-051 exam materials, and pass your next exam.
Exam4test 1z0-051 Exam Dumps
Exam : Oracle 1Z0-051 Exam
Title : Oracle Database: SQL Fundamentals I
1. 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
AS SELECT * FROM SALES
WHERE cust_id = 2034
WITH CHECK OPTION;
B. CREATE VIEW v1
AS SELECT * FROM SALES
WHERE time_id <= SYSDATE - 2*365
WITH CHECK OPTION;
C. CREATE VIEW v2
AS SELECT prod_id, cust_id, time_id FROM SALES
WHERE time_id <= SYSDATE - 2*365
WITH CHECK OPTION;
D. CREATE VIEW v4
AS SELECT prod_id, cust_id, SUM(quantity_sold) FROM SALES
WHERE time_id <= SYSDATE - 2*365
GROUP BY prod_id, cust_id
WITH CHECK OPTION;
Answer: AB
2. View the Exhibit and examine the structure of the SALES, CUSTOMERS, PRODUCTS, and TIMES tables.
The PROD_ID column is the foreign key in the SALES table, which references the PRODUCTS table. Similarly, the CUST_ID and TIME_ID columns are also foreign keys in the SALES table referencing the CUSTOMERS and TIMES tables, respectively.
Evaluate the following CREATE TABLE command:
CREATE TABLE new_sales(prod_id, cust_id, order_date DEFAULT SYSDATE)
AS
SELECT prod_id, cust_id, time_id
FROM sales;
Which statement is true regarding the above command?
A. The NEW_SALES table would not get created because the DEFAULT value cannot be specified in the column definition.
B. The NEW_SALES table would get created and all the NOT NULL constraints defined on the specified columns would be passed to the new table.
C. The NEW_SALES table would not get created because the column names in the CREATE TABLE command and the SELECT clause do not match.
D. The NEW_SALES table would get created and all the FOREIGN KEY constraints defined on the specified columns would be passed to the new table.
Answer: B
3. Which two statements are true regarding single row functions? (Choose two.)
A. They a ccept only a single argument.
B. They c an be nested only to two levels.
C. Arguments can only be column values or constants.
D. They a lways return a single result row for every row of a queried table.
E. They c an return a data type value different from the one that is referenced.
Answer: DE
4. 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
5. Which SQL statements would display the value 1890.55 as $1,890.55? (Choose three .)
A. SELECT TO_CHAR(1890.55,'$0G000D00')
FROM DUAL;
B. SELECT TO_CHAR(1890.55,'$9,999V99')
FROM DUAL;
C. SELECT TO_CHAR(1890.55,'$99,999D99')
FROM DUAL;
D. SELECT TO_CHAR(1890.55,'$99G999D00')
FROM DUAL;
E. SELECT TO_CHAR(1890.55,'$99G999D99')
FROM DUAL;
Answer: ADE