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

[++ BSIT ا ایمان زینب]

DEAR STUDENT:

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

including lectures from 26 to 30.

[++ BSIT ا ایمان زینب]

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

[++ BSIT ا ایمان زینب]

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)

[++ BSIT ا ایمان زینب]

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

[ADNAN BUTT]

my quiz No.3 of cs403

date:11-07-2014

check it and correct the errors.

Adnan Butt