::: vuaskari.com ::: CS403 QUIZ NO.4 PART B FEB 04, 2013

CS403- Database Management System

Quiz No. 4 Part B

Dated FEB 04, 2013

 

GRANT is a ______________ Command.

DDL

DML

DCL

None of the above

 

__________ User Interface is preferred over ________ User Interface with respect to user.

 Easy to understand, efficient

Hard to understand, efficient

Easy to understand, effective

Hard to understand, effective

 

REVOKE is a ______________ statement.

Data Definition

Control Access

Data manipulation

Data description

 

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 

False

 

 

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

DML (Right Answer)

DDL

DCL

Both DML and DDL

 

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

ONTO

INTO (Right Answer)

UPTO

WITH
 

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

Update (Right Answer)

Insert

Browse

Append

 

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

SELECT

FROM

Both SELECT and FROM (Right Answer)

DISTINCT

 

Columns used to uniquely identify individual rows of a given table, may be specified to be not NOT NULL.

True

False  (Right Answer)

 

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

True  (Right Answer)

False

 

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

INTO

VALUE (Right Answer)

INSERT

Modify

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

Select correct option:

 

IN

FROM

LIKE   (Right Answer)

None of the above.

 

Question # 3 of 10 ( Start time: 06:15:54 PM ) Total Marks: 1

Which of the following is not an aggregate function

Select correct option:

 AVG

SUM

UPPER   (Right Answer)

MAX 

 

Question # 4 of 10 ( Start time: 06:16:23 PM ) Total Marks: 1

UPDATE command belongs to which type of Classification

Select correct option:

 

DML (Right Answer)

DDL

DCL

DQL

 

 Question # 6 of 10 ( Start time: 06:18:52 PM ) Total Marks: 1

GRANT belongs to which type of SQL commands classification

Select correct option:

 

DML

DDL

DCL (Right Answer)

DQL

 

Question # 7 of 10 ( Start time: 06:20:21 PM ) Total Marks: 1

DML does not used to :

Select correct option:

 

add new rows to tables

retrieve rows from table

modify the rows of tables

alter a table definition (Right Answer)

 

 

 

Question # 9 of 10 ( Start time: 06:22:02 PM ) Total Marks: 1

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

Select correct option:

 

GRANT

REVOKE

Both GRANT and REVOKE (Right Answer)

SELECT

 

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. (Right Answer)

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 (Right Answer)

 

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

Like

IN (Right Answer)

AND

Between

 

Columns used to uniquely identify individual rows of a given table, may be specified to be not NOT NULL.

TRUE (Right Answer)

FALSE

 

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

Delete  (Right Answer)

Remove

Truncate

Both I and II

 

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

Where

Order by (Right Answer)

From

Having

 

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

Grant

Revoke

Both Grant and Revoke  (Right Answer)

Select

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

ONTO

INTIO (Right Answer)

UPTO

WITH

 

In SQL queries, while creating tables or relations in database, key columns may be specified by

Bull

Not Null (Right Answer)

Data Type

None of the above

 

Which of the following is not an aggregate function

AVG

SUM

UPPER (Right Answer)

MAX

 

_______ 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 (Right Answer)

DQL

 

Update command belong to which type of classification

DML (Right Answer)

DDL

DCL

DQL

 

 

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 not true regarding clustering ?

It increases the efficiency since related records are placed close to each other.

Clustering makes records, difficult to access  (Right Answer)

Suitable to relatively static situations

It is a process, which means to place record from different tables to places in adjacent physical locations.

 

Truncate command responses time is ____________ as compared to delete command.

Poor

Same

Better  (Right Answer)

Worst

 

Which of the following is a String function in SQL

Count

LEN (Right Answer)

SQRT

SIN

 

Revoke is a __________ Statement

Data Definition

Control Access  (Right Answer)

Data Manipulation

Data Description

 

GRANT is a _____________ command.

DDL

DML

DCL (Right Answer)

None of the above

 

Which of the following is one of the purposes of using DDL commands?

Inserting records into databases

Updating records into databases

Manipulation databases

Creating and destroying databases  (Right Answer)

 

Which of the following is not a part of an INSERT statement?
Select correct option:
INTO
VALUES (Right Answer)
INSERT
MODIFY

 

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' ORDERBY Age;

The statement has a syntax error
The statement displays the entire fields from emp in which the Empname is ALI in any order (Right Answer)
The statement displays the entire fields from emp in which the Empname is ALI in descending order of their age
The statement displays the entire fields from emp in which the Empname is ALI in ascending order of their age

 

