RPVV INA Skill Competition 10th

________is a software package with computer programs that controls the creation, maintenance, and use of a database

• RDBMS

• DBMS

• Primery Key

• Sticky Key

__________ is a unique value that identifies a row in a table

• RDBMS

• DBMS

• Primery Key

• Sticky Key

In this relationship, no table has the primary key column.

• RDBMS

• One to Many

• Primery Key

• Many to Many

_________means to arrange the data in either ascending order of descending order.

• RDBMS

• Sorting

• Primery Key

• Referential integrity

_________ is used to maintain accuracy and consistency of data in a relationship.

• RDBMS

• Sorting

• Primery Key

• Referential integrity

__________ Datatypes are: Char(fix), Varchar, Varchar_ignorecase and Longvarchar(Memo)

• Numeric

• String

• Boolean

• Alphanumeric

__________datatypes are: TinyInt, SmallInt, Integer, BigInt, Decimal, Real, Float, Double and Boolean.

• Numeric

• String

• Boolean

• Alphanumeric

The “one” side of a relation is always the ________, and provides the PK attributes to be copied.

• parent

• child

• fk

• pk

Rudrakshh wants that the name column of a table must not be left blank. Help him to

identify the field property for this purpose.

• Entry Required

• Default Value

• Size

• Length

Identify the property which help to set the number of characters in text/ varchar type field of a table in DBMS.

• Entry Required

• Default Value

• Size

• Length