GeekInterview.com
  I am new, Sign me up!
 

RDBMS Questions and Answers


 Sponsored Links

 
 RDBMS Questions and Answers - Page 4
Sorting Options :  

if we are using more business reules or more transformations then it is called complex mapping. If we have flat files then we use the flat as a sourse or we can take relational sources depends on the availability. ...
Read Answers (1) | Asked by : brahamaiah.g
Category: Informatica   Tags : RDBMS

Hi All, How do i run the otrcsvr.sql file in Oracle9i, it is suppose to be available in @$ORACLE_HOME/rdbms/admin; But its is not present in that folder. Can i use another script on Oracle 9i to achieve the same ?Regards,Ashish
Category: Oracle   Tags : RDBMS

 Julia Fractals Inc. is building a J2EE based application for Order Entry and management of their fractal software. Once the order is taken, it is submitted to a relational database. A provisioning system then queries data and makes appropriate calls to various subsystems using JMS on MQ Series. What design pattern is JMS an example of here? A             ObserverB             
 Choice D is correct. Bridge (GOF 151)"Decouple an abstraction from its implementation so that the two can vary independently." In this case JMS is the abstraction. The implementation 
Category: 310-051   Tags : RDBMS

Within 18 months, the customer will be moving all of their legacy data to a relationaldatabase in MSSQL server. The application needs to be implemented prior to this data conversion.You want to design this application to minimize effects of future data conversion and minimizedevelopment time. How should you do this?(A) Build a separate application for each database platform(B) Build applicationsetup SQL server to link to the legacy data via attached table.Replace the table later with native SQL
Category: 070-176   Tags : RDBMS

Your VB application uses ADO to interact with a relational database. Users require theability to update and browse records. You have an existing connection object named cndevserverand recordset object named rscustomers. You want to create a recordset. Which code fragmentshould you use?(A) rscustomers.open("select from tbicustomers", cndevserver, adopendynamic)(B) set rscustomers = cndevserver. Execute ("select from tbicustomers", adopenkeyset)*(C) rscustomers.open "select
Category: 070-176   Tags : RDBMS

Your Visual Basic application uses ADO to interact with a relational database. Users require the ability to update and browse records. You have an existing Connection object named cnDevServer and a Recordset object named rsCustomers. You have to create a recordset. Which code fragment should you use? A. rsCustomers.Open "Select * from tblCustomers", _ cnDevServer, adOpenDynamic, _ adLockOptimistic B. Set rsCustomers= cnDevServer.Execute_ "Select @* from tblCustomers"
Answer: A.  
Category: 070-176   Tags : RDBMS

You are building a Visual Basic application for a large corporation. The customer currently uses a flat-file legacy database. Within 18 months, the customer will be moving all of their data to a relational database in Microsoft SQL server. The application needs to be implemented prior to this data conversion. You want to design this application to minimize effects of future data conversion and to minimize development time. How should you do this? A. Implement a set of COM components
Answer: A.  
Category: 070-176   Tags : RDBMS

Inaccu Weather has a web site where people can check the weather forecast of a city for up to five days in advance. The data comes to Inaccu Weather through a specialized custom feed that directly updates a relational database. If the company can expect between fifty to hundred concurrent hits in to their site, which of the following Java based technologies may be best suited for their needs?A Servlets and JSP for presentation and Session Beans with DAO for retrieval. B Servlets and JSP
Answer: E  
Category: 310-051   Tags : RDBMS

Megasoft Corporation has a old application that uses a legacy database. Recently Megasoft made a decision to develop the front-end code for the application using the Java Applet technology. At this time however, Megasoft is not interested migrating its data to a relational database. In the order of importance, which of the following may be the best approach to connect to the legacy database.A JDBC-Bridge, Database Middleware, JDBC B Database Middleware, JDBC-ODBC bridge, JDBC C JDBC, Database
Answer: D 
Category: 310-051   Tags : RDBMS

Julia Fractals Inc. is building a J2EE based application for Order Entry and management of their fractal software. Once the order is taken, it is submitted to a relational database. A provisioning system then queries data and makes appropriate calls to various subsystems using JMS on MQ Series. What design pattern is JMS an example of here?A Observer B Mediator C Adapter D Bridge E Visitor
Answer: D 
Category: 310-051   Tags : RDBMS

View page << Previous 1 2 3 [4] 5 6 Next  >>

Ask A Question
Go Top
 Sponsored Links

 
Expert Members
# User Name Count
1mathan_vel 408
2sudhakar2068 390
3srinivasulub1981 380
4sahu 323
5jainbrijesh 283
6sampra 278
7samiksc 231
8Sujatars 206
9Beena 194
10G.D.S.Prasad 191
Subscribe
Get Latest Updates Via RSS Reader or by Email
 Forum Discussion Subscribe to Forum Discussions Via E-Mail Latest Forum Discussions Subscribers
 Knowledge Base Subscribe to Knowledge Base Series Via E-Mail Knowledge Base Subscribers
 Learning Series Subscribe to GeekInterview Learning Series Via EMail Learning Series Subscribers
 Freelance Jobs Subscribe to GeekInterview Freelance Jobs Via EMail Latest Freelance Jobs Subscribers
 GeekInterview Blog Subscribe to GeekInterview Blog Via EMail GeekInterview Blog Subscribers
 Testing Interview Questions Subscribe to Testing Interview Questions Via EMail Testing Interview Questions Subscribers
 Oracle Interview Questions Subscribe to Oracle Interview Questions Via EMail Oracle Interview Questions Subscribers
 Java Interview Questions Subscribe to Java Interview Questions Via EMail Java Interview Questions Subscribers
 Latest Placement Papers Subscribe to Latest Placement Papers Placement Papers Subscribers
 Free Training Subscribe to Free Training Via EMail Free Training Subscribers
 Learn AJAX Subscribe to AJAXwith.com Via EMail AJAXwith Subscribers
Sponsored Links

 
About Us -  Privacy Policy -  Terms and Conditions -  Contact -  Ask Question -  Propose Category -  Site Updates 

Copyright © 2005 - 2009 GeekInterview.com. All Rights Reserved

Page copy protected against web site content infringement by Copyscape