Free Download Pass4sure and Lead2pass 1Z0-051 Exam Question with PDF & VCE (131-140)

QUESTION 131
In the CUSTOMERS table, the CUST_CITY column contains the value ‘Paris’ for the
CUST_FIRST_NAME ‘ABIGAIL’.
Evaluate the following query:
SQL> SELECT INITCAP(cust_first_name || ‘ ‘ ||
UPPER(SUBSTR(cust_city,-LENGTH(cust_city),2)))
FROM customers
WHERE cust_first_name = ‘ABIGAIL’;
What would be the outcome?

A.    Abigail PA
B.    Abigail Pa
C.    Abigail IS
D.    an error message

Answer: B

QUESTION 132
Evaluate the following query:
SQL> SELECT TRUNC(ROUND(156.00,-1),-1) FROM DUAL;
What would be the outcome?

A.    16
B.    100
C.    160
D.    200
E.    150

Answer: C

QUESTION 133
View the Exhibit and examine the structure of the CUSTOMERS table.
In the CUSTOMERS table, the CUST_LAST_NAME column contains the values ‘Anderson’ and ‘Ausson’.
You issue the following query:
SQL> SELECT LOWER(REPLACE(TRIM(‘son’ FROM cust_last_name),’An’,’O’))
FROM CUSTOMERS
WHERE LOWER(cust_last_name) LIKE ‘a%n’;
What would be the outcome?

image

A.    ‘Oder’ and ‘Aus’
B.    an error because the TRIM function specified is not valid
C.    an error because the LOWER function specified is not valid
D.    an error because the REPLACE function specified is not valid

Answer: B

QUESTION 134
Which two statements are true regarding working with dates? (Choose two.)

A.    The default internal storage of dates is in the numeric format.
B.    The default internal storage of dates is in the character format.
C.    The RR date format automatically calculates the century from the SYSDATE function and does
not allow the user to enter the century.
D.    The RR date format automatically calculates the century from the SYSDATE function but allows
the user to enter the century if required.

Answer: AD

QUESTION 135
You are currently located in Singapore and have connected to a remote database in Chicago.
You issue the following command:
SQL> SELECT ROUND(SYSDATE-promo_begin_date,0)
FROM promotions
WHERE (SYSDATE-promo_begin_date)/365 > 2;
PROMOTIONS is the public synonym for the public database link for the PROMOTIONS table.
What is the outcome?

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

Answer: C

QUESTION 136
Examine the data in the CUST_NAME column of the CUSTOMERS table.
CUST_NAME
—————-
Renske Ladwig
Jason Mallin
Samuel McCain
Allan MCEwen
Irene Mikkilineni
Julia Nayer
You need to display customers’ second names where the second name starts with “Mc” or “MC.”
Which query gives the required output?

A.    SELECT SUBSTR(cust_name, INSTR(cust_name,’ ‘)+1)
FROM customers
WHERE INITCAP(SUBSTR(cust_name, INSTR(cust_name,’ ‘)+1))=’Mc’;
B.    SELECT SUBSTR(cust_name, INSTR(cust_name,’ ‘)+1)
FROM customers
WHERE INITCAP(SUBSTR(cust_name, INSTR(cust_name,’ ‘)+1)) LIKE ‘Mc%’;
C.    SELECT SUBSTR(cust_name, INSTR(cust_name,’ ‘)+1)
FROM customers
WHERE SUBSTR(cust_name, INSTR(cust_name,’ ‘)+1) LIKE INITCAP(‘MC%’);
D.    SELECT SUBSTR(cust_name, INSTR(cust_name,’ ‘)+1)
FROM customers
WHERE INITCAP(SUBSTR(cust_name, INSTR(cust_name,’ ‘)+1)) = INITCAP(‘MC%’);

Answer: B

