Oracle Database: SQL Fundamentals I - 1Z1-051 FREE EXAM DUMPS QUESTIONS & ANSWERS]

Question 1

The STUDENT_GRADES table has these columns:
STUDENT_ID NUMBER(12)
SEMESTER_END DATE
GPA NUMBER(4,3)
The registrar requested a report listing the students' grade point averages (GPA) sorted from highest grade point average to lowest.
Which statement produces a report that displays the student ID and GPA in the sorted order requested by the registrar?

A. SELECT student_id, gpa FROM student_grades SORT ORDER BY gpa DESC; B. SELECT student_id, gpa FROM student_grades ORDER BY gpa; C. SELECT student_id, gpa FROM student_grades SORT ORDER BY gpa ASC; D. SELECT student_id, gpa FROM student_grades ORDER BY gpa DESC; E. SELECT student_id, gpa FROM student_grades SORT ORDER BY gpa; F. SELECT student_id, gpa FROM student_grades ORDER BY gpa ASC;

Discussion 0

Correct Answer: D Vote an answer

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

Question 2

The following data exists in the PRODUCTS table:
PROD_ID PROD_LIST_PRICE
123456 152525.99
You issue the following query:
SQL> SELECT RPAD(( ROUND(prod_list_price)), 10,'*')
FROM products
WHERE prod_id = 123456; What would be the outcome?

A. an error message B. 152526**** C. 152525** D. **152525.99

Discussion 0

Correct Answer: B Vote an answer

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

Question 3

Examine the structure of the EMPLOYEES table:

Which UPDATE statement is valid?

A. UPDATE employees
SET first_name = 'John'
SET last_name = 'Smith'
WHERE employee_id = 180; B. UPDATE employee
SET first_name = 'John', last_name = 'Smith'
WHERE employee_id = 180; C. UPDATE employees
SET first_name = 'John',
SET last_name = 'Smoth'
WHERE employee_id = 180; D. UPDATE employee
SET first_name = 'John'
AND last_name = 'Smith'
WHERE employee_id = 180;

Discussion 0

Correct Answer: B Vote an answer

Question 4

You are currently located in Singapore and have connected to a remote database in Chicago. You issue the following command:
Exhibit:

PROMOTIONS is the public synonym for the public database link for the PROMOTIONS table.
What is the outcome?

A. Number of days since the promo started based on the current Chicago data and time B. An error because the WHERE condition specified is invalid C. Number of days since the promo started based on the current Singapore data and time. D. An error because the ROUND function specified is invalid

Discussion 0

Correct Answer: A Vote an answer

Question 5

View the Exhibit and examine the structure of the SALES table.
The following query is written to retrieve all those product IDs from the SALES table that have more than 55000 sold and have been ordered more than 10 times.

Which statement is true regarding this SQL statement?

A. It executes successfully but produces no result because COUNT(prod_id) should be usedinstead of COUNT(*). B. It executes successfully and generates the required result. C. It produces an error because COUNT(*) should be only in the HAVING clause and not in the WHERE clause. D. It produces an error because COUNT(*) should be specified in the SELECT clause also.

Discussion 0

Correct Answer: C Vote an answer

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

Question 6

Examine the structure proposed for the TRANSACTIONS table:

Which two statements are true regarding the storage of data in the above table structure? (Choose two.)

A. The CUST_STATUS column would allow storage of data up to the maximum VARCHAR2 size of 4,000 characters. B. The TRANS_DATE column would allow storage of dates only in the dd-mon-yyyy format. C. The TRANS_VALIDITY column would allow storage of a time interval in days, hours, minutes, and seconds. D. The CUST_CREDIT_VALUE column would allow storage of positive and negative integers.

Discussion 0

Correct Answer: C,D Vote an answer

Question 7

Which three tasks can be performed using SQL functions built into Oracle Database? (Choose three.)

A. Substituting a character string in a text expression with a specified string B. Finding the number of characters in an expression C. Combining more than two columns or expressions into a single column in the output D. Displaying a date in a nondefault format

Discussion 0

Correct Answer: A,B,D Vote an answer

Question 8

Which SQL statement accepts user input for the columns to be displayed, the table name, and WHERE condition?

A. SELECT &1, &2
FROM &3
WHERE last_name = '&4'; B. SELECT &1, '&2'
FROM &3
WHERE '&last_name = '&4' '; C. SELECT &1, '&2'
FROM EMP
WHERE last_name = '&4'; D. SELECT &1, "&2"
FROM &3
WHERE last_name = '&4';

Discussion 0

Correct Answer: A Vote an answer

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

Question 9

Evaluate the following SQL statements:
DELETE FROM sales;
There are no other uncommitted transactions on the SALES table.
Which statement is true about the DELETE statement?

A. It removes all the rows as well as the structure of the table B. It removes all the rows in the table and deleted rows cannot be rolled back C. It would not remove the rows if the table has a primary key D. It removes all the rows in the table and deleted rows can be rolled back

Discussion 0

Correct Answer: D Vote an answer

Question 10

The EMPLOYEES table contains these columns:
EMPLOYEE_ID NUMBER(4)
LAST_NAME VARCHAR2 (25)
JOB_ID VARCHAR2(10)
You want to search for strings that contain 'SA_' in the JOB_ID column. Which SQL statement do you use?

A. SELECT employee_id, last_name, job_id FROM employees WHERE job_id LIKE '%SA_'; B. SELECT employee_id, last_name, job_id FROM employees WHERE job_id LIKE '%SA_' ESCAPE "\"; C. SELECT employee_id, last_name, job_id FROM employees WHERE job_id = '%SA_'; D. SELECT employee_id, last_name, job_id FROM employees WHERE job_id LIKE '%SA\_' ESCAPE '\';

Discussion 0

Correct Answer: D Vote an answer

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

Question 11

The CUSTOMERS table has the following structure: Exhibit:

You need to write a query that does the following task:
*Display the first name and tax amount of the customers. Tax is 5% of their credit limit
*Only those customers whose income level has a value should be considered
*Customers whose tax amount is null should not be considered
Which statement accomplishes all the required tasks?

A. SELECT cust_first_name, cust_credit_limit * .05 AS TAX_AMOUNT FROM customers WHERE cust_income_level IS NOT NULL AND tax_amount IS NOT NULL; B. SELECT cust_first_name, cust_credit_limit * .05 AS TAX_AMOUNT FROM customers WHERE (cust_income_level,tax_amount) IS NOT NULL; C. SELECT cust_first_name, cust_credit_limit * .05 AS TAX_AMOUNT FROM customers WHERE cust_income_level <> NULL AND tax_amount <> NULL; D. SELECT cust_first_name, cust_credit_limit * .05 AS TAX_AMOUNT FROM customers WHERE cust_income_level IS NOT NULL AND cust_credit_limit IS NOT NULL;

Discussion 0

Correct Answer: D Vote an answer