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: 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
3. What items are important in every Android project?
Correct Answer: These are the essential items that are present each time an Android project is created: - AndroidManifestxml - buildxml - bin/ - src/ - res/ - assets/
4. When should we use container classes instead of arrays?
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
5. 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.
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
7. What is the difference between dao,rdo and ado explain simply ?
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
9. Can you give few examples of final classes defined in Java API?