(A) CREATE DATABASE company
(B) CREATE DB company
(C) ADD DATABASE company
(D) CREATE company DATABASE
Tag: DBMS Mcqs
Which of the following is one of the purposes of using DDL commands?
(A) Creating and destroying databases
(B) Manipulating databases
(C) Updating records into databases
(D) Inserting records into databases
Suppose there are 4 rows and 3 columns in TABLE1 and 6 rows and 5 coulmns in TABLE2; what is the size of the cartesian product incase of CROSS JOIN between these two tables?
(A) 15
(B) 18
(C) 20
(D) 24
Which of the following is one of the purposes of using DML commands?
(A) Creating databases
(B) Inserting data in tables
(C) Destroying databases
(D) None of the above
You can’t modify more than one table at a time through a view.
(A) True
(B) False
An entity can be logically connected to another by defining a?
(A) Hyperlink
(B) Common attribute
(C) Primary key
(D) Super key
An entity type is?
(A) Defined when the database is actually constructed
(B) A specific type such as an integer, text, date, logical etc
(C) A coherent set of similar objects that we want to store data on (e.g. STUDENT, COURSE, CAR)
(D) Defined by the database designer
Only one type of constraint can be enforced in any table by CREATE command.
(A) True
(B) False