ADVERTISEMENT

ADVERTISEMENT

ADVERTISEMENT

SQL Basic Aptitude Questions and Answers | Set 5

List of SQL Basic Aptitude Questions

21) If you do not use ASC or DESC keyword with ORDER BY clause, what will happen?
  1. Records will be displayed in Descending Order.
  2. Records will be displayed in Random Order.
  3. Records will be displayed in Ascending Order.
  4. Command will not be executed.

22) Which operator will be used, if you want to print all names of a table starts with 'A'?
  1. LIKE
  2. PATTERN
  3. SIMILAR
  4. =

23) Which operator can be used to check a range?
  1. RANGE
  2. FROM TO
  3. BETWEEN
  4. All of the above

24) Which operator allows you to specify multiple values in WHERE clause?
  1. LIKE
  2. IN
  3. BETWEEN
  4. RANGE

25 _______ are used to temporarily rename a table or column heading?
  1. RENAME
  2. ALTER
  3. RENAME
  4. SQL ALIAS (AS)



ADVERTISEMENT



ADVERTISEMENT



Comments and Discussions

ADVERTISEMENT

ADVERTISEMENT

ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT

Languages: » C » C++ » C++ STL » Java » Data Structure » C#.Net » Android » Kotlin » SQL
Web Technologies: » PHP » Python » JavaScript » CSS » Ajax » Node.js » Web programming/HTML
Solved programs: » C » C++ » DS » Java » C#
Aptitude que. & ans.: » C » C++ » Java » DBMS
Interview que. & ans.: » C » Embedded C » Java » SEO » HR
CS Subjects: » CS Basics » O.S. » Networks » DBMS » Embedded Systems » Cloud Computing
» Machine learning » CS Organizations » Linux » DOS
More: » Articles » Puzzles » News/Updates

© https://www.includehelp.com some rights reserved.