Question

2. Let the statement
SEL CET * FROM nameList:
retum 10 rows. The statement
SELECT * FROM nameList WHERE ROWNUM > 5:
will return
a) 4 rows
b) 5 rows
c) 6 rows
d) None of these
answer
​

Answer 1

Given : the statement  

SEL CET * FROM nameList:

return 10 rows.

To Find :  The statement  

SELECT * FROM nameList WHERE ROWNUM > 5:

will return

a) 4 rows

b) 5 rows

c) 6 rows

d) None of these

Solution:

SEL CET * FROM nameList:

return 10 rows.

Hence total 10 Rows

From Row 1 to Row 10

SELECT * FROM nameList WHERE ROWNUM > 5:

will Return  

Rows from Row 6 to Row 10

Hence there will be 5 rows

SELECT * FROM nameList WHERE ROWNUM > 5  will Return   5 rows

Learn More:

How do I write an algorithm

https://brainly.in/question/9522755