Scribd
Upload
143 views4 pages

IT-402 DBMS Basics for Students

The document is a quiz about database management systems and SQL. It contains 26 multiple choice questions about key concepts in databases and database management systems including: - The definition of a database, database management system, and relational database management system. - Popular DBMS software like Oracle, MS Access, and MySQL. - Database concepts like primary keys, columns, rows, datatypes, tables, relationships, and forms. - SQL commands and languages including DDL, DML, SELECT, UPDATE, DELETE, and ALTER statements. The document quizzes the reader on essential terminology and concepts relating to databases, database design, and the SQL language.

Uploaded by

Krish Patel
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
143 views4 pages

IT-402 DBMS Basics for Students

The document is a quiz about database management systems and SQL. It contains 26 multiple choice questions about key concepts in databases and database management systems including: - The definition of a database, database management system, and relational database management system. - Popular DBMS software like Oracle, MS Access, and MySQL. - Database concepts like primary keys, columns, rows, datatypes, tables, relationships, and forms. - SQL commands and languages including DDL, DML, SELECT, UPDATE, DELETE, and ALTER statements. The document quizzes the reader on essential terminology and concepts relating to databases, database design, and the SQL language.

Uploaded by

Krish Patel
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
You are on page 1/ 4

STD : 10 SUB : IT-402

DATABASE MANAGEMET SYSTEM ( W/S-4)


Fill in the blanks:
1. A __________ is an organized collection of data.
Ans. Database

2. A ________________ is a software package that can be


used for creating and managing databases.
Ans. Database Management system

3. A ____________ is a database management system that is


based on the relational model.
Ans. RDBMS

4.Three popular DBMS software are ________, ________, &


_______.
Ans. Oracle , MS Access , MySQL

5. A ____________ is a unique value that identifies a row in a


table.
Ans. Primary Key

6. Composite Key is a combination of ________ columns.


Ans. One or many

7. A table is a set of data elements that is organized using a


model of vertical ___________ and horizontal
____________.
Ans. Columns , rows
8. A _________ is a set of data values of a particular type,
one for each row of the table.
Ans. Column or field or attribute

9. A ___________ represents a single, data item in a table.


Ans. Row or record or tuple

10. _____________ are used to identify which type of data


we are going to store in the database.
Ans. Datatypes

11. There are ________ ways to create a table.


Ans. Different

12. Field properties can be set in both the ________ and


_________ .
Ans. Table and Form

13. The types of languages used for creating and


manipulating the data in the Database are ______________
& ______________.
Ans. DDL and DML

14. A _____________ is a standard for commands that define


the different structures in a database.
Ans. DDL ( Data Definition Language)

15. A ______________ is a language that enables users to


access and manipulate data in a database.
Ans. DML ( Data Manipulation Language)
16. A _____________ is a part of DML involving information
retrieval only.
Ans. SELECT statement

17. A popular data manipulation language is ____________


Ans. SQL language

18. ________ are the basic building block of a database


Ans. Tables

19. There are __________ types of Relationships in a table.


Ans. three

20. A _______ helps the user to systematically store


information in the database.
Ans. Form

21. A ________ enables users to view, enter, and change


data directly in database objects such as tables.
Ans. Form

22. _________ statement retrieves zero or more rows from


one or more database tables or database views.
Ans. Select statement

23. By default, data is arranged in _______ order using


ORDER BY clause.
Ans. Ascending order

24. __________ statement is used for modifying records in a


database.
Ans. Update statement

25. __________ statement is used to remove one or more


records in a Database.
Ans Delete statement

26. __________statements are used to add, delete or to


modify columns already existing in a database
Ans. Alter statement

You might also like