WorksheetsDatabase concepts
Total questions: 15
Worksheet time: 8mins
In which of the following formates data is stored in the database management system?
Image
Text
Table
Graph
Which is the following is not a type of database?
Hirerchical
Network
Distributed
Decentralized
Which of the following is not a function of the database?
Managing stored data
Manipulating data
Security for stored data
Analyzing data
Which of the following is known as a set of entities of the same type that share same properties or attributes?
Relation set
Tuples
Entity set
Entity Relation model
What does an RDBMS consist of?
Collection of records
Collection of Keys
Collection of Tables
Collection of Fields
The ability to query data as well as insert, delete, and alter tuples is offered by ________
DML(Data Manipulation Language)
TCL(Transaction Control Language)
DDL(Data Definition Language)
DCL(Data Control Language)
Which command is used to remove a relation from an SQL?
Delete
Drop table
Purge
Remove
What is the function of the following command?
Delete from r where P;
Clears entries from relation
Deletes relation
Deletes particular tuple from relation
All of the mentioned
_______ resembles Create view.
Create table...as
Create view as
Create table .... like
With data
Which one of the following given stament possibly contains the error?
select * from emp where empid=1003;
select empid from emp where empid=10006;
select empid from emp;
select empid where empid=1009 and Lastname='GELLER';
What do you mean by one to many relationships?
One class may have many teaches
One teacher can have many classes
Many classes may have many teachers
Many teachers may have many classes
A Database Management system isa type of ______ software.
Itis a type of system software
It is a kind of application software
It is a kind of general software
Both A and C
Rows os relation are known as the ______
Degree
Tuples
Entity
All of the above
Which one of th following is a type of Data Manipulation command?
Create
Alter
Delete
All of the above
In the relational table, which of the following can also be represented by the term 'attribute'?
Entity
Row
Column
Both A and C
