4 votes 4 votes The 'command' used to change contents of one database using the contents of another database by linking them on a common key field? Replace Join Change Update Databases isro2009 databases bad-question + – ajit asked Oct 5, 2015 ajit 4.5k views answer comment Share Follow See 1 comment See all 1 1 comment reply Aishwarya Gujrathi commented Apr 5, 2018 reply Follow Share Please confirm the answer for this question. I think answer should be update. Refer: https://www.javatpoint.com/sql-update-with-join 0 votes 0 votes Please log in or register to add a comment.
3 votes 3 votes ans is (b) join clause combines columns from one or more tables in a relationaldatabase. It creates a set that can be saved as a table or used as it is. A JOIN is a means for combining columns from one (self-table) or more tables by using values common to each. kvkumar answered Jun 26, 2016 kvkumar comment Share Follow See 1 comment See all 1 1 comment reply shankargadri commented Jun 12, 2019 reply Follow Share Why update cant be the answer as we change the contents of the table with this command only with the help of join command. Please explain. 0 votes 0 votes Please log in or register to add a comment.
1 votes 1 votes Answer is B Replace command in sql : Replaces all occurrences of a specified string value with another string value Change : I don't think any command in db is there with Change key word Update : Update a record in table naga praveen answered Jun 25, 2016 naga praveen comment Share Follow See all 0 reply Please log in or register to add a comment.
0 votes 0 votes I guess the answer is b)join . But join does not change the contents of the database David answered Oct 8, 2015 David comment Share Follow See 1 comment See all 1 1 comment reply neha singh commented Jun 28, 2016 reply Follow Share Agree.. 0 votes 0 votes Please log in or register to add a comment.
0 votes 0 votes D. Update Consider a situation: A table named as USER_DATA is there which contains user details. This table has one column(along with other columns) named as IS_ACTIVE which contain ‘0’ for a user, when a user will be in-active. One other table is there named as BLOG_DETAILS which contains columns asAUTHOR_ID, IS_ACTIVE and other column to keep blog details. Now if we want to run a script which should make column IS_ACTIVE = 0 in theBLOG_DATA table for in-active users. Here, we need a sql script which will containUPDATE with JOIN. BLOG_DETAILS->AUTHOR_ID is foreign key which refers to the primary key USER_DATA->USER_ID We can write the following query UPDATE BLOG_DETAILS SET IS_ACTIVE = 0 FROM BLOG_DETAILS BD INNER JOIN USER_DATA UD ON UD.USER_ID = BD.AUTHOR_ID AND UD.IS_ACTIVE = 0 and we are done… Shalu Jain answered Jul 2, 2016 Shalu Jain comment Share Follow See all 0 reply Please log in or register to add a comment.