SQL Interview Questions and Answers

Q. Latest version of Sql is……

  1. 2021
  2. 2019
  3. 2022
  4. 2018
    Ans:- 2019 Note : released November 4, 2019.
    Show Answer

Q. the key which uniquely identifies each record in a table is known as……

  1. Unique Key
  2. Primary Key
  3. Foreign Key
  4. Candidate Key
    Ans:- Primary Key
    Show Answer

Q. For comparing multiple value in table ………is used.

  1. or
  2. like
  3. in
  4. match
    Ans:- in
    Show Answer

Q……….is used for displaying Data from Multiple Tables.

  1. joins
  2. indexes
  3. view
  4. normalization
    Ans:- join
    Show Answer

Q. Which query is used to search for a special pattern in a column.

  1. like
  2. update
  3. drop
  4. view
    Ans:- like
    Show Answer

Q. Output of SELECT SQRT(25); is ….. 

  1. 15
  2. 5
  3. 25
  4. 5.5
    Ans:- 5
    Show Answer

Q. Output of this statement is SELECT TRUNCATE(10.45895, 3); is ….. 

  1. 10.458
  2. 10.45
  3. 10.45895
  4. 10
    Ans:- 10.45
    Show Answer

Q. Output of RAND(): function is…..

  1. 1586
  2. 5586
  3. 5858
  4. 2584
Ans:- 1586 Note : RAND(): It returns a random number.
Show Answer

Q. Output of SELECT ROUND(5.553);

  1. 6
  2. 5
  3. 5.5
  4. 4
    Ans:- 6 Note : It returns a number rounded to a certain number of decimal places.
    Show Answer

Q. What is Output of this command SELECT * FROM Customers;

  1. Shows the particular records
  2. Shows the all record
  3. Show the all tables of database
  4. All of these
    Ans:- Show the all record
    Show Answer

Q. What will be the output of SELECT DISTINCT Country FROM Customers;

  1. Shows the particular records form Customers table
  2. Shows the all record form Customers table
  3. Show the all name with name Country form Customers table
  4. Select all the different values from the Country column in the Customers table.
    Ans:- Select all the different values from the Country column in the Customers table.
    Show Answer


 


 









0Shares