php hit counter

Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
cs403 full solve paper fall 2011-2012 virtual university of pakistan
VU Help • House Banner VU Help Virtual University Students - Assignments, Solved Papers, GDB & Exam Help Student Help Forum • Collaborative • Free Support
#1
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

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
.doc   Quiz No. 3 13-01-2012.doc (Size: 86 KB / Downloads: 359)

0300-9520262
Get solution in 24 hour
|cpmputer & internetConfusedmileys81:[SIZE="4"][SIZE="3"]....[/SIZE][/SIZE]
Reply


Possibly Related Threads…
Thread Author Replies Views Last Post
  MCM301 MIDTERM solve paper 2011 Vuhelper 4 25,026 03-07-2015, 04:34 PM
Last Post: Xpert
  mgt602 midterm paper 3000 mcq's Xpert 5 11,557 05-30-2013, 02:16 PM
Last Post: Vuhelper
  MID TERM PAST PAPER CS401 - Computer Architecture and Assembly SOLVE AND UNSOLVED usmanali126 2 6,540 04-13-2012, 03:27 PM
Last Post: Xpert
  Solved Paper MGT101 Fall 2009 Final Term viki 12 56,059 02-07-2012, 10:52 PM
Last Post: Xpert
  CS304 final term current paper spring Jily 2011 Vuhelper 1 3,654 02-04-2012, 10:34 PM
Last Post: roshi786
  Solved Paper of Final Term 2009 MTH101 Calculus And Analytical Geometry viki 8 12,302 02-04-2012, 12:47 AM
Last Post: Xpert
  CS101 Introduction to Computing FINAL TERM PAPERS SOLVED MCQS January 2012 Vuhelper 2 7,243 02-04-2012, 12:46 AM
Last Post: Xpert
  eng 201 final term paper Business and Technical English Writing January 2012 Vuhelper 3 7,440 01-30-2012, 06:52 PM
Last Post: Xpert
  CS101- Introduction to Computing FINALTERM EXAMINATION mega paper 2012 Vuhelper 0 7,745 01-29-2012, 10:18 PM
Last Post: Vuhelper
  Solved Paper CS101 Introduction To Computing Fall 2009 viki 2 6,179 01-26-2012, 05:05 AM
Last Post: sluggishmentality

Forum Jump:


Users browsing this thread: 1 Guest(s)
VU Help • House Banner VU Help Virtual University Students - Assignments, Solved Papers, GDB & Exam Help Student Help Forum • Collaborative • Free Support