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


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

How to Add New Discussion in Study Group ? Step By Step Guide Click Here.

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 Follow the New Added Discussions at Your Mail Address?

+ 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?


See Your Saved Posts Timeline

Views: 5628

.

+ 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?)

+ Click Here To Join (Our facebook study Group)

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.

Adnan Butt

Attachments:

RSS

Latest Activity

Profile IconAmjad Abbas, Nimra zahid, Aisha RD and 31 more joined Virtual University of Pakistan
1 minute ago
+ Danial replied to +¢αяєℓєѕѕ gιяℓ's discussion Shadi Ho Rhi Hai Alhamdulillah.......... (^__^)!
2 minutes ago
+ Danial liked +¢αяєℓєѕѕ gιяℓ's discussion Shadi Ho Rhi Hai Alhamdulillah.......... (^__^)!
3 minutes ago
+ Iuuoɔǝut + posted videos
10 minutes ago
MUDASAR SHAKIL posted a status
"Mujhe Suspend kyon kar diya jata ha chat se yar"
13 minutes ago
ϝ ι ყ α replied to + "αяsαℓ " Ќąƶµяɨ •"'s discussion Happy Marriage to "Zee" & " Nomi weds Noor"....!
34 minutes ago
Aiman posted a status
"Hello students I am new please tell me their is any student of Bs Psychology I have a problem to make Isl201 assignment please help me"
37 minutes ago
Scorpio liked +¢αяєℓєѕѕ gιяℓ's discussion Shadi Ho Rhi Hai Alhamdulillah.......... (^__^)!
39 minutes ago
Sidra Mustafa replied to + M.Tariq Malik's discussion MGT610 Business Ethics GDB Fall 2019 Solution & Discussion in the group MGT610 Business Ethics
54 minutes ago
Sidra Mustafa joined + M.Tariq Malik's group
54 minutes ago
Imran Khan replied to + M.Tariq Malik's discussion MTH601 Assignment No 01 Fall 2019 Solution & Discussion in the group MTH601 Operations Research
1 hour ago
Profile IconImran Khan, Hashim and Aakash Ahmed joined + M.Tariq Malik's group
1 hour ago
+ ! ! ! ! Mehαr Mαh꧂ replied to + M.Tariq Malik's discussion MGT201 Financial Management GDB Fall 2019 Solution & Discussion Last Date: 22-11-2019 in the group MGT201 Financial Management
1 hour ago
+ ! ! ! ! Mehαr Mαh꧂ liked + M.Tariq Malik's discussion MGT201 Financial Management GDB Fall 2019 Solution & Discussion Last Date: 22-11-2019
1 hour ago
+"Khwab Zaadi"+ liked + M.Tariq Malik's discussion MTH501 Assignment No 01 Fall 2019 Solution & Discussion Due Date: 19-11-2019
1 hour ago
+ "αяsαℓ " Ќąƶµяɨ •" replied to + M.Tariq Malik's discussion MGT201 Financial Management GDB Fall 2019 Solution & Discussion Last Date: 22-11-2019 in the group MGT201 Financial Management
1 hour ago
+ "αяsαℓ " Ќąƶµяɨ •" replied to + M.Tariq Malik's discussion MGT201 Financial Management GDB Fall 2019 Solution & Discussion Last Date: 22-11-2019 in the group MGT201 Financial Management
1 hour ago
+ "αяsαℓ " Ќąƶµяɨ •" replied to + M.Tariq Malik's discussion MGT201 Financial Management GDB Fall 2019 Solution & Discussion Last Date: 22-11-2019 in the group MGT201 Financial Management
1 hour ago
Profile IconAmna Imran and Nisha Khan joined + M.Tariq Malik's group
1 hour ago
+ ! ! ! ! Mehαr Mαh꧂ replied to +¢αяєℓєѕѕ gιяℓ's discussion Shadi Ho Rhi Hai Alhamdulillah.......... (^__^)!
1 hour ago

Today Top Members 

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

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