SELECT COUNT(1) FROM TAB ANS:It gives the total number of tables,views,s

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

Question Posted / vishnu

Answer Posted / vishnu

SELECT COUNT(1) FROM TAB

ANS:It gives the total number of tables,views,synonyms
present in that schema.

Is This Answer Correct ?

23 Yes

2 No

Please Help Members By Posting Answers For Below Questions

How much does sqlite cost?

985

What is difference between cursor and trigger?

1017

What is sqlcontext?

986

What is a left join?

888

Is foreign key mandatory?

938

What is a left inner join?

946

What are functions in sql?

899

what are the features and advantages of object-oriented programming? : Sql dba

952

What is db journal file?

956

how to add a new column to an existing table in mysql? : Sql dba

1001

Does normalization improve performance?

980

What is the difference between a query and a report?

901

What will you get by the cursor attribute sql%rowcount?

971

State some properties of relational databases?

1001

What is a primary key? Explain

920