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

CS403 Quiz # 3 Feb 12 to 13, 2015

Please share your quizzes here.

+ Click Here To Join also Our facebook study Group.

..How to Join Subject Study Groups & Get Helping Material?..


See Your Saved Posts Timeline

Views: 1978

.

+ http://bit.ly/vucodes (Link for Assignments, GDBs & Online Quizzes Solution)

+ http://bit.ly/papersvu (Link for Past Papers, Solved MCQs, Short Notes & More)

Replies to This Discussion

Here goes my 3rd Quiz

By Juste

I have only saved the MCQ'S and my answers, didn't saved other options. Verify all answers yourself. Please share your quizzes as well.

Which of the following is not DML command?

select
update
delete
*truncate

REVOKE is a ______________ statement.
Data Definition
*Control Access
Data manipulation
Data description

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

SQL stands for ______________. I - Structured Query Language II – Standard Query Language lll- Status Query Language
*only I
only II
both I and II
only III

The _________ function helps reduce the need to use mutiple OR conditions.
Like
*IN
AND
BETWEEN

Which of the following is not a part of an INSERT statement?
INTO
VALUES
INSERT
*MODIFY

In vertical partitioning if we divide a table into two vertical partitions then efficiency of those applications will be reduced which used to.
Access data from both the vertical partitions.
*Access data from first vertical partition.
Access data from second vertical partition
None of the above.

Which of the following is a correct way of selecting all the columns from a table called PERSONS?
SELECT FROM * Persons
*SELECT * FROM Persons
SELECT * WHERE Persons
SELECT WHERE * Persons

Is the given SQL Statement prompt error? Select * from relation1;
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’;
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

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

true
false

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

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

where
order by
from
having

4. Which language is used to permit or prohibit access to a table?

DCL
DDL
DML

5. Which of the following prevents duplicate values to be displayed as a result of an SQL statement?


6. Which of the following is NOT a DDL command?

Create DB
Create table
Delete
Drop


7. 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 records from different tables to place in adjacent physical locations

8. Which of the following statements creates a database named IMDB.

CREATE DATABASE IMDB;
CREATE DB IMDB;
ADD DATABASE named IMDB;
CREATE IMDB DATABASE;


09. General reasoning for horizontal or vertical partitioning is.

Increasing the consistency
Decreasing the query response time
Smaller tables are more efficient to process as compared to the larger tables.
All of the above


10. Data Manipulation Language (DML) is the set of commands used to maintain and query a database including updating, inserting, modifying and retrieving data.

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

Within a table, each primary key value __.
Select correct option:

is a minimal super key
is always the first field in each table
must be numeric
must be unique

 

Foreign Key is
Select correct option:

A field in a table that matches a key field in another table
A field in a table that contains data that is also contained elsewhere in another table
A field in a table that has the same name as a key field in another table

 

 

 

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

 

 

Data about data is database
Select correct option:

True                             
False

Partially True
None of the Above

 

Which one of the following is NOT a characteristic of Meta data?
Select correct option:

Data about data
Describes a data dictionary
Self-describing
Includes user data

                  

 

The most widely used conceptual model is the __ model.
Select correct option:

implementation
ER
Object Oriented
internal

 

Which model operates at the lowest level of abstraction?
Select correct option:

conceptual
internal
external
physical


Which of the following describes a database system?
Select correct option:

A collection of stored operational data used by the application system of some particular enterprise
A shared collection of logically related data (and a description of this data) designed to meet the information needs of an organization
A collection of stored data organized in such a way that all user requirements are satisfied by the database. In general there is only one copy of each item of data although there may be controlled repetition of some data.
All of the above

 

Data inconsistency leads to a number of problems such as
Select correct option:

loss of information and incorrect results
less secure data
redundant data
Slow database development

 

Which of the following constraints enforces entity integrity?
Select correct option:

PRIMARY KEY
FOREIGN KEY
CHECK
NOT NULL

 

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


Which of the following is NOT a component of a DFD?
Select correct option:

Dataflow
Datastore
External entities
Relationship between external entities

 


A candidate key that does not have a null value and is selected to uniquely identify all other attribute values in any given row is called a __.
Select correct option:

superkey
candidate key
primary key
secondary key

 

Which of the following is correct regarding Dataflow diagram?
Select correct option:

Single DFD is required to represent a system
Created at increasing levels of detail
The dataflow must be bidirectional
Used to represent the relationships among the external entities

 

Data about data is metadata
Select correct option:

True
False


Data Redundancy Means
Select correct option:

Security of data
Duplication of data
Management of data
Recovery of data

 

 

 

Controlling redundancy in a database management system DOES NOT help to 
Select correct option: 

