Web
Analytics

Computer Fundamentals For Competitive Exams
Database Management Systems
Answer 25 questions in 10 minutes.

Database Management Systems |


A collection of interrelated records is called a
management information system
None
database
spreadsheet
text file

Periodically adding - changing and deleting file records is called file
renewing
upgrading
updating
None
restructiring

Meaningful filename helps in easy file ______.
Accessing
None of the above
Identification
Printing
Storing

How do businesses protect their databases?
Databases are protected by file swapping.
Databases are kept physically and electronically secure.
Databases are naturally protected.
The computer room is kept locked after office hours.
Security guards are hired to watch the databases at all times.

When data changes in multiple lists and all lists are not updated - this causes
information overload
data repetition
duplicate data
data redundancy
data inconsistency

A collection of unprocessed items is ________.
None
memory
data
reports
information

An ad hoc query is a __________.
question that will not return any results
None
pre-planned question
spur-of-the-moment question
pre-scheduled question

A data dictionary doesn-™t provide information about
None
how the data is used
who owns or is responsible for the data
the size of the disk storage disk
where data is located

Distributed processing involves
allowing users to share files on a network
allowing users to access network resources away from the office
solving computer component problems from a different computer
solving computing problems by breaking them into smaller parts that are seperately processed by different computers
None

The simultaneous execution of two or more instructions is called
sequential access
reduced instruction set computing
multiprocessing
disk mirroring
None

E-R modeling technique is a
bottom-up approach
left-right approach
both top-down and bottom-up
top-down approach
None

The DBMS acts as an interface between what two components of an enterprise-class database system?
None
Database application and SQL
Data and the database
The user and the database application
Database application and the database

Files are organised by storing them in _________.
tables
databases
folders
None
graphs

A relation (from the relational database model) consists of a set of tuples - which implies that
None
for any two tuples - the value associated with one or more of their attributes must differ.
all tuples in particular relation may have different attributes.
for any two tuples - the values associated with all of their attributes may be the same.
relational model supports multi-valued attributes whose values can be represented in sets.

What does the data dictionary identify?
DBMS; database
application program; database
None
application programs; users
database - users

__________ represents raw facts - whereas __________ is data made meaningful.
None
Information - bits
Information - reporting
Data - information
Records - bytes

Participants can see and hear each other in a/an
message system
None
electronic mail system
bulletin board
teleconference

A Field is a related group of __________.
Files
Records
None of the above
Characters
Cables

Which of these is considered intelligent CASE tool [IBPS Clerk - 2012]
Methodology companion
Upper CASE
Toolkit
Lower case
Workbench

GET PROVEN ADVICE FROM
100+ BEST BOOKS IN 1 BOOK

250 Top Work & Personal Skills Made Easy

The World's First & Only Encyclopedia of
Self Help, Self Improvement & Career Advice

250+ Easy-to-Follow Guides
5000+ Proven Tips
13 Types of Essential Skills

502 Pages | $3.99 | PDF / EPub, Kindle Ready



 
 
 




Please report any error in fatskills quizzes and questions to 'simpleversity at gmail.com'.

Without work one finishes nothing. - Ralph Waldo Emerson

© The Simple Project 2020