Latest Activity In Study Groups

Join Your Study Groups

VU Past Papers, MCQs and More

Salam to all. Dear fellows, plz share current quiz solved files. thanx and JAZAK ALLAH.

Views: 5233

Replies to This Discussion

no One share

SQL stands for ______________. I - Structured Query Language II – Standard Query Language lll- Status Query Language

  • Only I
  • Only II
  • Both I and II
  • Only lll
  • Only I

Consider a table named “emp” having fields Empname, EmpID, Age, salary. Which of the following is true if the following SQL statement tries to execute? SELECT * FROM emp WHERE Empname=’ALI’ ORDERBY Age;

  • The statement has a syntax error
  • The statement displays the entire fields from emp in which the Empname is ALI in any order
  • The statement displays the entire fields from emp in which the Empname is ALI in descending order of their age
  • The statement displays the entire fields from emp in which the Empname is ALI in ascending order of their age

The statement displays the entire fields from emp in which the Empname is ALI in any order

es ka ans

Which of the following syntax of the functions in SQL is used to add column values?

  • COUNT(*)
  • COUNT(expression)
  • MAX(expression)
  • SUM(expression)
  • SUM(expression)

Which of the following is NOT a DDL command?

  • Create DB
  • Create table
  • Delete
  • Drop
  • Delete

Which of the following is not DML command?

  • Select
  • Update
  • Delete
  • Truncate 

RSS

© 2021   Created by + M.Tariq Malik.   Powered by

Promote Us  |  Report an Issue  |  Privacy Policy  |  Terms of Service