17. TCS SQL Interview Questions and Answers| Advance SQL Interview Questions| Pandey Guruji

[@PandeyGuruji]

Subscribe My Vlog Channel: www.youtube.com/@pandeygurujivlog Subscribe Technical Channel: kzbin.info Facebook: facebook.com/pandeygurujivlog

[@nupur264]

In the stored procedure, only employee id should be checked for duplicates, as two persons can have same names or each department will have more than 1 person means these two columns can contain duplicate data.

[@BewithuNnk]

Hi Guru Ji, If not inserting data by Procedure how can we do this? I mean if data is entered by enduser through application is it helpful? Pls clarify my doubt?

[@sampurnabhattacharjee9748]

COuld we use alter table and modify the column with primary key constraint? ALTER TABLE EMPLOYEES MODIFY CONSTAINT emp_pk PRIMARY KEY(empid,empname,depid);

[@ahmermohiuddinsiddique5659]

Pandey Ji, Yesterday I paid 226.03 Rupees 199 + 27.03 convenience fee and I suppose to get the study material downloaded. but the file didn't download. Please share the study material. waiting for your reply.

[@PandeyGuruji]

I sent via email.

[@ahmermohiuddinsiddique5659]

@@PandeyGuruji thanks pandey ji.. Appreciated

[@PandeyGuruji]

Do you want to learn SQL and Python from me? Check www.studyiteducation.com/ for all my affordable courses.

[@JavedS-e6q]

1.5x speed