🧪 Oracle DB MCQ Quiz Hub

1. A table is in BCNF if it is in 3NF and if every determinant is a ______ key.
Dependent
Normal
Candidate
Both Normal and Candidate

2. The ____ normalization introduced by Chris Date, Hugh Darwen, and Nikos Lorentzos.
Third
Fourth
Fifth
Sixth

3. A table is in 3NF if it is in 2NF and if it has no ______
Functional Dependencies
Transitive Dependencies
Trivial Functional Dependency
Multivalued Dependencies

4. Every constraint on the table is a logical consequence of the table’s
Fourth normal form
Fifth normal form
Domain/key normal form
None of the mentioned

5. A ___________ is an indirect functional dependency, one in which X->Z only by virtue of X->Y and Y->Z.
Multivalued Dependencies
Join Dependency
Trivial Functional Dependency
Transitive Dependencies

6. In a given relationship R, if an attribute A uniquely defines all other attributes, then the attribute A is a key attribute which is also known as the _________ key.
Candidate
Join
Functional
None of the mentioned

7. Anomalies are avoided by splitting the offending relation into multiple relations, is also known as
Accupressure
Decomposition
Precomposition
Both Decomposition and Precomposition

8. Every time attribute A appears, it is matched with the same value of attribute B, but not the same value of attribute C. Therefore, it is true that:
A -> B
A -> C
A -> (B,C)
(B,C) -> A

9. When the values in one or more attributes being used as a foreign key must exist in another set of one or more attributes in another table, we have created a(n):
Transitive Dependency
Insertion Anomaly
Referential Integrity Constraint
Normal Form

10. Which of the following is not a restriction for a table to be a relation?
The cells of the table must contain a single value
All of the entries in any column must be of the same kind
The columns must be ordered
No two rows in a table may be identical

11. How can a SQL developer add a key on a table?
While creating a table
With Alter table command
With SQL server Properties window
All of the Mentioned

12. A ____ key is a minimal super key
Primary
Foreign
Candidate
Non-Prime

13. What is true about Unique and primary key?
Unique can have multiple NULL values but Primary can’t have.
Unique can have single NULL value but Primary can’t have even single.
Both can have duplicate values
none of the mentioned

14. By default, which key creates Clustered index?
Foreign Key
Unique Key
Primary Key
None of the mentioned

15. A Key which is a set of one or more columns that can identify a record uniquely is called?
Natural key
Candidate key
Not Null key
Alternate key

16. Which key accepts multiple NULL values?
Foreign Key
Unique Key
Primary Key
None of the mentioned

17. A Foreign key is combined with a foreign key creates
Parent child relationship between the tables that connect them
Many-Many relationship between the tables that connect them
Network model between the tables that connect them
None of the Mentioned

18. Which of the following statements is not correct?
The primary key must be unique for a given table
Specifying a zero (0) for the lower bound for the association multiplicity on a class diagram indicates that the item is required
Specifying a one (1) for the lower bound for the association multiplicity on a class diagram indicates that the item is required
Most databases allow multiple records that are identical

19. In a database, a foreign key is ?
A data element/attribute within a data field of a data record that is not unique, and cannot be used to distinguish one data record in a database from another data record within a database table
A data element/attribute within a data field of a data record within a database table that is a secondary key in another database table
A data element/attribute within a data field of a data record within a database table that is a primary key in another database table
A data element/attribute within a data field of a data record that enables a database to uniquely distinguish one data record in a database from another data record within a database table

20. In an E-R diagram an entity set is represent by a
Rectangle
Ellipse
Diamond box
Circle

21. A relational database developer refers to a record as
A criteria
A relation
A tuple
An attribute

22. The relational model feature is that there
is no need for primary key data
is much more data independence than some other database models
are explicit relationships among records
are tables with many dimensions

23. E-R model uses this symbol to represent weak entity set ?
Dotted rectangle
Diamond
Doubly outlined rectangle
None of the mentioned

24. A ____ normal form normalization will be needed where all attributes in a relation tuple are not functionally dependent only on the key attribute.
First
Second
Third
Third

25. Identify the criteria for designing database from the point of view of user
No redundancy
No inapplicable attributes
Uniformity in naming & definitions of the data items
All of the Mentioned

26. The relational model is based on the concept that data is organized and stored in two-dimensional tables called _______
Fields
Records
Relations
Keys

27. An aggregation association is drawn using which symbol:
a line which loops back onto the same table
small closed diamond at the end of a line connecting two tables
small open diamond at the end of a line connecting two tables
small triangle at the end of a line connecting the aggregated item and multiple component items

28. An n-array relationship is drawn using which symbol:
A diamond
A line with arrows showing direction
A line without arrows showing direction
A rectangle

29. What is the full form of SQL?
Structured Query Language
Structured Query List
Simple Query Language
None of the Mentioned

30. In SQL, which command(s) is(are) used to change a table’s storage characteristics?
ALTER TABLE
MODIFY TABLE
CHANGE TABLE
All of the Mentioned

31. In SQL, which of the following is not a data definition language commands?
RENAME
REVOKE
GRANT
Update

32. _____clause is an additional filter that is applied to the result.
Select
Group-by
Having
Order by

33. ______ defines rules regarding the values allowed in columns and is the standard mechanism for enforcing database integrity.
Column
Constraint
Index
Trigger

34. SQL has how many main commands for DDL:
1
2
3
4

35. Which command defines its columns, integrity constraint in create table:
Create command
Drop table command
Alter table command
All of the mentioned

36. Which command is used for removing a table and all its data from the database:
Create command
Drop table command
Alter table command
All of the Mentioned

37. Which command allows the removal of all rows from a table but flushes a table more efficiently since no rollback information is retained:
TRUNCATE command
Create command
Drop table command
Alter table command

38. The language used application programs to request data from the DBMS is referred to as _____
DML
DDL
Query language
All of the mentioned

39. In SQL, which of the following is not a data Manipulation Language Commands?
Delete
Truncate
Update
Create

40. TRUNCATE statement in SQL is a –
DML statement
DDL statement
DCL statement
TCL statement

41. In SQL, which command is used to add new rows to a table?
Alter Table
Add row
Insert
Append

42. Stack is also called _____
First In First Out (LIFO)
Last In First Out (FIFO)
First In Last Out (FILO)
First Come First Served (FCFS)

43. A table that displays data redundancies yields ________anomalies.
Update
Insertion
Deletion
All of the mentioned

44. A type of query that is placed within a WHERE or HAVING clause of another query is called
Master query
Sub query
Super query
Multi-query

45. The three language components of a database management system (DBMS) like DDL, DCL, DML. Two different types of people (users and practitioners) are concerned with them. Which of them do users of a DBMS usually deal with?
DDL
DML
DDL and DCL
DCL and DML

46. DCL stands for :
Data Control Language
Data Console Language
Data Console Level
Data Control Level

47. TCL stands for:
Transaction control languages
Transaction command languages
Transaction connect languages
Transaction connect languages

48. ______commands in SQL allow controlling access to data within database.
Database
Data
Data control
All of the mentioned

49. In an SQL statement, which of the following parts states the conditions for row selection?
Where
From
Order By
Group By

50. A transaction completes its execution is said to be
Committed
Aborted
Rolled back
Failed