Home
Discussion
Discuss: Ask DBMS Questions online
Tutorial Topics
Questions by Category
- Swing-AWT
- Date-Calendar
- JDBC
- Regex
- XML
- Security
- Java Server Faces Questions
- JSP Servlet
- EJB
- JavaMail
- JMS
- Java3D
- Log4J
- Spring
- Hibernate
- Maven
- IDE Questions
- Mobile Applications
- Ajax
- Framework
- Struts
- WebSevices
- Java Magazine
- JSP-Interview Questions
- Java Interview Questions
- Servlet Interview Questions
- Hibernate Interview Questions
- JUNIT
- Java Beginners
- Applet
- JNDI
- RMI
- LDAP
- RUP
- UML
- SQL
- Design concepts & design patterns
- Ant
- CVS
- Subversion
- Development process
- AOP
- IoC
- PHP
Services
Home Privacy Policy
© All Rights are Reserved for Rose India
- Website Development
- Web Designing
- Web Redesigning
- Web Development
- Logo Design
- Web Design Packages
- Domain Registration
- Web Promotion Services
- SEO Services
- Search Eng. Optimization
- Search Eng. Submission
- SEO Tips
- SEO Portfolio
- Web Promotion Plans
Home Privacy Policy
© All Rights are Reserved for Rose India
DBMS querieskrishna June 21, 2011 at 10:26 AM
Please sir, Reply for these........ 1. Is there any compiler or interpreter in oracle which checks for any error in query or others. 2. Any data automatically resulted in Tabular form, who manages in? 3. How data is retrieved, is there any channel or driver?
normalisationsueresh February 10, 2013 at 6:32 PM
how functional dependency works......what it's effect on the normalisation....
quespuru December 11, 2011 at 3:31 PM
how to delete row of table
DxJiJINiFBIyRWZOLpkAddy March 6, 2013 at 8:56 AM
Kudos to you! I hadn't thuoght of that!
DBMSPRASANTH March 4, 2012 at 8:03 PM
(1) Competition (Comp_code, Comp_name (Dancing, Painting, GK, etc.) ) Participants (Part_no, Part_name, DOB, Address, EmailID, Contact_number ) Scorecard (Part_no, Comp_code, Judge_no [1, 2, 3], Marks) Implement the following: A) 1. Find those participants who have registered both for ‘Dancing’ and ‘Painting’ (Note: Use set operator). 2. Find the average score, scored in each competition event. B) Create a PL/ SQL block to prepare report in following format. Display the score card in the following format, for the Participant whose ID/ Name should be provided by the user. Talent Winner 2011 ::: <Participant’s Name> -------------------------------------------------------------------------------------------- Competition name Judge1 Judge2 Judge3 -------------------------------------------------------------------------------------------- 1. Painting 2. Dancing -------------------------------------------------------------------------------------------- Total Marks: _______ --------------------------------------------------------------------------------------------
dbmsprasanth_saseendran March 4, 2012 at 8:09 PM
PL/SQL Practical List: (1) Competition (Comp_code, Comp_name (Dancing, Painting, GK, etc.) ) Participants (Part_no, Part_name, DOB, Address, EmailID, Contact_number ) Scorecard (Part_no, Comp_code, Judge_no [1, 2, 3], Marks) Implement the following: A) 1. Find those participants who have registered both for ‘Dancing’ and ‘Painting’ (Note: Use set operator). 2. Find the average score, scored in each competition event. B) Create a PL/ SQL block to prepare report in following format. Display the score card in the following format, for the Participant whose ID/ Name should be provided by the user. Talent Winner 2011 ::: <Participant’s Name> -------------------------------------------------------------------------------------------- Competition name Judge1 Judge2 Judge3 -------------------------------------------------------------------------------------------- 1. Painting 2. Dancing -------------------------------------------------------------------------------------------- Total Marks: _______ --------------------------------------------------------------------------------------------
BCNFprashant170392 March 21, 2012 at 7:36 PM
R = (A, B, C ) F = {A -> B, B -> C} Key = {A} Is R in BCNF? Please explain too
DBMSdeepti mishra April 8, 2012 at 6:34 PM
please tell me the exaples of transaction recovery
DBMSdeepti April 8, 2012 at 6:37 PM
transaction recovery
pls give queries sir...priya April 12, 2012 at 10:09 PM
please sir.. give queries for the following question sir... pname(varchar),splace(varchar),course(varchar),ccost(number) 1.display the names of those who have done the PGDCA course.
heyhari April 19, 2012 at 9:14 AM
sir,iam studying B.tech second year currently in india.My teachers and others suggest me Oracle9i which is not available any more ,as it is currently ORCALE 10G i want to execute the queries in some or other software .can u please suggest me one very fast
ER DIAGRAMvibhas singh December 1, 2012 at 6:41 PM
I NEED THE SOLUTIO FOR THIS PLZ HELP ME Identify all entity types, attributes, relationship types and in the following case. Hence draw an entity-relationship diagram. An organization makes many models of cars, where a model is characterized by a name and a suffix (such as GL or XL which indicates the degree of luxury) and an engine size. Each model is made up from many parts and each part may be used in the manufacture of more than one model. Each part has a description and an id code. Each model of car is produced at just one of the firm's factories, which are located in London, Birmingham, Bristol, Wolverhampton and Manchester - one in each city. A factory produces many models of car and many types of part although each type of part is produced at one factory only.
Post your Comment