What does “select count(*) from tab” result?

Answers were Sorted based on User's Feedback



What does “select count(*) from tab” result? ..

Answer / ram

Will display the count Schema

Is This Answer Correct ?    0 Yes 3 No

What does “select count(*) from tab” result? ..

Answer / shivashanker

it will display the total number of tables in the schema.

Is This Answer Correct ?    0 Yes 3 No

What does “select count(*) from tab” result? ..

Answer / amit kumar jaswal

display count of all rows from relation

Is This Answer Correct ?    3 Yes 7 No

What does “select count(*) from tab” result? ..

Answer / kamal kishore kashyap

display all the table which are currently in the schema.

Is This Answer Correct ?    0 Yes 6 No

What does “select count(*) from tab” result? ..

Answer / sheikbachan

hi I'm bachan

total num of row

Is This Answer Correct ?    0 Yes 7 No

Post New Answer

More SQL PLSQL Interview Questions

Differentiate between %type and %rowtype attribute in Oracle PL/AQL programming ?

7 Answers   PreVator,


How do you display "13th of November, 17 days left for month end" without hardcoding the date.

3 Answers  


How many types of privileges are available in sql?

0 Answers  


What does where 1 1 mean in sql?

0 Answers  


What is a table partition?

0 Answers  






What is a trigger ?

11 Answers   Accenture, BirlaSoft,


What operating systems are supported by oracle sql developer?

0 Answers  


explain the difference between bool, tinyint and bit. : Sql dba

0 Answers  


what is auto increment? : Sql dba

0 Answers  


How to display the records between two range in Oracle SQL Plus?

0 Answers   MCN Solutions,


Can we debug stored procedure?

0 Answers  


Why we use pl sql?

0 Answers  


Categories