In SQL, which command is used to modify the rows of tables.
Select correct option:
UPDATE (Right Answer)
INSERT
BROWSE
APPEND

 

In SQL, which command is used to delete rows from table.
Select correct option:
DELETE (Right Answer)
REMOVE
TRUNCATE
Both I and II

 

In SQL queries, while creating tables or relations in database, key columns may be specified by
Select correct option:
Null
Not Null (Right Answer)
Data Type
None of the above

 

What happens if the WHERE clause is omitted from a DELETE statement?
All records from the table are deleted (Right Answer)
No record from the table will be deleted
First record of the table will be deleted
The statement will not be executed and will give a syntax error

 

Truncate command response time is ____ as compared to Delete command.
Select correct option:
Poor
Same
Better (Right Answer)
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) Not Sure(Right Answer)

 

Which of the following is used to retrieve and insert information from database?
Select correct option:
DML (Right Answer)
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 (Right Answer)
UPDATE

 

Question # 1 of 10 ( Start time: 09:52:41 PM ) Total M a r k s: 1

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

Select correct option:

ONTO

INTO (Right Answer)

UPTO

WITH

 

 

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 (Right Answer)

SELECT * WHERE Persons

SELECT WHERE * Persons

 

 

 

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

Select correct option:

IN

FROM

LIKE (Right Answer)

None of the above.

 

Which of the following statements creates a database named IMDB.

Select correct option:

