(A) CREATE DATABASE company
(B) CREATE DB company
(C) ADD DATABASE company
(D) CREATE company DATABASE
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.
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