Toggle navigation
Login / Register
Ask Questions
Study
Current Affairs
Previous Papers
Kerala PSC
IBPS
UPSC
RBI
TNPSC
MPSC
SSC
CBSE
United States
Model Tests
News
More
Answers
Coaching Centres
Careers
Downloads
Colleges
Kuwait News & Classifieds
Classic Jhumka Earrings Silver
INR 113.00
Free Shipping
Buy Now
Black Jhumka Earrings & Studs
INR 94.00
Free Shipping
Buy Now
Classic Jhumka Earrings Silver
INR 207.00
Free Shipping
Buy Now
Beautiful stud earing
INR 93.00
Free Shipping
Buy Now
Different Size Hoop and Stud Earrings Set
INR 243.00
Free Shipping
Buy Now
Golden Hoop Earing
INR 70.00
Free Shipping
Buy Now
×
Create account with Openguide
Sign Up
By clicking Sign Up, you agree that you have read and accepted the
Open Guide Online User Agreement.
Already have an account?
Log in
×
Login to OpenGuide
Login
Forgot password?
Reset it
New user?
Register
×
Reset your password
Reset Password
Registered user?
Log in
New user?
Register
Home
Questions & Answer
Technology Questions & Answers
Data Base Questions & Answers
Data Base Questions & Answers
(Compiled from UPSC, SSC ,PSC ,IBPS previous question papers)
Non procedural query language can be related with
A
Function dependency
B
B tree
C
Domain calculus
D
Relational algebric operators
Natural join can be related with
A
Function dependency
B
B tree
C
Domain calculus
D
Relational algebric operators
Secondary index can be related with
A
Function dependency
B
B tree
C
Domain calculus
D
Relational algebric operators
Two basic types of record access methods are
A
sequential and random
B
direct and immediate
C
sequential and indexed
D
online and real time
Data dictionary is a special file that contains
A
the names of all fields in all files
B
the data types of all fields of all files
C
Both of above
D
None of above
In order to use a DBMS, it is important to understand
A
the physical schema
B
all subschemas
C
one sub schema
D
none of above
Large collection of files are called
A
fields
B
Records
C
Database
D
Sectors
Which is a type of DBMS software
A
utilities
B
query language
C
report writer
D
All of above
Fragmentation of a file system
A
Can always be prevented
B
occurs only is file is not used properly
C
Can be temporarily removed by compaction
D
None of above
Which among following is not a relational database
A
dBase IV
B
4th Dimention
C
FoxPro
D
Reflex
Modify operation is likely to be done after
A
Delete
B
Lookup
C
Indexing
D
Insertion
Physical location of a record in database is determined with the help of
A
B tree file
B
Indexed file
C
Hashed file
D
sequential file
Transaction processing was made possible by the development of
A
direct access storage
B
magnetic tape
C
cash register input
D
minicomputers
Which normal form is considered adequate for normal relational database design
A
2NF
B
5NF
C
3NF
D
4NF
The logical structure with one to many relationships is a
A
network
B
tree
C
chain
D
relational
Which among following contains a complete record of all activity that affected the contents of a database during a creation period of time
A
report writer
B
query language
C
DML
D
transaction log
E
Answer And Explanation
Which among following is an approach for standardizing storing of data
A
MIS
B
Structured programming
C
CODASYL specifications
D
None of above
RAID configurations of a disk are used to provide
A
fault tolerance
B
high speed
C
high data density
D
none of above
Data management system may be implemented as
A
system software
B
application software
C
computer program
D
all of above
File record length
A
should always be fixed
B
should always be variable
C
should be chosen to match the data character
D
depends upon the size of file
Network structure
A
is a physical representation of data
B
is conceptually simple
C
allows many to many relationships
D
none of above
Embedded pointer provides
A
a secondary access path
B
a physical record key
C
an inverted index
D
all of above
Which is not a logical database structure
A
Chain
B
Tree
C
Relational
D
Network
Ascending order of data hierarchy is
A
bit->byte->record->field->file->database
B
bit->byte->field->record->file->database
C
byte->bit->field->record->file->database
D
byte->bit->field->file->record->database
Database management systems are used to
A
eliminate data redundancy
B
establish relationships among records in different files
C
manage file access
D
none of above
The master list of an indexed file
A
is sorted in ascending order
B
contains only a list of keys and record numbers
C
has a number assigned to each record
D
none of above
Allocation map
A
Used to store program data
B
specifies which blocks are used by which file
C
is updated by application programs
D
allow programs to erase files
Attribute of one table matching to the primary key of other table, is called as
A
foreign key
B
secondary key
C
candidate key
D
composite key
If a relation scheme is in BSNF then it is also in
A
First normal form
B
Second normal form
C
Third normal form
D
Not in any normal form
‹ First
2
3
4
Categories
Android
C programming
C++ programming
Cloud Computing
Computer
Computer System Architecure
Data Base
Data Structure
Internet & Social Media
Java programming
Manual Testing
MS Office
MySQL
Networking
Operating System
PHP
Programming
Software Engineering
Software Testing
Help & Support
About Us
Contact Us
Terms of Service