(A) Creating, managing and deleting tables and manage the relationships among the stored date
(B) Generating queries, organizing, managing and retrieving data stored in a database
(C) Maintaining data integrity and coordinate data sharing
(D) All of the above
Tag: DBMS Mcqs
In SQL which command is used to modify the rows of tables?
(A) INSERT
(B) UPDATE
(C) APPEND
(D) BROWSE
CREATE TABLE and CREATE index belongs to which type of SQL commands?
(A) DDL
(B) DML
(C) DCL
(D) DQL
Which of the following is not an aggregate function?
(A) SUM
(B) AVG
(C) MAX
(D) UPPER
Which of the following is used to filter rows according to some condition?
(A) SELECT
(B) FROM
(C) UPDATE
(D) WHERE
in “One to One Relationship” One instance of first entity type is mapped with two instances of second entity type.
(A) True
(B) False
A second Normal Form (2 NF) relation should:
(A) Be in 1 NF
(B) Not have a composite key
(C) Not have attributes dependent on key attribute
(D) Not have attributes dependent on one another
In “One to Many” cardinality one instance of a relation is mapped with?
(A) Many instances of second entity type
(B) One instance of second entity type
(C) Primary key of 2 relations
(D) None of the above