Home Discussion Discuss: Ask DBMS Questions online

  • 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?

  • answer pleasejamal August 26, 2011 at 4:38 AM

    i am doing the summer resit in a couple of days and would just like to clarify this answer the quesiton is... Emp (eid: integer, ename: string, age: integer, salary: integer) Works (eid: integer, did: integer, pct_time: integer) Dept (did: integer, budget: real, dname: string, managerid: integer) Write the following queries in SQL: (a) Print/select the names and ages of each employee who works in both the Hardware department and the Software department. MY ANSWER IS SELECT ename, age FROM Emp WHERE DEPT= 'Hardware department' AND 'Software department'; is this correct if not what would the correct answer be? thank you

  • 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

  • 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



Your Name (*) :
Your Email :
Subject (*):
Your Comment (*):
  Reload Image
 
 
Related Articles
General

Ask DBMS Questions online
Ask DBMS Questions online       DBMS stands for Data Base Management System..., Structure Query Language (SQL), Sybase, Ingres, Ask any questions 

SQL Question

Advanced DBMS questions
Advanced DBMS questions   Five company/organization that involves in SQL Server database migration. what is the Transaction Recovery Method. What does Cloud Computing contributes in the RDBMS? Importance 

SQL Question

DBMs - SQL
to do the following thing:- QUESTIONS: Based on the particular case study 

HTML Questions

DBMS
 

SQL Question

DBMS
 

SQL Question

DBMS
 

SQL Question

DBMS
 

Design concepts & design patterns Questions

dbms
 

Java Magazine Questions

dbms
 

SQL Question

DBMS
 

JDBC Questions

DBMS
 

General

Ask Programming Questions Online
Ask Programming Questions Online   ..., Spring questions, Dojo questions, iBatis questions, DBMS questions, SQL questions.... So, feel free and post Java questions, JSP questions, Servlet questions, EJB 

Java Beginners

online quiz
online quiz  Define a Question class which stores a multiple choice... of up to 10 questions. Define the add method of the Quiz class to add a question... approach to populates a quiz, presents it by asking questions randomly 

Design concepts & design patterns Questions

online quiz
online quiz  Define a Question class which stores a multiple choice... of up to 10 questions. Define the add method of the Quiz class to add a question... approach to populates a quiz, presents it by asking questions randomly 

Java Interview Questions

online quiz
online quiz  Define a Question class which stores a multiple choice... of up to 10 questions. Define the add method of the Quiz class to add a question... approach to populates a quiz, presents it by asking questions randomly 

Java Magazine Questions

online quiz
online quiz  Define a Question class which stores a multiple choice... of up to 10 questions. Define the add method of the Quiz class to add a question... approach to populates a quiz, presents it by asking questions randomly 

Java Beginners

online quiz
online quiz  Define a Question class which stores a multiple choice... of up to 10 questions. Define the add method of the Quiz class to add a question... approach to populates a quiz, presents it by asking questions randomly 

Java Beginners

online quiz
online quiz  Define a Question class which stores a multiple choice... of up to 10 questions. Define the add method of the Quiz class to add a question... approach to populates a quiz, presents it by asking questions randomly 

WebSevices Questions

online exam portal
online exam portal  i am thinking of developing a small online exam pattern with multipe choice questions , can u please give me any idea of how to start 

SQL Question

Keys in DBMS
 

SQL Question

Advance DBMS
 

SQL Question

dbms - SQL
 

JDBC Questions

Isolation level is used by the DBMS.
Isolation level is used by the DBMS.  What isolation level is used by the DBMS when inserting, updating and selecting rows from a database 

JSP Servlet Questions

Online performance system
Online performance system  hi m developing Online performance... be created by the system , by automatically selecting the questions from database... an online test thanks vinoy 

JSP Servlet Questions

jsp online exam
jsp online exam  i have designed a html page with 20 multiple choice questions ...options are in radio button for each question .... now i have to retrieve all the selected answers and save it to database match it with correct 

JSP Servlet Questions

online examination system project in jsp
online examination system project in jsp  thanks for providing me 6 tables for online examination system. I want to know what will the id field of Answers1 table contain? Will it contain same id for all the questions of Set1 & 

JSP Servlet Questions

online examination system project in jsp
online examination system project in jsp  thanks for providing me 6 tables for online examination system. I want to know what will the id field of Answers1 table contain? Will it contain same id for all the questions of Set1 & 

JavaScript Questions

JAVASCRIPT FOR ONLINE QUIZ
JAVASCRIPT FOR ONLINE QUIZ  i m creating a set of online questionnaire consist of 12 questions with choice of answers from 0-6.i've done creating... want to use get element by id function to read the score.if any questions 

EJB Questions

Online Examination System
Online Examination System  Hi.. I have to create a Online Examination system using struts, Hibernate and stateful session beans.. I Wanna know... to add/edit/delete questions and users. System should be able to provide proper 

Programming Questions

Software Questions and Answers
; View Software Questions and Answers online Discuss Software development questions, ask your questions and get answers online. Here you can... programming problems. Ask Questions | Browse Latest Questions 

DMCA.com