1
The full form of DDL is
Correct Answer
Data Definition Language
☑ MCQ PRACTICE
Database Management Systems Unit 3
Practice objective questions for quick revision and examination preparation. Try answering each question before revealing the answer.
Database Management Systems - Unit-3
2
DROP is a ______________ statement in SQL.
Correct Answer
DDL
3
DML is provided for
Correct Answer
Manipulation & processing of database.
4
Which of the following is a legal expression in SQL?
Correct Answer
SELECT NAME FROM EMPLOYEE;
5
To delete a particular column in a relation the command used is:
Correct Answer
ALTER
6
Which of the following is not an integrity constraint?
Correct Answer
Positive
7
Foreign key is the one in which the ________ of one relation is referenced in another relation.
Correct Answer
Primary key
8
In which form of function there is no partial functional dependencies.
Correct Answer
2NF
9
which of the following is designed to cope with 4NF.
Correct Answer
multi value dependency
10
which of the following is designed to cope with 5NF.
Correct Answer
join dependency
11
Consider a schema R(A, B, C, D) and functional dependencies A -> B and C -> D. Then the decomposition of R into R1 (A, B) and R2(C, D) is
Correct Answer
dependency preserving but not lossless join
12
A table has fields F1, F2, F3, F4, and F5, with the following functional dependencies: A)F1->F3, B)F2->F4, C)(F1,F2)->F5 in terms of normalization, this table is in
Correct Answer
1NF
13
Assume that, in the suppliers relation above, each supplier and each street within a city has a unique name, and (sname, city) forms a candidate key. No other functional dependencies are implied other than those implied by primary and candidate keys. Which one of the following is TRUE about the above schema?
Correct Answer
The schema is in BCNF
14
normalization is used to design ________________
Correct Answer
relational database
15
SELECT ________ dept_name FROM instructor;
Correct Answer
Distinct
16
Updating the value of the view
Correct Answer
Will affect the relation from which it is defined
17
Inst_dept (ID, name, salary, dept name, building, budget) is decomposed into instructor (ID, name, dept name, salary) department (dept name, building, budget) This comes under
Correct Answer
Both Lossy and Lossy-join decomposition
18
Consider a relation R(A,B,C,D,E) with the following functional dependencies: ABC -> DE and D -> AB, The number of superkeys of R is:
Correct Answer
10
19
Suppose relation R(A,B,C,D,E) has the following functional dependencies: A -> B, B -> C, BC -> A, A -> D, E -> A, AND D -> E Which of the following is not a key?
Correct Answer
C
Fill in the Blanks
20
__________ can be used to create a table, index, or view.
Correct Answer
data definition
21
The __________ supported by SQL depend on the particular implementation.
Correct Answer
data types
22
Database system has several schemas according to the level of __________
Correct Answer
abstraction
23
__________ keyword is used to specify a condition.
Correct Answer
WHERE
24
The __________ statement is used to insert or add a row of data into the table.
Correct Answer
insert
25
The drop table command is used to delete a table and __________ in the table.
Correct Answer
all rows
26
Null means __________
Correct Answer
nothing
27
You can combine different query blocks into a single query expression with the __________ operator.
Correct Answer
union
28
A subquery is always a single query block __________ that can contain other subqueries but cannot contain a UNION.
Correct Answer
Select
29
A view can be dropped using a __________ statement.
Correct Answer
drop
30
__________ are useful for security of data.
Correct Answer
Views
31
__________ are used to query data from two or more tables, based on a relationship between certain columns in these tables.
Correct Answer
SQL joins
32
An __________ cannot be nested inside a Left Join or Right Join.
Correct Answer
inner join
33
__________ combines two tables based on their common columns.
Correct Answer
Natural join
34
Subqueries are similar to SELECT __________
Correct Answer
chaining
35
The __________ clause should follow the GROUP BY clause.
Correct Answer
having
36
A query inside a query is called as __________ query.
Correct Answer
nested
37
The fifth normal form deals with join-dependencies, which is a generalisation of the __________
Correct Answer
MVD(Multi Valued Dependency)
38
Normalization is the process of refining the design of relational tables to minimize data __________
Correct Answer
redundancy
39
__________ is based on the concept of normal forms.
Correct Answer
Normalization
40
The Third normal form resolves __________ dependencies.
Correct Answer
transitive
41
A __________ arises when a non-key column is functionally dependent on another non-key column that in turn is functionally dependent on the primary key.
Correct Answer
transitive dependency
42
__________ provide a method for maintaining integrity in the data.
Correct Answer
Foreign keys
43
A __________ dependency occurs when in a relational table containing at least three columns.
Correct Answer
Multivalued
44
The __________ form is usually applied only for large relational data models.
Correct Answer
Fifth Normal
45
Normal forms are table structures with __________
Correct Answer
minimum redundancy
46
Normalization eliminates data maintenance anomalies, minimizes redundancy, and eliminates __________
Correct Answer
data inconsistency