Interview Questions for CS/IT by Aryadrj - 2021

-

 

 Interview Questions for CS/IT by Aryadrj - 2021


Basic Questions

  1. Tell me about yourself.
  2. Why Should We Hire You?
  3. What Are Your Salary Expectations? 
    (How much salary are you expecting?)
  4. What Is Your Greatest Weakness?
  5. Why do you want to work with us?
  6. Why do you took a one year gap in your resume? (For experience person)
  7. Do you have any questions for us?
  8. Reasons behind leaving your last job? (For experience person).
  9. Tell me something about our company.

Technical Questions

  1. What do you know about the Waterfall cycle?
  2. What do you know about the Agile model?
  3. What is Blackbox Testing?
  4. What is Whitebox Testing?
  5. What is the difference between Blackbox and Whitebox Testing?
  6. What is functional Testing?
  7. What is non-functional Testing?
  8. What is the difference between Functional and Non-Functional Testing?
  9. Who will do blackbox testing?
  10. Who will do whitebox testing?
  11. What are types of software testing?
  12. What is the difference between RAM and ROM?
  13. What is the difference between primary and secondary memory?
  14. Who is Scrum master?


Few Interview Tips

  1. Wear your best clothes and shoes. Buy new set of clothes and shoes, in case you do not have any best clothes.
  2. Get a haircut to appear younger. Do not go with your shabby hair style. Go to a hair dresser and get a haircut that suits you.
  3. Wear rich accessories. Yes, it really makes an impression when you wear really nice watch and keep a nice phone.
  4. Deep breath. Take 10 deep breaths before interview to keep your calm and reduce any nervousness.
  5. Smile. Yes, practice your smile. You have to use it when you greet your interviewer, when you know an answer or when you do not know an answer. Give a wide grin to show your calmness to interviewer.
  6. Prepare common questions (if you don't have time).
  7. Confidence is the key: Even if you are shaking from inside, but do not show it to your interviewer. 
  8. Listen to the question carefully.
  9. Make it a conversation: When giving the interview, do not sit dumb , make it a conversation from two sides, that is, you and the interviewer.
  10. To the point answers: Do not talk unnecessarily with the interviewer, Be stick to the questions as asked. This will enhance your skills more.


Questions on Java

  1. What is the difference between java and c?
  2. Name some OOPS Concepts in Java?
  3. What is the difference between interface and abstraction?
  4. Why is multiple inheritance not supported in java?
  5. What is difference between JDK, JRE, and JVM?
  6. Can a main() method be declared final? 
  7. Can we override a static method ?
  8.  Can we execute a program without main() method ?
  9. Can we override the private methods ?
  10. Is Java a statically or dynamically typed language?
  11. What do we mean by polymorphism, inheritance and encapsulation?
  12. What is overloading and overriding in java?
  13. What is enumeration?
  14. In how many ways we can achieve abstraction ?
  15. Data Hiding vs Data binding?
  16. Difference between Default and Protected access specifiers.
  17. What is class and object in java?
  18. Why java is platform independent?
  19. What are wrapper classes in java?
  20. What are the differences between heap and stack memory in java?
  21. What is the difference between equals() and == in java?
  22. Explain constructors in java.
  23. List all the access specifiers for java classes.
  24. What is the default value of the local variables?
  25. What are the differences between the constructors and methods?
  26. Why is the main method static?
  27. Explain 'this' keyword in java.

Questions on DBMS

  1. What is DDL (Data Definition Language)?
  2. What are super, primary, candidate and foreign keys? 
  3. What is DML (Data Manipulation Language)?
  4. What are the differences between DDL, DML and DCL in SQL? 
  5. What is normalization?
  6. What is Denormalization?
  7. What is the E-R model?
  8. What is an attribute?
  9. What is 1NF?
  10. What is Join? 
  11. Difference between unique key and primary key.
  12. Difference between DBMS and RDBMS. 
  13. What are the differences between Null,Zero and Blankspace in SQL? 
  14. What are the advantages of DBMS? 
  15. List and explain different types of DBMS. 
  16. What is CLAUSE in terms of SQL? 
  17. Differentiate between aggregation and atomicity. 
  18. Differentiate between two and three-tier architectures. 
  19. Differentiate between Trigger and Stored Procedures. 
  20. Differentiate between Inner join and Outer join in SQL. 
  21. What is deadlock?


Questions on Python

Click here to view Interview Questions on Python.


Important formula for Aptitude Question

  1. km/hr to m/s conversion
    • a km/hr = (a * 5/18) m/s
  2. m/s to km/hr conversion
    • a m/s= (a * 18/5) km/hr
  3. Speed = distance/time
  4. Simple Interest = (p*t*r)/100
    • Where p is princple , t =time and s = second
  5. Principle = (100 * SI * / R * T)
  6. Rate = (100* SI / P*T)
  7. Time = (100 * SI / P * R)
  8. If A can do a piece of work in n days, then A's 1 day's work = 1 / n
  9. If A's 1 day's work = 1/n , then A can finish the work in n days.
  10. Sum of first n natural numbers = n(n+1)/2.
  11. Profit and loss
    • Profit = SP - CP
    • Loss = CP - SP
    • Percentage Profit = Profit / CP * 100
      • Where Profit = SP - CP.
    • Percentage Loss = Loss / CP * 100 
      • Where Loss = CP - SP
  12. Permutation


  13. Combination




New Group Discussion Topic

  1. Impact of COVID-19 (Coronavirus) on Global economy.
  2. How prepared is India to tackle the COVID-19 outbreak?
  3. Farm Bills 2020 – Pros, Cons.
  4. Atmanirbhar Bharat Abhiyan.
  5. English must remain the official language of India.
  6. WhatsApp, Facebook, Instagram, and Snapchat are killing creativity.
  7. Beef ban is logical.
  8. Work from home – Pros & Cons.
  9. Unemployment in India.
  10. Chinese App  Ban.



Golden Interview Tips

  1. Use your mirror and practice how to introduce yourself.
  2. Read about the company and be thorough.
  3. Wear strictly formal tip-top clothes.
  4. Leave 15 minutes early.
  5. Keep reminding yourself that you can do it.
  6. Take deep breaths before you get into the interview room.
  7. Behave like a professional, even in the waiting room .
  8. Knock twice and enter the interview room.
  9. Confidence is a must.
  10. Do not fidget with your hands, hair or legs.
  11. Look at your interviewer, eye to eye.
  12. Keep a pleasant face.
  13. Make sure your answers are to the point.
  14. Be genuinely interested to work hard, it shows on your face.
  15. Only start asking questions to them when they ask you to.
  16. Ask for your feedback towards the end.

Questions on C program

  1. Find factorial of a number.
  2. Swap two bits.
  3. Swap two numbers without using third variable.
  4. Write a program for palindrome.
  5. Program to find Lcm of two numbers.
  6. What is Function overloading?
  7. Program to find given number is even or odd without using modulus.

Questions on Aptitude

 
  1. A train running at the speed of 70 km/hr crosses a pole in 8 seconds. What is the length of the train?
  2. The length of the bridge, which a train 130 metres long and travelling at 45 km/hr can cross in 30 seconds, is?
  3. A sum fetched a total simple interest of Rs. 4016.25 at the rate of 9 p.c.p.a. in 5 years. What is the sum?
  4. Avg of 12 member is 20, 4 more joined, Avg increased by 1, find the Avg of new member?
  5. Total strength of company is 720, 168 members were only on leave, How many percentages of employees were present?
  6. Cost of bike is 2, 50,000, discount is 20% what will be the selling price?
  7. HCF of first 4 natural no?
  8. GOAT is coded as HPBU
    LION is coded as what?
  9. JOHN is coded as INGM
    MARY is coded as what?
  10. 30 apples cost 1 Rs, how much apple we should sell for 1 Rs to get 20% profit.


Online Interview Preparation Course 2022


Contact : 

WhatsApp : +917892657546




*** Thankyou ***


Comments

Post a Comment

Popular posts from this blog

How to set image in carousel using flask?

-
Image
How to set image in carousel using flask? Step 1: Create one folder on the desktop called my Flask . Step 2: Create Two folder called static and templates  in the myFlask folder. Create one file called main.py   in the myFlask folder. Step 3: Add the code in the main.py file.      from flask import Flask,render_template      app = Flask(__name__)      @app.route('/')      def hello_world():          return render_template("index.html")      app.run(debug=True) Step 4: Create image folder in the static folder. Add one image  in the image folder. [arya.png]. Step 5: Create index.html in the templates folder and add the below code in that folder. <html> . . . <div id= "carouselExampleSlidesOnly" class= "carousel slide" data-ride= "carousel" > <div class= "carousel-inner" > <div class= "carousel-item active" > <img src= "{{url_for('static', filename='arya.png'
Read more

Invalid syntax , perhaps you forgot a comma? Error in Python

-
Image
Invalid syntax , perhaps you forgot a comma? Error n Python Problem : Invalid syntax , perhaps you forgot a comma? Error in Python Solution 1: May be you  have missed the assignment operator."="  Example: Solution 2: May be you have missed the comma between value or variable","  Example: Still Problem is not solved? For any queries, you can contact us: 📬 Contact Me 📞 Phone:  +918431334381 💬 WhatsApp:  +918431334381 📧 Email:   aryadrj@gmail.com 📝 Form:   Click here to fill out the form
Read more

How to run PL/SQL Code With Command Line?

-
Image
How to run PL/SQL Code With Run SQL Command Line? So What is PL/SQL? PL/SQL is Oracle Corporation's procedural extension for SQL and the Oracle relational database. PL/SQL is available in Oracle Database, Times Ten in-memory database, and IBM DB 2.  In Simple Word PL/SQL means instructing the compiler 'what to do' through SQL and 'how to do' through its procedural way.  Follow these steps to run the code of PL/SQL with SQL command Line. Step 1: Type this in command prompt: connect sys as sysdba Enter password: wb Connected. Step 2: We need to type and execute "set serveroutput on" if  to see the output of the program. Step 3: Type this Sample Code: set serveroutput on BEGIN dbms_output.put_line ('Hello World..'); END; / Step 4: You will get output: Hello World Thank-you. Also Read : String in PL/SQL.
Read more