avoid duplication 
avoid unnecessary wastage of storage space 
avoid unauthorized access to data 
avoid inconsistency among data

 

In an ERD, the focus is on the __ and the relationships between them.  
Select correct option: 

attributes 
entities 
keys 
indexes

 

User rights information is stored in 
Select correct option: 

Physical database 
Catalog 
Logical database 
Buffer

 

Which of the following might be represented with a multivalued attribute? 
Select correct option: 

person's name 

class location              (Not Confirm) 
bank account balance 
book title

 

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


Which levels are mostly used for Detailed DFD?
Select correct option:

Level-0, Level-1
Level-1, Level-2
Level-2, Level-3
Level-3, Level-4

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. True or false?
Select correct option:

True
False
Partially True
None of the given


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


Incase of Context-level Diagram, the system is represented by
Select correct option:

One process atleast
Two processes atleast
One process only
Any number of processes

The Entity Relation Model models
Select correct option:

Entities, Relationships and Processes
Entities and Relationships
Relationships
Entities

An instance is
Select correct option:

A particular occurrence of an entity

A special type of relation

An attribute of an entity
Any particular entity

 

Software packages designed to store and manage databases

Database
DBMS
Data model
Data

 

A table can be logically connected to another table by defining a ____.

hyperlink         
common attribute
primary key
superkey

 

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

Database
DBMS
Data model
Data

 

The main software package that supports a database management approach is called
Select correct option:

Data Dictionary
Report Generator
Database Management System
Distributed database

 

 

The ER model is meant to
select correct option:

replace relational design
be close to a user’s perception of the data
enable low level descriptions of data
enable detailed descriptions of data query processing

 

 

A description on a particular collection of data using the given data model
Select correct option:

Database
Relation
Schema
None

 

Which of the following functions are NOT performed by a database administrator?
Select correct option:

Planning, designing and implementing database systems
Establishing standards and procedures for database systems
Communicating with database users
Allocation of storage locations and data structures

 Level of data at which entities or objects exist in reality is called

Real world data
Schema for real world data
Meta data
Data about data

An entity type is

defined when the database is actually constructed
a specific type such as an integer, text, date, logical etc
a coherent set of similar objects that we want to store data on (e.g. STUDENT, COURSE, CAR)
defined by the database designer

 

In a three-level DBMS architecture, the ______ level interacts directly with the users.

Select correct option:

external

conceptual

internal

physical

 

 

Revoke is a __________ Statement

Data Definition

Control Access

Data Manipulation

Data Description 

 

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.

 

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

 

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.

 

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

SELECT

FROM

Both SELECT and FROM

DISTINCT

 

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

 

Truncate is an alternative of Delete command.

Select correct option:

True

False

 

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

SUM 
MIN 
MAX 
All of the above

 

Quiz No. 03 ---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

 

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

True (not sure)
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

 

Which of the following is not an aggregate function 
Select correct option:

AVG
SUM
UPPER 
MAX

 

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


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.

 

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

Like 
IN
AND
Between

 

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

Delete 
Remove 
Truncate 
Both I and II

 

Which of the following clauses allows sorting 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

Bull
Not Null
Data Type 
None of the above

 

_______ Operators are the ones that require two operands on both sides of the operator.

Double 
Two 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 a String function in SQL

Count 
LEN
SQRT
SIN

 

GRANT is a _____________ command.

DDL
DML
DCL
None of the above

 

 

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

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 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;
CREATE DB IMDB;
ADD DATABASE named IMDB;
CREATE IMDB DATABASE;

 

 

CREATE TABLE and CREATE index belongs to which type of SQL commands
Select correct option:

DML
DDL not sure
DCL
DQL

 

 

The ______________ condition allows to retrieve values within a specific range.

            AND

            LIKE

BETWEEN

            FROM

 

 

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

 

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

 

Query Analyzer is used to practice SQL in MS-Access and MS-SQL Server.
Select correct option:

True
False

 

 

Identify the language which is used to specify database schema.

DCL
DML
DDL
None of the above

 

 

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

True
False

 

 

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

Where

Order by

From

Having

 

 

Which of the following cannot be included into CREATE TABLE statement?

Select correct option:

Data types

Constraints

Attributes

Cardinalities

 

  

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

  

 

What does the abbreviation DBMS stand for?

Database Manipulation Software.

Data Borrowing and Movement Software

Digital Base Mapping System.

Database Management System.

 


The ____________ keyword is used in SELECT statement to return different values.
Select correct option:

LIKE
IN
DISTINCT
WHERE

 

DML stands for _____________.
Select correct option:

Dynamic Modeling Language
Data Manipulation Language
Data Management Language
Domain Modeling Language


Functions in SQL return a single value
Select correct option:

True
False

