BCA - Data Manipulation and Analysis (DMA)

Find Question?

What is Tuple ?

Tuple is the collection of information about the attributes of table for single instance. In simple this also can be called as a 'row' in a Table.

What do you understand by memo data type ?

A Memo field can be useful for storing large amounts alphanumeric information. Some typical uses for this data type would be a note, comments, description, or address field, The Memo data type allows up to 65,536 alphanumeric characters with options to set several properties such as rich text
Continue reading →

Explain the relationship between entity, entity class, and entity instance

An entity is something that can be identified in the users' work environment, something that the users want to track. Entities of a given type are grouped into entity classes. An entity instance is the representation of a particular entity.

What is Query ?

A query (noun) is a question that must typically be expressed in a formal manner.
The query is the term used in computers to describe what a user types into a search engine or database.

Name Dbms ?

MS-Access , DB2 , Ingres, SQLBase

What is NULL value ?

its is just a blank value that is represented by the null word.

What are different types of keys ?

primary key :- The attribute or combination of attributes that uniquely identifies a row or record.

Foreign Key:- an attribute or combination of attribute in a table whose value match a

primary key in another table.

Composite key:- A primary key that consists
Continue reading →

Types of Relationships Explain All With example

There are three types of relationships:

One to One
One to Many [or Many to One]
Many to Many

Compare BCNF and 3NF or How BCNF is better than third Normal Form

Boyce Codd normal form (also known as BCNF) is a normal form –that is a form that provides criteria for determining a table’s degree of vulnerability to logical inconsistencies and anomalies. This normal form is used in database normalisation. It is a bit stronger than its
Continue reading →

Explain DCL

Data Control Language (DCL)

It is used to control access to data in the database.
It controls permission on the database objects using grant, revoke or deny statement.

1
2