VU VICKY Virtual University Assignment Solution, Past Papers, Handouts and other material

Question # 1 of 10

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;

Question # 2 of 10

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

Question # 3 of 10

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

Select correct option:

INTO

VALUES

INSERT

MODIFY

Question # 4 of 10

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

Select correct option:

DELETE

REMOVE

TRUNCATE

Both I and II

Question # 5 of 10

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.

Question # 6 of 10

GRANT belongs to which type of SQL commands classification

Select correct option:

DML

DDL

DCL

DQL

Question # 7 of 10

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

Question # 8 of 10

What does the abbreviation DBMS stand for?

Select correct option:

Database Manipulation Software.

Data Borrowing and Movement Software

Digital Base Mapping System.

Database Management System.

Question # 9 of 10

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

Select correct option:

SELECT

FROM

WHERE

UPDATE

Question # 10 of 10

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

Select correct option:

DML

DDL

DCL

DQL 

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

Question # 3 of 10 ( Start time:09:53:51 PM) Total M - 1

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 # 4 of 10 ( Start time:09:54:15 PM) Total M - 1

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;

Question # 5 of 10 ( Start time:09:54:31 PM) Total M - 1

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

Question # 6 of 10 ( Start time:09:54:55 PM) Total M - 1

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

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

Select correct option:

UPDATE

INSERT

BROWSE

APPEND

Identify the basic part(s) of a SELECT statement?
SELECT
FROM
Both SELECT and FROM
DISTINCT

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
GRANT is a ______________ Command.


Select correct option:
DDL
DML
DCL
None of the above

Is the given SQL Statement prompt error? Select * from relation1;
Select correct option:
Logical Error
No Error
Parameter Error
Time out Error


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

Consider the two relations, Supplier (S_no, S_name, Contact_No, Address) and Supply (S_no, Item_no). Which of the following statements give(s) a list of supplier names supplying the item with Item_no ‘555’?
Select correct option:
SELECT S_name FROM Supplier WHERE Item_no=’555’
SELECT S_name FROM Supplier, Supply WHERE Supplier.S_no=Supply.S_no AND Item_no=’555’
SELECT S_name FROM Supplier WHERE S_no EXISTS (SELECT S_no FROM Supply WHERE Item_no=’555’)
SELECT S_name FROM Supplier WHERE S_name EXISTS (SELECT S_name FROM Supply WHERE Item_no='555')

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 :
Select correct option:
add new rows to tables
retrieve rows from table
modify the rows of tables
alter a table definition

Objective of an order by clause is to display or arrange output of a select statement in a particular order.
Select correct option:
True
False

Which of the following is not DML command?
Select correct option:
Select
Update
Delete
Truncate

Which of the following is incorrect about alter table statement?
Select correct option:
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 tablet.

In “One to Many” cardinality one instance of a relation is mapped with
Select correct option:
 many instances of second entity type
 One instance of second entity type
 Primary key of 2 relations
 none of above
 
A second Normal Form (2 NF) relation should
Select correct option:
 be in 1 NF
 not have a composite key
 not have attributes dependent on key attribute
 not have attributes dependent on one another
 
Normalization of database is essential to
 (i) avoid accidental deletion of required data when some data is deleted
 (ii) eliminate inconsistencies when a data item is modified in the database
 (iii) allows storage of data in a computer’s disk
(iv) use a database management system
Select correct option:
 i and iii
 i and ii
 ii and iii
 ii and iv
 
A relation which is in a higher normal form
Select correct option:
 implies that it also qualifies to be in lower normal form
 does not necessarily satisfy the conditions of lower normal form
 is included in the lower normal form
 is independent of lower normal forms
 
“Unary relationship” is one which involves
Select correct option:
 Single entity
 Two entities
 Many entities
 No entity
 
An attribute y may be functionally dependent on
 (i) a composite attribute x,y
(ii) a single attribute x (iii) no attribute
Select correct option:
 i and ii
 i and iii
 ii and iii
 iii
 
in “One to One Relationship” One instance of first entity type is mapped with two instances of second entity type
Select correct option:
 true
 false

DML perform functions such as
Select correct option:
 Insertion
 Deletion
 Creation of database
 All of above
 

“Select” and “project” are the examples of
Select correct option:
 Unary operations
 Binary operations
 Ternary operations
 All of above

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

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

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

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

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

Data Definition Language (DDL) statements are used to define the database structure or schema. Some examples:
CREATE - to create objects in the database
ALTER - alters the structure of the database
DROP - delete objects from the database
TRUNCATE - remove all records from a table, including all spaces allocated for the records are removed
COMMENT - add comments to the data dictionary
RENAME - rename an object

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

Revoke is a __________ Statement
Data Definition
Control Access
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 
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 
FALSE

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

Which of the following function falls in the category of Aggregate functions.
Select correct option:
SUM
MIN
MAX
All of the above

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