CREATE DATABASE IMDB; (Right 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 (Right 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 (Right Answer)

UPDATE

  

Question # 7 of 10 ( Start time: 09:55:14 PM ) Total M a r k s: 1

Which of the following is not an aggregate function

Select correct option:

AVG

SUM

UPPER (Right Answer)

MAX

  

CREATE TABLE and CREATE index belongs to which type of SQL commands

Select correct option:

DML

DDL (Right Answer)

DCL

DQL

  

 

Question # 9 of 10 ( Start time: 09:55:59 PM ) Total M a r k s: 1

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

Select correct option:

UPDATE (Right 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 (Right Answer)

 

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

SELECT 
FROM 
WHERE  (Right Answer)
UPDATE

 

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

DCL  (Right Answer)
DDL 
DML 
All of the above.

 

Which of the following is a String function in SQL 

COUNT 
LEN  (Right Answer)
SQRT 
SIN

 

Truncate is an alternative of Delete command. 
Select correct option: 
True  (Right Answer)
False

 

 

 

Which of the following SQL statements used to control access to the data and to the database? 
Select correct option: 

GRANT 
REVOKE 
Both GRANT and REVOKE (Right Answer) 
SELECT

 

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  (Right Answer)
False

 

Which of the following is NOT a DDL command? 
Select correct option: 
Create DB 
Create table 
Delete  (Right Answer)
Drop

 

Which of the following is one of the purposes of using DDL commands? 
Select correct option: 

inserting records into databases 
updating records into databases  (Right Answer)
manipulating databases 
creating and destroying databases

 

Which of the following function falls in the category of Aggregate functions. 
Select correct option: 

SUM 
MIN 
MAX 
All of the above (Right Answer)

 

SQL stands for ______________.

I - Structured Query Language

II – Standard Query Language

lll- Status Query Language

Select correct option:

Only I

Only II

Both I and II (Right Answer)

Only lll

 

Making a change to the conceptual schema of a database but not affecting the existing

external schemas is an example of

 

Physical data independence.

Concurrency control.

Logical data independence. (Right Answer)

Functional dependency

 

SQL data types do not have support for storing multi-media objects directly.

Select correct option:

 

True (Right Answer)

False

 

Truncate is an alternative of Delete command.

Select correct option:

True (Right Answer)

False

 

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

Select correct option:

 All records from the table are deleted (Right Answer)

No record from the table will be deleted

First record of the table will be deleted

The statement will not be executed and will give a syntax error

 

Query Analyzer is used to practice SQL in MS-Access and MS-SQL Server.

Select correct option:

True (Right Answer)

False

 

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

Select correct option:

DML (Right Answer)

DDL

DCL

Both DML and DDL

Which of the following can not be included into CREATE TABLE statement?

Select correct option:

 

Data types

Constraints

Attributes

Cardinalities (Right Answer)

 

 

Which of the following is NOT a DDL command?

Select correct option:

Create DB

Create table

Delete (Right Answer)

Drop

 

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

Select correct option:

GRANT

REVOKE

Both GRANT and REVOKE (Right Answer)

SELECT

 

A relational database is

Select correct option:

one that consists of two or more tables

a database that is able to process tables, queries, forms, reports and macros

one that consists of two or more tables that are joined in some way (Right Answer)

the same as a flat file database

 

 

Which model operates at the lowest level of abstraction?

Select correct option:

conceptual

internal

external

physical (Right Answer)

 

A________is used to maintain a connection between the users of the database system.

Select correct option:

 

mail server

file server (Right Answer)

client-server

none of the given

 

A collection of concepts that can be used to describe the structure of a database

Select correct option:

Database

DBMS

Data model (Right Answer)

Data

 

 

Data about data is metadata

Select correct option:

True (Right Answer)

False

 

A primary key is an attribute (or set of attributes) that has been chosen for an entity, whose values are used to uniquely identify a particular instance of an entity.

Select correct option:

True (Right Answer)

False

Partially True

None of the given

 

Which of the following is INCORRECT statement concerning the database design process?

Select correct option:

During requirements collection and analysis phase, one can gather the data requirements of database users.

By referring to a high level data model, it is possible to understand the data requirements of the users, entity types, relationships and constraints.

Transformation of the high level data model into the implementation data model is called logical design or data model mapping.

During the logical design phase of internal storage structures, access paths and file organization for the database files are specified. (Right Answer)

 

Which feature of database provides conversion from inconsistent state of DB to a consistent state ensuring minimum data loss?

Select correct option:

User accessible catalog

Data processing

Recovery service (Right Answer)

Authorization service

 Who is responsible for authorizing access to the database, for coordinating and monitoring its use?

Select correct option:

Database Designer

Database Administrator (Right Answer)

End User

Application Programmer

 

 

Which of the following describes the job of a database administrator?

Select correct option:

Development, implementation operation of the physical database

Creation of the system catalog

Monitoring and controlling database security and authorization: Setting up controls to ensure the quality and integrity of data (Right Answer)

All of the above

 Which of the following is NOT a component of a DFD?

Select correct option:

Dataflow

Datastore

External entities

Relationship between external entities (Right Answer)

 

The Entity Relation Model models

Select correct option:

Entities, Relationships and Processes

Entities and Relationships

Relationships (Right Answer)

Entities

 

A relational database system is based on the concept(s) of:

Select correct option:

A network of data records (Right Answer)

Nested tables

Tables, rows and columns

A tree-like structure of data

 

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 (Right Answer)

False

 

DML does not used to :

Add new rows to tables

Retrieve row from tables

Modify the rows of tables

Alter a table definition  (Right Answer)

 

What does the abbreviation DBMS stand for?

Database Manipulation Software.

Data Borrowing and Movement Software

Digital Base Mapping System.

Database Management System. (Right Answer)

 

 

Identify the language which is used to specify database schema.

DCL

DML

DDL

Non of the above (Right Answer)

 

Columns used to uniquely identify individual rows of a given table, may be specified to be not NOT NULL.

 

True

False (Right Answer)

 

 

Value of a function in SQL is always determined by the input parameters

True (Right Answer)

False

 

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 (Right Answer)

 

 

Which of the following is incorrect about alter table statement?

Cannot be used to modify type or size of an existing column      (Right Answer)          

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

--

Zindagi mein 2 Logo ka buhat khayal rahkoooo
Ist woh jiss ney tumhari jeet ke Liye buhat kuch hara hoo

(Father)

2nd woh jiss ko tum ney har dukh me pukaara hoo (Mother)

Regards,

Umair Saulat Mc100403250

--
We say, "Be one as Pakistani Nation and grow up for Pakistan's Future". Wish you all the best. Join www.vuaskari.com,
To post to this group, send email to vuaskari_com@googlegroups.com
Visit these groups:
This (Main) Group:http://groups.google.com/group/vuaskari_com?hl=en?hl=en
MIT/MCS Group: http://groups.google.com/group/vu_askarimit?hl=en?hl=en
HRM Group: http://groups.google.com/group/askari_hrm?hl=en?hl=en
Banking Group: http://groups.google.com/group/askari_banking?hl=en?hl=en
Management: https://groups.google.com/group/vuaskari_mgt?hl=en
Marketing: https://groups.google.com/group/vuaskari_mkt?hl=en
MIS Group: http://groups.google.com/group/askari_mis?hl=en
---
You received this message because you are subscribed to the Google Groups ":::www.vuaskari.com :::" group.
To unsubscribe from this group and stop receiving emails from it, send an email to vuaskari_com+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.