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

Answer Posted / deepshikha

it will result the count of TABLE,CLUSTER,VIEW,SYNONYM
in given schema

Is This Answer Correct ?    3 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Can we declare a column having number data type and its scale is larger than pricesionex: column_name number(10,100),column_name numbaer(10,-84)

535


What is dense_rank?

536


How do I add a primary key to a table?

537


Is sql sequential or random?

535


What is the difference between distinct and unique in sql?

468






What is a ddl command?

532


Is nosql relational?

546


Which certification is best for sql?

534


What are sql ddl commands?

545


What is a crud api?

495


What is sql clause?

539


What is meant by truncate in sql?

520


what are ddl statements in mysql? : Sql dba

577


What is primary key and foreign key with example?

494


What are commit, rollback, and savepoint?

569