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

www.vustudents.ning.com

 www.bit.ly/vucodes + Link For Assignments, GDBs & Online Quizzes Solution www.bit.ly/papersvu + Link For Past Papers, Solved MCQs, Short Notes & More

Dear Students! Share your Assignments / GDBs / Quizzes files as you receive in your LMS, So it can be discussed/solved timely. Add Discussion

# Quizz No 3: CS403 (Database Management System) will be opened on 10th July, 2014 and last date 11th July, 2014

DEAR STUDENT:

It is to remind that quiz 03 of CS403 (Database Management System) will be opened on 10th July, 2014 and last date to attempt quiz will be 11th July, 2014

including lectures from 26 to 30.

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

+ How to become Top Reputation, Angels, Intellectual, Featured Members & Moderators?

+ VU Students Reserves The Right to Delete Your Profile, If?

Views: 5634

.

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

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

### Replies to This Discussion

MY TODAY QUIZZ.......

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

• SELECT
• FROM
• WHERE( true)

Question # 2 of 10 ( Start time: 04:17:05 PM ) Total Marks: 1 The _________ function helps reduce the need to use mutiple OR conditions.

• Like
• IN( true)
• AND
• BETWEEN

3:-   Which of the following is incorrect about alter table statement?

• Cannot be used to modify type or size of an existing column ( true)
• 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

4:-  The ________ condition allows to retrieve values within a specific range.

• in
• And
• like
• between (true)

5:   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 (true)
• suitable to relatively static situations
• It is a process, which means to place records from different tables to place in adjacent physical locations

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

• UPDATE (true)
• INSERT
• BROWES
• APPEND

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

• where
• order by (true)
• From
• Having

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

• grant
• revoke
• both 1 and 2 (true)
• select

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

• delete (true)
• remove

10:   Which of the following is a String function in SQL

• count
• len (true)
• sqrt
• Sin

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

• where
• order by (true)
• from
• having

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

• DML (true)
• DDL
• DCL
• Both DML and DDL

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

• 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. (true)
• None of the above.

4:     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 (true)
• suitable to relatively static situations.

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

• update (true)

6:    The ____________ keyword is used in SELECT statement to return different values.

• distinct ( true)

7:     Which of the following is a String function in SQL

• COUNT
• LEN (true)
• SIN
• SQL

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

• Like
• IN (true)
• AND
• BETWEEN

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

• SELECT
• FROM
• BOTH SELECT AND FROM( true)

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

• all data(record) will be effected (true)

1:-Which of the following is not an aggregate function

• AVG
• SUM
• UPPER
• MAX (true)

2:   UPDATE command belongs to which type of Classification

• DML( true)
• DDL
• DCL
• DQL

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

• INTO
• VALUES
• INSERT
• MODIFY( true)

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

• ONTO
• INTO (true)
• UPTO
• WITH

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

• T (ture ans)
• F

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

• LIKE (true)
• IN
• NOne of the option
• FROM

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

• DELETE (true)
• REMOVE
• TRUNCATE

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

• SELECT
• FROM
• BOTH SELECT AND FROM (true)

9:    The ____________ keyword is used in SELECT statement to return different values.

• LIKE
• IN
• Distinct (true)

10:   Which of the following prevents duplicate values to be displayed as a result of an SQL statement?

• DISTINCT( true)
• DELETE
• UPDATE

my quiz No.3 of cs403

date:11-07-2014

check it and correct the errors.

Attachments:

## Latest Activity

7 minutes ago
9 minutes ago
Aqsa Khan liked Alishba's discussion Nikkah Mubarak To <3 !! 'JS' !! <3
27 minutes ago
+!!!❣Stylo Queen❣!!!+ updated their profile
51 minutes ago
+ ! Suspecious+ updated their profile
53 minutes ago
+ ! Suspecious+ replied to + ! Suspecious+'s discussion احساسات
57 minutes ago
+ ! ❤SΕNSΙТΙVΕ(∂ΕSΕЯТ ΡЯΙNCΕSS)❤ liked + ! Suspecious+'s discussion احساسات
1 hour ago
1 hour ago
1 hour ago

1

2

3