Planning Oracle Applications(Engineering > Computer Science And Engineering > Oracle Database ) Questions and Answers
Question 1. The "curse of dimensionality relates to which problem of using operational data for BI reporting?
Dirty data
Inconsistent data
Too much data
Non-integrated data
Explanation:-
Answer: Option C. -> Too much data
The curse of dimensionality refers to various phenomena that arise when analyzing and organizing data in high-dimensional spaces.
Question 2. E-R model uses this symbol to represent weak entity set ?
Dotted rectangle
Diamond
Doubly outlined rectangle
None of the Mentioned
Explanation:-
Answer: Option C. -> Doubly outlined rectangle
A weak entity set is indicated by a doubly-outlined box.
Question 3. 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
Explanation:-
Answer: Option D. -> All of the Mentioned
To designing database from the point of user view we need all the mentioned required.
Question 4. 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
Explanation:-
Answer: Option B. -> Unique can have single NULL value but Primary can't have even single.
primary key doesn't allow Null values and Unique key allows Null value, but only one Null value.
Question 5. Business Intelligence (BI) reporting systems cannot do which of the following operations?
Filter data
Group data
Modify data
Both filter and group data
Explanation:-
Answer: Option C. -> Modify data
Business intelligence (BI) is a technology-driven process for filter data and group information.
Question 6. A table is in 3NF if it is in 2NF and if it has no ____________
Functional Dependencies
Transitive Dependencies
Trivial Functional Dependency
Multivalued Dependencies
Explanation:-
Answer: Option B. -> Transitive Dependencies
For a relation to be in Third Normal Form, it must be in Second Normal form and the following must satisfy:No non-prime attribute is transitively dependent on prime key attribute For any non-trivial functional dependency, X - A, then eitherX is a superkey or,A is prime attribute.
Question 7. The relationship between DEPARTMENT and EMPLOYEE is a
One-to-one relationship
One-to-many relationship
Many-to-many relationship
Many-to-one relationship
Explanation:-
Answer: Option B. -> One-to-many relationship
The relationship between DEPARTMENT and EMPLOYEE is a one-to-many relationship.
Question 8. Which of the following is the oldest database model?
Relational
Deductive
Physical
Network
Explanation:-
Answer: Option D. -> Network
Network Model is the oldest database model.
Question 9. The language used application programs to request data from the DBMS is referred to as the
DML
DDL
Query language
All of the Mentioned
Explanation:-
Answer: Option A. -> DML
The effect of a DML statement is not permanent until you commit the transaction that includes it. A transaction is a sequence of SQL statements that Oracle Database treats as a unit.
Question 10. 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
Explanation:-
Answer: Option A. -> Candidate
A candidate key is a column, or set of columns, in a table that can uniquely identify any database record without referring to any other data. Each table may have one or more candidate keys.