Which of the following is a feature of CHECK constraint?
Select correct option:

limit the values that can be placed in a column.
used to enforce referential integrity.
enforces the uniqueness of the values in a set of columns.
is a unique identifier for a row within a database table.

 

The check constraint checks the values for any particular attribute. In this way
different types of constraints can be enforced in any table by CREATE command.

 

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

 

in “one to one relationship” one instance of first entity can be mapped with two instances of second entity

true
false

 

 

in “many to many relationship” one instance of first entity can be mapped with many instances of second entity
Select correct option:

true
false


Which of the following constraints enforces entity integrity?  
Select correct option:  

PRIMARY KEY (Correct)
            FOREIGN KEY 
            CHECK 
            NOT NULL 
 

 


Binary relationships are those, which are established between  
Select correct option:  

One entity type

Two entity type (Correct)
            Three entity type 
            Unlimited entities 
 


Unary Operation involve

one Operation only

Only two operations

More than two relations

No more than five relations

 

Which of the following might be represented with a multivalued attribute? 
Select correct option: 

person's name 
class location 
bank account balance 
book title

 

Which of the following might be represented with a single-valued attribute 
           

Person’s phone number

            Car’s color

            Employee’s educational background

computer's processor speed

 

 


8- In an ERD, the focus is on the ____ and the relationships between them.  

attributes 
entities 
keys 
indexes

 

Equi-join is similar to _________ with a slight difference.

Natural Join

Semi join

Outer join

Theta join


_____ is same as Equi-Join with a slight difference.
Select correct option:

Natural Join
Semi Join
Outer Join
Theta Join

 

Description on a particular collection of data using the given data model 
Select correct option: 

Database 
Relation 
Schema 
None

 

 A candidate key that does not have a null value and is selected to uniquely identify all other attribute values in any given row is called a __.
Select correct option: 

superkey 
candidate key 
primary key 
secondary key

 

The database management system (DBMS) is used to 
Select correct option: 

Store the data 
Access the data 
Manage its users 
All of above

 

 

Which model operates at the lowest level of abstraction? 

Select correct option: 

conceptual 
internal 
external 
physical

 

A Foreign Key is 
Select correct option: 

A field in a table that matches a key field in another table
A field in a table that contains data that is also contained elsewhere in another table
A field in a table that has the same name as a key field in another table 
A field in a table that has the same name as a key field in another table

 

Each table must have a __ key. 
Select correct option: 

primary 
secondary 
logical 
foreign

 

A software package designed to store and manage databases 
Select correct option: 

Database
DBMS
Data model
Data

 

 

A_______________ entity has a primary key that is partially or totally derived from the parent entity in the relationship.

            Strong

            Weak

            Business

            Relationship

 

In ERD, the focus is on the _________ and the relationships between them.

            Attributes

            Entities

            Keys

            Indexes

 

“Select” and “project” are the examples of

            Unary operations

            Binary operations

            Ternary operations

            All of the above

 

Atomicity is a feature of _____________.

            1NF

            2NF

            3NF

            BCNF

 

 

If Aà B and AàC then Aà BC the inference Rules applies is:

            Union

            Decomposition

            Augmentation

            Reflexivity

 

Relational Calculus is a _____________ relational data manipulation language.

            Procedural, Informal

            Non-Procedural, Informal

            Procedural, Formal

            Non-Procedural, Formal

 

 

 

A third Normal Form (3 NF) relation should

Select correct option:

be in 2 NF

not have complete key

not be 1 NF

should not have non-key attributes depend on key attribute

 

 

General reasoning for horizontal or vertical partitioning is.

Select correct option:

Increasing the consistency

Decreasing the query response time

Smaller tables are more efficient to process as compared to the larger tables.

All of the above

 

 

 

 

The process of normalization

Select correct option:

is automatic using a computer program

requires one to understand dependency between attributes

is manual and requires semantic information

is finding the key of a relation

 

 

 

Given the following relation it is not 3 NF because Student (roll no, name, course no,

course max. marks, year of study, address), where roll no is PK

Select correct option:

it is not in 2 NF

it does not have composite key

non-key attributes course no and course max. marks are functionally dependent

it has more than 3 non-key attributes

 

 

A relation is said to be in 2 NF if (i) it is in 1 NF (ii) non-key attributes dependent on key

attribute (iii) non-key attributes are independent of one another (iv) if it has a composite

key, no non-key attribute should be dependent on part of the composite key

Select correct option:

i, ii, iii

i and ii

i, ii, iv

i, iv

 

 

Attributes are (i) properties of relationship (ii) attributed to entities (iii) properties of

members of an entity set

Select correct option:

i

i and ii

i and iii

iii

 

 

In vertical partitioning if we divide a table into two vertical partitions then efficiency of

