MCQGeeks
0 : 0 : 1
CBSE
JEE
NTSE
NEET
English
UK Quiz
Quiz
Driving Test
Practice
Games
Quiz
Computer Science
Database Systems
Quiz 4
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
Q.1
Versatile report generators can provide
Columnar totals
Subtotals
Calculations
All of the above
None of the above
Q.2
Related fields in a data base are grouped to form
data file
data record
menu
bank
None of the above
Q.3
A _____ means that one record in a particular record type can be related to many records in another record type and vice-versa.
One-to-one relationship
One-to-many relationship
Many-to-one relationship
Many-to-many relationship
None of the above
Q.4
A data dictionary is a special file that contains
the names of all fields in all files
the data types of all fields in all files
the widths of all fields in all files
All of the above
None of the above
Q.5
A file that is organized in uniform format is formally referred to as a _____ or a database file.
Document
Database
Record
Structured data file
None of the above
Q.6
A _____ Contains fields of data about one entity.
Record
File
Fields
Document
None of the above
Q.7
A condition that led to the development of databases was
a demand for more data to support information needs
an increase in the amount of data handled by organizations
the proliferation of data files
All of the above
None of the above.
Q.8
A report form
appears on the computer monitor during data entry
is used during report generation to format data
both (a) and (b)
All of the above
None of the above
Q.9
A computer file can be best described as
a single data item
a general collection of data items
an orderly collection of data items
a random collection of data items
None of the above
Q.10
One data dictionary software package is called
DB/DC dictionary
TOTAL
ACCESS
any of the above
None of the above
Q.11
One approach to standardizing storing of data
MIS
structured programming
CODASYL specifications
All of the above
None of the above
Q.12
The distinguishable parts of a record are called
files
data
fields
database
None of the above
Q.13
Large collections of files are called
fields
records
databases
file system
None of the above
Q.14
Two files may be joined into a third file if
they have a row in common
they have a field in common
they have no records with the same value in the common field
both (b) and (c)
None of the above
Q.15
The _____ command is used to allocates an extent for the table in SQL
MODIFY ALLOCATES
MODIFY TABLE
ALTER TABLE
REDEFINE TABLE
None of the above
Q.16
Embedded pointer provide
a secondary access path
a physical record key
an inverted index
All of the above
None of the above
Q.17
A good query system
can accept English language commands
allows non-programmers to access information stored in a database
can be accessed only by data processing professionals
both (a) and (b)
None of the above
Q.18
If you want to organize a file in multiple ways, it is better to _____ the data rather than to sort it.
Delete
Update
Sort Key
Index
None of the above
Q.19
The modify operation is likely to be done after
Delete
Look-up
Insert
All of the above
None of the above
Q.20
What software packages are commonly used for businesses that have to track extensive lists of clients and inventory?
Special purpose packages
Custom made programs
Single function application packages
Data management packages
None of the above
Q.21
A multiple-form file management system
lets you define different forms for different operations
lets you create a look-up form with an associated read-only password to prevent access by unauthorized users
both (a) and (b)
allow you to entry data in all the forms
None of the above
Q.22
The index consists of
a list of keys
pointers to the master list
both (a) and (b)
All of the above
None of the above
Q.23
In SQL, which command is used to select data in rows and column from one or more tables?
CHOOSE
SELECT
LIST
BROWSE
None of the above
Q.24
Characteristic(s) of a distributed MIS structure is
interactive sharing of the workload
a multiprocessing environment
computers supporting local DP operations
All of the above
None of the above
Q.25
The data-base environment has all of the following components except:
users
separate files
data base
data-base administrator
None of the above
Q.26
Which of the following is a type of DBMS software?
database manipulation language
query language
utilities
report writer
All of the above
Q.27
The term _____ is sometimes used to refer to a data file in which all the records have the same record format, that is, the same field names, field lengths, and data types.
Database
Table
Flat file
Data structure
None of the above
Q.28
In any hierarchy of data organization, the smallest entity to be processed as a single unit is called
data field
data record
data file
database
None of the above
Q.29
A scheme describes
data elements
records and files
record relationships
All of the above
None of the above
Q.30
The way a particular application views the data from the data base that the application uses is a :
module
relational model
schema
subschema
None of the above
0 h : 0 m : 1 s
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
Report Question
×
What's an issue?
Question is wrong
Answer is wrong
Other Reason
Want to elaborate a bit more? (optional)
Support mcqgeeks.com by disabling your adblocker.
×
Please disable the adBlock and continue.
Thank you.
Reload page