• 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
In SQL, which command(s) is(are) used to change a table's storage characteristics?

ALTER TABLE
MODIFY TABLE
All of these
CHANGE TABLE

ANSWER DOWNLOAD EXAMIANS APP

Introduction to SQL
The benefits of a standard relational language include which of the following?

All of these
Applications are not needed
Increased dependence on a single vendor
Reduced training costs

ANSWER DOWNLOAD EXAMIANS APP

Introduction to SQL
Table employee has 10 records. It has a non-NULL SALARY column which is also UNIQUE.The SQL statementSELECT COUNT(*) FROM employee WHERE SALARY > ALL (SELECT SALARY FROM EMPLOYEE);prints

0
5
9
10

ANSWER DOWNLOAD EXAMIANS APP

Introduction to SQL
To sort the results of a query use:

ORDER BY.
SORT BY.
GROUP BY.
None of these

ANSWER DOWNLOAD EXAMIANS APP

Introduction to SQL
The result of a SQL SELECT statement is a(n) ________ .

table
file
report
form

ANSWER DOWNLOAD EXAMIANS APP

Introduction to SQL
SELECT DISTINCT is used if a user wishes to see duplicate columns in a query.

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
↑