InterviewSolution
Saved Bookmarks
InterviewSolution
This section includes InterviewSolutions, each offering curated multiple-choice questions to sharpen your ORACLE knowledge and support exam preparation. Choose a topic below to get started.
| 1. |
An n-array relationship is drawn using which symbol:(a) A diamond(b) A line with arrows showing direction(c) A line without arrows showing direction(d) A rectangleI had been asked this question in a national level competition.I need to ask this question from Attribute, Tuple and Entity topic in division Planning Oracle Applications of Oracle |
| Answer» <html><body><p>The correct option is (a) A diamond<br/><br/>Explanation: When a single <a href="https://interviewquestions.tuteehub.com/tag/parent-1146949" style="font-weight:bold;" target="_blank" title="Click to know more about PARENT">PARENT</a>-child <a href="https://interviewquestions.tuteehub.com/tag/relationship-1183331" style="font-weight:bold;" target="_blank" title="Click to know more about RELATIONSHIP">RELATIONSHIP</a> exists, the relationship is called binary. All of the previous examples of relationships to this point have been binary relationships. However, when creating a <a href="https://interviewquestions.tuteehub.com/tag/data-25577" style="font-weight:bold;" target="_blank" title="Click to know more about DATA">DATA</a> model, it is not uncommon to come across n-array relationships, the <a href="https://interviewquestions.tuteehub.com/tag/modeling-13558" style="font-weight:bold;" target="_blank" title="Click to know more about MODELING">MODELING</a> name for relationships between two or more parent entities and a single child table.</p></body></html> | |
| 2. |
The relational model is based on the concept that data is organized and stored in two-dimensional tables called _____________(a) Fields(b) Records(c) Relations(d) KeysThe question was asked during an internship interview.Origin of the question is Attribute, Tuple and Entity topic in portion Planning Oracle Applications of Oracle |
| Answer» <html><body><p>The correct answer is (b) Records<br/><br/>Easy explanation: In the context of a <a href="https://interviewquestions.tuteehub.com/tag/relational-1183272" style="font-weight:bold;" target="_blank" title="Click to know more about RELATIONAL">RELATIONAL</a> database, a row also <a href="https://interviewquestions.tuteehub.com/tag/called-907796" style="font-weight:bold;" target="_blank" title="Click to know more about CALLED">CALLED</a> a record or tuple represents a single, <a href="https://interviewquestions.tuteehub.com/tag/implicitlybrbr-2728692" style="font-weight:bold;" target="_blank" title="Click to know more about IMPLICITLY">IMPLICITLY</a> <a href="https://interviewquestions.tuteehub.com/tag/structured-2283056" style="font-weight:bold;" target="_blank" title="Click to know more about STRUCTURED">STRUCTURED</a> data item in a table.</p></body></html> | |
| 3. |
A ___________ normal form normalization will be needed where all attributes in a relation tuple are not functionally dependent only on the key attribute.(a) First(b) Second(c) Third(d) FourthI have been asked this question by my school principal while I was bunking the class.This intriguing question originated from Attribute, Tuple and Entity in division Planning Oracle Applications of Oracle |
| Answer» <html><body><a href="https://interviewquestions.tuteehub.com/tag/right-1188951" style="font-weight:bold;" target="_blank" title="Click to know more about RIGHT">RIGHT</a> <a href="https://interviewquestions.tuteehub.com/tag/option-25810" style="font-weight:bold;" target="_blank" title="Click to know more about OPTION">OPTION</a> is (c) Third<br/><br/>The <a href="https://interviewquestions.tuteehub.com/tag/explanation-455162" style="font-weight:bold;" target="_blank" title="Click to know more about EXPLANATION">EXPLANATION</a> is: A database is in third normal form if it satisfies the <a href="https://interviewquestions.tuteehub.com/tag/following-463335" style="font-weight:bold;" target="_blank" title="Click to know more about FOLLOWING">FOLLOWING</a> conditions:1)It is in second normal form. <a href="https://interviewquestions.tuteehub.com/tag/2-283658" style="font-weight:bold;" target="_blank" title="Click to know more about 2">2</a>)There is no transitive functional dependency</body></html> | |
| 4. |
An aggregation association is drawn using which symbol:(a) a line which loops back onto the same table(b) small closed diamond at the end of a line connecting two tables(c) small open diamond at the end of a line connecting two tables(d) small triangle at the end of a line connecting the aggregated item and multiple component itemsThe question was posed to me during an online exam.I would like to ask this question from Attribute, Tuple and Entity in portion Planning Oracle Applications of Oracle |
| Answer» <html><body><p>Right option is (c) small open diamond at the end of a line connecting two tables<br/><br/>Easy explanation: There are <a href="https://interviewquestions.tuteehub.com/tag/three-708969" style="font-weight:bold;" target="_blank" title="Click to know more about THREE">THREE</a> primary inter-object relationships: <a href="https://interviewquestions.tuteehub.com/tag/association-886116" style="font-weight:bold;" target="_blank" title="Click to know more about ASSOCIATION">ASSOCIATION</a>, aggregation, and composition. Using the right relationship line is important for placing implicit restrictions on the visibility and propagation of changes to the related classes, matter which <a href="https://interviewquestions.tuteehub.com/tag/play-1156558" style="font-weight:bold;" target="_blank" title="Click to know more about PLAY">PLAY</a> major role in <a href="https://interviewquestions.tuteehub.com/tag/reducing-2981618" style="font-weight:bold;" target="_blank" title="Click to know more about REDUCING">REDUCING</a> system complexity.</p></body></html> | |
| 5. |
Identify the criteria for designing database from the point of view of user(a) No redundancy(b) No inapplicable attributes(c) Uniformity in naming & definitions of the data items(d) All of the MentionedI had been asked this question during an internship interview.My question comes from Attribute, Tuple and Entity in division Planning Oracle Applications of Oracle |
| Answer» <html><body><p>Right answer is (d) All of the Mentioned<br/><br/>The best explanation: To <a href="https://interviewquestions.tuteehub.com/tag/designing-949336" style="font-weight:bold;" target="_blank" title="Click to know more about DESIGNING">DESIGNING</a> database from the <a href="https://interviewquestions.tuteehub.com/tag/point-1157106" style="font-weight:bold;" target="_blank" title="Click to know more about POINT">POINT</a> of <a href="https://interviewquestions.tuteehub.com/tag/user-25565" style="font-weight:bold;" target="_blank" title="Click to know more about USER">USER</a> view we need all the mentioned <a href="https://interviewquestions.tuteehub.com/tag/required-1185621" style="font-weight:bold;" target="_blank" title="Click to know more about REQUIRED">REQUIRED</a>.</p></body></html> | |
| 6. |
Which of the following is record based logical model?(a) Network Model(b) Object oriented model(c) E-R Model(d) None of the MentionedThe question was asked during an interview.My enquiry is from Attribute, Tuple and Entity topic in portion Planning Oracle Applications of Oracle |
| Answer» <html><body><p>The <a href="https://interviewquestions.tuteehub.com/tag/correct-409949" style="font-weight:bold;" target="_blank" title="Click to know more about CORRECT">CORRECT</a> answer is (a) Network <a href="https://interviewquestions.tuteehub.com/tag/model-942" style="font-weight:bold;" target="_blank" title="Click to know more about MODEL">MODEL</a><br/><br/>Explanation: The network model is a database model conceived as a <a href="https://interviewquestions.tuteehub.com/tag/flexible-992632" style="font-weight:bold;" target="_blank" title="Click to know more about FLEXIBLE">FLEXIBLE</a> <a href="https://interviewquestions.tuteehub.com/tag/way-1450548" style="font-weight:bold;" target="_blank" title="Click to know more about WAY">WAY</a> of representing objects and their relationships.</p></body></html> | |
| 7. |
E-R model uses this symbol to represent weak entity set ?(a) Dotted rectangle(b) Diamond(c) Doubly outlined rectangle(d) None of the MentionedThe question was posed to me in examination.My question is from Attribute, Tuple and Entity in division Planning Oracle Applications of Oracle |
| Answer» <html><body><p>The <a href="https://interviewquestions.tuteehub.com/tag/correct-409949" style="font-weight:bold;" target="_blank" title="Click to know more about CORRECT">CORRECT</a> <a href="https://interviewquestions.tuteehub.com/tag/option-25810" style="font-weight:bold;" target="_blank" title="Click to know more about OPTION">OPTION</a> is (c) <a href="https://interviewquestions.tuteehub.com/tag/doubly-7375303" style="font-weight:bold;" target="_blank" title="Click to know more about DOUBLY">DOUBLY</a> outlined rectangle<br/><br/>Explanation: A weak <a href="https://interviewquestions.tuteehub.com/tag/entity-972730" style="font-weight:bold;" target="_blank" title="Click to know more about ENTITY">ENTITY</a> set is indicated by a doubly-outlined <a href="https://interviewquestions.tuteehub.com/tag/box-401352" style="font-weight:bold;" target="_blank" title="Click to know more about BOX">BOX</a>.</p></body></html> | |
| 8. |
A relational database developer refers to a record as(a) A criteria(b) A relation(c) A tuple(d) An attributeI had been asked this question in a national level competition.I want to ask this question from Attribute, Tuple and Entity in portion Planning Oracle Applications of Oracle |
| Answer» <html><body><p>The <a href="https://interviewquestions.tuteehub.com/tag/correct-409949" style="font-weight:bold;" target="_blank" title="Click to know more about CORRECT">CORRECT</a> <a href="https://interviewquestions.tuteehub.com/tag/option-25810" style="font-weight:bold;" target="_blank" title="Click to know more about OPTION">OPTION</a> is (<a href="https://interviewquestions.tuteehub.com/tag/c-7168" style="font-weight:bold;" target="_blank" title="Click to know more about C">C</a>) A tuple<br/><br/>Explanation: A tuple is analogous to a record in non-relational databases.</p></body></html> | |
| 9. |
The relational model feature is that there(a) is no need for primary key data(b) is much more data independence than some other database models(c) are explicit relationships among records(d) are tables with many dimensionsThe question was asked during an interview for a job.My question is based upon Attribute, Tuple and Entity topic in division Planning Oracle Applications of Oracle |
| Answer» <html><body><a href="https://interviewquestions.tuteehub.com/tag/right-1188951" style="font-weight:bold;" target="_blank" title="Click to know more about RIGHT">RIGHT</a> answer is (b) is much more data <a href="https://interviewquestions.tuteehub.com/tag/independence-505804" style="font-weight:bold;" target="_blank" title="Click to know more about INDEPENDENCE">INDEPENDENCE</a> than some other database models<br/><br/>The explanation is: The relational <a href="https://interviewquestions.tuteehub.com/tag/model-942" style="font-weight:bold;" target="_blank" title="Click to know more about MODEL">MODEL</a> is the <a href="https://interviewquestions.tuteehub.com/tag/conceptual-928163" style="font-weight:bold;" target="_blank" title="Click to know more about CONCEPTUAL">CONCEPTUAL</a> basis of relational databases. Proposed by E.F.Codd in 1969, it is a method of structuring data using relations, which are grid-like mathematical structures consisting of columns and rows.</body></html> | |
| 10. |
In an E-R diagram an entity set is represent by a(a) Rectangle(b) Ellipse(c) Diamond box(d) CircleI got this question during an interview.My doubt is from Attribute, Tuple and Entity topic in portion Planning Oracle Applications of Oracle |
| Answer» <html><body><p>The <a href="https://interviewquestions.tuteehub.com/tag/correct-409949" style="font-weight:bold;" target="_blank" title="Click to know more about CORRECT">CORRECT</a> answer is (a) Rectangle<br/><br/>Easy <a href="https://interviewquestions.tuteehub.com/tag/explanation-455162" style="font-weight:bold;" target="_blank" title="Click to know more about EXPLANATION">EXPLANATION</a>: Entity types <a href="https://interviewquestions.tuteehub.com/tag/represent-613876" style="font-weight:bold;" target="_blank" title="Click to know more about REPRESENT">REPRESENT</a> sets of objects and are pictured by <a href="https://interviewquestions.tuteehub.com/tag/rectangular-1180623" style="font-weight:bold;" target="_blank" title="Click to know more about RECTANGULAR">RECTANGULAR</a> <a href="https://interviewquestions.tuteehub.com/tag/nodes-1121644" style="font-weight:bold;" target="_blank" title="Click to know more about NODES">NODES</a>.</p></body></html> | |
| 11. |
In a database, a foreign key is ?(a) 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(b) 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(c) 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(d) 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 tableThe question was posed to me at a job interview.I'm obligated to ask this question of Foreign, Candidate, Primary, Composite, Unique Keys topic in chapter Planning Oracle Applications of Oracle |
| Answer» <html><body><p>The correct choice is (c) A data element/attribute within a data <a href="https://interviewquestions.tuteehub.com/tag/field-987291" style="font-weight:bold;" target="_blank" title="Click to know more about FIELD">FIELD</a> of a data record within a database table that is a <a href="https://interviewquestions.tuteehub.com/tag/primary-1165403" style="font-weight:bold;" target="_blank" title="Click to know more about PRIMARY">PRIMARY</a> key in another database table<br/><br/>The <a href="https://interviewquestions.tuteehub.com/tag/best-390038" style="font-weight:bold;" target="_blank" title="Click to know more about BEST">BEST</a> I can explain: A FOREIGN KEY <a href="https://interviewquestions.tuteehub.com/tag/constraint-930945" style="font-weight:bold;" target="_blank" title="Click to know more about CONSTRAINT">CONSTRAINT</a> can reference columns in tables in the same database or within the same table. These are called self-referencing tables. For example, consider an employee table that contains three columns: employee_number, employee_name, and manager_employee_number. Because the manager is also an employee, there is a foreign key <a href="https://interviewquestions.tuteehub.com/tag/relationship-1183331" style="font-weight:bold;" target="_blank" title="Click to know more about RELATIONSHIP">RELATIONSHIP</a> from the manager_employee_number column to the employee_number column.</p></body></html> | |
| 12. |
A Foreign key is combined with a foreign key creates(a) Parent child relationship between the tables that connect them(b) Many-Many relationship between the tables that connect them(c) Network model between the tables that connect them(d) None of the MentionedThe question was posed to me in semester exam.The doubt is from Foreign, Candidate, Primary, Composite, Unique Keys topic in division Planning Oracle Applications of Oracle |
| Answer» <html><body><p>Correct answer is (a) Parent child relationship between the tables that connect them<br/><br/>To explain I would <a href="https://interviewquestions.tuteehub.com/tag/say-1195451" style="font-weight:bold;" target="_blank" title="Click to know more about SAY">SAY</a>: In a <a href="https://interviewquestions.tuteehub.com/tag/foreign-995515" style="font-weight:bold;" target="_blank" title="Click to know more about FOREIGN">FOREIGN</a> key reference, a link is created between two tables when the column or columns that hold the primary key <a href="https://interviewquestions.tuteehub.com/tag/value-1442530" style="font-weight:bold;" target="_blank" title="Click to know more about VALUE">VALUE</a> for one table are referenced by the column or columns in <a href="https://interviewquestions.tuteehub.com/tag/another-876628" style="font-weight:bold;" target="_blank" title="Click to know more about ANOTHER">ANOTHER</a> table. This column becomes a foreign key in the second table.</p></body></html> | |
| 13. |
Which of the following statements is not correct?(a) The primary key must be unique for a given table(b) Specifying a zero (0) for the lower bound for the association multiplicity on a class diagram indicates that the item is required(c) Specifying a one (1) for the lower bound for the association multiplicity on a class diagram indicates that the item is required(d) Most databases allow multiple records that are identicalI got this question during a job interview.This key question is from Foreign, Candidate, Primary, Composite, Unique Keys topic in portion Planning Oracle Applications of Oracle |
| Answer» <html><body><p>Correct choice is (b) Specifying a zero (0) for the <a href="https://interviewquestions.tuteehub.com/tag/lower-1080637" style="font-weight:bold;" target="_blank" title="Click to know more about LOWER">LOWER</a> bound for the association multiplicity on a class diagram <a href="https://interviewquestions.tuteehub.com/tag/indicates-1041501" style="font-weight:bold;" target="_blank" title="Click to know more about INDICATES">INDICATES</a> that the item is required<br/><br/>Easy <a href="https://interviewquestions.tuteehub.com/tag/explanation-455162" style="font-weight:bold;" target="_blank" title="Click to know more about EXPLANATION">EXPLANATION</a>: A foreign key is a column that references a column (most often the primary key) of another table. The purpose of the foreign key is to ensure referential integrity of the data. In other <a href="https://interviewquestions.tuteehub.com/tag/words-25841" style="font-weight:bold;" target="_blank" title="Click to know more about WORDS">WORDS</a>, only values that are supposed to appear in the database are permitted.</p></body></html> | |
| 14. |
A Key which is a set of one or more columns that can identify a record uniquely is called?(a) Natural key(b) Candidate key(c) Not Null key(d) Alternate keyThe question was asked in an interview for internship.I'm obligated to ask this question of Foreign, Candidate, Primary, Composite, Unique Keys topic in portion Planning Oracle Applications of Oracle |
| Answer» <html><body><p>Correct answer is (b) Candidate key<br/><br/>For explanation: A candidate key is a combination of attributes that can be uniquely used to <a href="https://interviewquestions.tuteehub.com/tag/identify-496703" style="font-weight:bold;" target="_blank" title="Click to know more about IDENTIFY">IDENTIFY</a> a database <a href="https://interviewquestions.tuteehub.com/tag/record-1180336" style="font-weight:bold;" target="_blank" title="Click to know more about RECORD">RECORD</a> without any extraneous data. Each table may have one or more candidate <a href="https://interviewquestions.tuteehub.com/tag/keys-15619" style="font-weight:bold;" target="_blank" title="Click to know more about KEYS">KEYS</a>. One of these candidate keys is selected as the table <a href="https://interviewquestions.tuteehub.com/tag/primary-1165403" style="font-weight:bold;" target="_blank" title="Click to know more about PRIMARY">PRIMARY</a> key.</p></body></html> | |
| 15. |
Which key accepts multiple NULL values?(a) Foreign Key(b) Unique Key(c) Primary Key(d) None of the MentionedI got this question in an interview for job.I want to ask this question from Foreign, Candidate, Primary, Composite, Unique Keys in section Planning Oracle Applications of Oracle |
| Answer» <html><body><p>Correct choice is (a) <a href="https://interviewquestions.tuteehub.com/tag/foreign-995515" style="font-weight:bold;" target="_blank" title="Click to know more about FOREIGN">FOREIGN</a> Key<br/><br/>Easy <a href="https://interviewquestions.tuteehub.com/tag/explanation-455162" style="font-weight:bold;" target="_blank" title="Click to know more about EXPLANATION">EXPLANATION</a>: A foreign key is a key <a href="https://interviewquestions.tuteehub.com/tag/used-2318798" style="font-weight:bold;" target="_blank" title="Click to know more about USED">USED</a> to link two <a href="https://interviewquestions.tuteehub.com/tag/tables-1238306" style="font-weight:bold;" target="_blank" title="Click to know more about TABLES">TABLES</a> together. This is sometimes called a <a href="https://interviewquestions.tuteehub.com/tag/referencing-1181633" style="font-weight:bold;" target="_blank" title="Click to know more about REFERENCING">REFERENCING</a> key.Foreign Key is a column or a combination of columns whose values match a Primary Key in a different table.</p></body></html> | |
| 16. |
By default, which key creates Clustered index?(a) Foreign Key(b) Unique Key(c) Primary Key(d) None of the MentionedI have been asked this question in an interview.My question comes from Foreign, Candidate, Primary, Composite, Unique Keys topic in portion Planning Oracle Applications of Oracle |
| Answer» <html><body><p>The <a href="https://interviewquestions.tuteehub.com/tag/correct-409949" style="font-weight:bold;" target="_blank" title="Click to know more about CORRECT">CORRECT</a> <a href="https://interviewquestions.tuteehub.com/tag/answer-15557" style="font-weight:bold;" target="_blank" title="Click to know more about ANSWER">ANSWER</a> is (<a href="https://interviewquestions.tuteehub.com/tag/c-7168" style="font-weight:bold;" target="_blank" title="Click to know more about C">C</a>) Primary Key<br/><br/>Best explanation: Primary Key by default it <a href="https://interviewquestions.tuteehub.com/tag/adds-849677" style="font-weight:bold;" target="_blank" title="Click to know more about ADDS">ADDS</a> a clustered index.</p></body></html> | |
| 17. |
What is true about Unique and primary key?(a) Unique can have multiple NULL values but Primary can’t have.(b) Unique can have single NULL value but Primary can’t have even single.(c) Both can have duplicate values(d) None of the MentionedThe question was posed to me in homework.My doubt stems from Foreign, Candidate, Primary, Composite, Unique Keys topic in section Planning Oracle Applications of Oracle |
| Answer» <html><body><p>Right <a href="https://interviewquestions.tuteehub.com/tag/option-25810" style="font-weight:bold;" target="_blank" title="Click to know more about OPTION">OPTION</a> is (b) <a href="https://interviewquestions.tuteehub.com/tag/unique-720618" style="font-weight:bold;" target="_blank" title="Click to know more about UNIQUE">UNIQUE</a> can have single NULL value but Primary can’t have even single.<br/><br/>To <a href="https://interviewquestions.tuteehub.com/tag/explain-447165" style="font-weight:bold;" target="_blank" title="Click to know more about EXPLAIN">EXPLAIN</a> I would <a href="https://interviewquestions.tuteehub.com/tag/say-1195451" style="font-weight:bold;" target="_blank" title="Click to know more about SAY">SAY</a>: Primary key doesn’t allow Null values and Unique key allows Null value, but only <a href="https://interviewquestions.tuteehub.com/tag/one-585732" style="font-weight:bold;" target="_blank" title="Click to know more about ONE">ONE</a> Null value.</p></body></html> | |
| 18. |
Which of the following is not a Key in SQL Server?(a) Primary(b) Foreign(c) Alternate(d) SecondaryThis question was addressed to me in a job interview.My question is taken from Foreign, Candidate, Primary, Composite, Unique Keys topic in section Planning Oracle Applications of Oracle |
| Answer» <html><body><p>Right option is (d) Secondary<br/><br/>The best I can explain: Except Secondary all are the <a href="https://interviewquestions.tuteehub.com/tag/types-15918" style="font-weight:bold;" target="_blank" title="Click to know more about TYPES">TYPES</a> of <a href="https://interviewquestions.tuteehub.com/tag/key-11608" style="font-weight:bold;" target="_blank" title="Click to know more about KEY">KEY</a> in <a href="https://interviewquestions.tuteehub.com/tag/sql-4621" style="font-weight:bold;" target="_blank" title="Click to know more about SQL">SQL</a> <a href="https://interviewquestions.tuteehub.com/tag/server-11236" style="font-weight:bold;" target="_blank" title="Click to know more about SERVER">SERVER</a>.</p></body></html> | |
| 19. |
A _______________ key is a minimal super key(a) Primary(b) Foreign(c) Candidate(d) Non-PrimeI had been asked this question in quiz.My question is based upon Foreign, Candidate, Primary, Composite, Unique Keys topic in section Planning Oracle Applications of Oracle |
| Answer» <html><body><p>Right <a href="https://interviewquestions.tuteehub.com/tag/choice-915996" style="font-weight:bold;" target="_blank" title="Click to know more about CHOICE">CHOICE</a> is (<a href="https://interviewquestions.tuteehub.com/tag/c-7168" style="font-weight:bold;" target="_blank" title="Click to know more about C">C</a>) <a href="https://interviewquestions.tuteehub.com/tag/candidate-25673" style="font-weight:bold;" target="_blank" title="Click to know more about CANDIDATE">CANDIDATE</a><br/><br/>The explanation: In the relational model of databases, a candidate key of a relation is a <a href="https://interviewquestions.tuteehub.com/tag/minimal-1097157" style="font-weight:bold;" target="_blank" title="Click to know more about MINIMAL">MINIMAL</a> <a href="https://interviewquestions.tuteehub.com/tag/superkey-1235021" style="font-weight:bold;" target="_blank" title="Click to know more about SUPERKEY">SUPERKEY</a> for that relation.</p></body></html> | |
| 20. |
How can a SQL developer add a key on a table?(a) While creating a table(b) With Alter table command(c) With SQL server Properties window(d) All of the MentionedI have been asked this question by my college professor while I was bunking the class.My question comes from Foreign, Candidate, Primary, Composite, Unique Keys in division Planning Oracle Applications of Oracle |
| Answer» <html><body><p>Right answer is (d) All of the <a href="https://interviewquestions.tuteehub.com/tag/mentioned-1093838" style="font-weight:bold;" target="_blank" title="Click to know more about MENTIONED">MENTIONED</a><br/><br/>Easiest <a href="https://interviewquestions.tuteehub.com/tag/explanation-455162" style="font-weight:bold;" target="_blank" title="Click to know more about EXPLANATION">EXPLANATION</a>: Adding <a href="https://interviewquestions.tuteehub.com/tag/key-11608" style="font-weight:bold;" target="_blank" title="Click to know more about KEY">KEY</a> on a table can be <a href="https://interviewquestions.tuteehub.com/tag/done-2591742" style="font-weight:bold;" target="_blank" title="Click to know more about DONE">DONE</a> with all the above mentioned way.</p></body></html> | |
| 21. |
Which of the following is not a restriction for a table to be a relation?(a) The cells of the table must contain a single value(b) All of the entries in any column must be of the same kind(c) The columns must be ordered(d) No two rows in a table may be identicalI got this question during an interview.The query is from Normalization topic in chapter Planning Oracle Applications of Oracle |
| Answer» <html><body><a href="https://interviewquestions.tuteehub.com/tag/right-1188951" style="font-weight:bold;" target="_blank" title="Click to know more about RIGHT">RIGHT</a> answer is (<a href="https://interviewquestions.tuteehub.com/tag/c-7168" style="font-weight:bold;" target="_blank" title="Click to know more about C">C</a>) The columns must be ordered<br/><br/>The <a href="https://interviewquestions.tuteehub.com/tag/explanation-455162" style="font-weight:bold;" target="_blank" title="Click to know more about EXPLANATION">EXPLANATION</a>: To <a href="https://interviewquestions.tuteehub.com/tag/format-11876" style="font-weight:bold;" target="_blank" title="Click to know more about FORMAT">FORMAT</a> the columns differently, assign a <a href="https://interviewquestions.tuteehub.com/tag/unique-720618" style="font-weight:bold;" target="_blank" title="Click to know more about UNIQUE">UNIQUE</a> alias to each column within the SELECT command itself (do not use the ALIAS clause of the COLUMN command) and enter a COLUMN command for each column’s alias.</body></html> | |
| 22. |
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):(a) Transitive Dependency(b) Insertion Anomaly(c) Referential Integrity Constraint(d) Normal FormI had been asked this question during an interview.This intriguing question comes from Normalization in portion Planning Oracle Applications of Oracle |
| Answer» <html><body><p>Right answer is (c) Referential <a href="https://interviewquestions.tuteehub.com/tag/integrity-1047170" style="font-weight:bold;" target="_blank" title="Click to know more about INTEGRITY">INTEGRITY</a> Constraint<br/><br/>For <a href="https://interviewquestions.tuteehub.com/tag/explanation-455162" style="font-weight:bold;" target="_blank" title="Click to know more about EXPLANATION">EXPLANATION</a> I <a href="https://interviewquestions.tuteehub.com/tag/would-3285927" style="font-weight:bold;" target="_blank" title="Click to know more about WOULD">WOULD</a> <a href="https://interviewquestions.tuteehub.com/tag/say-1195451" style="font-weight:bold;" target="_blank" title="Click to know more about SAY">SAY</a>: Referential Integrity is set of constraints applied to foreign key which prevents <a href="https://interviewquestions.tuteehub.com/tag/entering-7266267" style="font-weight:bold;" target="_blank" title="Click to know more about ENTERING">ENTERING</a> a row in child table for which you don’t have any corresponding row in parent table i.e. entering NULL or invalid foreign keys.</p></body></html> | |
| 23. |
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) A -> B(b) A -> C(c) A -> (B,C)(d) (B,C) -> AI have been asked this question by my college director while I was bunking the class.Asked question is from Normalization in chapter Planning Oracle Applications of Oracle |
| Answer» <html><body><p>The correct choice is (a) A -> B<br/><br/>To explain I <a href="https://interviewquestions.tuteehub.com/tag/would-3285927" style="font-weight:bold;" target="_blank" title="Click to know more about WOULD">WOULD</a> say: <a href="https://interviewquestions.tuteehub.com/tag/transitivity-1426115" style="font-weight:bold;" target="_blank" title="Click to know more about TRANSITIVITY">TRANSITIVITY</a> rule: Same as transitive rule in <a href="https://interviewquestions.tuteehub.com/tag/algebra-19699" style="font-weight:bold;" target="_blank" title="Click to know more about ALGEBRA">ALGEBRA</a>, if a -> b <a href="https://interviewquestions.tuteehub.com/tag/holds-1028346" style="font-weight:bold;" target="_blank" title="Click to know more about HOLDS">HOLDS</a> and b -> <a href="https://interviewquestions.tuteehub.com/tag/c-7168" style="font-weight:bold;" target="_blank" title="Click to know more about C">C</a> holds then a -> c also hold. a -> b is called as a functionally determines b.</p></body></html> | |
| 24. |
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.(a) Candidate(b) Join(c) Functional(d) None of the MentionedI have been asked this question in examination.This is a very interesting question from Normalization in division Planning Oracle Applications of Oracle |
| Answer» <html><body><p>The correct answer is (a) Candidate<br/><br/>The explanation is: A candidate key is a column, or <a href="https://interviewquestions.tuteehub.com/tag/set-11758" style="font-weight:bold;" target="_blank" title="Click to know more about SET">SET</a> of columns, in a table that can uniquely identify any <a href="https://interviewquestions.tuteehub.com/tag/database-11539" style="font-weight:bold;" target="_blank" title="Click to know more about DATABASE">DATABASE</a> record without referring to any other data. Each table <a href="https://interviewquestions.tuteehub.com/tag/may-557248" style="font-weight:bold;" target="_blank" title="Click to know more about MAY">MAY</a> have <a href="https://interviewquestions.tuteehub.com/tag/one-585732" style="font-weight:bold;" target="_blank" title="Click to know more about ONE">ONE</a> or more candidate <a href="https://interviewquestions.tuteehub.com/tag/keys-15619" style="font-weight:bold;" target="_blank" title="Click to know more about KEYS">KEYS</a>.</p></body></html> | |
| 25. |
Anomalies are avoided by splitting the offending relation into multiple relations, is also known as(a) Accupressure(b) Decomposition(c) Precomposition(d) Both Decomposition and PrecompositionI had been asked this question in quiz.My doubt is from Normalization topic in section Planning Oracle Applications of Oracle |
| Answer» <html><body><p>Right option is (<a href="https://interviewquestions.tuteehub.com/tag/b-387190" style="font-weight:bold;" target="_blank" title="Click to know more about B">B</a>) Decomposition<br/><br/>To elaborate: <a href="https://interviewquestions.tuteehub.com/tag/eliminate-450326" style="font-weight:bold;" target="_blank" title="Click to know more about ELIMINATE">ELIMINATE</a> <a href="https://interviewquestions.tuteehub.com/tag/redundancy-1181475" style="font-weight:bold;" target="_blank" title="Click to know more about REDUNDANCY">REDUNDANCY</a> by decomposing a relation into several relations in a <a href="https://interviewquestions.tuteehub.com/tag/higher-1022060" style="font-weight:bold;" target="_blank" title="Click to know more about HIGHER">HIGHER</a> normal form.</p></body></html> | |
| 26. |
A ___________ is an indirect functional dependency, one in which X->Z only by virtue of X->Y and Y->Z.(a) Multivalued Dependencies(b) Join Dependency(c) Trivial Functional Dependency(d) Transitive DependenciesI had been asked this question in examination.The query is from Normalization topic in section Planning Oracle Applications of Oracle |
| Answer» <html><body><p>The correct choice is (d) Transitive <a href="https://interviewquestions.tuteehub.com/tag/dependencies-948486" style="font-weight:bold;" target="_blank" title="Click to know more about DEPENDENCIES">DEPENDENCIES</a><br/><br/>To explain I would say: Third Normal Form <a href="https://interviewquestions.tuteehub.com/tag/deals-945317" style="font-weight:bold;" target="_blank" title="Click to know more about DEALS">DEALS</a> with something called ‘transitive’ dependencies. This <a href="https://interviewquestions.tuteehub.com/tag/means-1091780" style="font-weight:bold;" target="_blank" title="Click to know more about MEANS">MEANS</a> if we have a primary key A and a non-key domain <a href="https://interviewquestions.tuteehub.com/tag/b-387190" style="font-weight:bold;" target="_blank" title="Click to know more about B">B</a> and C where C is more dependent on B than A and B is directly dependent on A, then C can be considered transitively dependent on A.</p></body></html> | |
| 27. |
Every constraint on the table is a logical consequence of the table’s(a) Fourth normal form(b) Fifth normal form(c) Domain/key normal form(d) None of the MentionedThis question was addressed to me in an online quiz.The origin of the question is Normalization in chapter Planning Oracle Applications of Oracle |
| Answer» <html><body><p>Correct <a href="https://interviewquestions.tuteehub.com/tag/choice-915996" style="font-weight:bold;" target="_blank" title="Click to know more about CHOICE">CHOICE</a> is (c) Domain/key normal form<br/><br/>The <a href="https://interviewquestions.tuteehub.com/tag/explanation-455162" style="font-weight:bold;" target="_blank" title="Click to know more about EXPLANATION">EXPLANATION</a> is: A relation is in domain-key normal form (DK/NF) if every <a href="https://interviewquestions.tuteehub.com/tag/constraint-930945" style="font-weight:bold;" target="_blank" title="Click to know more about CONSTRAINT">CONSTRAINT</a> on the relation is a <a href="https://interviewquestions.tuteehub.com/tag/logical-543774" style="font-weight:bold;" target="_blank" title="Click to know more about LOGICAL">LOGICAL</a> <a href="https://interviewquestions.tuteehub.com/tag/consequence-929774" style="font-weight:bold;" target="_blank" title="Click to know more about CONSEQUENCE">CONSEQUENCE</a> of the definition of keys and domains.</p></body></html> | |
| 28. |
A table is in 3NF if it is in 2NF and if it has no ____________(a) Functional Dependencies(b) Transitive Dependencies(c) Trivial Functional Dependency(d) Multivalued DependenciesThe question was asked in an online quiz.This intriguing question originated from Normalization in section Planning Oracle Applications of Oracle |
| Answer» <html><body><p>Correct option is (<a href="https://interviewquestions.tuteehub.com/tag/b-387190" style="font-weight:bold;" target="_blank" title="Click to know more about B">B</a>) Transitive Dependencies<br/><br/>Easy explanation: For a relation to be in Third Normal Form, it <a href="https://interviewquestions.tuteehub.com/tag/must-2185568" style="font-weight:bold;" target="_blank" title="Click to know more about MUST">MUST</a> be in Second Normal form and the following must <a href="https://interviewquestions.tuteehub.com/tag/satisfy-1195236" style="font-weight:bold;" target="_blank" title="Click to know more about SATISFY">SATISFY</a>:No non-prime attribute is <a href="https://interviewquestions.tuteehub.com/tag/transitively-7384444" style="font-weight:bold;" target="_blank" title="Click to know more about TRANSITIVELY">TRANSITIVELY</a> dependent on prime key attribute For any non-trivial functional <a href="https://interviewquestions.tuteehub.com/tag/dependency-948489" style="font-weight:bold;" target="_blank" title="Click to know more about DEPENDENCY">DEPENDENCY</a>, X -> A, then eitherX is a superkey or,A is prime attribute.</p></body></html> | |
| 29. |
A table is in BCNF if it is in 3NF and if every determinant is a ___________ key.(a) Dependent(b) Normal(c) Candidate(d) Both Normal and CandidateThis question was addressed to me in an interview for internship.This interesting question is from Normalization in chapter Planning Oracle Applications of Oracle |
| Answer» <html><body><a href="https://interviewquestions.tuteehub.com/tag/right-1188951" style="font-weight:bold;" target="_blank" title="Click to know more about RIGHT">RIGHT</a> <a href="https://interviewquestions.tuteehub.com/tag/answer-15557" style="font-weight:bold;" target="_blank" title="Click to know more about ANSWER">ANSWER</a> is (c) Candidate<br/><br/>The explanation: A table is in Boyce-Codd normal <a href="https://interviewquestions.tuteehub.com/tag/form-996208" style="font-weight:bold;" target="_blank" title="Click to know more about FORM">FORM</a> (BCNF) if and only if it is in 3NF and every determinant is a candidate <a href="https://interviewquestions.tuteehub.com/tag/key-11608" style="font-weight:bold;" target="_blank" title="Click to know more about KEY">KEY</a>.</body></html> | |
| 30. |
The ___________ normalization introduced by Chris Date, Hugh Darwen, and Nikos Lorentzos.(a) Third(b) Fourth(c) Fifth(d) SixthI had been asked this question by my school teacher while I was bunking the class.My question is based upon Normalization in section Planning Oracle Applications of Oracle |
| Answer» <html><body><a href="https://interviewquestions.tuteehub.com/tag/correct-409949" style="font-weight:bold;" target="_blank" title="Click to know more about CORRECT">CORRECT</a> answer is (d) Sixth<br/><br/>The <a href="https://interviewquestions.tuteehub.com/tag/explanation-455162" style="font-weight:bold;" target="_blank" title="Click to know more about EXPLANATION">EXPLANATION</a>: Chris Date, Hugh <a href="https://interviewquestions.tuteehub.com/tag/darwen-7675202" style="font-weight:bold;" target="_blank" title="Click to know more about DARWEN">DARWEN</a>, and Nikos Lorentzos introduced Sixth Normal form (<a href="https://interviewquestions.tuteehub.com/tag/6nfbrbr-1912457" style="font-weight:bold;" target="_blank" title="Click to know more about 6NF">6NF</a>).</body></html> | |
| 31. |
The benefits of a standard relational language include which of the following ?(a) Reduced training costs(b) Increased dependence on a single vendor(c) Applications are not needed(d) All of the MentionedThis question was posed to me in unit test.My doubt stems from Data Entry, Query and Reporting topic in division Planning Oracle Applications of Oracle |
| Answer» <html><body><p>Correct choice is (a) <a href="https://interviewquestions.tuteehub.com/tag/reduced-1181337" style="font-weight:bold;" target="_blank" title="Click to know more about REDUCED">REDUCED</a> training <a href="https://interviewquestions.tuteehub.com/tag/costs-25578" style="font-weight:bold;" target="_blank" title="Click to know more about COSTS">COSTS</a><br/><br/>Easiest explanation: Standard <a href="https://interviewquestions.tuteehub.com/tag/relational-1183272" style="font-weight:bold;" target="_blank" title="Click to know more about RELATIONAL">RELATIONAL</a> language <a href="https://interviewquestions.tuteehub.com/tag/gives-1007647" style="font-weight:bold;" target="_blank" title="Click to know more about GIVES">GIVES</a> the benefits of reducing the training costs.</p></body></html> | |
| 32. |
Each answer below shows example data from a table. Which answer is an example of the general-purpose remarks column problem?(a) Three columns have the values 534-2435, 534-7867, and 546-2356 in the same row(b) Three rows have the values Brown Small Chair, Small Chair Brown, and Small Brown Chair in the same column(c) Three rows have the values Brown, NULL, and Blue in the same column(d) One row has the value “He is interested in a Silver Porsche from the years 1978-1988” in a columnI have been asked this question in an online interview.This is a very interesting question from Data Entry, Query and Reporting in portion Planning Oracle Applications of Oracle |
| Answer» <html><body><p>Correct answer is (d) <a href="https://interviewquestions.tuteehub.com/tag/one-585732" style="font-weight:bold;" target="_blank" title="Click to know more about ONE">ONE</a> row has the value “He is interested in a <a href="https://interviewquestions.tuteehub.com/tag/silver-644119" style="font-weight:bold;" target="_blank" title="Click to know more about SILVER">SILVER</a> Porsche from the years 1978-1988” in a <a href="https://interviewquestions.tuteehub.com/tag/column-922494" style="font-weight:bold;" target="_blank" title="Click to know more about COLUMN">COLUMN</a><br/><br/>The best <a href="https://interviewquestions.tuteehub.com/tag/explanation-455162" style="font-weight:bold;" target="_blank" title="Click to know more about EXPLANATION">EXPLANATION</a>: Option d fullfill the condition of column.</p></body></html> | |
| 33. |
The wildcard in a WHERE clause is useful when?(a) An exact match is necessary in a SELECT statement(b) An exact match is not possible in a SELECT statement(c) An exact match is necessary in a CREATE statement(d) An exact match is not possible in a CREATE statementThis question was posed to me by my school teacher while I was bunking the class.My enquiry is from Data Entry, Query and Reporting topic in chapter Planning Oracle Applications of Oracle |
| Answer» <html><body><p>Correct <a href="https://interviewquestions.tuteehub.com/tag/choice-915996" style="font-weight:bold;" target="_blank" title="Click to know more about CHOICE">CHOICE</a> is (<a href="https://interviewquestions.tuteehub.com/tag/b-387190" style="font-weight:bold;" target="_blank" title="Click to know more about B">B</a>) An exact match is not possible in a SELECT <a href="https://interviewquestions.tuteehub.com/tag/statement-16478" style="font-weight:bold;" target="_blank" title="Click to know more about STATEMENT">STATEMENT</a><br/><br/>Easy explanation: Wildcard <a href="https://interviewquestions.tuteehub.com/tag/useful-1441152" style="font-weight:bold;" target="_blank" title="Click to know more about USEFUL">USEFUL</a> only when an exact match is not possible in a SELECT statement.</p></body></html> | |
| 34. |
Which of the following is not a component of a data warehouse?(a) Data extraction/cleaning/preparation programs(b) Data warehouse data(c) Data metadata(d) None of the MentionedThis question was posed to me in quiz.This question is from Data Entry, Query and Reporting topic in division Planning Oracle Applications of Oracle |
| Answer» <html><body><a href="https://interviewquestions.tuteehub.com/tag/correct-409949" style="font-weight:bold;" target="_blank" title="Click to know more about CORRECT">CORRECT</a> choice is (c) Data <a href="https://interviewquestions.tuteehub.com/tag/metadata-14512" style="font-weight:bold;" target="_blank" title="Click to know more about METADATA">METADATA</a><br/><br/>For explanation: Data warehouse is not <a href="https://interviewquestions.tuteehub.com/tag/deal-945294" style="font-weight:bold;" target="_blank" title="Click to know more about DEAL">DEAL</a> with the Data metadata.</body></html> | |
| 35. |
A report generated by a reporting system is delivered to the appropriate users via a user-accessed Web site. This system uses which of the following report modes?(a) Push(b) Pull(c) RFM(d) OLAPI got this question in an internship interview.This interesting question is from Data Entry, Query and Reporting in chapter Planning Oracle Applications of Oracle |
| Answer» <html><body><p>Correct choice is (<a href="https://interviewquestions.tuteehub.com/tag/b-387190" style="font-weight:bold;" target="_blank" title="Click to know more about B">B</a>) Pull<br/><br/>For <a href="https://interviewquestions.tuteehub.com/tag/explanation-455162" style="font-weight:bold;" target="_blank" title="Click to know more about EXPLANATION">EXPLANATION</a>: The push-pull <a href="https://interviewquestions.tuteehub.com/tag/model-942" style="font-weight:bold;" target="_blank" title="Click to know more about MODEL">MODEL</a> to not allow mixed port type combinations for a connection, such as connecting a push <a href="https://interviewquestions.tuteehub.com/tag/output-1142821" style="font-weight:bold;" target="_blank" title="Click to know more about OUTPUT">OUTPUT</a> port to a pull <a href="https://interviewquestions.tuteehub.com/tag/input-11237" style="font-weight:bold;" target="_blank" title="Click to know more about INPUT">INPUT</a> port, and a pull output port to a push input port.</p></body></html> | |
| 36. |
The “curse of dimensionality” relates to which problem of using operational data for BI reporting?(a) Dirty data(b) Inconsistent data(c) Too much data(d) Non-integrated dataI have been asked this question in class test.My question is taken from Data Entry, Query and Reporting topic in portion Planning Oracle Applications of Oracle |
| Answer» <html><body><p>Right option is (c) Too much data<br/><br/>For <a href="https://interviewquestions.tuteehub.com/tag/explanation-455162" style="font-weight:bold;" target="_blank" title="Click to know more about EXPLANATION">EXPLANATION</a>: The curse of dimensionality refers to various phenomena that <a href="https://interviewquestions.tuteehub.com/tag/arise-363879" style="font-weight:bold;" target="_blank" title="Click to know more about ARISE">ARISE</a> when <a href="https://interviewquestions.tuteehub.com/tag/analyzing-874301" style="font-weight:bold;" target="_blank" title="Click to know more about ANALYZING">ANALYZING</a> and organizing data in high-dimensional spaces.</p></body></html> | |
| 37. |
Business Intelligence (BI) reporting systems cannot do which of the following operations?(a) Filter data(b) Group data(c) Modify data(d) Both filter and group dataI had been asked this question during an interview.I'm obligated to ask this question of Data Entry, Query and Reporting in chapter Planning Oracle Applications of Oracle |
| Answer» <html><body><p>Correct choice is (c) Modify data<br/><br/>Easy explanation: <a href="https://interviewquestions.tuteehub.com/tag/business-21797" style="font-weight:bold;" target="_blank" title="Click to know more about BUSINESS">BUSINESS</a> intelligence (BI) is a technology-driven <a href="https://interviewquestions.tuteehub.com/tag/process-11618" style="font-weight:bold;" target="_blank" title="Click to know more about PROCESS">PROCESS</a> for filter data and group information.</p></body></html> | |
| 38. |
A BI reporting system does not _____________(a) Create meaningful information(b) Deliver information to users on a timely basis(c) Use statistical procedures to predict future events(d) Use disparate data sourcesThe question was posed to me in a job interview.My question is from Data Entry, Query and Reporting in chapter Planning Oracle Applications of Oracle |
| Answer» <html><body><p>The correct choice is (c) <a href="https://interviewquestions.tuteehub.com/tag/use-1441041" style="font-weight:bold;" target="_blank" title="Click to know more about USE">USE</a> statistical <a href="https://interviewquestions.tuteehub.com/tag/procedures-15993" style="font-weight:bold;" target="_blank" title="Click to know more about PROCEDURES">PROCEDURES</a> to predict future events<br/><br/>Explanation: Business intelligence (BI) is a technology-driven process for analyzing data and <a href="https://interviewquestions.tuteehub.com/tag/presenting-7277346" style="font-weight:bold;" target="_blank" title="Click to know more about PRESENTING">PRESENTING</a> <a href="https://interviewquestions.tuteehub.com/tag/actionable-367206" style="font-weight:bold;" target="_blank" title="Click to know more about ACTIONABLE">ACTIONABLE</a> <a href="https://interviewquestions.tuteehub.com/tag/information-1043838" style="font-weight:bold;" target="_blank" title="Click to know more about INFORMATION">INFORMATION</a>.</p></body></html> | |
| 39. |
Which of the following is not one of the three ways to classify an action assertion?(a) Condition(b) Integrity Control(c) Authorization(d) EnablerThe question was posed to me in unit test.My question comes from The Atomic Data Models and Business Models topic in division Planning Oracle Applications of Oracle |
| Answer» <html><body><p>Right choice is (d) Enabler<br/><br/>The <a href="https://interviewquestions.tuteehub.com/tag/explanation-455162" style="font-weight:bold;" target="_blank" title="Click to know more about EXPLANATION">EXPLANATION</a> is: The CREATE <a href="https://interviewquestions.tuteehub.com/tag/assertion-384238" style="font-weight:bold;" target="_blank" title="Click to know more about ASSERTION">ASSERTION</a> statement names a <a href="https://interviewquestions.tuteehub.com/tag/new-1114486" style="font-weight:bold;" target="_blank" title="Click to know more about NEW">NEW</a> <a href="https://interviewquestions.tuteehub.com/tag/constraint-930945" style="font-weight:bold;" target="_blank" title="Click to know more about CONSTRAINT">CONSTRAINT</a> and defines the Constraint’s deferral mode, initial constraint <a href="https://interviewquestions.tuteehub.com/tag/check-25817" style="font-weight:bold;" target="_blank" title="Click to know more about CHECK">CHECK</a> time and its CHECK search condition.</p></body></html> | |
| 40. |
Use of a supertype/subtype relationship is necessary when which of the following exists?(a) An instance of a subtype participates in a relationship that is unique to that subtype(b) An instance of a subtype participates in a relationship that is the same as the other subtypes(c) Attributes apply to all of the instances of an entity type(d) No attributes apply to any of the instances of an entity typeI got this question in my homework.My doubt is from The Atomic Data Models and Business Models topic in division Planning Oracle Applications of Oracle |
| Answer» <html><body><p>Right answer is (a) An <a href="https://interviewquestions.tuteehub.com/tag/instance-25561" style="font-weight:bold;" target="_blank" title="Click to know more about INSTANCE">INSTANCE</a> of a <a href="https://interviewquestions.tuteehub.com/tag/subtype-1231813" style="font-weight:bold;" target="_blank" title="Click to know more about SUBTYPE">SUBTYPE</a> participates in a relationship that is unique to that subtype<br/><br/>The explanation: Super-types and sub-types show <a href="https://interviewquestions.tuteehub.com/tag/hierarchy-1020132" style="font-weight:bold;" target="_blank" title="Click to know more about HIERARCHY">HIERARCHY</a> in the structure; graphs and <a href="https://interviewquestions.tuteehub.com/tag/trees-1427074" style="font-weight:bold;" target="_blank" title="Click to know more about TREES">TREES</a> show hierarchy in the data.</p></body></html> | |
| 41. |
Which of the following statements concerning business rules is true?(a) It should be complex(b) It should not be convertible to computer code(c) It may include restrictions(d) All of the MentionedThe question was posed to me in semester exam.This is a very interesting question from The Atomic Data Models and Business Models in section Planning Oracle Applications of Oracle |
| Answer» <html><body><a href="https://interviewquestions.tuteehub.com/tag/right-1188951" style="font-weight:bold;" target="_blank" title="Click to know more about RIGHT">RIGHT</a> answer is (c) It may include restrictions<br/><br/>For explanation I <a href="https://interviewquestions.tuteehub.com/tag/would-3285927" style="font-weight:bold;" target="_blank" title="Click to know more about WOULD">WOULD</a> say: It is used to <a href="https://interviewquestions.tuteehub.com/tag/define-947004" style="font-weight:bold;" target="_blank" title="Click to know more about DEFINE">DEFINE</a>, deploy, execute, monitor and maintain the variety and complexity of decision logic that is used by operational systems within an <a href="https://interviewquestions.tuteehub.com/tag/organization-25610" style="font-weight:bold;" target="_blank" title="Click to know more about ORGANIZATION">ORGANIZATION</a> or <a href="https://interviewquestions.tuteehub.com/tag/enterprise-3569" style="font-weight:bold;" target="_blank" title="Click to know more about ENTERPRISE">ENTERPRISE</a>.</body></html> | |
| 42. |
A supertype/subtype hierarchy is which of the following?(a) Each subtype has only one attribute(b) Each supertype has only one attribute(c) Each subtype has only one supertype(d) Each supertype has only one subtypeThis question was posed to me in a national level competition.This intriguing question comes from The Atomic Data Models and Business Models topic in section Planning Oracle Applications of Oracle |
| Answer» <html><body><p>Right <a href="https://interviewquestions.tuteehub.com/tag/answer-15557" style="font-weight:bold;" target="_blank" title="Click to know more about ANSWER">ANSWER</a> is (c) Each subtype has only one supertype<br/><br/>Easy explanation: Two <a href="https://interviewquestions.tuteehub.com/tag/entities-972724" style="font-weight:bold;" target="_blank" title="Click to know more about ENTITIES">ENTITIES</a> are of <a href="https://interviewquestions.tuteehub.com/tag/distinct-432063" style="font-weight:bold;" target="_blank" title="Click to know more about DISTINCT">DISTINCT</a> types if they have no attributes in common. It is <a href="https://interviewquestions.tuteehub.com/tag/possible-592355" style="font-weight:bold;" target="_blank" title="Click to know more about POSSIBLE">POSSIBLE</a> for entities to have both common and distinct attributes. If they have a common identifier (that is, a common primary <a href="https://interviewquestions.tuteehub.com/tag/key-11608" style="font-weight:bold;" target="_blank" title="Click to know more about KEY">KEY</a>), they have a special supertype-subtype relationship: they are neither distinct nor the same.</p></body></html> | |
| 43. |
When an entity instance must be a member of only one sub-type, it is which of the following?(a) Disjoint with total specialization(b) Disjoint with partial specialization(c) Overlap with total specialization(d) Overlap with partial specializationThis question was addressed to me during an online interview.This intriguing question originated from The Atomic Data Models and Business Models in section Planning Oracle Applications of Oracle |
| Answer» <html><body><p>The correct option is (a) Disjoint with <a href="https://interviewquestions.tuteehub.com/tag/total-711110" style="font-weight:bold;" target="_blank" title="Click to know more about TOTAL">TOTAL</a> specialization<br/><br/>The explanation is: GradStudent (_id_, <a href="https://interviewquestions.tuteehub.com/tag/name-573193" style="font-weight:bold;" target="_blank" title="Click to know more about NAME">NAME</a>, gradStuff) UndergradStudent (_id_, name, underGradStuff) Professor (_id_, name) <a href="https://interviewquestions.tuteehub.com/tag/teaches-1240036" style="font-weight:bold;" target="_blank" title="Click to know more about TEACHES">TEACHES</a>(_prof_id_, _stud_id_)<br/><br/>Considering that the relational database above is meant to represent total disjoint specialization, i.e. there is no table Student but rather two completely separate ones, when writing this in SQL in <a href="https://interviewquestions.tuteehub.com/tag/order-1138220" style="font-weight:bold;" target="_blank" title="Click to know more about ORDER">ORDER</a> to implement the database, how would I fetch the student id for the Teaches table? I cannot figure out how to <a href="https://interviewquestions.tuteehub.com/tag/make-546668" style="font-weight:bold;" target="_blank" title="Click to know more about MAKE">MAKE</a> a foreign key from two different tables.</p></body></html> | |
| 44. |
Which of the following is the process of selecting the data storage and data access characteristics of the database?(a) Logical database design(b) Physical database design(c) Testing and performance tuning(d) Evaluation and selectingI had been asked this question by my school principal while I was bunking the class.I'd like to ask this question from The Atomic Data Models and Business Models topic in section Planning Oracle Applications of Oracle |
| Answer» <html><body><p>Right <a href="https://interviewquestions.tuteehub.com/tag/option-25810" style="font-weight:bold;" target="_blank" title="Click to know more about OPTION">OPTION</a> is (b) Physical <a href="https://interviewquestions.tuteehub.com/tag/database-11539" style="font-weight:bold;" target="_blank" title="Click to know more about DATABASE">DATABASE</a> design<br/><br/>Easiest explanation: Physical database design is the <a href="https://interviewquestions.tuteehub.com/tag/process-11618" style="font-weight:bold;" target="_blank" title="Click to know more about PROCESS">PROCESS</a> of <a href="https://interviewquestions.tuteehub.com/tag/selecting-639335" style="font-weight:bold;" target="_blank" title="Click to know more about SELECTING">SELECTING</a> the data storage and data access characteristics of the database.</p></body></html> | |
| 45. |
If the state of the database no longer reflects a real state of the world that the database is supposed to capture, then such a state is called(a) Consistent state(b) Inconsistent state(c) Durable state(d) Atomic stateThis question was addressed to me in an internship interview.The doubt is from The Atomic Data Models and Business Models in chapter Planning Oracle Applications of Oracle |
| Answer» <html><body><p>Correct <a href="https://interviewquestions.tuteehub.com/tag/choice-915996" style="font-weight:bold;" target="_blank" title="Click to know more about CHOICE">CHOICE</a> is (b) Inconsistent state<br/><br/>The best explanation: If the state of the database no <a href="https://interviewquestions.tuteehub.com/tag/longer-1078655" style="font-weight:bold;" target="_blank" title="Click to know more about LONGER">LONGER</a> <a href="https://interviewquestions.tuteehub.com/tag/reflects-2982290" style="font-weight:bold;" target="_blank" title="Click to know more about REFLECTS">REFLECTS</a> a real state of the world that the database is <a href="https://interviewquestions.tuteehub.com/tag/supposed-1235466" style="font-weight:bold;" target="_blank" title="Click to know more about SUPPOSED">SUPPOSED</a> to capture, then such a state is calledin <a href="https://interviewquestions.tuteehub.com/tag/consistent-424867" style="font-weight:bold;" target="_blank" title="Click to know more about CONSISTENT">CONSISTENT</a> state.</p></body></html> | |
| 46. |
The relationship between DEPARTMENT and EMPLOYEE is a(a) One-to-one relationship(b) One-to-many relationship(c) Many-to-many relationship(d) Many-to-one relationshipThe question was posed to me during a job interview.My question is from The Atomic Data Models and Business Models in division Planning Oracle Applications of Oracle |
| Answer» <html><body><a href="https://interviewquestions.tuteehub.com/tag/right-1188951" style="font-weight:bold;" target="_blank" title="Click to know more about RIGHT">RIGHT</a> choice is (<a href="https://interviewquestions.tuteehub.com/tag/b-387190" style="font-weight:bold;" target="_blank" title="Click to know more about B">B</a>) One-to-many <a href="https://interviewquestions.tuteehub.com/tag/relationship-1183331" style="font-weight:bold;" target="_blank" title="Click to know more about RELATIONSHIP">RELATIONSHIP</a><br/><br/>For explanation: The relationship between <a href="https://interviewquestions.tuteehub.com/tag/department-948402" style="font-weight:bold;" target="_blank" title="Click to know more about DEPARTMENT">DEPARTMENT</a> and EMPLOYEE is aone-to-many relationship.</body></html> | |
| 47. |
A collection of data designed to be used by different people is called a/an(a) Organization(b) Database(c) Relationship(d) SchemaThis question was addressed to me in exam.The origin of the question is The Atomic Data Models and Business Models topic in portion Planning Oracle Applications of Oracle |
| Answer» <html><body><a href="https://interviewquestions.tuteehub.com/tag/right-1188951" style="font-weight:bold;" target="_blank" title="Click to know more about RIGHT">RIGHT</a> answer is (<a href="https://interviewquestions.tuteehub.com/tag/b-387190" style="font-weight:bold;" target="_blank" title="Click to know more about B">B</a>) Database<br/><br/>For <a href="https://interviewquestions.tuteehub.com/tag/explanation-455162" style="font-weight:bold;" target="_blank" title="Click to know more about EXPLANATION">EXPLANATION</a>: A collection of data designed to be <a href="https://interviewquestions.tuteehub.com/tag/used-2318798" style="font-weight:bold;" target="_blank" title="Click to know more about USED">USED</a> by different people is called a data base.</body></html> | |
| 48. |
Which of the following is the oldest database model?(a) Relational(b) Deductive(c) Physical(d) NetworkI got this question in semester exam.My question is taken from The Atomic Data Models and Business Models topic in division Planning Oracle Applications of Oracle |
| Answer» <html><body><a href="https://interviewquestions.tuteehub.com/tag/correct-409949" style="font-weight:bold;" target="_blank" title="Click to know more about CORRECT">CORRECT</a> <a href="https://interviewquestions.tuteehub.com/tag/option-25810" style="font-weight:bold;" target="_blank" title="Click to know more about OPTION">OPTION</a> is (d) <a href="https://interviewquestions.tuteehub.com/tag/network-1114046" style="font-weight:bold;" target="_blank" title="Click to know more about NETWORK">NETWORK</a><br/><br/>Easiest explanation: Network Model is the <a href="https://interviewquestions.tuteehub.com/tag/oldest-585375" style="font-weight:bold;" target="_blank" title="Click to know more about OLDEST">OLDEST</a> database model.</body></html> | |
| 49. |
In order to use a record management system(a) you need to understand the low level details of how information is stored(b) you need to understand the model the record management system uses(c) you need to understandboth information storage and the model of record management system(d) None of the MentionedThe question was asked in an online quiz.This question is from Planning Oracle Applications in section Planning Oracle Applications of Oracle |
| Answer» <html><body><p>The correct <a href="https://interviewquestions.tuteehub.com/tag/answer-15557" style="font-weight:bold;" target="_blank" title="Click to know more about ANSWER">ANSWER</a> is (b) you need to <a href="https://interviewquestions.tuteehub.com/tag/understand-720010" style="font-weight:bold;" target="_blank" title="Click to know more about UNDERSTAND">UNDERSTAND</a> the model the <a href="https://interviewquestions.tuteehub.com/tag/record-1180336" style="font-weight:bold;" target="_blank" title="Click to know more about RECORD">RECORD</a> management system uses<br/><br/>The best <a href="https://interviewquestions.tuteehub.com/tag/explanation-455162" style="font-weight:bold;" target="_blank" title="Click to know more about EXPLANATION">EXPLANATION</a>: For get to know the RMS (Record Management System) you should know the <a href="https://interviewquestions.tuteehub.com/tag/flow-993213" style="font-weight:bold;" target="_blank" title="Click to know more about FLOW">FLOW</a> and of model and record management system.</p></body></html> | |
| 50. |
Which of the following statements concerning business rules is true?(a) It should be complex.(b) It should not be convertible to computer code.(c) It may include restrictions.(d) All of the MentionedThis question was addressed to me during an online exam.The query is from Planning Oracle Applications topic in portion Planning Oracle Applications of Oracle |
| Answer» <html><body><p>The correct <a href="https://interviewquestions.tuteehub.com/tag/choice-915996" style="font-weight:bold;" target="_blank" title="Click to know more about CHOICE">CHOICE</a> is (c) It may include restrictions.<br/><br/>For explanation I <a href="https://interviewquestions.tuteehub.com/tag/would-3285927" style="font-weight:bold;" target="_blank" title="Click to know more about WOULD">WOULD</a> say: According to the business rule it <a href="https://interviewquestions.tuteehub.com/tag/always-373607" style="font-weight:bold;" target="_blank" title="Click to know more about ALWAYS">ALWAYS</a> may include restrictions.</p></body></html> | |