Latest Oracle 1Z1-051 Actual Free Exam Questions & Community Discussion, Page 1

Question #1

You are the DBA for an academic database. You need to create a role that allows a group of users to modify existing rows in the STUDENT_GRADES table.
Which set of statements accomplishes this?

A. CREATE ROLE registrar; GRANT MODIFY ON student_grades TO registrar; GRANT registrar to user1, user2, user3

B. CREATE ROLE registrar; GRANT UPDATE ON student_grades TO registrar; GRANT registrar to user1, user2, user3;

C. CREATE registrar; GRANT CHANGE ON student_grades TO registrar; GRANT registrar;

D. CREATE ROLE registrar; GRANT UPDATE ON student_grades TO registrar; GRANT ROLE registrar to user1, user2, user3

E. CREATE NEW ROLE registrar; GRANT ALL ON student_grades TO registrar; GRANT registrar to user1, user2, user3

Discussion 0

Correct Answer: B Vote an answer

Explanation: Only visible for EduDump members. You can sign-up / login (it's free).

Question #2

Examine the structure and data of the CUSTJTRANS table:
CUSTJRANS Name Null? Type CUSTNO NOT NULL CHAR(2) TRANSDATE DATE TRANSAMT NUMBER(6.2) CUSTNO
TRANSDATE TRANSAMT 11 01-JAN-07 1000 22 01-FEB-07 2000 33 01-MAR-07 3000
Dates are stored in the default date format dd-mon-rr in the CUSTJTRANS table. Which three SQL statements would execute successfully? (Choose three.)

A. SELECT * FROM custjrans WHERE transdate='01-JANUARY-07':

B. SELECT custno - 'A' FROM custjrans WHERE transamt > 2000:

C. SELECT * FROM custjrans WHERE transdate = '01-01-07':

D. SELECT transamt FROM custjrans WHERE custno > '11':

E. SELECT transdate + '10' FROM custjrans;

Discussion 0

Correct Answer: A,D,E Vote an answer

Question #3

Which three statements are true regarding the data types in Oracle Database 10g/11g? (Choose three.)

A. The BLOB data type column is used to store binary data in an operating system file

B. The value for a CHAR data type column is blank-padded to the maximum defined columnwidth

C. Only One LONG column can be used per table

D. The minimum column width that can be specified for a VARCHAR2 data type column is one

E. A TIMESTAMP data type column stores only time values with fractional seconds

Discussion 0

Correct Answer: B,C,D Vote an answer

Explanation: Only visible for EduDump members. You can sign-up / login (it's free).

Question #4

Examine the structure of the STUDENTS table:

You need to create a report of the 10 students who achieved the highest ranking in the course INT SQL and who completed the course in the year 1999.
Which SQL statement accomplishes this task?

A. SELECTstudent_id, marks, ROWID "Rank"
FROMstudents
WHEREROWID <= 10
ANDfinish_date BETWEEN '01-JAN-99' AND '31-DEC-99'
ANDcourse_id = 'INT_SQL'
ORDER BYmarks;

B. SELECTstudent_id, marks, ROWNUM "Rank"
FROM(SELECT student_id, marks
FROMstudents
WHEREROWNUM <= 10
ANDfinish_date BETWEEN '01-JAN-99' AND '31-DEC-
99'
ANDcourse_id = 'INT_SQL'
ORDER BYmarks DESC);

C. SELECTstudent id, marks, ROWNUM "Rank"
FROM(SELECT student_id, marks
FROM students
ORDER BY marks)
WHEREROWNUM <= 10
ANDfinish date BETWEEN '01-JAN-99' AND '31-DEC-99'
ANDcourse_id = 'INT_SQL';

D. SELECTstudent_ id, marks, ROWNUM "Rank"
FROMstudents
WHEREROWNUM <= 10
ANDfinish_date BETWEEN '01-JAN-99' AND '31-DEC-99
ANDcourse_id = 'INT_SQL'
ORDER BYmarks DESC;

E. SELECTstudent_id, marks, ROWNUM "Rank"
FROM(SELECT student_id, marks
FROMstudents
WHERE (finish_date BETWEEN '01-JAN-99 AND '31-DEC-99'
AND course_id = 'INT_SQL'
ORDER BY marks DESC)
WHEREROWNUM <= 10 ;

Discussion 0

Correct Answer: E Vote an answer

Question #5

The SQL statements executed in a user session as follows:
Exhibit:

Which two statements describe the consequence of issuing the ROLLBACK TO SAVE POINT a command in the session? (Choose two.)

A. Only the DELETE statements are rolled back

B. The rollback generates an error

C. Only the seconds DELETE statement is rolled back

D. Both the DELETE statements and the UPDATE statement are rolled back

E. No SQL statements are rolled back

Discussion 0

Correct Answer: B,E Vote an answer

Question #6

The PRODUCTS table has these columns:
PRODUCT_ID NUMBER(4)
PRODUCT_NAME VARCHAR2(45)
PRICE NUMBER(8,2)
Evaluate this SQL statement:
SELECT *
FROM PRODUCTS
ORDER BY price, product_name;
What is true about the SQL statement?

A. The results are sorted numerically and then alphabetically.

B. The results are sorted numerically.

C. The results are not sorted.

D. The results are sorted alphabetically.

Discussion 0

Correct Answer: A Vote an answer

Explanation: Only visible for EduDump members. You can sign-up / login (it's free).

Question #7

Evaluate the following SQL statements:
Exhibit:

Which is the correct output of the above query?

A. +00-300,+00-650,+00 11:12:10.123457

B. +00-300, +54-02,+00 11:12:10.123457

C. +25-00,+00-650,+00 11:12:10.123457

D. +25-00, +54-02, +00 11:12:10.123457

Discussion 0

Correct Answer: D Vote an answer

Question #8

Examine the description of the EMPLOYEES table:
EMP_ID NUMBER(4) NOT NULL
LAST_NAME VARCHAR2(30) NOT NULL
FIRST_NAME VARCHAR2(30)
DEPT_ID NUMBER(2)
Which statement produces the number of different departments that have employees with last name Smith?

A. SELECT DISTINCT(COUNT(dept_id)) FROM employees WHERE last_name='Smith';

B. SELECT UNIQUE(dept_id) FROM employees WHERE last_name='Smith';

C. SELECT COUNT(DISTINCT dept_id) FROM employees WHERE last_name='Smith';

D. SELECT COUNT (dept_id) FROM employees WHERE last_name='Smith';

E. SELECT COUNT(*) FROM employees WHERE last_name='Smith';

Discussion 0

Correct Answer: C Vote an answer

Question #9

View the Exhibit and examine the structure of ORDERS and CUSTOMERS tables. There is only one customer with the cus_last_name column having value Roberts. Which INSERT statement should be used to add a row into the ORDERS table for the customer whose CUST_LAST_NAME is Roberts and CREDIT_LIMIT is 600?

A. INSERT INTO(SELECT o.order_id. o.order_date.o.order_modex.customer_id. o.ordertotal FROM orders o. customers c WHERE o.customer_id = c.customerid AND c.cust_la$t_name-RoberTs' ANDc.credit_liinit=600) VALUES (L'10-mar-2007\ 'direct'.( SELECT customer_id FROM customers WHERE cust_last_iiame='Roberts' AND credit_limit=600). 1000);

B. INSERT INTO orders VALUES (l.'10-mar-2007\ 'direct'. (SELECT customerid FROM customers WHERE cust_last_iiame='Roberts' AND credit_limit=600). 1000);

C. INSERT INTO orders (order_id.order_date.order_mode. (SELECT customer_id FROM customers WHERE cust_last_iiame='Roberts' AND credit_limit=600).order_total)
VALUES(l.'10-mar-2007\ 'direct'. &customer_id. 1000):

D. INSERT INTO orders (order_id.order_date.order_mode. (SELECT customer id FROM customers WHERE cust_last_iiame='Roberts' AND redit_limit=600).order_total) VALUES(L'10-mar-2007'. 'direct', &&customer_id, 1000):

Discussion 0

Correct Answer: B Vote an answer

Question #10

View the Exhibits and examine the structures of the PRODUCTS SALES and CUSTOMERS tables.

You need to generate a report that gives details of the customer's last name, name of the product, and the quantity sold for all customers in Tokyo'. Which two queries give the required result? (Choose two.)

A. SELECT c.cust_id,c.cust_last_name,p.prod_id, p.prod_name, s.quantity_sold FROM products p
JOIN saless
USING(prod_id)
JOIN customers c
USING(cust_id)
WHERE c.cust_city='Tokyo';

B. SELECT c.cust_last_name,p.prod_name, s.quantity_sold FROM sales s JOIN products p USING(prod_id)
JOIN customers c
USING(cust_id)
WHERE c.cust_city='Tokyo';

C. SELECT c.cust_last_name, p.prod_name, s.quantity_sold
FROM products p JOIN sales s
ON(p.prod_id=s.prod_id)
JOIN customers c
ON(s.cust_id=c.cust_id)
AND c.cust_city='Tokyo';

D. SELECT c.cust_last_name, p.prod_name, s.quantity_sold
FROM products p JOIN sales s JOIN customers c
ON(p.prod_id=s.prod_id)
ON(s.cust_id=c.cust_id)
WHERE c.cust_city='Tokyo';

Discussion 0

Correct Answer: B,C Vote an answer

Question #11

The STUDENT_GRADES table has these columns:
STUDENT_ID NUMBER(12)
SEMESTER_END DATE
GPA NUMBER(4,3)
Which statement finds the highest grade point average (GPA) per semester?

A. SELECT (gpa) FROM student_grades GROUP BY semester_end WHERE gpa IS NOT NULL;

B. SELECT MAX(gpa) GROUP BY semester_end WHERE gpa IS NOT NULL FROM student_grades;

C. SELECT MAX(gpa) FROM student_grades WHERE gpa IS NOT NULL;

D. SELECT MAX(gpa) FROM student_grades GROUP BY semester_end WHERE gpa IS NOT NULL;

E. SELECT MAX(gpa) FROM student_grades WHERE gpa IS NOT NULL GROUP BY semester_end;

Discussion 0

Correct Answer: E Vote an answer

Explanation: Only visible for EduDump members. You can sign-up / login (it's free).

Question #12

Examine the structure of the EMPLOYEES and NEW_EMPLOYEES tables:

Which MERGE statement is valid?

A. name = e.first_name ||','|| e.last_name WHEN NOT MATCHED THEN INSERT value S(e.employee_id, e.first_name ||', '||e.last_name);

B. MERGE INTO new_employees c USING employees e ON (c.employee_id = e.employee_id) WHEN MATCHED THEN UPDATE SET

C. name = e.first_name ||','|| e.last_name WHEN NOT MATCHED THEN INSERT INTO new_employees valueS(e.employee_id, e.first_name ||', '||e.last_name);

D. name = e.first_name ||','|| e.last_name WHEN NOT MATCHED THEN INSERT valueS(e.employee_id, e.first_name ||', '||e.last_name);

E. name = e.first_name ||','|| e.last_name WHEN NOT MATCHED THEN INSERT value S(e.employee_id, e.first_name ||', '||e.last_name);

F. MERGE new_employees c USING employees e ON (c.employee_id = e.employee_id) WHEN EXISTS THEN UPDATE SET

G. MERGE new_employees c FROM employees e ON (c.employee_id = e.employee_id) WHEN MATCHED THEN UPDATE SET

H. MERGE INTO new_employees cUSING employees e ON (c.employee_id = e.employee_id) WHEN EXISTS THEN UPDATE SET

Discussion 0

Correct Answer: B Vote an answer

Explanation: Only visible for EduDump members. You can sign-up / login (it's free).

Question #13

A SELECT statement can be used to perform these three functions:
-Choose rows from a table.
-Choose columns from a table
-Bring together data that is stored in different tables by creating a link between them.
Which set of keywords describes these capabilities?

A. difference, projection, join

B. selection, projection, join

C. difference, projection, product

D. selection, intersection, join

E. intersection, projection, join

Discussion 0

Correct Answer: B Vote an answer

Explanation: Only visible for EduDump members. You can sign-up / login (it's free).

Oracle 1Z1-051 Actual Free Exam Questions & Community Discussion

Download Free Oracle 1Z1-051 Demo