Class X Information Technology Code(402)
UNIT-3: Relational Database Management System(Basic) (Important Questions)
Fill in the blanks:
1. A database is an organized collection of data.
2. A database management system is a software package that can be used for creating and managing databases.
3. A RDBMS is a database management system that is based on the relational model.
4.Three popular DBMS software are SQL Server, Sybase & MySQL.
5. A primary key is a unique value that identifies a row in a table.
6. Composite Key is a combination of ____two____ columns.
Short Answer Questions
1. What does DBMS stands for?
Ans : Database Management System
2. What does RDBMS stands for?
Ans: Relational Database Management System.
3. How is data organized in a RDBMS?
Ans: In RDBMS data organized into tables.
Fill in the blanks:
1. A table is a set of data elements that is organized using a model of vertical columns and horizontal rows.
2. A column is a set of data values of a particular type, one for each row of the table.
3. A tuple represents a single, data item in a table.
4. Datatype are used to identify which type of data we are going to store in the database.
5. There are two ways to create a table.
Q1. Which of the following will help to maintain the unique record in the table?
a. Foreign Key
b. Primary Key
c. Composite Key
d. Alternate Key
Q2. Which of the following field of table “Book” can act as the primary key?
a. Book_number
b. Subject
c. price
d. Author_name
Q3. When the primary key is made up of two or more columns then it is called __ primary key.
a. Mixed
b. Reference
c. Composite
d. Compost
Q4. Duplicate values can be entered in the primary key. (T/F)
a. True
b. False
Q5. A key which is referring to the primary key of another table is called _
a. Alternate Key
b. Primary Key
c. First Primary Key
d. Foreign Key
Q6. A field that is __ for each and every record is called the Primary key.
a. Common
b. Same
c. Unique
d. None of the above
Q7. When data is stored, maintained, and retrieved from multiple tables then special database software are required called __
a. DBMS
b. RDBMS
c. Special DBMS
d. All of the above
Q8. Identify the Foreign Key from table “Sales”
Table Client:
ClientID (primary Key)
client name
client phone
Table: Sales
sales (Primary Key)
ClientID
Profit
a. SalesID
b. Profit
c. Client phone
d. ClientID
Q9. Which of the following is not a valid field of table “Student”
a. admno
b.name
c. fees
d. salary
Q10. There can be multiple primary keys in a table. (T/F)
a. True
b. False
Short Answer Questions
1. Why are data types used in DBMS /RDBMS?
Ans : Datatypes are used to identify which type of data (value) we are going to store in the database. Fields themselves can be of different types depending on the data they contain.
Data types in OpenOffice base are broadly classified into five categories listed below.
• Numeric Types
• Alphanumeric Types
• Binary Types
• Date time
• Other Variable type
2. List datatypes available in Numeric Datatype?
Ans : Numeric data types are used for describing numeric values for the field used in the table of a database. Numeric data types in a database can be used for storing information such as mobile number, roll number, door number, year of school admission, true or false statements, statistical values, etc. The different types of numeric data types available are listed here.
1. BOOLEAN
2. TINYINT
3. SMALLINT
4. INTEGER
5. BIGINT
6. NUMERIC
7. DECIMAL
8. REAL
9. FLOAT
10. DOUBLE
Q. How many types of relationships can created in tables?
Ans : There are three types of relationships which can be created in tables:
1. ONE to ONE
2. ONE to MANY OR MANY to ONE
3. MANY to MANY
Fill in the blanks :
1. The types of languages used for creating and manipulating the data in the Database are DDL & DML
2. A Queries is a standard for commands that define the different structures in a database.
3. A DML is a language that enables users to access and manipulate data in a database.
4. A SELECT is a part of DML involving information retrieval only. 5. A popular data manipulation language is SQL.
Q. Difference between DDL and DML.
Ans : DDL stands for Data Definition Language. DML stands for Data Manipulation Language. DDL statements are used to create database, schema, constraints, users, tables etc. DML statement is used to insert, update or delete the records.
Q. Difference between RDBMS and DBMS.
Ans: DBMS stores data as a file whereas in RDBMS, data is stored in the form of tables. DBMS supports single users, while RDBMS supports multiple users. DBMS does not support client-server architecture but RDBMS supports client-server architecture.
Important Notes
The DDL commands in SQL are used to create database schema and to define the type and structure of the data that will be stored in a database.
No comments:
Post a Comment