BPSC TRE – DBMS | Full Length Mock Test 1

Second Normal Form (2NF) requires that the table is in 1NF and no non-prime attribute is partially dependent on any candidate key of the table; every non-prime attribute must be fully functionally dependent on the primary key.

The INSERT INTO command in SQL is the standard Data Manipulation Language (DML) statement used to insert new records/tuples into a relation.

Standard recognized database models include Relational, Object-Oriented, Hierarchical, and Network. Sequential DBMS is not a recognized category of DBMS.

The total count of columns/attributes in a relation is termed its Degree (or Arity), whereas the total count of tuples/rows is its Cardinality.

ALTER TABLE is a DDL command used to add, delete, or modify columns, datatypes, and constraints in the schema of an existing table.