Hello for everyone, today we talk about the SQL sample exam questions #3, or like exam questions, I hope this lesson useful for you.

https://www.examveda.com — Visit

Question) What is the full form of DDL?

  • a) Dynamic Data Language
  • b) Detailed Data Language
  • c) Data Definition Language
  • d) Data Derivation Language

Answer: C

———————————————————————————————————————————–

Question) The virtual table thet it’s created by data from the result of an SQL ‘Select’ statement is called ——- ?

  • a) View
  • b) Synonym
  • c) Sequence
  • d) Transaction

Answer: A

———————————————————————————————————————————–

Question) ——- is not a category of SQL command?

  • a) TCL
  • b) SCL
  • c) DCL
  • d) DDL

Answer: B

———————————————————————————————————————————–

Question) Whic of the following SQL clauses is used to DELETE tuples from a database table?

  • a) DELETE
  • b) REMOVE
  • c) DROP
  • d) CLEAR

Answer: A

———————————————————————————————————————————–

Question) If you want to allow age of a person > 18 in the column Age of table Person, then which constraint will be applied to AGE column ?

  • a) Default
  • c) Check
  • c) NOT NULL
  • b) Nnoe

Answer: B

———————————————————————————————————————————–

Question) If you don’t specify ASC or DESC after a SQL ORDER BY clause, the following is used by default —– ?

  • a) ASC
  • b) There is no default value
  • c) DESC
  • d) None of the mentioned

Answer: A

———————————————————————————————————————————–

Question) Which command undo all the updates performed by the SQL in the transaction?

  • a) ROLLBACK
  • b) COMMIT
  • c) TRUNCATE
  • d) DELETE

Answer: C

———————————————————————————————————————————–

Question) Which function is used to divides one numeric expression by another and get the remainder?

  • a) POWER
  • b) MOD
  • c) ROUND
  • d) REMAINDER

Answer: B

———————————————————————————————————————————–

Question) A SQL query will not work if there are no indexes on the relations – Is it true?

  • a) NO
  • b) YES

Answer: A

———————————————————————————————————————————–

I hope this lesson is be useful for you, have a more success and have a good day.

maintain social distance & wash your hands with soap for 20 seconds