(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
Category: Database Mcqs
Database Mcqs for Screening tests, Interviews, Viva and Other competitive exams. Database Mcqs section will help users to prepare mcqs of Database for various exams. Aspirants of Lecturer Computer Science, SST Computer Science, Subject Specialist Computer Science, Data Entry operator, Computer Programmer, Computer Operator, System administrator, Database Administrator and all other Exams can prepare their Database portion from here.
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