DBMS and IS Development Quiz

What is a major benefit of using a database over a traditional file system?

• Increased data redundancy

• Faster manual retrieval

• Reduced data inconsistency

• Simpler storage hardware

Which component of DBMS is used to create data structures and define relationships?

• Data Manipulation

• Data Definition

• Application Generation

• Inference Engine

Which type of database allows multiple users to access data from different physical locations?

• Flat-file database

• Relational database

• Distributed database

• Hierarchical database

Which language is commonly used to interact with relational databases?

• HTML

• SQL

• XML

• CSS

Which is the correct order in the data hierarchy from smallest to largest?

• Record, Field, File, Database

• Character, Field, Record, File

• File, Record, Field, Database

• Field, Record, File, Database

In SDLC, which phase involves determining user requirements?

• Design

• Analysis

• Implementation

• Maintenance

What does CRUD stand for in the context of database operations?

• Create, Read, Update, Delete

• Connect, Run, Update, Debug

• Compute, Retrieve, Upload, Deliver

• Check, Render, Use, Dump

Which of the following is an advantage of Rapid Application Development (RAD)?

• Minimal user involvement

• Focuses only on coding

• Longer development cycle

• Quick feedback and prototyping

Which SDLC phase includes testing system components?

• Design

• Implementation

• Analysis

• Planning

Which methodology delivers software in small, incremental builds?

• Waterfall

• Agile

• RAD

• SOA