DBMS MCQ 01
- Database
associated
- Database administrator
- Database
application
- None
of these
- Database
associated
- Database
administrator
- Database
application
- Database management system
- Which
means a place where data can be stored in a structured manner:
- CPU
- Database
- ALU
- All
of these
- A
database is a complex ______:
- Data structure
- Memory
- Both
- None
- The
set of data available to the user, the so-called:
- Start-user
data
- End-user data
- Database
- None
of these
- How is
describing the end-user data:
- DBMS
is to impose a logical and structured organization on:
- Register
- Data
- Memory
- None
of these
- How many basic operation performed in
DBMS:
- Basic operation performed in DBMS are:
- Management
of data in the database
- Management
of user associated with database
- Both
- None
- _____is a collection of programs
performing all necessary action associated with a database:
- Database
associated
- Database
administrator
- Database
application
- Database management system
- _______is
a program or set of program that interacts with the database at some point
in its execution:
- A
database system
- A database application
- Both
- None
- ________is
a collection of application programs that interacts with the database
along with DBMS:
- A database system
- A
database application
- Both
- None
- In
which services the processes of database management and data management
are complementary:
- Database
associated
- Database
administrator
- Database
application
- Database management system
- ACID
stands for:
- Atomicity, consistency, isolation,
and durability
- Atomicity,
command, integrity, and data
- Atomicity,
control, integrated, and direct
- None
of these
- A DBMS provides users with the conceptual
representation of:
- Register
- Data
- Logical
view
- Physical
view
- Which
structure of data clearly is one of the main features of the database
approach:
- Logical
view
- Physical
view
- Both
- None
- A
_____view of data expresses the way a user thinks about data
- Logical view
- Physical
view
- Both
- None
- A physical
view of data refers to the way data is handled at a_____ its storage and
retrieval:
- High
level
- Low level
- Medium
level
- All
of these
- In
logical and physical view of data the set of principles that defines a
data model may be divided into how many parts:
- In
logical and physical view of data the set of principles that defines a
data model may be divided into which part:
- Data
definition
- Data
manipulation
- Data
integrity
- All of these
- The
overall description of a database is called______:
- Data
definition
- Data
manipulation
- Data
integrity
- Database schema
- Which
is proper subset designed to support ‘views’ belonging to different
classes of users in order to hid or protect information:
- Schema
- Subschema
- Non-schema
- None-subschema
- A data
dictionary is a repository that manages _____:
- Database
- Memory
- Metadata
- All
of these
- Which
languages are used to define and query a database:
- Database
- Memory
- Metadata
- All
of these
- Data definition language
- Data
description languages
- Data
design languages
- Database
dictionary languages
- Which
are the not most frequently used DDL statements:
- CREATE
- DROP
- ALTER
- None of these
- VDL
stand for:
- View
data languages
- View
design languages
- View definition languages
- View
done languages
- SDL
stands for
- Stand
definition languages
- Storage definition languages
- Select definition languages
- system definition languages
- The
DDL is used to specify the_____:
- Conceptual schemas
- Internal
schemas
- Both
- None
- The SDL is used to specify the_______:
- Conceptual
schemas
- Internal schemas
- Both
- None
- DML
stands for:
- Data
description languages
- Data
design languages
- Database
dictionary languages
- Data manipulation languages
- Which
is used for data retrieval from the database:
- Which is used to specify the user views
and their mappings to the conceptual schema:
- What
are the types of DML:
- Low
level
- High
level
- Procedural
DML
- All of these
- Which is requires a user to specify what
data is needed and how to get it:
- Low
level
- Procedural
DML
- Both
- None
- Data
is manipulated by procedure calls to subroutines provided by a_____:
- Data
- DBMS
- Register
- All
of these
- The
programming languages is called:
- Sublanguages
- Host languages
- VDL
- DDL
- Sublanguages
- Host
languages
- VDL
- DDL
- Which
command are included in a general purpose programming languages:
- A
database management system are very complex_____:
- Art
- Command
- Languages
- System
- How
many levels of abstraction in DBMS:
- Which
are the three levels of abstraction:
- Physical
- Logical
- External
- All of these
- How
many types of data independence:
- Which
are the types of data independence:
- Physical
- Logical
- Both
- All
of these
- Which
is the transformation of requests and results between different levels of abstraction:
- Evaluation
- Mapping
- Compiler
- Precompiler
- Which
mapping exists between the conceptual and internal levels:
- Conceptual
- Internal
- Both
- None
- Which
mapping exists between the external and conceptual levels:
- Conceptual
- Internal
- Both
- None
- The
related and interconnected software
components of a DBMS are described by the _______:
- Logical
architecture
- Physical
architecture
- Both
- None
- Which
are the types of physical DBMS architecture can be split :
- Back
end
- Front
end
- Both
- None
- In
which end is really just any application that runs on top of the DBMS and acts
as a user interface:
- Back
end
- Front end
- Both
- None
- Data are
stored in________ as database:
- Data files
- Data
dictionary
- Database
- Data
administrator
- RAD
stands for:
- Rotate
application development
- Register
application development
- Related
application development
- Rapid application development
- DA
stands for:
- Data administrator
- Database
active
- Define
application
- All
of these
- Which
is the person responsible for overall control f the database system:
- DBA
stands for:
- Database
maintenance
- Database administrator
- Database
backup
- Database
designer
- Transaction
is an action used to perform some manipulation on data stored in the____:
- Memory
- Record
- Database
- All
off these
- How
many features of a DBMS which provide a number of advantages for data
management:
- Which
is a DBMS keeps back-up copies of the database:
- Backup
- Recovery
- Both
- None
- In
which the database can be restored up to the last consistent state after
the system failure:
- Backup
- Recovery
- Both
- None
- Which
are the not user in End-user:
- Naïve
users
- Casual
users
- Sophisticated
user
- All of these
- Which
are the not features of a DBMS which provide a number of advantages for
data management:
- DML
- DDL
- SDL
- None of these
- Minimal
data redundancy means improved _________:
- Data
independence
- Data consistency
- Data
integration
- Data
sharing
- Who
access the database occasionally and have different needs each time:
- Naïve
users
- Casual users
- Sophisticated
user
- All
of these
- Who
interact with the system without writing a program:
- Naïve
users
- Casual
users
- Sophisticated user
- All
of these
- Who
interact with the system by invoking one of the permanent application
program:
- Naïve users
- Casual
users
- Sophisticated
user
- All
of these
- The
main interface that a native user uses is a form interface using___:
- The provision
of _______ is a major objective for database system:
- Data independence
- Data
consistency
- Data
integration
- Data
sharing
- Who is
requested to carry out various operation, such as insert, delete, update
and retrieval vwiours on the database by the user:
- ____
is a translates into low-level instruction that a query processor
understands:
- Retrieval
of data is done by using a ____:
- Stack
- Query
- Linked
list
- All
of these
- DML is
a languages by which user accesses or manipulates the ________:
- Data model
- Data
consistency
- Data
integration
- Data
sharing
- Which is
the central component of the DBMS software that can also be termed as the
database control system:
- Data
consistency
- Data
integration
- Data
sharing
- Data manager
- Which
is stored information about description of data in the database:
- Data
files
- Data dictionary
- Database
- Data
administrator
- After
conversion of high level queries into low level commands for file access
and is called compiled_____:
- Which
is installs, configures, troubleshoots and maintains a database system:
- Which
is incorporated to create an appropriate physical database that is
transformed by a logical data model:
- SQL
stands for:
- System
query language
- Sequential query language
- Sets
query languages
- None
of these
- CSV
stands for:
- Command
system values
- Comma
system values
- Command
separated values
- Comma separated values
- PDF
stands for:
- Physical
data format
- Portable document format
- Physical
document format
- Portable
data format
- XML stands for:
- Xtensible markup languages
- Xtensible
memory languages
- Both
- None
- BLOB
stands for:
- Binary
languages Objects
- Bit
large Objects
- Binary
low objects
- Binary large objects
- Which
is refers to the collection of related data values or items called fields:
- Record
- Record
blocking
- Fixed-length
record
- Variable-length
record
- Every
record in the same size in bytes the file is constituted of_____:
- Record
- Record
blocking
- Fixed-length record
- Variable-length
record
- _________
is the records in the file are of different sizes:
- Record
blocking
- Fixed-length
record
- Variable-length record
- None
of these
- In
which circumstances not variable-length record occur:
- Mixed
files
- Repeating
field
- Both
- None
- The
block containing the record is the unit of data transferred between
the________:
- Main memory and The disk
- Data
and Memory
- Data
and Disk
- All
of these
- Who is
the unit of data transferred:
- The
memory
- The
data
- The
user
- The block
- _____is a collection of all occurrences
of similar types of records:
- Data
- Data
item
- File
- All
of these
- How
many types of recodes in a file-based system:
- Which are is not type of recodes in a
file-based system:
- Logical
records
- Physical
records
- Both
- None
- Which
contain information about a file needed by system programs for accessing file
records:
- File
blocks
- File
operations
- File headers
- None
of these
- The
file operations can be divided into how many categories:
- _____
take into account only such records that are valid:
- Algorithm
- Searching algorithm
- Flow
chart
- All
of these
- ______ file organization is vital for ensuring
the most efficient access of files and records:
- File
blocks
- File
operations
- File
headers
- File organization
- New records
are placed at the end of the file it is referred to as____:
- Heap
file
- Pile
file
- Both
- None
- The field
which is used to order the file is referred to as ________:
- Sorted
field
- Ordering field
- Both
- None
- Binary
search accesses _____ blocks:
- Log(b)
- Log2(b)
- 2log(b)
- Log(2b)
- Which
provides precise partition between abstract characteristics of the data
type and its implementation specifications:
- Data
- Data
item
- File
- Data abstraction
- ODBS
stands for:
- Off
data base connection
- Open data base connection
- Oriented
data base connection
- All
of these
- DDL
stands for:
- Decode
data languages
- Data define languages
- Database
define languages
- Define
data languages
- SOA stands for:
- Services
oriented abstraction
- System oriented abstraction
- Services oriented architecture
- All
of these
- ADSL stands for:
- Acquired
data system line
- Asymmetric digital subscribe line
- Asymmetric
digital subscribe languages
- Acquired
data system languages
- Which
services are insulated by abstraction from the fundamental physical data:
- EII
stand for:
- Enterprise information integration
- End
information integration
- Enterprise
input information
- None
of these
- ______
is another name given to data integration when use in the management
context:
- Logical
as view
- Local as view
- Land
as view
- Last
as view
- Global as view
- Global
as verify
- Both
- None
- ETL
stands for:
- End
transforming and loudening
- Extracting transforming and loading
- Extracting
transforming and languages
- End transforming and languages
- GSM
stands for:
- Global source mapping
- Global
system map
- Global
system master
- Global
system mode
- Which
are the accepted ways for modeling such correspondence:
- CDI
stands for:
- Computer
data input
- Code
data input
- Computer data integration
- Computer
data information
- How
many structure used in ontology based on data integration application are
explained:
- ______
is the commercial application of data integration:
- ANSI
stands for:
- Analyst
national system institute
- Analog national system institute
- Analyst
national standards institute
- American national standards institute
- SPARC
stands for:
- System
planning and requirements
- Standards planning and requirements
- Both
- None
correct the 78th Question's answer it's not sequential it must be structured
ReplyDeletenice,,
ReplyDeleteQuestions are good but grammar is poor
ReplyDeleteThis is awesome help me lot...guys u can check here for some important DBMS question
ReplyDelete