those applications will be reduced which used to.

Select correct option:

Access data from both the vertical partitions.

Access data from first vertical partition.

Access data from second vertical partition

None of the above.

The entity relationship diagram is used to graphically represent the __ database model. 
Select correct option: 

condensed 
physical 
logical 
conceptual

Which of the following is a feature of CHECK constraint?
Select correct option:

limit the values that can be placed in a column.
used to enforce referential integrity.
enforces the uniqueness of the values in a set of columns.
is a unique identifier for a row within a database table.

 

The check constraint checks the values for any particular attribute. In this way
different types of constraints can be enforced in any table by CREATE command.

 

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

 

in “one to one relationship” one instance of first entity can be mapped with two instances of second entity

true
false

 

 

in “many to many relationship” one instance of first entity can be mapped with many instances of second entity
Select correct option:

true
false


Which of the following constraints enforces entity integrity?  
Select correct option:  

PRIMARY KEY (Correct)
            FOREIGN KEY 
            CHECK 
            NOT NULL 
 

 


Binary relationships are those, which are established between  
Select correct option:  

One entity type

Two entity type (Correct)
            Three entity type 
            Unlimited entities 
 


Unary Operation involve

one Operation only

Only two operations

More than two relations

No more than five relations

 

Which of the following might be represented with a multivalued attribute? 
Select correct option: 

person's name 
class location 
bank account balance 
book title

 

Which of the following might be represented with a single-valued attribute 
           

Person’s phone number

            Car’s color

            Employee’s educational background

computer's processor speed

 

 


8- In an ERD, the focus is on the ____ and the relationships between them.  

attributes 
entities 
keys 
indexes

 

Equi-join is similar to _________ with a slight difference.

Natural Join

Semi join

Outer join

Theta join


_____ is same as Equi-Join with a slight difference.
Select correct option:

Natural Join
Semi Join
Outer Join
Theta Join

 

Description on a particular collection of data using the given data model 
Select correct option: 

Database 
Relation 
Schema 
None

 

 A candidate key that does not have a null value and is selected to uniquely identify all other attribute values in any given row is called a __.
Select correct option: 

superkey 
candidate key 
primary key 
secondary key

 

The database management system (DBMS) is used to 
Select correct option: 

Store the data 
Access the data 
Manage its users 
All of above

 

 

Which model operates at the lowest level of abstraction? 

Select correct option: 

conceptual 
internal 
external 
physical

 

A Foreign Key is 
Select correct option: 

A field in a table that matches a key field in another table
A field in a table that contains data that is also contained elsewhere in another table
A field in a table that has the same name as a key field in another table 
A field in a table that has the same name as a key field in another table

 

Each table must have a __ key. 
Select correct option: 

primary 
secondary 
logical 
foreign

 

A software package designed to store and manage databases 
Select correct option: 

Database
DBMS
Data model
Data



Correct statement for creating table in Microsoft SQL server is.
Select correct option:
    CREATE TABLE Customer (SID integer PRIMARY KEY, Last_Name varchar(30), First_Name varchar(30));    (not sure)
    CREATE TABLE Customer (SID integer, Last_Name varchar(30), First_Name varchar(30))
    CREATE Customer (SID integer, Last_Name varchar(30), First_Name varchar(30));
    All of the above

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 table

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

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 retrieve and insert information from database?
Select correct option:
    DML
    DDL
    DCL
    Both DML and DDL

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 used to filter rows according to some condition(s)?
Select correct option:
    SELECT
    FROM
    WHERE
    UPDATE

We should not compromise ________ over efficiency.
Select correct option:
    Consistency
    Normalization
    Query response time
    All of the above  not sure


Which of the following prevents duplicate values to be displayed as a result of an SQL statement?
Select correct option:
    DISTINCT
    DELETE
    UPDATE
    ALTER

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 abov
e

jo MCQ's Muddassar bhai nay share kiya hai pehlay comment main un k elawa just ye 3 MCQs aye

Correct statement for creating table in Microsoft SQL server is.

Select correct option:

            CREATE TABLE Customer (SID integer PRIMARY KEY, Last_Name varchar(30), First_Name varchar(30));       (not sure)

            CREATE TABLE Customer (SID integer, Last_Name varchar(30), First_Name varchar(30))

            CREATE Customer (SID integer, Last_Name varchar(30), First_Name varchar(30));

            All of the above

 

We should not compromise ________ over efficiency.

Select correct option:

            Consistency

            Normalization

            Query response time

            All of the above         (not sure)

 

Which of the following prevents duplicate values to be displayed as a result of an SQL statement?

Select correct option:

            DISTINCT

            DELETE

            UPDATE

            ALTER

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

RSS

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

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