Correct Answer: These are the essential items that are present each time an Android project is created: - AndroidManifestxml - buildxml - bin/ - src/ - res/ - assets/
2. 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
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
5. What is the difference between Listview and Treeview?
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
6. 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
8. Can you give few examples of final classes defined in Java API?