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

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

Question Posted / deepshikha

Answer Posted / deepshikha

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

Is This Answer Correct ?

3 Yes

3 No

Please Help Members By Posting Answers For Below Questions

The in operator may be used if you know the exact value you want to return for at least one of the columns.

1136

what is view? : Sql dba

971

Is it possible to Restore a Dropped Table using Rollback Command in Oracle SQL Plus ?

1233

who introduced sql?

1026

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

1085

What are the benefits of pl/sql packages?

1107

What is the difference between cluster and non-cluster index?

1108

When a dml statement is executed, in which cursor attributes, the outcome of the statement is saved?

1121

How many joins in sql?

1017

What are three advantages to using sql?

1024

What is implicit cursor in pl sql?

1097

What is pl sql variable?

997

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

965

Is crud a cuss word?

1036

How do I view tables in mysql?

986