• 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 establish a range of values, < and > can be used.

False
True

ANSWER DOWNLOAD EXAMIANS APP

Introduction to SQL
How to select all data from student table starting the name from letter 'r'?

SELECT * FROM student WHERE name LIKE 'r%';
SELECT * FROM student WHERE name LIKE '_r%';
SELECT * FROM student WHERE name LIKE '%r';
SELECT * FROM student WHERE name LIKE '%r%';

ANSWER DOWNLOAD EXAMIANS APP

Introduction to SQL
The Microsoft Access wildcards are ____ and ____ .

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

ANSWER DOWNLOAD EXAMIANS APP

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

Equijoin
Self-Join
None of these
Non-Equijoin

ANSWER DOWNLOAD EXAMIANS APP

Introduction to SQL
The SQL statement that queries or reads data from a table is ________ .

None of these
QUERY
READ
SELECT

ANSWER DOWNLOAD EXAMIANS APP

Introduction to SQL
Data manipulation language (DML) commands are used to define a database, including creating, altering, and dropping tables and establishing constraints.

True
False

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
↑