Welcome to the DBMS Basics MCQs Page

Dive deep into the fascinating world of DBMS Basics with our comprehensive set of Multiple-Choice Questions (MCQs). This page is dedicated to exploring the fundamental concepts and intricacies of DBMS Basics, a crucial aspect of DBMS. In this section, you will encounter a diverse range of MCQs that cover various aspects of DBMS Basics, from the basic principles to advanced topics. Each question is thoughtfully crafted to challenge your knowledge and deepen your understanding of this critical subcategory within DBMS.

Check out the MCQs below to embark on an enriching journey through DBMS Basics. Test your knowledge, expand your horizons, and solidify your grasp on this vital area of DBMS.

Note: Each MCQ comes with multiple answer choices. Select the most appropriate option and test your understanding of DBMS Basics. You can click on an option to test your knowledge before viewing the solution for a MCQ. Happy learning!

DBMS Basics MCQs | Page 36 of 38

Explore more Topics under DBMS

01

Data Models

02

The Entity Relationship Approach

03

Relational Databases

04

Data Storage and Querying

05

Relational Algebra

06

Normalization

07

Storage and File Structures

08

Indexing and Hashing

09

Transactions

10

Concurrency Control

11

Recovery System

12

Distributed Databases

13

SQL

14

Data Warehousing and Data Mining

15

RDBMS

16

Advanced SQL

17

SQL Queries,Constraints and Triggers

Q351.

Which program do you use to edit code for data access pages?

Microsoft script editor

Microsoft code editor

Microsoft data access pages editor

None of the above

Discuss

Answer: (a).Microsoft script editor

Q352.

The way a particular application views thedata from the database that the applicaton uses is a

Module

Relational model

Schema

Sub-schema

Discuss

Answer: (d).Sub-schema

Q353.

Which of the following is a database management system?

Ms-Word

Lotus 1-2-3

Oracle

None of the above

Discuss

Answer: (c).Oracle

Q354.

What is the corresponding text for the <#1/1/ 95# validation rule setting?

Neter a value less or more than 1,195

Value must be less than 95 characters

Enter a date before 1995

All of above

Discuss

Answer: (a).Neter a value less or more than 1,195

Q355.

What is the name of the Visual Basic Editor utility that allows you to view the Microsoft Access type librarys available objects and members?

Object Viewer

Object Browser

Type Library Spy

None of the above

Discuss

Answer: (b).Object Browser

Q356.

A computer language for informing the DBMS regarding the data structure used is

PASCAL

DDL

PROLOG

FORTRAN

Discuss

Answer: (b).DDL

Q357.

Which of the following is not a data type ?

Picture/graphic

Data/time

Texst

Number

Discuss

Answer: (a).Picture/graphic

Q358.

The executive responsible for the data processing function in an organization is

DBMS

DPM

Discuss

Answer: (b).DBMS

Q359.

A subset of characters within a data field is known as

Record

File

Data string

Byte

Discuss

Answer: (c).Data string

Q360.

Data items groped together for storage purposes are called a

Record

Title

List

string

Discuss

Answer: (a).Record

Page 36 of 38

Welcome to the DBMS Basics MCQs Page

DBMS Basics MCQs | Page 36 of 38

Explore more Topics under DBMS

Data Models

The Entity Relationship Approach

Relational Databases

Data Storage and Querying

Relational Algebra

Normalization

Storage and File Structures

Indexing and Hashing

Transactions

Concurrency Control

Recovery System

Distributed Databases

SQL

Data Warehousing and Data Mining

RDBMS

Advanced SQL

SQL Queries,Constraints and Triggers

Suggested Topics

Artificial Intelligence

CSS

SQL Server

Internet of Things (IoT)

Software Architecture and Design

Hadoop

Object Oriented Programming Using C++

UNIX

C# programming