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?
REPLACE('123123tech', '123');

1. 123
2. tech
3. Access Mostly Uused Products by 50000+ Subscribers
4. None of the above



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

REPLACE( string1, string_to_replace, [ replacement_string ] )
Parameters or Arguments

string1 is the string to replace a sequence of characters with another set of characters.

string_to_replace is the string that will be searched for in string1.

replacement_string is optional. All occurrences of string_to_replace will be replaced with replacement_string in string1. If the replacement_string parameter is omitted, the REPLACE function simply removes all occurrences of string_to_replace, and returns the resulting string.






Question : What value is returned after executing the following statement?
REPLACE('0000123', '0', ' ');

1. 123
2. 4 space and 123
3. Access Mostly Uused Products by 50000+ Subscribers
4. None of the above



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

REPLACE( string1, string_to_replace, [ replacement_string ] )
Parameters or Arguments

string1 is the string to replace a sequence of characters with another set of characters.

string_to_replace is the string that will be searched for in string1.

replacement_string is optional. All occurrences of string_to_replace will be replaced with replacement_string in string1. If the replacement_string parameter is omitted, the REPLACE function simply removes all occurrences of string_to_replace, and returns the resulting string.
Let's look at some Oracle REPLACE function examples and explore how to use the REPLACE function in Oracle/PLSQL.

For example:

REPLACE('123123tech', '123');
Result: 'tech'

REPLACE('123tech123', '123');
Result:'tech'

REPLACE('222tech', '2', '3');
Result: '333tech'

REPLACE('0000123', '0');
Result: '123'

REPLACE('0000123', '0', ' ');
Result: ' 123'






Question : What value is returned after executing the following statement?
MOD(15, 4)

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



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

MOD( m, n )
Parameters or Arguments

The MOD is calculated as:

m - n * floor(m/n)

NOTE

The MOD function returns m if n is 0.
The MOD function uses the FLOOR function in its formula.
See also the REMAINDER function.

Related Questions

---

Question : Select the possible languages You can use in the Oracle c database, to derive the a particular stock return using a formula and data stored in the table.
A. SQL
B. C
C. PL/SQL
D. Java
E. Any other language linked to the OCI libraries


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


Question : Which is the most suitable form for data to be stored in RDBMS so can be processed easily.

1. First normal form
2. Second normal form
3. Access Mostly Uused Products by 50000+ Subscribers
4. Fourth normal form
5. Fifth normal form


Question : Select the features which define SQL as a set-oriented language.

1. Each row must have unique key
2. Each row must have primary key
3. Access Mostly Uused Products by 50000+ Subscribers
4. One SQL statement can affect multiple rows.



Question : Which of the following will not be supported as part of set-oriented language.
A. WHILE
B. FOR DO
C. IF..THEN..ELSE
D. COMMIT
E. ROLLBACK


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


Question :. You have two user called HadoopExamDev and HadoopExamTest in oracle database, now you have created a schema called HadoopExam with user
HadoopExamDev, and want to move it to HadoopExamTest, what is the best approach for doing that.

1. Using ALTER Schema command
2. Not possible
3. Access Mostly Uused Products by 50000+ Subscribers
4. USING UPDATE SCHEMA command


Question : Which query creates a projection of the EMPLOYEE_NAME and LOCATION_ID columns from the EMPLOYEES table?

1. SELECT DISTINCT EMPLOYEE_NAME, LOCATION_ID FROM EMPLOYEES;
2. SELECT EMPLOYEE_NAME, LOCATION_ID FROM EMPLOYEES;
3. Access Mostly Uused Products by 50000+ Subscribers
4. SELECT EMPLOYEE_NAME AS "LOCATION_ID" FROM EMPLOYEES;