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

Answer Posted / shivashanker

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

Is This Answer Correct ?    0 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Enlist the advantages of sql.

573


Is it important to partition hard disk?

536


What are properties of the transaction?

562


Define commit, rollback and savepoint?

582


what are date and time intervals? : Sql dba

567






What plvcmt and plvrb does in pl/sql?

881


Can we use the cursor's to create the collection in PL/SQL?

524


Which sql statement is used to delete data from a database?

470


How does postgresql compare to oracle/db2/ms sql server/informix?

574


Why is a trigger used?

531


name 3 ways to get an accurate count of the number of records in a table? : Sql dba

574


What is fmtonly in sql?

534


what is the difference between delete and truncate commands? : Sql dba

542


How many functions are there in sql?

544


Is keyword pl sql?

562