-
-
-
Names of Constraints
Oracle stores information regarding the names of all the constraints on which table? A)USER_CONSTRAINTS B)DUAL C)USER D)None of these
-
-
Degree of Relationship
What is the degree of relationship? Name the three degrees.
-
Indexes Searching Capabilities
How do indexes increase the searching capabilities?
-
Intersection table
What is an intersection table and why is it important?
-
-
-
Starting oracle services on vmware
Hi, I am starting oracle services on redhat linux ,
but unable to start " sql * plus service" from console as well as from em(oracle enterprise manager)
Error : "The connection was refused when attempting to contact localhost : 5560"
-
What kind of a query is this? How does it work?
Hi, I recently tried to get employee names and their dept names without a join condition, this query, although succeeds, I can't figure how it works. please help.
select ename,(select dname from dept where deptno=e.deptno) from emp e; -
Integrity Rules
List the rules used to enforce table level integrity.
-
Error Trapping Functions
Functions for error trapping are contained in which section of a PL/SQL block?
-
Requirement Gathering
Name three activities involved in requirement gathering
-
DDL Operation Trigger
Which types of trigger can be fired on DDL operation?
A. Instead of triggerB. DML triggerC. System triggerD. DDL trigger -
-
-
Entity Relationship
Explain a one-to-many strong vs. one-to-many weak entity relationship.
-
Using examples differentiate between a DBMS, RDBMS and a Distributed database
Been given this question from my son and he has told me that he googled the question but got no satisfactory answer. Would much appreciate an answer.
-
Database Interview Questions
Sub Category
Questions
Answers
Last Updated
Ans