QUESTION 137
Examine the data in the CUST_NAME column of the CUSTOMERS table.
CUST_NAME
—————-
Lex De Haan
Renske Ladwig
Jose Manuel Urman
Jason Mallin
You want to extract only those customer names that have three names and display the * symbol in place of the first name as follows:
CUST NAME
——————
*** De Haan
**** Manuel Urman
Which two queries give the required output? (Choose two.)

A.    SELECT LPAD(SUBSTR(cust_name,INSTR(cust_name,’ ‘)),LENGTH(cust_name),’*’) “CUST NAME”
FROM customers
WHERE INSTR(cust_name, ‘ ‘,1,2)<>0;
B.    SELECT LPAD(SUBSTR(cust_name,INSTR(cust_name,’ ‘)),LENGTH(cust_name),’*’) “CUST NAME”
FROM customers
WHERE INSTR(cust_name, ‘ ‘,-1,2)<>0;
C.    SELECT LPAD(SUBSTR(cust_name,INSTR(cust_name,’ ‘)),LENGTH(cust_name)- INSTR(cust_name,”),
‘*’) “CUST NAME”
FROM customers
WHERE INSTR(cust_name, ‘ ‘,-1,-2)<>0;
D.    SELECT LPAD(SUBSTR(cust_name,INSTR(cust_name,’ ‘)),LENGTH(cust_name)- INSTR(cust_name,’ ‘),
‘*’) “CUST NAME”
FROM customers
WHERE INSTR(cust_name, ‘ ‘,1,2)<>0 ;

Answer: AB

QUESTION 138
View the Exhibit and examine the structure of the EMPLOYEES table.
Examine the data in the ENAME and HIREDATE columns of the EMPLOYEES table:
ENAME       HIREDATE
——–   —————-
SMITH       17-DEC-80
ALLEN       20-FEB-81
WARD        22-FEB-81
You want to generate a list of user IDs as follows:
USERID
————-
Smi17DEC80
All20FEB81
War22FEB81
You issue the following query:
SQL>SELECT CONCAT(SUBSTR(INITCAP(ename),1,3), REPLACE(hiredate,’-‘)) “USERID”
FROM employees;
What is the outcome?

image
A.    It executes successfully and gives the correct output.
B.    It executes successfully but does not give the correct output.
C.    It generates an error because the REPLACE function is not valid.
D.    It generates an error because the SUBSTR function cannot be nested in the CONCAT function.

Answer: A

QUESTION 139
View the Exhibit and examine the structure and data in the INVOICE table.
name         Null            Type
——-     ———      ———–
INV_NO      NOT NULL        NUMBER(3)
INV_DATE                     DATE
INV_AMT                      NUMBER(10,2)
Which statements are true regarding data type conversion in expressions used in queries? (Choose all that apply.)

A.    inv_amt =’0255982′ : requires explicit conversion
B.    inv_date > ’01-02-2008′ : uses implicit conversion
C.    CONCAT(inv_amt,inv_date) : requires explicit conversion
D.    inv_date = ’15-february-2008′ : uses implicit conversion
E.    inv_no BETWEEN ‘101’ AND ‘110’ : uses implicit conversion

Answer: DE

QUESTION 140
Examine the structure and data of the CUST_TRANS table:
CUST_TRANS
———————————–
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 CUST_TRANS table.
Which SQL statements would execute successfully? (Choose three .)

A.    SELECT transdate + ’10’ FROM cust_trans;
B.    SELECT * FROM cust_trans WHERE transdate = ’01-01-07′;
C.    SELECT transamt FROM cust_trans WHERE custno > ’11’;
D.    SELECT * FROM cust_trans WHERE transdate=’01-JANUARY-07′;
E.    SELECT custno + ‘A’ FROM cust_trans WHERE transamt > 2000;

Answer: ACD

If you want to pass Oracle 1Z0-051 exam successfully, donot missing to read latest lead2pass Oracle 1Z0-051 dumps.
If you can master all lead2pass questions you will able to pass 100% guaranteed.

http://www.lead2pass.com/1z0-051.html