UPDATE statement can on a single table or on the multiple
table?
Answers were Sorted based on User's Feedback
Answer / govind
yes. But by using views(some) we r able to update the
multiple table
| Is This Answer Correct ? | 17 Yes | 4 No |
Answer / sandeep
single table.
View is updatable if it is a only one table reference view.
| Is This Answer Correct ? | 3 Yes | 1 No |
What are the differences between union, intersect, and minus operators?
What is bit data type? What's the information that can be stored inside a bit column?
What is the difference between a function and a stored procedure?
Mention the different types of triggers?
What is a covered index?
What is the use of CASCADE CONSTRAINTS?
Which data type can be used only on OUTPUT parameters of the stored proceduer?
what is the difference between table and view
Is there any performance difference between if exists (select null from table) and if exists (select 1 from table)?
Can you explain important index characteristics?
What is named query? : sql server analysis services, ssas
What is BCP? When do we use it?
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)