• HOME
  • QUIZ
  • CONTACT US
EXAMIANS
  • COMPUTER
  • CURRENT AFFAIRS
  • ENGINEERING
    • Chemical Engineering
    • Civil Engineering
    • Computer Engineering
    • Electrical Engineering
    • Mechanical Engineering
  • ENGLISH GRAMMAR
  • GK
  • GUJARATI MCQ

Introduction to SQL

Introduction to SQL
Which SQL keyword is used to retrieve a maximum value?

UPPER
MOST
MAX
TOP

ANSWER DOWNLOAD EXAMIANS APP

Introduction to SQL
The ADD command is used to enter one row of data or to add multiple rows as a result of a query.

True
False

ANSWER DOWNLOAD EXAMIANS APP

Introduction to SQL
DISTINCT and its counterpart, ALL, can be used more than once in a SELECT statement.

True
False

ANSWER DOWNLOAD EXAMIANS APP

Introduction to SQL
............. joins two or more tables based on a specified column value not equaling a specified column value in another table.

EQUIJOIN
NON-EQUIJOIN
OUTER JOIN
NATURAL JOIN

ANSWER DOWNLOAD EXAMIANS APP

Introduction to SQL
The SQL statementSELECT ROUND(45.926, -1) FROM DUAL;

prints garbage
prints 045.926
is illegal
prints 50

ANSWER DOWNLOAD EXAMIANS APP

Introduction to SQL
The SQL statementSELECT SUBSTR('123456789', INSTR('abcabcabc', 'b'), 4) FROM DUAL;

1234
2345
6789
456789

ANSWER DOWNLOAD EXAMIANS APP
MORE MCQ ON Introduction to SQL

DOWNLOAD APP

  • APPLE
    from app store
  • ANDROID
    from play store

SEARCH

LOGIN HERE


  • GOOGLE

FIND US

  • 1.70K
    FOLLOW US
  • EXAMIANSSTUDY FOR YOUR DREAMS.
  • SUPPORT :SUPPORT EMAIL ACCOUNT : examians@yahoo.com

OTHER WEBSITES

  • GUJARATI MCQ
  • ACCOUNTIANS

QUICK LINKS

  • HOME
  • QUIZ
  • PRIVACY POLICY
  • DISCLAIMER
  • TERMS & CONDITIONS
  • CONTACT US
↑