Database concepts

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';