Home > Know-IT-All Chapter Quiz: SQL concepts & facilities
Quiz:
EMAIL THIS

Know-IT-All Chapter Quiz: SQL concepts & facilities

04 Apr 2006 | Search400.com

Digg This!    StumbleUpon Toolbar StumbleUpon    Bookmark with Delicious Del.icio.us   

Think you know all there is to know about SQL? We challenge you to test your skills by taking our latest quiz. All answers to this quiz are found in the free excerpt. It is best to copy and paste the answer into the box. Good luck!

  1. SQL is a query language for end users. True or false?

    Your answer:

    See book excerpt for answer

  2. Triggers are implemented via the SQL language and the DB2 UDB database. True or false?

    Your answer:

    See book excerpt for answer

  3. SQL basic facilities include:
    a. table facility, table editor, query facility
    b. table facility, table editor
    c. SQL facility, table query
    Your answer:

    See book excerpt for answer

  4. The SQL name is log, the System 5 name is:
    a. journal
    b. job
    c. book

    Your answer:

    See book excerpt for answer


  5. A relational database is a database that is perceived by its users to be a collection of tables. True or false?

    Your answer:

    See book excerpt for answer

  6. CRTPF is short for:
    a. create physical file
    b. create real table physical file
    c. both above options are correct

    Your answer:

    See book excerpt for answer

  7. DDS and SQL's capabilities are virtually the same. True or false?

    Your answer:

    See book excerptfor answer

  8. DML is short for:
    a. Data Manual Language
    b. Decimal Manipulation Language
    c. Data Manipulation Language

    Your answer:

    See book excerpt for answer

  9. The function is "Select verb starts the statement." What is the command?
    a. start
    b. select
    c. from

    Your answer:

    See book excerpt for answer

  10. What does DCL stand for?
    a. Decimal Control Language
    b. Basic SQL Data Control Language
    c. Data Capacity Language

    Your answer:

    See book excerpt for answer






    11. Digg This!    StumbleUpon Toolbar StumbleUpon    Bookmark with Delicious Del.icio.us   



    RELATED CONTENT
    iSeries SQL commands and statements
    Enhancing RPG with external SQL stored procedures
    Tracking data changes on IBM i with triggers
    Introduction to SQLRPGLE on IBM i: Making a report
    Making the most of RPG data handling on IBM i
    When is the YES option for 'reuse deleted files' function the best choice?
    Monitoring members 'stuck' within a physical file on an EDI system
    Creating a host variable of the 'where in' statement in SQL
    SQL server error message -321
    Choose which column names are returned via ODBC when working with DB2 files
    Convert a numeric physical file to a character in SQL without leading zeros
    iSeries SQL commands and statements Research

    RELATED RESOURCES
    2020software.com, trial software downloads for accounting software, ERP software, CRM software and business software systems
    Search Bitpipe.com for the latest white papers and business webcasts
    Whatis.com, the online computer dictionary




iSeries AS/400 Solutions: Grid Computing
HomeNewsTopicsITKnowledge ExchangeTipsBlogsAsk the ExpertsMultimediaWhite PapersProducts
About Us  |  Contact Us  |  For Advertisers  |  For Business Partners  |  Site Index  |  RSS
SEARCH 
TechTarget provides technology professionals with the information they need to perform their jobs - from developing strategy, to making cost-effective purchase decisions and managing their organizations' technology projects - with its network of technology-specific websites, events and online magazines.

TechTarget Corporate Web Site  |  Media Kits  |  Site Map




All Rights Reserved, Copyright 1999 - 2009, TechTarget | Read our Privacy Policy 		  TechTarget - The IT Media ROI Experts