DATA BASE MANAGEMENT SYSTEM
Multiple Choice Questions/ Answer.
1. The clause ALTER TABLE in SQL can be used to
(a) Add an attribute (b) delete an attribute
(c)alter the default values of an attribute (d)all of the above
Ans- d
2. Which of the following is not an example of DBMS?
(a) MySQL (b) Microsoft Access c) IBM DB2 (d) Google
Ans- d
3. Which of the following is a function of the DBMS?
a) Storing data (b) Providing multi-users access control
c) Data Integrity (d) All of the above
Ans- d
4. Which one of the following attribute can be taken as a primary key?
(a) Name (b) Street (c) Id (d) Department
Ans- c
5. In Relational Model, the number of attributes in table is termed as
(a) Cardinality (b) Degree (c) Domain (d) None of these
Ans-b
6. Which of the following is a component of the DBMS?
(a) Data (b) Data Languages (c) Data Manager (d) All of the above
Ans- d
7. Count function in SQL returns the number of
(a) Values (b) columns (c) groups (d) rows
Ans- d
8. Which of the following are components of the DBMS?
(a) Data (b) Data language (c) data manager (d) All of these
Ans - d
9. Identify the operator that performs pattern searching in MYSQL.
(a) EXISTS (b) BETWEEN (c) LIKE (d) SEARCH
Ans - c
10.Cardinality of a table is four and degree is three. If two columns and four
rows are added to a table what will be the new degree and cardinality of
the given table.
(a) 5, 8 (b)3,4 (c) 8,5 (d) 4,3
Ans- a
11.Which command is used to see the structure of a table?
(a) LIKE (b) Show (c) Describe (d) Modify
Ans- c
12._____________ command is used to delete the structure of the table
(a) Drop table (b) Modify Database (c) Delete Table (d) Alter Table
Ans- a
13.Which statement is used to delete an existing row from the table?
(a) DELETE (b) WHERE (c) MODIFY (d) None of the mentioned
Ans-a
14._______________ command is used to eliminate duplicate values of an
attribute in the select query
(a) Update (b) Unique (c) Distinct (d) No Duplicate
Ans- c
15.The clause ALTER TABLE in SQL can be used to
(a) Add an attribute (b) delete an attribute
(c) Alter the default values of an attribute (d) all of the above
16.Which one of the following attribute can be taken as a primary key?
(a) Name (b) Street (c) Id (d) Department
Ans-c
17.What are the different types of DBMS users_______.
(a) End users (b) database administrator
(c) Application programmers (d) All of the above
Ans- d
18.Which operator tests column for absence of data
(a) Not (b) exists (c) is null (d) none of the above
Ans- c
19.The command used to delete a particular column in a relation is ______
(a) UPDATE TABLE (b) TRUNCATE COLUMN
(c) ALTER, DROP (d) DELETE COLUMN
Ans-c
20.A huge collection of the information or data accumulated from several
different sources is known as ________:
(a) Data management (b) Data mining
(c)Data warehouse (d) both b and c
Ans-c
21.Rows of a relation are known as the _______.
(a) Degree (b) Tuples (c) Domain (d) Relation
Ans- b
22.Which of the following command is a type of Data Definition language
command?
(a) Create (b) Update (c) Delete (d) Merge
Ans- a
23.Which one of the following commands is used to modify a column inside a
table?
(a) Drop (b) Update (c) Alter (d) Set
Ans- c
24.Which of the following is a comparison operator in SQL?
(a) Double equal sign ( == ) (b) LIKE
(c) BETWEEN (d) Single equal sign ( = )
Ans-a
25. Which of the following is not a function of the database?
(a) Managing stored data (b) Manipulating data
(c) Security for stored data (d) Analyzing code
Ans-d
