• 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
The SQL statement: SELECT Name, COUNT(*) FROM NAME_TABLE; counts the number of name rows and displays this total in a table with a single row and a single column.

True
False

ANSWER DOWNLOAD EXAMIANS APP

Introduction to SQL
The SQL statementSELECT SUBSTR('abcdefghij', INSTR('123321234', '2', 3, 2), 2) FROM DUAL;prints

ab
gh
bc
23

ANSWER DOWNLOAD EXAMIANS APP

Introduction to SQL
Which of the following join is also called as an 'inner-join'?

None of these
Non-Equijoin
Equijoin
Self-Join

ANSWER DOWNLOAD EXAMIANS APP

Introduction to SQL
A subquery in an SQL SELECT statement:

cannot have its results sorted using ORDER BY.
can always be duplicated by a join.
can only be used with two tables.
has a distinct form that cannot be duplicated by a join.

ANSWER DOWNLOAD EXAMIANS APP

Introduction to SQL
Which of the following is valid SQL for an Index?

CHANGE INDEX ID;
CREATE INDEX ID;
REMOVE INDEX ID;
ADD INDEX ID;

ANSWER DOWNLOAD EXAMIANS APP

Introduction to SQL
Find all the cities whose humidity is 89

SELECT city WHERE humidity = 89;
SELECT city FROM weather WHERE humidity = 89;
SELECT city FROM weather;
SELECT humidity = 89 FROM weather;

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
↑