-
question_answer1)
Devices that could be used to input data into a database are
A)
keyboard, fax roller ball done
clear
B)
mouse, keyboard, monitor done
clear
C)
mouse, keyboard, touch screen done
clear
D)
All of the above done
clear
E)
None of the above done
clear
View Solution play_arrow
-
question_answer2)
DBMS is comprised of tables that made up of rows called ......... and columns called ......
A)
fields, records done
clear
B)
records, fields done
clear
C)
address, fields done
clear
D)
ranges, sheet done
clear
E)
records, ranges done
clear
View Solution play_arrow
-
question_answer3)
A database that contains tables linked by common fields is called a
A)
centralised database done
clear
B)
flat file database done
clear
C)
relational database done
clear
D)
All of these done
clear
E)
None of these done
clear
View Solution play_arrow
-
question_answer4)
Which of the following places the common data elements in order from smallest to largest?
A)
Character, File, Record, Field, Database done
clear
B)
Character, Record, Field, File, Database done
clear
C)
Character, Field, Record, File, Database done
clear
D)
Bit, Byte, Character, Record, Field, File, Database done
clear
E)
None of the above done
clear
View Solution play_arrow
-
question_answer5)
The primary key must be
A)
numeric done
clear
B)
unique done
clear
C)
multiple done
clear
D)
related done
clear
E)
object done
clear
View Solution play_arrow
-
question_answer6)
Periodically adding, changing and deleting file records is called ......... file.
A)
updating done
clear
B)
upgrading done
clear
C)
restructuring done
clear
D)
renewing done
clear
E)
None of these done
clear
View Solution play_arrow
-
question_answer7)
Items such as names and addresses are considered as
A)
input done
clear
B)
data done
clear
C)
output done
clear
D)
records done
clear
E)
information done
clear
View Solution play_arrow
-
question_answer8)
Which of the following objects is/are contained in database?
A)
Table done
clear
B)
Query done
clear
C)
Form done
clear
D)
All of these done
clear
E)
None of these done
clear
View Solution play_arrow
-
question_answer9)
A ......... is a collection of data that is stored electronically as a series of records in a table.
A)
spreadsheet done
clear
B)
presentation done
clear
C)
database done
clear
D)
Web page done
clear
E)
None of the above done
clear
View Solution play_arrow
-
question_answer10)
In files, there is a key associated with each record which is used to differentiate among different records. For every file, there is atleast one set of' keys that is unique. Such a key is called
A)
unique key done
clear
B)
prime attribute done
clear
C)
index key done
clear
D)
primary key done
clear
E)
null key done
clear
View Solution play_arrow
-
question_answer11)
Rows of a relation are called
A)
relation done
clear
B)
tuples done
clear
C)
data structure done
clear
D)
an entity done
clear
E)
None of these done
clear
View Solution play_arrow
-
question_answer12)
Which of the following types of table constraints will prevent the entry of duplicate rows?
A)
Primary key done
clear
B)
Unique done
clear
C)
Null done
clear
D)
Foreign key done
clear
E)
None of these done
clear
View Solution play_arrow
-
question_answer13)
The dBASE III Plus is mostly used for
A)
office automation done
clear
B)
database management problems done
clear
C)
scientific problems done
clear
D)
calculations only done
clear
E)
None of the above done
clear
View Solution play_arrow
-
question_answer14)
Which out of the following is not a DBMS software?
A)
dBASE done
clear
B)
FoxPro done
clear
C)
Oracle done
clear
D)
SyBase done
clear
E)
Database 2000 done
clear
View Solution play_arrow
-
question_answer15)
The primary key must be a (n)......... field.
A)
numeric done
clear
B)
object done
clear
C)
unique done
clear
D)
related done
clear
E)
None of these done
clear
View Solution play_arrow
-
question_answer16)
Architecture of database can be viewed as
A)
two levels done
clear
B)
four levels done
clear
C)
three levels done
clear
D)
one level done
clear
E)
None of these done
clear
View Solution play_arrow
-
question_answer17)
In an ER diagram, attributes are represented by
A)
rectangle done
clear
B)
square done
clear
C)
ellipse done
clear
D)
triangle done
clear
E)
circle done
clear
View Solution play_arrow
-
question_answer18)
In case of entity integrity, the primary key may be
A)
not null done
clear
B)
null done
clear
C)
Both a and b done
clear
D)
any value done
clear
E)
None of these done
clear
View Solution play_arrow
-
question_answer19)
In an ER diagram, an entity set is represented by a
A)
rectangle done
clear
B)
ellipse done
clear
C)
diamond box done
clear
D)
circle done
clear
E)
None of these done
clear
View Solution play_arrow
-
question_answer20)
An advantage of the database management approach is
A)
data is dependent on programs done
clear
B)
data redundancy increases done
clear
C)
data is integrated and can be accessed by multiple programs done
clear
D)
All of the above done
clear
E)
None of the above done
clear
View Solution play_arrow
-
question_answer21)
DBMS helps to achieve
A)
data independence done
clear
B)
centralised control of data done
clear
C)
selection of data done
clear
D)
Both a and b done
clear
E)
None of the above done
clear
View Solution play_arrow
-
question_answer22)
A set of possible data values is called
A)
attribute done
clear
B)
degree done
clear
C)
tuple done
clear
D)
domain done
clear
E)
None of these done
clear
View Solution play_arrow
-
question_answer23)
Which type of database, organised the data in the form of tree with nodes?
A)
Network Database done
clear
B)
Hierarchical Database done
clear
C)
Relational Database done
clear
D)
Multiple Database done
clear
E)
None of these done
clear
View Solution play_arrow
-
question_answer24)
The code that relational database management systems use to perform their database task is referred to as
A)
QBE done
clear
B)
SQL done
clear
C)
OLAP done
clear
D)
Sequel Server done
clear
E)
None of these done
clear
View Solution play_arrow
-
question_answer25)
In which the database can be restored up to the last consistent state after the system failure?
A)
Backup done
clear
B)
Recovery done
clear
C)
Redundancy done
clear
D)
Security done
clear
E)
None of these done
clear
View Solution play_arrow
-
question_answer26)
The cardinality property of a relation, refers to the
A)
number of database done
clear
B)
number of columns done
clear
C)
number of rows done
clear
D)
number of tables done
clear
E)
None of these done
clear
View Solution play_arrow
-
question_answer27)
The smallest unit of information about a record in a database is called a
A)
cell done
clear
B)
field done
clear
C)
record done
clear
D)
query done
clear
E)
None of these done
clear
View Solution play_arrow
-
question_answer28)
......... means that the data contained in a database is accurate and reliable.
A)
Data redundancy done
clear
B)
Data integrity done
clear
C)
Data reliability done
clear
D)
Data consistency done
clear
E)
None of these done
clear
View Solution play_arrow
-
question_answer29)
Which of the following contains information about a single 'entity' in the database like a person, place, event or thing?
A)
Query done
clear
B)
Form done
clear
C)
Record done
clear
D)
Table done
clear
E)
None of these done
clear
View Solution play_arrow
-
question_answer30)
A program that generally has more user-friendly interface than a DBMS is called a
A)
front end done
clear
B)
repository done
clear
C)
back end done
clear
D)
form done
clear
E)
None of these done
clear
View Solution play_arrow
-
question_answer31)
The database stores information in [SBI PO 2010]
A)
rows and columns done
clear
B)
blocks done
clear
C)
tracks and sectors done
clear
D)
All of these done
clear
E)
None of these done
clear
View Solution play_arrow
-
question_answer32)
The database administrator's function in an organization is [SBI PO 2010]
A)
to be responsible for the technical aspects of managing the information contained in organizational databases done
clear
B)
to be responsible for the executive level aspects of decision regarding the information management done
clear
C)
to show the relationship among entity classes in a data warehouse done
clear
D)
to define which data mining tools must be used to extract data done
clear
E)
None of the above done
clear
View Solution play_arrow
-
question_answer33)
Key to represent relationship between tables is called [SBI Clerk 2010]
A)
primary key done
clear
B)
secondary key done
clear
C)
foreign key done
clear
D)
composite key done
clear
E)
None of these done
clear
View Solution play_arrow
-
question_answer34)
A collection of related files is called a [SBI PO 2011]
A)
character done
clear
B)
field done
clear
C)
database done
clear
D)
record done
clear
E)
None of these done
clear
View Solution play_arrow
-
question_answer35)
A logical schema [SBI PO 2011]
A)
is the entire database done
clear
B)
is a standard way of organising information into accessable part done
clear
C)
describes how data is actually stored on disk done
clear
D)
All of the above done
clear
E)
None of the above done
clear
View Solution play_arrow
-
question_answer36)
In the relational modes, cardinality is termed as [IBPS Clerk 2011]
A)
number of tuples done
clear
B)
number of attributes done
clear
C)
number of tables done
clear
D)
number of constraints done
clear
E)
None of the above done
clear
View Solution play_arrow
-
question_answer37)
An E-R diagram is a graphic method of presenting [IBPS Clerk 2011]
A)
primary keys and their relationships done
clear
B)
primary keys and their relationships to instances done
clear
C)
entity classes and their relationships done
clear
D)
entity classes and their relationships to primary keys done
clear
E)
None of the above done
clear
View Solution play_arrow
-
question_answer38)
A computer checks the ...... of username and password for a match before granting access. [SBI Clerk 2011]
A)
Website done
clear
B)
network done
clear
C)
backup file done
clear
D)
database done
clear
E)
None of these done
clear
View Solution play_arrow
-
question_answer39)
An entity set that does not have sufficient attributes to form a primary key, is a [IBPS Clerk 2011]
A)
strong entity set done
clear
B)
weak entity set done
clear
C)
simple entity set done
clear
D)
primary entity set done
clear
E)
None of the above done
clear
View Solution play_arrow
-
question_answer40)
In a relational database, a data structure that organises the information about a single topic into rows and columns, is [RBI PO 2011]
A)
block done
clear
B)
record done
clear
C)
tuple done
clear
D)
table done
clear
E)
None of these done
clear
View Solution play_arrow
-
question_answer41)
In ER diagram, relationship type is represented by [IBPS Clerk 2012]
A)
ellipse done
clear
B)
dashed ellipse done
clear
C)
rectangle done
clear
D)
diamond done
clear
E)
None of these done
clear
View Solution play_arrow
-
question_answer42)
To locate a data item for storage is [IBPS PO 2012]
A)
field done
clear
B)
feed done
clear
C)
database done
clear
D)
fetch done
clear
E)
None of these done
clear
View Solution play_arrow
-
question_answer43)
......... are distinct items that don't have much meaning to you in a given context. [SBI PO 2012]
A)
Fields done
clear
B)
Data done
clear
C)
Queries done
clear
D)
Properties done
clear
E)
None of these done
clear
View Solution play_arrow
-
question_answer44)
The particular field of a record that uniquely identifies each record is called the [SBI PO 2012]
A)
key field done
clear
B)
primary field done
clear
C)
master field done
clear
D)
order field done
clear
E)
None of these done
clear
View Solution play_arrow
-
question_answer45)
............ provides total solutions to reduce data redundancy, inconsistency, dependence and unauthorised access of data. [IBPS Clerk 2012]
A)
DBMS done
clear
B)
Tables done
clear
C)
Database done
clear
D)
Protection password done
clear
E)
Centralisation of data done
clear
View Solution play_arrow
-
question_answer46)
......... is one reason for problems of data integrity. [IBPS Clerk 2012]
A)
Data availability constraints done
clear
B)
Data inconsistency done
clear
C)
Security constraints done
clear
D)
Unauthorised access of data done
clear
E)
Data redundancy done
clear
View Solution play_arrow
-
question_answer47)
Dr. E F Codd represented .......... rules that a database must obey if it has to be considered truly relational. [IBPS Clerk 2012]
A)
10 done
clear
B)
8 done
clear
C)
12 done
clear
D)
6 done
clear
E)
5 done
clear
View Solution play_arrow
-
question_answer48)
A collection of conceptual tools for describing data, relationships, semantics and constraints is referred to as [IBPS Clerk 2012]
A)
ER model done
clear
B)
database done
clear
C)
data model done
clear
D)
DBMS done
clear
E)
None of these done
clear
View Solution play_arrow
-
question_answer49)
What is the overall term for creating, editing, formatting, storing, retrieving a text document? [IBPS PO 2012]
A)
Word processing done
clear
B)
Spreadsheet design done
clear
C)
Web design done
clear
D)
Database management done
clear
E)
Presentation generation done
clear
View Solution play_arrow
-
question_answer50)
When data changes in multiple lists and all lists are not updated. This causes. [RBI Grade B 2012]
A)
Data redundancy done
clear
B)
Information overload done
clear
C)
Duplicate data done
clear
D)
Data consistency done
clear
E)
Data inconsistency done
clear
View Solution play_arrow
-
question_answer51)
A collection of interrelated records is called a [RBI Grade B 2012]
A)
utility file done
clear
B)
management information system done
clear
C)
database done
clear
D)
spreadsheet done
clear
E)
datasheet done
clear
View Solution play_arrow
-
question_answer52)
......... is a primary key of one file that also appears in another file. [IBPS Clerk 2013]
A)
Physical key done
clear
B)
Primary key done
clear
C)
Foreign key done
clear
D)
Logical key done
clear
E)
None of these done
clear
View Solution play_arrow
-
question_answer53)
......... is an invalid type of database key. [IBPS Clerk 2013]
A)
Structured primary key done
clear
B)
Atomic primary key done
clear
C)
Primary key done
clear
D)
Composite primary key done
clear
E)
None of the above done
clear
View Solution play_arrow
-
question_answer54)
Which name is suitable to run a macro at starting time of database? [RBI Grade B 2014]
A)
Start, exe done
clear
B)
Auto.exec done
clear
C)
Mocro.exe done
clear
D)
Any of these done
clear
E)
None of these done
clear
View Solution play_arrow
-
question_answer55)
A field is a related group of.......... [IBPS Clerk 2013]
A)
cables done
clear
B)
records done
clear
C)
files done
clear
D)
characters done
clear
E)
None of these done
clear
View Solution play_arrow
-
question_answer56)
Oracle is a (n) [IBPS Clerk 2014]
A)
hardware done
clear
B)
high level language done
clear
C)
operating system done
clear
D)
system software done
clear
E)
RDBMS done
clear
View Solution play_arrow
-
question_answer57)
......... tags, placed on animal's body can be used to record and track in a database all of the animal's movements. [IBPS Clerk 2014]
A)
POS done
clear
B)
RFID done
clear
C)
PPS done
clear
D)
GPS done
clear
E)
Other than those given as options done
clear
View Solution play_arrow
-
question_answer58)
What is a stored question about information in a database? [SBI Clerk 2015]
A)
Query done
clear
B)
Sort done
clear
C)
Report done
clear
D)
Record done
clear
E)
Field done
clear
View Solution play_arrow
-
question_answer59)
Data duplication wastes the space, but also promotes a more serious problem called [IBPS PO 2015]
A)
isolated called done
clear
B)
data inconsistency done
clear
C)
other than those given as: options done
clear
D)
program dependency done
clear
E)
separated data done
clear
View Solution play_arrow
-
question_answer60)
The purpose of the primary key in a database is to [IBPS Clerk 2015]
A)
unlock the database done
clear
B)
provide a map of the data done
clear
C)
uniquely identity a record done
clear
D)
establish constraints on database operations done
clear
E)
None of the above done
clear
View Solution play_arrow
-
question_answer61)
Which of the following contains data descriptions and defines the name, data type and length of each field in the database? [IBPS Clerk 2015]
A)
Data dictionary done
clear
B)
Data table done
clear
C)
Data record done
clear
D)
Data field done
clear
E)
None of these done
clear
View Solution play_arrow
-
question_answer62)
A range checks [IBPS Clerk 2015]
A)
that only the correct data type is entered into a field done
clear
B)
that all required data are present done
clear
C)
whether a number is within a specified limit done
clear
D)
if the data in two or more associated fields is logical done
clear
E)
None of the above done
clear
View Solution play_arrow
-
question_answer63)
Which of the following will not eliminate the ambiguities of a null value? [IBPS Clerk 2015]
A)
Define the attribute as required done
clear
B)
Define subtypes done
clear
C)
Define each attribute as having an initial value that is recognised as blank done
clear
D)
Define super types done
clear
E)
None of the above done
clear
View Solution play_arrow
-
question_answer64)
Which of the following statements is true? [IBPS Clerk 2015]
A)
Logical design is software dependent. done
clear
B)
In a distributed database, database is stored in one physical location done
clear
C)
Conceptual design translates the logical design into internal model. done
clear
D)
Logical design is software independent. done
clear
E)
None of the above done
clear
View Solution play_arrow