We are here with you hands in hands to facilitate your learning & don't appreciate the idea of copying or replicating solutions. Read More>>

Looking For Something at vustudents.ning.com? Click Here to Search

www.bit.ly/vucodes

+ Link For Assignments, GDBs & Online Quizzes Solution

www.bit.ly/papersvu

+ Link For Past Papers, Solved MCQs, Short Notes & More

CS403 - Database Management Systems Quiz#4 Due Date: Jan 16, 2013 12:00 AM Jan 16, 2013 11:59 PM

please share here your current online quizs

+ Click Here To Join also Our facebook study Group.

..How to Join Subject Study Groups & Get Helping Material?..


See Your Saved Posts Timeline

Views: 1030

.

+ http://bit.ly/vucodes (Link for Assignments, GDBs & Online Quizzes Solution)

+ http://bit.ly/papersvu (Link for Past Papers, Solved MCQs, Short Notes & More)

+ Click Here to Search (Looking For something at vustudents.ning.com?)

Replies to This Discussion

Please Share your online Quizzes here to help each other.thanks

All students share ur quiz its very helpful for other students ................

Must share ur quiz .......

if any1 having helping material for preparation of Quiz-3; kindly share here

Thanks

Meray five k five quizzezz yeheen se aey thay.....

aik dafa zror read kar lay...


CS403- Database Management System

Quiz No. 3

Dated 13-01-2012

Dear Students,

Quiz No. 03 of CS403 - DBMS, would held on January 13, 2012 (Friday) and will be open for 24 hours (1 Day). Quiz would be from Lecture 25 to Lecture 32

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<span style="font-size:11pt;font-f...
Show original

ye 2012 mn ay thy ya 2013 mn ans me soon 

thanks for post
mera quiz b ese ma se aya.

Dear Maha Habib

is file ko .doc format mn send kro

 

my today quiz of cs 403

Attachments:

solved files send kro quizzes plzzzzzzzzzzzzzzzzzzzz?????????????????????????????????????????????????????????????????????????????????

halo

plz contact to solve quiz

3007494196

+-_-_*Ca$uAL$ mcs*_-_- personal id's nd contact numbers r not allowed so plz dnt share cell numbers nd id's

RSS

Latest Activity

Ali Shah updated their profile
36 minutes ago
+++Mahoo+++ replied to +++Amara+++++'s discussion DAROOD ki FAZiLAt
42 minutes ago
+++Mahoo+++ liked +++Amara+++++'s discussion DAROOD ki FAZiLAt
43 minutes ago
+++Amara+++++ posted discussions
52 minutes ago
+++Mahoo+++ updated their profile
54 minutes ago
☑ Steve liked Sharal Khan's blog post janta ho.........
1 hour ago
☑ Steve liked Sharal Khan's blog post ALLAH.........
1 hour ago
☑ Steve commented on Sharal Khan's blog post ALLAH.........
1 hour ago

Today Top Members 

© 2019   Created by + M.Tariq Malik.   Powered by

Promote Us  |  Report an Issue  |  Privacy Policy  |  Terms of Service