Sponsored Links


Results 1 to 1 of 1

Thread: cs403 full solve paper fall 2011-2012 virtual university of pakistan

  1. #1
    Administrator Vuhelper's Avatar
    Join Date
    Apr 2011
    Posts
    9,578

    cs403 full solve paper fall 2011-2012 virtual university of pakistan

    Sponsored Links1


    solve paper in attachment

    Which of the following is one of the purposes of using DDL commands?

    inserting records into databases

    updating records into databases

    manipulating databases

    creating and destroying databases





    Which of the following is incorrect about alter table statement?

    Cannot be used to modify type or size of an existing column

    Can be used to delete a column

    Can not be used to create a new table

    Can be used to add column in the existing table



    Which of the following is used to retrieve and insert information from database?

    DML

    DDL

    DCL

    Both DML and DDL



    Which of the following is used with INSERT command to insert values in a DB table?

    ONTO

    INTO

    UPTO

    WITH


    In SQL, which command is used to modify the rows of tables.

    Update

    Insert

    Browse

    Append



    Identify the basic part(s) of a SELECT statement?

    SELECT

    FROM

    Both SELECT and FROM

    DISTINCT



    Columns used to uniquely identify individual rows of a given table, may be specified to be not NOT NULL.

    True

    False



    Objective of an order by clause is to display or arrange output of a select statement in a particular order.

    True

    False



    Which of the following is not a part of an INSERT statement?

    INTO

    VALUE

    INSERT

    Modify

    The ________ operator allows to use wild cards in the where clause of an SQL statement.

    Select correct option:



    IN

    FROM

    LIKE

    None of the above.



    Question # 3 of 10 ( Start time: 06:15:54 PM ) Total Marks: 1

    Which of the following is not an aggregate function

    Select correct option:



    AVG

    SUM

    UPPER

    MAX



    Question # 4 of 10 ( Start time: 06:16:23 PM ) Total Marks: 1

    UPDATE command belongs to which type of Classification

    Select correct option:



    DML

    DDL

    DCL

    DQL



    Question # 6 of 10 ( Start time: 06:18:52 PM ) Total Marks: 1

    GRANT belongs to which type of SQL commands classification

    Select correct option:



    DML

    DDL

    DCL

    DQL



    Question # 7 of 10 ( Start time: 06:20:21 PM ) Total Marks: 1

    DML does not used to :

    Select correct option:



    add new rows to tables

    retrieve rows from table

    modify the rows of tables

    alter a table definition







    Question # 9 of 10 ( Start time: 06:22:02 PM ) Total Marks: 1

    Which of the following SQL statements used to control access to the data and to the database?

    Select correct option:



    GRANT

    REVOKE

    Both GRANT and REVOKE

    SELECT



    Which of the following is the correct syntax for adding a new column into an existing table.

    Select correct option:



    ALTER TABLE table_name { ALTER [COLUMN] column type [(size)] [DEFAULT default] }

    ALTER TABLE table_name { ADD [COLUMN] column type [(size)] [DEFAULT default] }

    Both I and II.

    None of the above.





    DML does not used to

    Add new Rows to tables

    Retrieve Rows from table

    Modify the rows of tables

    Alter table definition



    The _________ function helps reduce the need to use mutiple OR conditions.

    Like

    IN

    AND

    Between



    Columns used to uniquely identify individual rows of a given table, may be specified to be not NOT NULL.

    TRUE

    FALSE



    In SQL, which command is used to delete rows from table.

    Delete

    Remove

    Truncate

    Both I and II



    Which of the fllowing clauses allows to sort the records in result set?

    Where

    Order by

    From

    Having



    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 with INSERT command to insert values in a DB table?

    ONTO

    INTIO

    UPTO

    WITH



    In SQL queries, while creating tables or relations in database, key columns may be specified by

    Bull

    Not Null

    Data Type

    None of the above



    Which of the following is not an aggregate function

    AVG

    SUM

    UPPER

    MAX



    _______ Operators are the ones that require two operands on both sides of the operator.

    Double

    Tow Sided

    Binary

    None of the given options



    What happened if the Where clause is omitted from a Delete Statement?

    All record from the table are deleted

    No record from the tables will be deleted

    First record of the tables will be deleted

    The statement will not be executed and will give a syntax error



    Grant belong to which types of SQL command classification

    DML

    DDL

    DCL

    DQL



    Update command belong to which type of classification

    DML

    DDL

    DCL

    DQL





    Which of the following is incorrect about alter table statement?

    Cannot be used to modify type or size of an existing column

    Can be used to delete a column

    Can not be used to create a new table

    Can be used to add column in the existing table



    Which of the following is not true regarding clustering ?

    It increases the efficiency since related records are placed close to each other.

    Clustering makes records, difficult to access

    Suitable to relatively static situations

    It is a process, which means to place record from different tables to places in adjacent physical locations.



    Truncate command responses time is ____________ as compared to delete command.

    Poor

    Same

    Better

    Worst



    Which of the following is a String function in SQL

    Count

    LEN

    SQRT

    SIN



    Revoke is a __________ Statement

    Data Definition

    Control Access

    Data Manipulation

    Data Description



    GRANT is a _____________ command.

    DDL

    DML

    DCL

    None of the above



    Which of the following is one of the purposes of using DDL commands?

    Inserting records into databases

    Updating records into databases

    Manipulation databases

    Creating and destroying databases











    Which of the following is not a part of an INSERT statement?
    Select correct option:
    INTO
    VALUES
    INSERT
    MODIFY



    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
    The statement displays the entire fields from emp in which the Empname is ALI in any order
    The statement displays the entire fields from emp in which the Empname is ALI in descending order of their age
    The statement displays the entire fields from emp in which the Empname is ALI in ascending order of their age



    In SQL, which command is used to modify the rows of tables.
    Select correct option:
    UPDATE
    INSERT
    BROWSE
    APPEND



    In SQL, which command is used to delete rows from table.
    Select correct option:
    DELETE
    REMOVE
    TRUNCATE
    Both I and II



    In SQL queries, while creating tables or relations in database, key columns may be specified by
    Select correct option:
    Null
    Not Null
    Data Type
    None of the above



    What happens if the WHERE clause is omitted from a DELETE statement?
    All records from the table are deleted
    No record from the table will be deleted
    First record of the table will be deleted
    The statement will not be executed and will give a syntax error



    Truncate command response time is ____ as compared to Delete command.
    Select correct option:
    Poor
    Same
    Better
    worst





    Which of the following syntax of the functions in SQL is used to add column values?
    Select correct option:
    COUNT(*)
    COUNT(expression)
    MAX(expression)
    SUM(expression) Not Sure



    Which of the following is used to retrieve and insert information from database?
    Select correct option:
    DML
    DDL
    DCL
    Both DML and DDL




    Which of the following is used to filter rows according to some condition(s)?
    Select correct option:
    SELECT
    FROM
    WHERE
    UPDATE



    Question # 1 of 10 ( Start time: 09:52:41 PM ) Total M a r k s: 1

    Which of the following is used with INSERT command to insert values in a DB table?

    Select correct option:

    ONTO

    INTO

    UPTO

    WITH





    Which of the following is a correct way of selecting all the columns from a table called PERSONS?

    Select correct option:

    SELECT FROM * Persons

    SELECT * FROM Persons

    SELECT * WHERE Persons

    SELECT WHERE * Persons







    The ________ operator allows to use wild cards in the where clause of an SQL statement.

    Select correct option:

    IN

    FROM

    LIKE

    None of the above.



    Which of the following statements creates a database named IMDB.

    Select correct option:

    CREATE DATABASE IMDB;

    CREATE DB IMDB;

    ADD DATABASE named IMDB;

    CREATE IMDB DATABASE;



    Which of the following is not true regarding clustering?

    Select correct option:

    It increases the efficiency since related records are placed close to each other

    Clustering makes records, difficult to access

    Suitable to relatively static situations.

    It is a process, which means to place records from different tables to place in adjacent physical locations



    Which of the following is used to filter rows according to some condition(s)?

    Select correct option:

    SELECT

    FROM

    WHERE

    UPDATE



    Question # 7 of 10 ( Start time: 09:55:14 PM ) Total M a r k s: 1

    Which of the following is not an aggregate function

    Select correct option:

    AVG

    SUM

    UPPER

    MAX



    CREATE TABLE and CREATE index belongs to which type of SQL commands

    Select correct option:

    DML

    DDL

    DCL

    DQL





    Question # 9 of 10 ( Start time: 09:55:59 PM ) Total M a r k s: 1

    In SQL, which command is used to modify the rows of tables.

    Select correct option:

    UPDATE

    INSERT

    BROWSE

    APPEND







    SQL is used for:
    Select correct option:

    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



    Which of the following is used to filter rows according to some condition(s)?
    Select correct option:

    SELECT
    FROM
    WHERE
    UPDATE



    Which language is used to permit or prohibit access to a table?
    Select correct option:

    DCL
    DDL
    DML
    All of the above.



    Which of the following is a String function in SQL

    COUNT
    LEN
    SQRT
    SIN



    Truncate is an alternative of Delete command.
    Select correct option:
    True
    False







    Which of the following SQL statements used to control access to the data and to the database?
    Select correct option:

    GRANT
    REVOKE
    Both GRANT and REVOKE
    SELECT



    Data Manipulation Language (DML) is the set of commands used to maintain and query a database including updating, inserting, modifying and retrieving data.
    Select correct option:

    True
    False



    Which of the following is NOT a DDL command?
    Select correct option:
    Create DB
    Create table
    Delete
    Drop



    Which of the following is one of the purposes of using DDL commands?
    Select correct option:

    inserting records into databases
    updating records into databases
    manipulating databases
    creating and destroying databases



    Which of the following function falls in the category of Aggregate functions.
    Select correct option:

    SUM
    MIN
    MAX
    All of the above



    SQL stands for ______________.

    I - Structured Query Language

    II – Standard Query Language

    lll- Status Query Language

    Select correct option:

    Only I

    Only II

    Both I and II

    Only lll



    Making a change to the conceptual schema of a database but not affecting the existing

    external schemas is an example of



    Physical data independence.

    Concurrency control.

    Logical data independence.

    Functional dependency



    SQL data types do not have support for storing multi-media objects directly.

    Select correct option:



    True

    False



    Truncate is an alternative of Delete command.

    Select correct option:

    True

    False



    What happens if the WHERE clause is omitted from a DELETE statement?

    Select correct option:

    All records from the table are deleted

    No record from the table will be deleted

    First record of the table will be deleted

    The statement will not be executed and will give a syntax error



    Query Analyzer is used to practice SQL in MS-Access and MS-SQL Server.

    Select correct option:

    True

    False



    Which of the following is used to retrieve and insert information from database?

    Select correct option:

    DML

    DDL

    DCL

    Both DML and DDL

    Which of the following can not be included into CREATE TABLE statement?

    Select correct option:



    Data types

    Constraints

    Attributes

    Cardinalities





    Which of the following is NOT a DDL command?

    Select correct option:

    Create DB

    Create table

    Delete

    Drop



    Which of the following SQL statements used to control access to the data and to the database?

    Select correct option:

    GRANT

    REVOKE

    Both GRANT and REVOKE

    SELECT



    A relational database is

    Select correct option:

    one that consists of two or more tables

    a database that is able to process tables, queries, forms, reports and macros

    one that consists of two or more tables that are joined in some way

    the same as a flat file database





    Which model operates at the lowest level of abstraction?

    Select correct option:

    conceptual

    internal

    external

    physical



    A________is used to maintain a connection between the users of the database system.

    Select correct option:



    mail server

    file server

    client-server

    none of the given



    A collection of concepts that can be used to describe the structure of a database

    Select correct option:

    Database

    DBMS

    Data model

    Data





    Data about data is metadata

    Select correct option:

    True

    False



    A primary key is an attribute (or set of attributes) that has been chosen for an entity, whose values are used to uniquely identify a particular instance of an entity.

    Select correct option:

    True

    False

    Partially True

    None of the given



    Which of the following is INCORRECT statement concerning the database design process?

    Select correct option:

    During requirements collection and analysis phase, one can gather the data requirements of database users.

    By referring to a high level data model, it is possible to understand the data requirements of the users, entity types, relationships and constraints.

    Transformation of the high level data model into the implementation data model is called logical design or data model mapping.

    During the logical design phase of internal storage structures, access paths and file organization for the database files are specified.



    Which feature of database provides conversion from inconsistent state of DB to a consistent state ensuring minimum data loss?

    Select correct option:

    User accessible catalog

    Data processing

    Recovery service

    Authorization service

    Who is responsible for authorizing access to the database, for coordinating and monitoring its use?

    Select correct option:

    Database Designer

    Database Administrator

    End User

    Application Programmer





    Which of the following describes the job of a database administrator?

    Select correct option:

    Development, implementation operation of the physical database

    Creation of the system catalog

    Monitoring and controlling database security and authorization: Setting up controls to ensure the quality and integrity of data

    All of the above



    Which of the following is NOT a component of a DFD?

    Select correct option:

    Dataflow

    Datastore

    External entities

    Relationship between external entities



    The Entity Relation Model models

    Select correct option:

    Entities, Relationships and Processes

    Entities and Relationships

    Relationships

    Entities



    A relational database system is based on the concept(s) of:

    Select correct option:

    A network of data records

    Sponsored Links

    Nested tables

    Tables, rows and columns

    A tree-like structure of data



    Data Manipulation Language (DML) is the set of commands used to maintain and query a database including updating, inserting, modifying and retrieving data.

    Select correct option:

    True

    False



    DML does not used to :

    Add new rows to tables

    Retrieve row from tables

    Modify the rows of tables

    Alter a table definition







    What does the abbreviation DBMS stand for?

    Database Manipulation Software.

    Data Borrowing and Movement Software

    Digital Base Mapping System.

    Database Management System.





    Identify the language which is used to specify database schema.

    DCL

    DML

    DDL

    Non of the above



    Columns used to uniquely identify individual rows of a given table, may be specified to be not NOT NULL.



    True

    False





    Value of a function in SQL is always determined by the input parameters

    True

    False
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. cs403 full solve current paper spring July 2011
    By Vuhelper in forum Current paper 2011
    Replies: 0
    Last Post: 07-10-2011, 07:21 PM
  2. Replies: 0
    Last Post: 05-11-2011, 02:41 AM
  3. Replies: 0
    Last Post: 04-15-2011, 07:36 AM
  4. Replies: 1
    Last Post: 04-15-2011, 05:50 AM
  5. Replies: 0
    Last Post: 04-14-2011, 06:48 PM

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