Sybase Quiz :: 2

10 Questions | Attempts: 398
Share

SettingsSettingsSettings
Software Quizzes & Trivia

Sybase SQL , T-SQL Quiz


Questions and Answers
  • 1. 
    Which SQL command is used to extract data from tables?
    • A. 

      EXTRACT

    • B. 

      SELECT

    • C. 

      FIND

    • D. 

      None of above

  • 2. 
    Which SQL keyword is used to sort the result set?
    • A. 

      ORDER

    • B. 

      SORT

    • C. 

      ORDER BY

    • D. 

      SORT BY

  • 3. 
    The AND operator displays a record if ANY of the conditions listed are true.
    • A. 

      True

    • B. 

      False

  • 4. 
    Stored procedures can be execute on remote Adaptive Servers.
    • A. 

      YES

    • B. 

      NO

  • 5. 
    In Create stored procedure, the Parameter names can be a maximum of 30 bytes long, including the @ sign.
    • A. 

      True

    • B. 

      False

  • 6. 
    Which of the following command will be used for execute a Stored procedure? A) exec procedure_name B) execute procedure_name C) procedure_name
    • A. 

      A and B

    • B. 

      Only A

    • C. 

      Only B

    • D. 

      All A, B and C

  • 7. 
    Count(*) returns the total number of non-NULL values in the column.
    • A. 

      True

    • B. 

      False

  • 8. 
    Assume that today's is monday and today's date is 11 apr 2011. Result of the following query: select datename(dw,getdate())
    • A. 

      11 apr 2011 monday

    • B. 

      11 apr 2011

    • C. 

      Monday

    • D. 

      Error

  • 9. 
    Assume that today's is monday and today's date is 11 apr 2011. Result of the following query: select datepart(dw,getdate())
    • A. 

      Monday

    • B. 

      Apr

    • C. 

      11

    • D. 

      2

  • 10. 
    We can define primary key and foreign key on views.
    • A. 

      True

    • B. 

      False

Back to Top Back to top
×

Wait!
Here's an interesting quiz for you.

We have other quizzes matching your interest.