WorksheetsRDBMS
Total questions: 15
Worksheet time: 8mins
A collection of facts is
Data
Information
Database
None of the above
Example of Processed data is
Red
The color of my car is red
Car
Color
What is not true about DBMS?
It is collection of data/information.
Data is collected in an organised way
Data can be easily accessed, managed and updated
Data once entered cannot be changed.
A group of software that organises data by using packages to define, manipulate, retrieve and mangage data is called
Database Management System
Spreadsheet Software
Multimedia Software
Desktop Publishing Software
Choose all the DBMS software
Oracle
Mysql
Excel
Word
Foxpro
________________ and ______________ are the two types of Database
Flat file and Relational file
Flat file and Word file
Relational file and Word file
Word file and Excel file
Choose all the statement true about flat file
Can store data in a single Table
Tables are inter-related
Suitable to store small amount of data
Can have duplicate values
Can accidently delete an important data
Choose all the statement true about Relational Database Management System
Can store data in multiple tables that are inter-related
Developed using 13 golden rules of E F Codd
Avoids Duplicate Data
Cannot run complex queries
Better security and easy upgradation of the existing software is available.
Dedicated computers that holds the data and the database software is called
Server
Client
Front end
None of the above
A unique value that individually identifies each row in a RDBMS table is called
Foreign Key
Primary key
Candidate key
Composite key
Primary key constraint applied on more than one column is called
Primary key
Candidate key
Foreign Key
Composite key
Constraints on primary key are
Cannot be left null and cannot have duplicate value
Can be left null and cannot have duplicate value
Cannot be left null and can have duplicate value
Can be left null and can have duplicate value.
A key that refers to the primary key of another table and used for table inter relationship is called
Foreign key
Primary key
Candidate key
Composite key
Keys in an RDBMS table that can be used as primary key also but are not primary key are called
Foreign key
Primary key
Candidate key
Composite key
Correct Syntax of 'SELECT' DML commands is
SELECT * FROM <TABLE_NAME>
SELECT FIELD1,FIELD2... FROM <TABLE_NAME> WHERE <CONDITION>
SELECT FIELD1,FIELD2... FROM <TABLE_NAME>
SELECT FIELD1,FIELD2... FROM <TABLE_NAME> WHERE <CONDITION> ORDER BY <FIELD_NAME> ASC/DESC
