Interested to Buy Any Domain ? << Click Here >> for more details...
If a table has a column "dept" (declared to have nulls) and
there are 10 rows in the table of which 3 have a null value
in the dept column, what will select count(*) and select
count(distinct dept) return?
- 6 Answers
- 8442 Views
- I also Faced
- E-Mail Answers
Answer Posted / i go crazy
MADHURI IS CORRECT.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
How is the value function used?
Which component is used to execute the sql statements?
I HAVE 500 ROW TO UPDATE I WOULD LIKE TO USE ROLLBACK ALONG WITH COMMIT.WHAT IS THE SYNTAX TO CODE COMMIT AND ROLLBACK FOR EVERY 100 ROWS.AND HOW THE CURSOR ROLLBACK TO THE LAST COMMITTING POINT.
What is the physical storage length of timestamp data type?
What is phantom read in db2?
Explain various types of locks in db2?
Explain about mirror activator disk mirroring?
Is db2 a database?
When reorg is used?
in my project..TEST is db2 8.1 version In PROD it is 7.1 if i do REORG in TEST.. can I use the same REORG jcl with out modification in PROD region (this is DB2 8.1 )? if not, what modification i need to do in my REORG control card?
What is database alias db2?
What do you mean by cursor?
Mention the downsides of page level lock.
What is database manager in db2?
What is the syntax for creating a table in the db2 database?
