• 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
To remove duplicate rows from the results of an SQL SELECT statement, the ________ qualifier specified must be included.

SINGLE
DISTINCT
ONLY
UNIQUE

ANSWER DOWNLOAD EXAMIANS APP

Introduction to SQL
In SQL, which of the following is not a data definition language commands?

RENAME
UPDATE
GRANT
REVOKE

ANSWER DOWNLOAD EXAMIANS APP

Introduction to SQL
The HAVING clause acts like a WHERE clause, but it identifies groups that meet a criterion, rather than rows.

True
False

ANSWER DOWNLOAD EXAMIANS APP

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

bc
gh
23
ab

ANSWER DOWNLOAD EXAMIANS APP

Introduction to SQL
SQL is a data sublanguage.

True
False

ANSWER DOWNLOAD EXAMIANS APP

Introduction to SQL
The SQL -92 wildcards are ____ and ____ .

asterisk (*); percent sign (%)
percent sign (%); underscore (_)
question mark (?); asterisk (*)
underscore(_); question mark (?)

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
↑