• Home
  • Courses
  • School
  • Programs
  • Problems
  • Contact Us
  • My account
  • Register

Have any question?

(+91) 98222 16647
info@simplycoding.in
RegisterLogin
Simply Coding
  • Home
  • Courses
  • School
  • Programs
  • Problems
  • Contact Us
  • My account
  • Register

Database

Database Basic Questions for Practice

  • Categories Database, Data Management
Database Questions
Q 1.What is the Database?

Ans:

A database is a collection of information that is organized in such a way that it can be easily accessed, managed and updated.

Q 2.What is DBMS?

Ans:

A DBMS or DataBase Management System is software application that helps users in handling the storage, retrieval, and updating of data in a computer system.  It helps to manage large volume of data.

Q 3.What is RDBMS?

Ans:

RDBMS or Relational DataBase Management System is a database which stores information in relational format or tables. E.g. Oracle, MYSQL, MSAccess, Sybase etc.

Q 4.What are advantages of DBMS?

Ans:

The advantages of DBMS are

      1. Avoids Data redundancy or duplication of data
      2. Allows Data Independence
      3. It allows sharing of data.
      4. It removes data inconsistency hence ensures data Integrity is maintained.
      5. It provides enhanced security through authorization, passwords etc.
Q 5.What is data redundancy?

Ans:

Data redundancy means duplication of data. Non-database systems maintain separate copy of

data for each application. This duplication of data may lead to inconsistency or incorrect data at times. DBMS stores all data at one place and all the application programs that require this data can refer to the same central place. This centralization makes sure, that data remain consistent and secure.

Q 6.What is the Table? Or what are the components of table.

Ans:

A table is data set that is organized into rows and columns. A row is also called as record which represents one complete unit of information. Columns are also called as Fields which contains one type of information.

Q 7.What is Record?

Ans:

Records are the rows representing one complete unit of information. A logical record contains contents of all the fields. A database may have many records.

Q 8.What is Data Item or Field?

Ans:

A data item or Field is the column containing one type of information. It is the smallest unit of named data. It may consist of any number of bits or bytes.

Q 9.What is  a Data Type?

Ans:

A data type is type of data that is stored in a field, it can be character, number, image etc.

Q 10.What is  Primary Key?

Ans:

Primary key is a field which uniquely identifies each record in the table. A table can have only one primary key and this key cannot be empty.

Q 11.What are 3 levels of structure of DBMS?

Ans:

The structure of DBMS is divided into 3 levels.

      1. External Level
      2. Conceptual Level
      3. Internal Level
Q 12.What is the difference between external, Conceptual and internal level of database structure?

Ans:

Database structure is divided into 3 levels.

External LevelConceptual LevelInternal Level
It is also called as user view and is the highest levelIt is the intermediate levelThis is the lowest level
Allows access to only portions of database which concerns the user.It describes the detail of all information that is kept and relationship between them.It describes how data will be stored. It describes the data structure and access methods.

Q 13.What is data Independence?

Ans:

Data independence means it is possible to change the storage structure or records and relations without affecting the applications

Q 14.What are different types of DBMS users?

Ans:

Different types of DBMS users are

Passive UsersOnline UsersApplication ProgrammersDatabase administrators
Users not aware of database systemUsers are aware of database systemProfessional programmers with good knowledge of databaseIn depth knowledge of database and people who manage the database
Need to be instructed to carry out a transactionCan carry out direct communication with database.Write application programs in Java, C++ to control databasesResponsible to create & maintain database.
Also recover database in case of failure.
e.g. ATM user.e.g. online banking/trading users.e.g C++ programmer.e.g. MySQL Administrator

Q 15.What is the difference between DDL and DML?

Ans:

DDL (Data Definition Language)DML (Data Manipulation Language)
It is a language used for defining data in the databaseLanguage used for manipulating data in a database
Used for creating, modifying, and deleting TABLES in the database.It provides commands to select and retrieve data from the database.
e.g. CREATE, ALTER, DROP TABLES.e.g. INSERT, UPDATE, DELETE,SELECT

Q 16.What are major components of DBMS?

Ans:

Major components of DBMS are

      1. DDL Compiler: It converts data definition statements into set of tables
      2. Data Manager: IT is the database control system which maintains and secures data. It interfaces with file system
      3. File Manager: It is responsible for maintaining the structure of files and managing the file space. It interfaces between Data and disk manager and coordinates between them.
      4. Disk Manager: It performs all input and output operation on the storage disk. It saves/returns block of pages requested by file manager.
      5. Query Processor: It interprets online user queries
      6. Telecommunication System: Online user communicates by sending and receiving messages over communication system.
      7. Data Dictionary: Information about structure and usage of data contained in database is maintained in data dictionary.
Q 17.Give full form of following?

Ans:

DDL: Data Definition Language.
DML: Data Manipulation Language.
DBMS: Data Base Management System.
RDBMS: Relational Database management system.
DBA: Data Base Administrator
ATM: Automated Teller Machine.

