Sponsored Links


Results 1 to 1 of 1

Thread: Online Virtual university Cs403 solved quiz online 13-1-2012

  1. #1
    Administrator
    Join Date
    Oct 2011
    Posts
    468

    Wink Online Virtual university Cs403 solved quiz online 13-1-2012

    Sponsored Links1


    Cs403 solved quiz online 13-1-2012
    Consider a table named “emp” having fields Empname, EmpID, Age, salary. Which of the following is true if the following SQL statement tries to execute? SELECT * FROM emp WHERE Empname=’ALI’ ORDERBY Age;
    The statement has a syntax error
    Which of the following function falls in the category of Aggregate functions.
    SUM
    MIN
    MAX
    All of the above
    REVOKE is a ______________ statement.
    Data Definition
    Control Access
    Data manipulation
    Data description
    Correct statement for creating table in Microsoft SQL server is.
    Which of the following statements creates a database named IMDB.
    CREATE DATABASE IMDB
    In SQL, which command is used to delete rows from table.
    DELETE
    REMOVE
    TRUNCATE
    Both I and II
    Truncate is an alternative of Delete command.
    False
    The ________ condition allows to retrieve values within a specific range.
    from
    Which of the following SQL statements used to control access to the data and to the database
    GRANT
    REVOKE
    Both GRANT and REVOKE
    SELECT
    Which of the following is used to retrieve and insert information from database?
    DML
    DDL
    DCL
    Both DML and DDL
    Value of a function in SQL is always determined by the input parameters
    True
    False
    Which of the following is used with INSERT command to insert values in a DB table?
    Onto
    INTO
    UPTO
    WITH
    Is the given SQL Statement prompt error? Select * from relation1;


    Consider a table named “emp” having fields Empname, EmpID, Age, salary. Which of the following is true if the following SQL statement tries to execute? SELECT * FROM emp WHERE Empname=’ALI’ ORDERBY Age;
    DCL
    In SQL, which command is used to modify the rows of tables.
    UPDATE
    INSERT
    BROWSE
    APPEND
    The ________ operator allows to use wild cards in the where clause of an SQL statement.
    LIKE

    Truncate command response time is ______ as compared to Delete command.
    Worst
    Which of the following is not DML command?
    Select
    Update

    Identify the language which is used to specify database schema.
    Non of the above
    Which of the following prevents duplicate values to be displayed as a result of an SQL statement?
    DISTINCT
    DELETE
    UPDATE
    ALTER
    SQL stands for ______________. I - Structured Query Language II – Standard Query Language lll- Status Query Language
    ONLY I
    ONLY II
    BOTH I AND II
    ONLY III
    Which language is used to permit or prohibit access to a table?
    DCL
    SQL is used for:
    Creating, managing and deleting tables and manage the relationships among the stored date.
    Generating queries, organizing, managing and retrieving data stored in a database.
    Maintaining data integrity and coordinate data sharing.
    All of the above

    Sponsored Links
    Attached Files Attached Files
    03009520262
    Rabeel Website

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 0
    Last Post: 04-28-2012, 05:00 AM
  2. Replies: 0
    Last Post: 01-11-2012, 04:10 PM
  3. Replies: 0
    Last Post: 01-05-2012, 04:08 AM
  4. MGT411 Online Quiz#2 Fall 2010 Solved quiz
    By Xpert in forum Solved MCQS
    Replies: 0
    Last Post: 11-24-2010, 03:09 PM
  5. cs403 Online quiz fall 2010
    By Xpert in forum MCQ's & Quiz Discussion
    Replies: 0
    Last Post: 11-24-2010, 03:04 PM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
-: Vuhelp Disclaimer :-
None of the files shown here are hosted or transmitted by this server. The links are provided solely by this site's users. The administrator's or staff of Vuhelp.net cannot be held responsible for what its users post, or any other actions of its users. You may not use this site to distribute or download any material when you do not have the legal rights to do so. It is your own responsibility to adhere to these terms. If you have any doubts about legality of content or you have any suspicions, feel free to contact us.
Online Education | JhelumSoft