if we give update table_name set column_name= default.
what will happen?

Answers were Sorted based on User's Feedback



if we give update table_name set column_name= default. what will happen?..

Answer / mano chinna

It Will update NULL to the column. In SQL, while
inserting and updating if you are assigning a column value
as DEFAULT keyword without single or doubled quote it will
take NULL automatically.

Is This Answer Correct ?    6 Yes 0 No

if we give update table_name set column_name= default. what will happen?..

Answer / akki julak

if you gave a default value for that column

then it takes that default value

otherwise it takes NULL

Is This Answer Correct ?    7 Yes 2 No

if we give update table_name set column_name= default. what will happen?..

Answer / meher

If any default value have been declare to that column when
creating the table then the defaul value will be updated.
Otherwise the column will be update by NULL.

Is This Answer Correct ?    1 Yes 0 No

if we give update table_name set column_name= default. what will happen?..

Answer / kolla radha sri seshu

In SQL you will get the message 'X' rows updated
In PL / SQL you will get the message pl / sql procedure
sucessfully completed

Is This Answer Correct ?    0 Yes 3 No

Post New Answer

More SQL PLSQL Interview Questions

How do sql triggers work?

0 Answers  


Can 2 queries be executed simultaneously in a distributed database system?

0 Answers  


Why do we use sqlite?

0 Answers  


What is the first action to perform a query? Suppose I have four tables and five joins and my query is getting slow day by day.

4 Answers   Hexaware,


Does sql profiler affect performance?

0 Answers  






Does asenumerable execute the query?

0 Answers  


What is the purpose of the primary key?

0 Answers  


What is partition by in sql?

0 Answers  


What is referential integrity ?

3 Answers   BirlaSoft,


What is the difference between subquery and correlated query?

0 Answers  


How can we find duplicate records in a table?

0 Answers  


What is cold data?

0 Answers  


Categories