Tutorials
PPTs
Lecture Notes
Objective Questions
Lab ProgramsObjective Type Questions & Answers
Database Management System Objective Type Question Bank-Unit-3
1. The full form of DDL is
A . Dynamic Data Language
B . Detailed Data Language
C . Data Definition Language
D . Data Derivation Language
2. DROP is a ______________ statement in SQL.
A . Query
B . Embedded SQL
C . DDL
D . DCL
3. DML is provided for
A . Description of logical structure of database.
B . Addition of new structures in the database system.
C . Manipulation & processing of database.
D . Definition of physical structure of database system.
4. Which of the following is a legal expression in SQL?
A . SELECT NULL FROM EMPLOYEE;
B . SELECT NAME FROM EMPLOYEE;
C . SELECT NAME FROM EMPLOYEE WHERE SALARY = NULL;
D . None of the above
5. To delete a particular column in a relation the command used is:
A . UPDATE
B . DROP
C . ALTER
D . DELETE
6. Which of the following is not an integrity constraint?
A . NOT NULL
B . Positive
C . Unique
D . Check ‘predicate’
7. Foreign key is the one in which the ________ of one relation is referenced in another relation.
A . Foreign key
B . Primary key
C . References
D . Check constraint
8. In which form of function there is no partial functional dependencies.
A . BCNF
B . 2NF
C . 3NF
D . 4NF
9. which of the following is designed to cope with 4NF.
A . multi value dependency
B . join dependency
C . Transitive dependency
D . all of the above
10. which of the following is designed to cope with 5NF.
A . multi value dependency
B . join dependency
C . Transitive dependency
D . none of these
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
A . dependency preserving and lossless join
B . lossless join but not dependency preserving
C . dependency preserving but not lossless join
D . not dependency preserving and 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
A . 1NF
B . 2NF
C . 3NF
D . None of these
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?
A . The schema is in BCNF
B . The schema is in 3NF but not in BCNF
C . The schema is in 2NF but not in 3NF
D . The schema is not in 2NF
14. normalization is used to design ________________
A . join dependencies
B . relational database
C . multi-valued dependencies
D . cyclic dependencies
15. SELECT ________ dept_name FROM instructor;
A . All
B . From
C . Distinct
D . Name
16. Updating the value of the view
A . Will affect the relation from which it is defined
B . Will not change the view definition
C . Will not affect the relation from which it is defined
D . Cannot determine
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
A . a) Lossy-join decomposition
B . b) Lossy decomposition
C . c) Lossless-join decomposition
D . d) 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:
A . 2
B . 7
C . 10
D . 12
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?
A . A
B . E
C . C
D . D
Fill in the Blanks
20. ......................... can be used to create a table, index, or view.
21. The .......................... supported by SQL depend on the particular implementation.
22. Database system has several schemas according to the level of ..........................
23. ............................... keyword is used to specify a condition.
24. The ............................. statement is used to insert or add a row of data into the table.
25. The drop table command is used to delete a table and ......................... in the table.
26. Null means .............................
27. You can combine different query blocks into a single query expression with the .............................. operator.
28. A subquery is always a single query block .............................. that can contain other subqueries but cannot contain a UNION.
29. A view can be dropped using a .............................. statement.
30. .............................. are useful for security of data.
31. .............................. are used to query data from two or more tables, based on a relationship between certain columns in these tables.
32. An .............................. cannot be nested inside a Left Join or Right Join.
33. .............................. combines two tables based on their common columns.
34. Subqueries are similar to SELECT ..............................
35. The .............................. clause should follow the GROUP BY clause.
36. A query inside a query is called as .............................. query.
37. The fifth normal form deals with join-dependencies, which is a generalisation of the ...........................
38. Normalization is the process of refining the design of relational tables to minimize data ...........................
39. ........................................... is based on the concept of normal forms.
40. The Third normal form resolves ........................................... dependencies.
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.
42. ........................................... provide a method for maintaining integrity in the data.
43. A ........................................... dependency occurs when in a relational table containing at least three columns.
44. The ........................................... form is usually applied only for large relational data models.
45. Normal forms are table structures with ...........................................
46. Normalization eliminates data maintenance anomalies, minimizes redundancy, and eliminates ...........................................
Relevant Materials :
☞ Database Management System Objective Type Question Bank-Unit-1 - [ DBMS ]
☞ Database Management System Objective Type Question Bank-Unit-2 - [ DBMS ]
☞ Database Management System Objective Type Question Bank-Unit-3 - [ DBMS ]
☞ Database Management System Objective Type Question Bank-Unit-4 - [ DBMS ]
☞ Database Management System Objective Type Question Bank-Unit-5 - [ DBMS ]
Similar Materials :
☞ R - Programming MCQs - Unit-1 - [ R-Programming ]
☞ R - Programming MCQs - Unit-2 - [ R-Programming ]
☞ R - Programming MCQs - Unit-3 - [ R-Programming ]
☞ R - Programming MCQs - Unit-4 - [ R-Programming ]
☞ R - Programming MCQs - Unit-5 - [ R-Programming ]
☞ Formal Languages and Automata Theory (FLAT) MCQs - Unit-1 - [ FLAT ]
☞ Formal Languages and Automata Theory (FLAT) MCQs - Unit-2 - [ FLAT ]
☞ Formal Languages and Automata Theory (FLAT) MCQs - Unit-3 - [ FLAT ]
☞ Formal Languages and Automata Theory (FLAT) MCQs - Unit-4 - [ FLAT ]
☞ Formal Languages and Automata Theory (FLAT) MCQs - Unit-5 - [ FLAT ]
☞ PPS MCQs - Unit-1 - [ PPS ]
☞ PPS MCQs - Unit-2 - [ PPS ]
☞ PPS MCQs - Unit-3 - [ PPS ]
☞ PPS MCQs - Unit-4 - [ PPS ]
☞ PPS MCQs - Unit-5 - [ PPS ]
☞ Object Oriented Programming through Java MCQs - Unit-1 - [ OOP_JAVA ]
☞ Object Oriented Programming through Java MCQs - Unit-2 - [ OOP_JAVA ]
☞ Object Oriented Programming through Java MCQs - Unit-3 - [ OOP_JAVA ]
☞ Object Oriented Programming through Java MCQs - Unit-4 - [ OOP_JAVA ]
☞ Object Oriented Programming through Java MCQs - Unit-5 - [ OOP_JAVA ]
☞ Design and Analysis of Algorithms MCQs - Unit-1 - [ DAA ]
☞ Design and Analysis of Algorithms MCQs - Unit-2 - [ DAA ]
☞ Design and Analysis of Algorithms MCQs - Unit-3 - [ DAA ]
☞ Design and Analysis of Algorithms MCQs - Unit-4 - [ DAA ]
☞ Design and Analysis of Algorithms MCQs - Unit-5 - [ DAA ]
☞ Software Engineering MCQs - Unit-1 - [ SE ]
☞ Software Engineering MCQs - Unit-2 - [ SE ]
☞ Software Engineering MCQs - Unit-3 - [ SE ]
☞ Software Engineering MCQs - Unit-4 - [ SE ]
☞ Software Engineering MCQs - Unit-5 - [ SE ]
☞ Data Mining MCQs - Unit-1 - [ DM ]
☞ Data Mining MCQs - Unit-2 - [ DM ]
☞ Data Mining MCQs - Unit-3 - [ DM ]
☞ Data Mining MCQs - Unit-4 - [ DM ]
☞ Data Mining MCQs - Unit-5 - [ DM ]
☞ Computer Organization and Architecture (COA) Objective Question Bank-Unit-1 - [ COA ]
☞ Computer Organization and Architecture (COA) Objective Question Bank-Unit-2 - [ COA ]
☞ Computer Organization and Architecture (COA) Objective Question Bank-Unit-3 - [ COA ]
☞ Computer Organization and Architecture (COA) Objective Question Bank-Unit-4 - [ COA ]
☞ Computer Organization and Architecture (COA) Objective Question Bank-Unit-5 - [ COA ]
☞ Data Structures Objective Type Question Bank-Unit-1 - [ DS ]
☞ Data Structures Objective Type Question Bank-Unit-2 - [ DS ]
☞ Data Structures Objective Type Question Bank-Unit-3 - [ DS ]
☞ Data Structures Objective Type Question Bank-Unit-4 - [ DS ]
☞ Data Structures Objective Type Question Bank-Unit-5 - [ DS ]
☞ Cyber Forensics Objective Type Question Bank-Part-2 - [ Cyber Forensics ]
☞ Cyber Forensics Objective Type Question Bank-Part-1 - [ Cyber Forensics ]
☞ Java Programming Objective Type Question Bank - [ Java Programming ]
☞ Java Programming Objective Type Questions-Part-1 - [ Java Programming ]
☞ Java Programming Objective Type Questions-Part-2 - [ Java Programming ]