Articles

CS403 MCQ Solved Bank Solved by vuZs team

Solved by vuZs Team

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

 

Logical data independence

Logical data independence provides the independence in a way that

changes in conceptual model do not af fect the external views. Or

simply i t can be stated at the Immunity of external level f rom

changes at conceptual level .

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

 

SQL commands that allow for the manipulation of data in the database, such as SELECT, INSERT, DELETE, and UPDATE.

 

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 f i le server is used

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

Each cl ient of the network runs its own copy of the DBMS and the

database resides on the f i le server .

 

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

Select correct option:

Database

DBMS

Data model

Data

 

Data model is a set or collection of construct used for creating a database and producing designs for the databases

 

Data about data is metadata

Select correct option:

True

False

Database is a data structure that stores metadata, i.e. data about data. More generally we can say an organized collection of information.

 

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.

 

These things are done at physical design stage not at logical design stage. At logical design stage we are concerned about schema structures.

 

 

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

 

 

 

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

 

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

Data about data is database

Select correct option:

 

True

False

Partially True

None of the Above

 

Database is a data structure that stores metadata, i.e. data about data. More generally we can say an organized collection of information

Not sure

 

 

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

most commercial DBMS are based on the record-based data models, like Hierarchical, Network or Relational.

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