This results the total count of tables,views,synonyms present in a schema

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

Question Posted / nisha

Answer Posted / nisha

This results the total count of tables,views,synonyms
present in a schema.

Is This Answer Correct ?

3 Yes

4 No

Please Help Members By Posting Answers For Below Questions

Explain about various levels of constraint.

941

Can we create index on primary key?

961

Does sap use sql?

982

What is the purpose of a secondary key?

962

What is the difference between having and a where in sql?

1099

How do I start sql from command line?

1019

What is the purpose of the sql select top clause?

1104

What are the sql aggregate functions?

1118

Why should I use postgresql?

1010

what are the difference between clustered and a non-clustered index? : Sql dba

1030

What is difference between stored procedures and application procedures?

1009

hi,i plan to put experience on PLSQL ,can anyone suggest me for any institutes in bangalore or how to prepare for interviews

2012

how to implement one-to-one, one-to-many and many-to-many relationships while designing tables? : Sql dba

983

Is sql a oracle?

974

What is the use of <> sql?

973