Accenture Interview

Displaying 1 - 16 of 16

Sl No. QUESTION RATING ANSWER 1 What is MySQL ?   View Answer 2 What is DDL, DML and DCL ?   View Answer 3 How do you get the number of rows affected by query? View Answer 4 If the value in the column is repeatable, how do you find out the unique values? View Answer 5 How do you return the a hundred books starting from 25th? View Answer 6 You wrote a search engine that should retrieve 10 results at a time, but at the same time you’d like to know how many rows there’re total. How do you display that to the user?      View Answer 7 How would you write a query to select all teams that won either 2, 4, 6 or 8 games? View Answer 8 How would you select all the users, whose phone number is null? View Answer 9 What does this query mean: SELECT user_name, user_isp FROM users LEFT JOIN isps USING (user_id) ?    View Answer 10 How do you find out which auto increment was assigned on the last insert?    View Answer 11 What does –i-am-a-dummy flag to do when starting MySQL?    View Answer 12 On executing the DELETE statement I keep getting the error about foreign key constraint failing. What do I do? View Answer 13 When would you use ORDER BY in DELETE statement?    View Answer 14 How can you see all indexes defined for a table?    View Answer 15 How would you change a column from VARCHAR(10) to VARCHAR(50)?     View Answer 16 How would you delete a column?     View Answer