🧪 Data Base Management System (DBMS) MCQ Quiz Hub

1. When primary key is made up of two or more columns then it is called __ primary key.
Mixed
Reference
Composite
Compost

2. A key which is referring to the primary key of another table is called __
Common
Same
Unique
None of the above

3. When data is stored, maintained and retrieved from multiple tables then special database software are required called _
DBMS
RDBMS
Special DBMS
All the above

4. Identify the Foreign Key from table “Sales” Table Client: ClientID (primary Key) clientname clientphone Table : Sales SalesID (Primary Key) ClientID Profit
SalesID
Profit
Clientphone
ClientID

5. Which of the following is not valid field of table “Student” a. admno b.name c. fees d. salary
admno
name
fees
salary

6. In RDBMS, data is organized in the form of __________________
Table
Record
Field
None of the above

7. SQL stands for _________________
Structured Queue Language
Structured Query Language
Structured Query Lang
None of the above

8. All the values in ________ are of same type.
Records
Table
Database
Fields

9. _ represent a single data item in a table.
Tuples
Attributes
Relation
All the above

10. ________ are the basic building blocks of a database.
Tables
Record
Fields
All the above

11. We can create table :
in design view
use Wizard
Both of the above
None of the above

12. By default data type of fields is.
Text[Varchar]
Text[Char]
Int
Long

13. By default the length of Varchar data type is __
20
30
40
50

14. By default the name of the table is ______
Tab 1
Table 1
First Table
Untitled 1

15. ___ are used to identify which type of data we are going to store in the database.
Datatype
Record
Table
Attributes

16. Which data type will be appropriate to store information as Salary, Fees, Price etc b. Alphanumeric Data types
Alphanumeric Data types
Numeric Data type
Binary Data types
Date Time

17. Which of the following is not a numeric data type?
Tinyint
Smallint
Boolean
Date

18. Which of the following data types can not store decimal values?
Decimal
Real
Numeric
Boolean

19. Which of the following will occupy more space in computer memory?
Bigint
Integer
Smallint
Boolean

20. __ data types are used for storing photos, music files etc
Binary
Alphanumeric
Numeric
Special

21. Char is a ______ length data type and varchar is a ______ length data type.
Fixed, Variable
Variable, Fixed
Variable, Variable
Fixed, Fixed

22. Which field is suitable for storing records of employees?
EmpNo
Empname
Salary
All the above

23. Auto Value is a property of __ data type .
Numeric
Character
Binary
Date

24. Which of the following property help to set the number of characters in Varchar type.
Auto value
Required
Default Value
Length

25. Which property ensures that field can not be left blank?
Entry required
Format
Required Entry
Required

26. By default the length of the Integer data type is ______________
10
15
20
25

27. Which of the following property to be turned “yes” so that value will be auto incremented?
Default
Format
Auto value
Length

28. Which of the following is not the binary data types?
Longvarbinary
Varbinary
Binary
Charbinary

29. Which of the following is not the date time data types?
Date
Time
Datestamp
Timestamp

30. Which data type is used to store value of fields like “Date of Birth”?
Date Time
Varchar
Integer
Other

31. We can ____________________ data in table.
modify
insert
delete
All the above

32. In which view data can be entered in table?
Datasheet view
Design view
Both of the above
None of the above

33. In which mode we can change the structure of table?
Datasheet view
Design view
Structure view
All the above

34. Sorting means to arrange data in _______________ order.
increasing
decreasing
increasing or decreasing
All the above

35. In Base data can be linked between two or more tables with the help of _________________
primary key
foreign key
primary and foreign key
None of the above

36. Relationship can be created between
two tables only
one table only
two or more tables
None of the above

37. Relationship between tables can be created from _____________________ menu.
View
Insert
Windows
Tools

38. There are __________________ types of relationship which can be created between tables.
three
two
four
infinite

39. Which language help to extract/fetch data from table?
MySQL
Python
OOBase
HTML

40. We can create query (in Open Office Base) in _______________________
In design view
Using wizard
Both of the above
None of the above

41. SQL stands for __________________
Structural Query Language
Structured Query Language
Skeletal Query Language
None of the above

42. _________ statement is used to retrieve data from table.
Delete
Update
Print
Select

43. _________ is the most common DML command.
Delete
Update
Select
All the above

44. DML stands for ____________
Data Manipulation Language
Database Manipulation Language
Data Modify Language
All the above

45. Which of the following clause return specific rows?
Order By
Where
Having
Specific

46. Which of the following clause return records in ascending order?
Order By
Where
Order Asc
Order Inc

47. Command to display all the data in the table “emp” is. a.
Select * from emp
Select * from emp;
Select all from emp
Select all from emp;

48. Command to display all the data in the table “emp” is.
Select * from emp
Select * from emp;
Select all from emp
Select all from emp;

49. Shortcut to execute query in Create Query in SQL View is __
F7 Key
F5 Key
F8 Key
F6 Key

50. Which command is used to display the salary of all the employees after incrementing by 1000.
Select
b. Update
Modify
Change

51. Select “salary” from emp;
will display all the records of table emp
will display only particular columns of table emp
will display only salary column of table emp;
None of the above

52. Select “empname”, “salary” * 3 from emp;
will increase the salary three times of all employees in table
display name and three times salary
give error
None of the above

53. To get details about the list of students whose favorite color is blue. Query for this is :
select all from Stud where fav_Color=’Blue’;
select name from Stud where fav_Color=’Blue’;
To get details about the list of students whose favorite color is blue. Query for this is :
select all from Stud where fav_Color is ’Blue’;

54. select * from Stud order by “Rollno” ASC;
display all the records of table.
display records in increasing order of roll number.
both of the above
None of the above

55. Command to increase the salary of all employees by 15000.(table name emp and column name sal)
update emp set sal = sal + 15000;
update emp set sal = 15000;
update set sal = sal + 15000;
None of the above

56. By default data is arranged in _____ order using order by clause.
Ascending
Descending
Primary Key
None of the above

57. Which of the following is DML commands?
Insert
Update
Delete
All the above

58. A ________ provides a systematic way of storing information into the database.
Report
Query
Formic
None of the above

59. Which of the following act as an interface to view, enter and change data in database?
Report
Table
Query
Form

60. A _______ helps to collect specific information from the pool of data.
Query
Report
Form
None of the above

61. Which of the following is to be created first?
Report
Query
Form
Table

62. Which of the following field is invalid for storing information of “Library” Table? b. c. d.
Cost
Booknumber
Authorname
Dateofbirth

63. Which of the following is suitable to act as a primary key in table student?
Rollno
Name
Class
Section

64. A foreign key is a reference of the ________ key in another table.
Alternate
Primary
Candidate
None of the above

65. In a table we can have only ______ primary key.
1
2
3
more than 3