RDBMS Schema
* Used for OLTP systems
* Traditional and old schema
* Normalized
* Difficult to understand and navigate
* Cannot solve extract and complex problems
* Poorly modelled
DWH Schema
* Used for OLAP systems
* New generation schema
* De Normalized
* Easy to understand and navigate
* Extract and complex problems can be easily solved
* Very good model
How would you write a LEFT JOIN statement to return a result set of movie.title’s and director.name’s?
How do you call a module named “testmod.cfm” with the parameters param1=”yes” and param2=5?
If there are no indices defined on any of the columns in the above two tables, which columns would you index to speed up the LEFT JOIN query?
How would you write a simple stored procedure in TSQL which takes a movie_id and returns all the directors associated with it?
How can you communicate with web server (Apache or IIS) from Coldfusion?
What are the advantages and disadvantages of using stored procedures versus calling SQL inline in Cold Fusion?
How can you clear the cache?
Difference between Cold fusion 5 and Cold fusion MX 6?
What are the advantages of Cold fusion?
What are Session Timeout and Application Timeout? Where we have to do this process?
rendc.org
Whether it is technological solutions or user-oriented innovations, We have put together for you the best sources of HR Interview Questions and Answers, Tech Ideas, and Programming Tutorials."
Get all the latest information on rendc.org
© 2022 | All rights reserved.
RENDC
welcome to www.rendc.org
