SQL Basic Aptitude Questions and Answers | Set 4

List of SQL Basic Aptitude Questions

16) Which command is used to submit (apply) all changes?
  1. COMMIT
  2. DONE
  3. SUBMIT
  4. APPLY

17) Which command is used to provide permissions to the database user?
  1. GIVE
  2. PROVIDE
  3. GRT
  4. GRANT

18) Which operator(s) is/are used to check more than one conditions with WHERE clause?
  1. AND
  2. OR
  3. BOTH AND, OR
  4. None of these

19) Which statement is used to extract different values from a table?
  1. SELECT DISTINCT
  2. SELECT RANDOM
  3. SELECT DIFFERENT
  4. SELECT DIFF

20 Which keyword is used with ORDER BY clause to display record set in descending order?
  1. DESCENDING
  2. DESC
  3. REVERSE
  4. REV



ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT


Top MCQs

Comments and Discussions!




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.