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?
MOD(-100, 0)

1. 100
2. 0
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.
Let's look at some Oracle MOD function examples and explore how to use the MOD function in Oracle/PLSQL.

For example:

MOD(15, 4)
Result: 3

MOD(15, 0)
Result: 15

MOD(11.6, 2)
Result: 1.6

MOD(11.6, 2.1)
Result: 1.1

MOD(-15, 4)
Result: -3

MOD(-15, 0)
Result: -15







Question : What value is returned after executing the following statement?
ADD_MONTHS('01-Aug-03', 3)

1. 01-Nov-03
2. 01-Nov-06
3. Access Mostly Uused Products by 50000+ Subscribers
4. 01-Sep-03



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

ADD_MONTHS( date1, n )
Parameters or Arguments

date1 is the starting date (before the n months have been added).

n is the number of months to add to date1.






Question : What value is returned after executing the following statement?
ADD_MONTHS('21-Aug-03', -3)

1. 21-Jan-03
2. 21-Mar-03
3. Access Mostly Uused Products by 50000+ Subscribers
4. 21-Nov-03



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

ADD_MONTHS( date1, n )
Parameters or Arguments

date1 is the starting date (before the n months have been added).

n is the number of months to add to date1.

Related Questions

---

Question : In a Oracle there is data type of NUMBER(,). Which value will not be permitted in this column?

1. 99999999
2. 999999.99
3. Access Mostly Uused Products by 50000+ Subscribers
4. 999999
5. 99.99



Question : When you do the SQL operation as below

DATE1-DATE2
Where both DATE1 and DATE2 are having datatype as DATE. Select the correct statement from below.

1. It will return number of days between two dates, with data type as a Number
2. Returned number of days with Datatype as DATE
3. Access Mostly Uused Products by 50000+ Subscribers
4. Returned number of days with Datatype as VARCHAR2



Question :Which statement is correct for column having data type VARCHAR()

1. The VARCHAR2 data type is replaced by the CHAR data type.
2. This column must store character data that is at least 50 characters long.
3. Access Mostly Uused Products by 50000+ Subscribers
4. None of the above



Question : Which expressions do not return NULL values?
A. select ((99 + 44) * 5) + null from dual;
B. select 'HadoopExam '||null||'QuickTechie.com' from dual;
C. select null/0 from dual;
D. select null||'HadoopExam'||null as "QuickTechie.com" from dual;


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




Question : Which of the following will return all the columns from a table

1. select all from table;
2. select % from table;
3. Access Mostly Uused Products by 50000+ Subscribers
4. select *.* from table;




Question : There are rows of data in the Total table. Consider the following SQL statement: SELECT ' * ' "Score" FROM total;
Select correct statement

1. 1 row returned, Score column contains value 12
2. 100 rows returned, Score column contains value 12 for all 100 rows
3. Access Mostly Uused Products by 50000+ Subscribers
4. 100 rows returned, Score column contains value 4*3 for all 100 rows
5. Error