Q 18.Fill in the blanks
  1. ______________ is responsible for managing and maintaining the database management system.

Ans. DBA: Data Base Administrator

 

  1. ______________ contains information about structure and usage of data contained in database.

Ans. Data Dictionary.

 

  1. ______________ is a type of data base system which stores data in tables

Ans. RDBMS (Relational Database)

 

  1. ______________ is a row in database giving one full unit of information

Ans. Record

 

  1. ______________, ____________ and ____________are three levels of database

Ans. External, Conceptual, Internal

 

  1. ______________ means it is possible to change the storage structure of database without affecting the applications.

Ans. Data Independence

 

  1. ______________ is a field which uniquely identifies as each record in a table

Ans. Primary Key

 

  1. ______________ is an example of an RDBMS

Ans. MS Access, MSSQL, Oracle, PostgreSQL.

 

  1. DROP, ALTER are example of ______________ type of database command.

Ans. DDL, Data Definition language.

 

  1. INSERT, SELECT are example of ______________ type of database command.

Ans. DML, Data Manipulation language.

 

  1. _____________converts data definition statements into set of tables.

Ans. DDL Compiler.

 

  1. The disk manager performs _____________and _____________ operations.

Ans. DDL Compiler.

 

  1. _____________part of DBMS is responsible to maintain the structure of files and managing file space.

Ans. File Manager.

 

  1. _____________is the lowest level of database implementation.

Ans. Internal.

 

  1. _____________interprets online user query.

Ans. Query Processor.

 

  1. _____________and ___________ are example of DDL Command.

Ans. CREATE, ALTER, DROP TABLES.

 

  1. _____________and ___________ are example of DML Command.

Ans. INSERT, UPDATE, DELETE, SELECT

  • Share:
author avatar
Simply Coding

Previous post

What is XML?
June 18, 2020

Next post

What is Logo Programming?
June 18, 2020

You may also like

Screenshot_20201209-112442__01
Index Commands in SQL
14 December, 2020
Screenshot_20201209-113227__01
SQL Select Statement: Tutorial
14 December, 2020
Screenshot_20201209-111403__01
SQL: Join
10 December, 2020

Leave A Reply Cancel reply

You must be logged in to post a comment.

Categories

  • Uncategorized
  • Programs
    • Python
    • Java
  • Problems
    • Python
    • Java
    • Web Development
      • Internet
    • Emerging Technologies
  • Notes
    • General
    • QBasic
    • MS Access
    • Web Development
      • XML
      • HTML
      • JavaScript
      • Internet
    • Database
    • Logo Programming
    • Scratch
    • Emerging Trends
      • Artificial Intelligence
      • Internet of Things
      • Cloud Computing
      • Machine Learning
    • Computer Fundamentals
      • Computer Networks
      • E-Services
      • Computer Hardware
    • Python
    • Java
  • School
    • ICSE
      • Computers Class 9
        • Java Introduction
        • Tokens & Data Types
        • Java Operators
        • Math Library
        • if & switch
        • For & While
        • Nested loops
      • Computer Class 10
        • Sample Papers
        • OOPS concepts
        • Functions in Java
        • Constructors
        • Arrays in Java
        • Strings in Java
    • SSC
      • IT Class 11
        • IT Basics
        • DBMS
        • Web Designing
        • Cyber Laws
      • IT Class 12
        • Web Designing
        • SEO
        • Advanced JavaScript
        • Emerging Tech
        • Server Side Scripting
        • E-Com & E-Gov
      • Computer Science 11
      • Computer Science 12
    • CBSE
      • Computer 9
        • Basics of IT
        • Cyber Safety
        • Scratch
        • Python
      • Computer 10
        • Sample Papers
        • Networking
        • HTML
        • Cyber Ethics
        • Scratch
        • Python
      • Computer Science 11
        • Computer Systems
        • Python 11
          • Python Basics
          • Python Tokens
          • Python Operators
          • Python if-else
          • Python loops
          • Python Strings
          • Python List
          • Python Tuple
          • Python Dictionary
          • Python Modules
        • Data Management
      • Computer Science 12
        • Sample Papers
        • Python 12
          • Python Functions
          • Python File Handling
          • Python Libraries
          • Python Recursion
          • Data Structures
        • Computer Networks
        • Data Management
    • ISC
      • Computer Science 11
        • Introduction to Java
        • Values & Data Types
        • Operators
        • if & switch
        • Iterative Statements
        • Functions
        • Arrays
        • String
        • Data Structures
        • Cyber Ethics
      • Computer Science 12
        • Sample Papers
        • Boolean Algebra
        • OOPS
        • Wrapper Classes
        • Functions
        • Arrays
        • String
Simply Coding Computer Courses for School                Privacy Policy     Terms of Use     Contact Us

© 2021 Simply Coding

Login with your site account

Lost your password?

Not a member yet? Register now

Register a new account

Are you a member? Login now