(A) R has no duplicates and S is non-empty
(B) R and S has no duplicates
(C) S has no duplicates and R is non-empty
(D) R and S has same numbers of tuples
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.
The concept of locking can be used to solve the problem?
(A) lost update
(B) uncommitted dependency
(C) inconsistant data
(D) All the three
Which normal form is considerd adequate for rational database design?
(A) 2NF
(B) 3NF
(C) 4NF
(D) BCNF
The __ function helps reduce the need to use mutiple OR conditions.
(A) IN
(B) Like
(C) AND
(D) Between
Which of the following is the correct syntax for adding a new column into an existing table?
(A) ALTER TABLE table_name { ALTER [COLUMN] column type [(size)] [DEFAULT default] }
(B) ALTER TABLE table_name { ADD [COLUMN] column type [(size)] [DEFAULT default] }
(C) Both of the above
(D) None of the above
GRANT belongs to which type of SQL commands classification?
(A) DML
(B) DDL
(C) DCL
(D) DQL
UPDATE command belongs to which type of Classification?
(A) DML
(B) DDL
(C) DCL
(D) DQL
Which of the following is not a part of an INSERT statement?
(A) INTO
(B) VALUE
(C) INSERT
(D) Modify