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

Please all students related this subject Share your online Quizzes here to help each other.thanks

 

Please share the question and their answers of this quiz if anyone has done.
Thanks. 

Question # 1 of 10 ( Start time: 12:23:34 PM )  Total Marks: 1
Is the given SQL Statement prompt error? Select * from relation1;
Select correct option:
Logical Error
No Error      ///////
Parameter Error
Time out Error


Question # 2 of 10 ( Start time: 12:24:01 PM )  Total Marks: 1
REVOKE is a ______________ statement.
Select correct option:
Data Definition
Control Access ////////
Data manipulation
Data description


Question # 3 of 10 ( Start time: 12:25:23 PM )  Total Marks: 1
Functions in SQL return a single value
Select correct option:
True //////
False


Question # 4 of 10 ( Start time: 12:26:05 PM )  Total Marks: 1
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) //////////


Question # 5 of 10 ( Start time: 12:26:24 PM )  Total Marks: 1
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’;
Select correct option:
The statement has a syntax error
The statement only displays the EmpID of those employees whose name is ALI
The statement displays the entire fields from emp in which the Empname is ALI ///////
The statement must have an ORDERBY clause


Question # 6 of 10 ( Start time: 12:26:45 PM )  Total Marks: 1
DML stands for _____________.
Select correct option:
Dynamic Modeling Language
Data Manipulation Language //////
Data Management Language
Domain Modeling Language


Question # 7 of 10 ( Start time: 12:27:05 PM )  Total Marks: 1
Truncate command response time is ______ as compared to Delete command.
Select correct option:
Poor
Same
Better ////////////
worst


Question # 8 of 10 ( Start time: 12:27:19 PM )  Total Marks: 1
Which language is used to permit or prohibit access to a table?
Select correct option:
DCL///////
DDL 
DML
All of the above.


Question # 9 of 10 ( Start time: 12:28:15 PM )  Total Marks: 1
GRANT is a ______________ Command.
Select correct option:
DDL
DML
DCL ///////
None of the above


Question # 10 of 10 ( Start time: 12:29:39 PM )  Total Marks: 1
Suppose we have two tables T1 and T2. Tuples of T1 that do not match some row in T2 will not appear in
Select correct option:
Outer Join
Inner Join \\\\\
Both I and II
None of the above

UPDATE command belongs to which type of Classification
DML 208
DDL
DCL
DQL


The _________ function helps reduce the need to use multiple OR conditions.
Like
IN 218
AND
Between

Which of the flowing clauses allows to sort the records in result set?
Where
Order by 219
From
Having

In SQL queries, while creating tables or relations in database, key columns may be specified by
Null
Not Null 203
Data Type
None of the above

Identify the language which is used to specify database schema.
DCL
DML
DDL 201
Non of the above




_______ 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

Which of the following is a String function in SQL
Count
LEN 221
SQRT
SIN

Revoke is a __________ Statement
Data Definition
Control Access 233
Data Manipulation
Data Description


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)

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 212
UPDATE

Which language is used to permit or prohibit access to a table? 
Select correct option: 
DCL 
DDL 
DML 
All of the above.

Data Manipulation Language (DML) is the set of commands used to maintain and query a database including updating, inserting, modifying and retrieving data. 
Select correct option: 
True 208 
FALSE

Which of the following is NOT a DDL command? 
Select correct option: 
Create DB 
Create table 
Delete 



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.
UPDATE command belongs to which type of Classification
Select correct option:

DML
DDL
DCL
DQL

GRANT belongs to which type of SQL commands classification
Select correct option:

DML
DDL
DCL
DQL

DML does not used to :

add new rows to tables
retrieve rows from table
modify the rows of tables
alter a table definition



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. 206
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


Which of the following is used with INSERT command to insert values in a DB table?
ONTO
INTO
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


_______ 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 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

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




Which of the following statements creates a database named IMDB.
Select correct option:
CREATE DATABASE IMDB; = Answer
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 = Answer
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 = Answer
UPDATE

Which of the following is not an aggregate function
Select correct option:
AVG
SUM
UPPER = Answer
MAX

CREATE TABLE and CREATE index belongs to which type of SQL commands
Select correct option:
DML
DDL = Answer
DCL
DQL


In SQL, which command is used to modify the rows of tables.
Select correct option:
UPDATE = Answer
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 = Answer

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

SELECT 
FROM 
WHERE = Answer
UPDATE

Which language is used to permit or prohibit access to a table? 
Select correct option:

DCL = Answer
DDL 
DML 
All of the above.

Which of the following is a String function in SQL

COUNT 
LEN = Answer
SQRT 
SIN

Truncate is an alternative of Delete command. 
Select correct option: 
True = Answer
False




CS403 Quize no.3

Attachments:

 Muhammad Azmat thanx for sharing

Kindly download this file, you will get all quiz from this file

Attachments:

RSS

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

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

.