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

Question :

1. A,B,C
2. B,C,D
3. A,C,D
4. A,B,D


Correct Answer : 2

Explanation:






Question : Select the wrong statement from below.



1. TO_CHAR may convert date items to character items.
2. TO_DATE may convert character items to date items.
3. TO_CHAR may convert numbers to character items.
4. TO_DATE may convert date items to character items.


Correct Answer : 4

Explanation: The syntax for the Oracle/PLSQL TO_DATE function is:

TO_DATE( string1, [ format_mask ], [ nls_language ] )
Parameters or Arguments

string1 is the string that will be converted to a date.

format_mask is optional. This is the format that will be used to convert string1 to a date.

nls_language is optional. This is the nls language used to convert string1 to a date. Let's look at some Oracle TO_DATE function examples and explore how to use the TO_DATE function in Oracle/PLSQL.

For example:

TO_DATE('2003/07/09', 'yyyy/mm/dd')
Result: date value of July 9, 2003

TO_DATE('070903', 'MMDDYY')
Result: date value of July 9, 2003

TO_DATE('20020315', 'yyyymmdd')
Result: date value of Mar 15, 2002






Question : What value is returned after executing the following statement?
TO_CHAR(1210.73, '9999.9')



1. 1210.9
2. 1210.7
3. 1210.73
4. 1210


Correct Answer : 2

Explanation: The syntax for the Oracle/PLSQL TO_CHAR function is:

TO_CHAR( value, [ format_mask ], [ nls_language ] )
Parameters or Arguments

value can either be a number or date that will be converted to a string.

format_mask is optional. This is the format that will be used to convert value to a string.

nls_language is optional. This is the nls language used to convert value to a string.

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;