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: 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)

+ 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

+ ! ! ! ❣ Sanam ❣ !+ replied to + " J ɨ y α •" ⋆'s discussion Let's celebrate the Birthday of our Beloved Mod + "αяsαℓ " Ќąƶµяɨ •"
7 minutes ago
Nishal Jafry liked + M.Tariq Malik's group MTH302 Business Mathematics & Statistics
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
Alishba replied to Alishba's discussion Nikkah Mubarak To <3 !! 'JS' !! <3
1 hour ago
༺łℳℜ₳₦༻ immy replied to + " J ɨ y α •" ⋆'s discussion Let's celebrate the Birthday of our Beloved Mod + "αяsαℓ " Ќąƶµяɨ •"
1 hour ago
+ M.Tariq Malik replied to + M.Tariq Malik's discussion EDU433 Current Mid Term Papers Fall 2019 (14 to 26 December 2019) & All Solved Past Papers, Solved MCQs & Helping Material in the group EDU433 Professionalism in Teaching
1 hour ago
+ M.Tariq Malik replied to + M.Tariq Malik's discussion PSY403 Current Mid Term Papers Fall 2019 (14 to 26 December 2019) & All Solved Past Papers, Solved MCQs & Helping Material in the group PSY403 Social Psychology
1 hour ago
+ M.Tariq Malik replied to + M.Tariq Malik's discussion PSY403 Current Mid Term Papers Fall 2019 (14 to 26 December 2019) & All Solved Past Papers, Solved MCQs & Helping Material in the group PSY403 Social Psychology
1 hour ago

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

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

.