Discussion
Home ‣ Interview ‣ Technology Comments
- Question
State the difference between View and Materialized View ?
- Correct Answer
- The main differenc between View and Materialized View states that - 1 View means it stores the SQL statement in the database and let you use it as a table Everytime you access the view, the SQL statement executes 2 Materialized view means it stores the results of the SQL in table form in the database SQL statement only executes once and after that everytime you run the query, the stored result set is used Advantage include quick query results
- 1. What items are important in every Android project? Discuss
- 2. When should we use container classes instead of arrays? Discuss
- 3. What is meaning of following declaration? int(*p[5])();
Options- A. p is pointer to function.
- B. p is array of pointer to function.
- C. p is pointer to such function which return type is array.
- D. p is pointer to array of function. Discuss
- 4. Which object is create by UIApplicationMain function at app launch time? Discuss
- 5. What is Interpreter in Java? Discuss
- 6. What does BUS Schema means ? Discuss
- 7. Define "Correlated Subqueries" ? Discuss
- 8. What is the difference between Listview and Treeview? Discuss
- 9. What is the difference between dao,rdo and ado explain simply ? Discuss
- 10. What is SQL*Plus? Explain its features Discuss
Technology problems
Search Results
Correct Answer: These are the essential items that are present each time an Android project is created: - AndroidManifestxml - buildxml - bin/ - src/ - res/ - assets/
Correct Answer: It is advisable to use container classes of the STL so that you don?t have to go through the pain of writing the entire code for handling collisions, making sure its working well, testing it repeatedly with an overhead of time consumption Suppose you have some data that has values associated with strings and its fields consist of grades> in this situation you can directly use hash table instead of having it created by yourself
Correct Answer: p is array of pointer to function.
Correct Answer: The app delegate object is created by UIApplicationMain function at app launch time The app delegate object's main job is to handle state transitions within the app
Correct Answer: An Interpreter is a program that reads in as input a source program, along with data for the program, and translates the source program step by step The Java interpreter decodes each lines bytecode and runs a series of machine instructions for that bytecode The JVM takes the byte code and generates machine code The byte code is compiled to machine code, and the machine code is executed
Correct Answer: BUS Schema is composed of a master suite of confirmed dimension and standardized definition if facts
Correct Answer: In a SQL Database, a 'correlated subquery' is a kind of sub query yet connected subquery is dependent on another query for a value that is returned In case of execution, the sub query is executed first and afterwards the correlated query will be executed
Correct Answer: Tree view control is designed to display data that is hierarchical in nature, such as organization trees, the entries in an index, the files, directories on a disk It is often used in conjuction with the List view control, which is used to display the contents of the folder selected in the tree view List view control displays data as listitem objects The control excels at representing subsets of data or discrete objectsThe list view property is often used in association with a tree view control
Correct Answer: DAO (Data access object ) is used for accessing data before ado it was used for database installed on same sys where the application resides RDO (Remote data object ) is used for accessing remote data ADO (Active data object ) most powerful till date it is nothing but combination of both DAO and RDO
Correct Answer: SQL*plus allows SQL and PL/SQL scripts to interactively run in command line It allows three kinds of commands to run; SQL, PL/SQL and SQL * Plus commands It?s most commonly used by DBA?s to interact with the oracle database
Comments
There are no comments.More in Interview:
Programming
Copyright ©CuriousTab. All rights reserved.