CS403- Database Management System
Quiz No. 3
Dated 13-01-2012
Dear Students,
Quiz No. 03 of CS403 - DBMS, would held on January 13, 2012 (Friday) and will be open for 24 hours (1 Day). Quiz would be from Lecture 25 to Lecture 32
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.
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
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
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
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
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
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.
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 to the database?
Grant
Revoke
Both Grant and Revoke
Select
Which of the following is used with INSERT command to insert values in a DB table?
ONTO
INTIO
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
Which of the following is not an aggregate function
AVG
SUM
UPPER
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
DQL
Update command belong to which type of classification
DML
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
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
Worst
Which of the following is a String function in SQL
Count
LEN
SQRT
SIN
Revoke is a __________ Statement
Data Definition
Control Access
Data Manipulation
Data Description
GRANT is a _____________ command.
DDL
DML
DCL
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
Which of the following is not a part of an INSERT statement?
Select correct option:
INTO
VALUES
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
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
INSERT
BROWSE
APPEND
In SQL, which command is used to delete rows from table.
Select correct option:
DELETE
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
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
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
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
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
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
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
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
None of the above.
Which of the following statements creates a database named IMDB.
Select correct option:
CREATE DATABASE IMDB;
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
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
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
MAX
CREATE TABLE and CREATE index belongs to which type of SQL commands
Select correct option:
DML
DDL
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
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
Which of the following is used to filter rows according to some condition(s)?
Select correct option:
SELECT
FROM
WHERE
UPDATE
Which language is used to permit or prohibit access to a table?
Select correct option:
DCL
DDL
DML
All of the above.
Which of the following is a String function in SQL
COUNT
LEN
SQRT
SIN
Truncate is an alternative of Delete command.
Select correct option:
True
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
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
False
Which of the following is NOT a DDL command?
Select correct option:
Create DB
Create table
Delete
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
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
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
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.
Functional dependency
SQL data types do not have support for storing multi-media objects directly.
Select correct option:
True
False
Truncate is an alternative of Delete command.
Select correct option:
True
False
What happens if the WHERE clause is omitted from a DELETE statement?
Select correct option:
All records from the table are deleted
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
False
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 can not be included into CREATE TABLE statement?
Select correct option:
Data types
Constraints
Attributes
Cardinalities
Which of the following is NOT a DDL command?
Select correct option:
Create DB
Create table
Delete
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
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
the same as a flat file database
Which model operates at the lowest level of abstraction?
Select correct option:
conceptual
internal
external
physical
A________is used to maintain a connection between the users of the database system.
Select correct option:
mail server
file server
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
Data
Data about data is metadata
Select correct option:
True
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
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.
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
Authorization service
Who is responsible for authorizing access to the database, for coordinating and monitoring its use?
Select correct option:
Database Designer
Database Administrator
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
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
The Entity Relation Model models
Select correct option:
Entities, Relationships and Processes
Entities and Relationships
Relationships
Entities
A relational database system is based on the concept(s) of:
Select correct option:
A network of data records
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
False
DML does not used to :
Add new rows to tables
Retrieve row from tables
Modify the rows of tables
Alter a table definition
What does the abbreviation DBMS stand for?
Database Manipulation Software.
Data Borrowing and Movement Software
Digital Base Mapping System.
Database Management System.
Identify the language which is used to specify database schema.
DCL
DML
DDL
Non of the above
Columns used to uniquely identify individual rows of a given table, may be specified to be not NOT NULL.
True
False
Value of a function in SQL is always determined by the input parameters
True
False
Zindagi mein 2 Logo ka buhat khayal rahkoooo
2nd woh jiss ko tum ney har dukh me pukaara hoo (Mother)
--
--
Please visit www.vuzs.net For Current & Old Papers, Quizzes, Assignments and study material.
To post a new message on this group, send email to vuZs@googlegroups.com
Message Posting Rules: http://vuzs.net/faq/4795-vuzs-google-groups-basic-rules-for-posting-messages.html
--
To unsubscribe from this group, send email to vuZs+unsubscribe@googlegroups.com
--
To join this group Send blank email to vuZs+subscribe@googlegroups.com
or visit
http://groups.google.com/group/vuZs/subscribe
No comments:
Post a Comment