Oracle Advanced SQL and PL/SQL Developer Certification Questions and Answers (Dumps and Practice Questions)

Question : What value is returned after executing the following statement?
LENGTH('Tech on the Net')

1. 15
2. 16
3. Access Mostly Uused Products by 50000+ Subscribers
4. 12



Correct Answer : Get Lastest Questions and Answer :
Exp: The syntax for the Oracle/PLSQL LENGTH function is:

LENGTH( string1 )
Parameters or Arguments

string1 is the string to return the length for.






Question : What value is returned after executing the following statement?
LENGTH(NULL)

1. 0
2. 1
3. Access Mostly Uused Products by 50000+ Subscribers
4. Null



Correct Answer : Get Lastest Questions and Answer :
Exp: The syntax for the Oracle/PLSQL LENGTH function is:

LENGTH( string1 )
Parameters or Arguments

string1 is the string to return the length for.

NOTE

If string1 is NULL, then the LENGTH function will return NULL.






Question : What value is returned after executing the following statement?
LENGTH('')

1. 0
2. 1
3. Access Mostly Uused Products by 50000+ Subscribers
4. Null



Correct Answer : Get Lastest Questions and Answer :
Exp: The syntax for the Oracle/PLSQL LENGTH function is:

LENGTH( string1 )
Parameters or Arguments

string1 is the string to return the length for.

NOTE

If string1 is NULL, then the LENGTH function will return NULL.
et's look at some Oracle LENGTH function examples and explore how to use the LENGTH function in Oracle/PLSQL.

For example:

LENGTH(NULL)
Result: NULL

LENGTH('')
Result: NULL

Related Questions

---

Question : View the Exhibit and
examine the structure of the customers table.
Using the customers table, you need to generate
a report that shows the average credit limit for
customers in Washington and NEW YORK.
Which SQL statement would produce the required result?

1. A
2. B
3. Access Mostly Uused Products by 50000+ Subscribers
4. D




Question : View the Exhibit and examine the data in the employees table:
You want to display all the employee names and their corresponding manager names.
Evaluate the given query:
Which join option can be used in the blank in the above query to get the required output?


1. INNER JOIN
2. FULL OUTER JOIN
3. Access Mostly Uused Products by 50000+ Subscribers
4. RIGHT OUTER JOIN



Question : Evaluate the following query:
What would be the outcome of the above query?

1. It produces an error because flower braces have been used.
2. It produces an error because the data types are not matching.
3. Access Mostly Uused Products by 50000+ Subscribers
4. It executes successfully and displays the literal "{'s start date was \} * for each row in the output.



Question : Examine the structure of the transactions table:
You want to display the date, time, and transaction amount of transactions that where done before
12 noon. The value zero should be displayed for transactions where the transaction amount has
not been entered.
Which query gives the required result?


1. A
2. B
3. Access Mostly Uused Products by 50000+ Subscribers
4. D




Question : What is the outcome?

1. It executes successfully and gives the correct output.
2. It executes successfully but does not give the correct output.
3. Access Mostly Uused Products by 50000+ Subscribers
4. It generates an error because the SUBSTR function cannot be nested in the CONCAT function.



Question : Evaluate the following SQL commands:
The command to create a table fails. Identify the two reasons for the SQL statement failure?
A. You cannot use SYSDATE in the condition of a check constraint.
B. You cannot use the BETWEEN clause in the condition of a check constraint.
C. You cannot use the NEXTVAL sequence value as a default value for a column.
D. You cannot use ORD_NO and ITEM_NO columns as a composite primary key because ORD_NO is also the foreign key.

1. A,B
2. B,C
3. Access Mostly Uused Products by 50000+ Subscribers
4. C,D
5. B,D