• 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
SQL provides five built-in functions: COUNT, SUM, AVG, MAX, MIN.

False
True

ANSWER DOWNLOAD EXAMIANS APP

Introduction to SQL
The command to remove rows from a table 'CUSTOMER' is:

UPDATE FROM CUSTOMER ...
REMOVE FROM CUSTOMER ...
DROP FROM CUSTOMER ...
DELETE FROM CUSTOMER WHERE ...

ANSWER DOWNLOAD EXAMIANS APP

Introduction to SQL
You can add a row using SQL in a database with which of the following?

INSERT
ADD
MAKE
CREATE

ANSWER DOWNLOAD EXAMIANS APP

Introduction to SQL
The command to eliminate a table from a database is:

DELETE TABLE CUSTOMER;
DROP TABLE CUSTOMER;
REMOVE TABLE CUSTOMER;
UPDATE TABLE CUSTOMER;

ANSWER DOWNLOAD EXAMIANS APP

Introduction to SQL
The SELECT statement SELECT 'Hi' FROM DUAL WHERE NULL = NULL; Outputs

TRUE
Hi
Nothing
FLASE

ANSWER DOWNLOAD EXAMIANS APP

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

2345
456789
1234
6789

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
↑