1. MS Access International Characters
2. How to migrate the MS access to Oracle?
3. How to write script using Database
4. How does Microsoft Access database recover free space?
5. Explain dynasets in MS Access
6. How do you remodel an existing Access database ?
7. What is Replication Manager?
8. how to insert and retrive images on MSACCESS using java
9. How to share a Microsoft Access database across a network?
10. What are the steps to be taken for improving performance in Microsoft Access database?
11. How to run a query using macro in Microsoft Access database?
12. What are the differences between Table queries and Select queries in Microsoft Access database?
13. What are the ways to ways to run queries in Microsoft Access database?
14. How can Parameters be added to a query in Microsoft Access database?
15. What are the query types available in Microsoft Access database?
16. What is the way for summing up a column in a table in Microsoft Access database?
17. How can one get the deleted records in Microsoft Access database?
18. How can one implement the concept of triggers in Microsoft Access database?
19. What are the levels in which data validation can be done in Microsoft Access database?
20. What are the steps to be taken for changing the title of the Microsoft Access title bar?
21. How to spell check a field in Microsoft Access database?
22. What are the steps to be taken for repairing a corrupted Design Master?
23. What is the approach or method for implementing user-level security with replication in Microsoft Access database?
24. What are the objects present in the table MsysObjects of Microsoft Access database?
25. What are the steps for setting referential integrity between two tables present in the Microsoft Access database?
26. What is the way for finding out whether a table exists in the Microsoft Access database?
27. what are the advantages of an access database over an oracle database?
28. What is an Index, Primary Key and Foreign Key? When do one use index?
29. What are superior keys?How are they diferent from candidate keys
Data Access Interview Questions
1. How can Restrict the row through View.
2. How to find that when and which record inserted in the table ? Read / Answer
3. Define Transaction ?
4. How we can transform the columns of a table in rows ?
5. I am running a queue handler process which polls oracle table at a particular frequency. After some 'n' number of polls oracle drops connection, where n is very large integer value. Can any one reason out, why oracle drops the connection.
6. How do you connect Lotus Notes to Oracle Database using ODBC
7. how to choose between indexing and partitioning , to make query faster.
8. how to add data from excel sheet to oracle database?
9. What does COMMIT do ?
10. What is the function of Optimizer ?
11. What is Execution Plan ?
12. When does a Transaction end ?
13. What is SAVE POINT ?
14. What does ROLLBACK do ?
15. There is a field of type character in the table, but we are storing numeric values like (Roll number) in this field, so if we want to sort the field (in java) according to numbers.How?
16. can we delete tuples in a table based on date column? And how?
17. What is Read-Only Transaction ?
18. What are the values that can be specified for OPTIMIZER MODE Parameter ?
19.What are the different approaches used by Optimizer in choosing an execution plan ?
20. What are the factors that affect OPTIMIZER in choosing an Optimization approach ?
22. What is the effect of setting the value "CHOOSE" for OPTIMIZER_GOAL, parameter of the ALTER SESSION Command ?
23. What is the effect of setting the value "ALL_ROWS" for OPTIMIZER_GOAL parameter of the ALTER SESSION command ?
24. What is RULE-based approach to optimization ?
25. What is COST-based approach to optimization ?
2. How to migrate the MS access to Oracle?
3. How to write script using Database
4. How does Microsoft Access database recover free space?
5. Explain dynasets in MS Access
6. How do you remodel an existing Access database ?
7. What is Replication Manager?
8. how to insert and retrive images on MSACCESS using java
9. How to share a Microsoft Access database across a network?
10. What are the steps to be taken for improving performance in Microsoft Access database?
11. How to run a query using macro in Microsoft Access database?
12. What are the differences between Table queries and Select queries in Microsoft Access database?
13. What are the ways to ways to run queries in Microsoft Access database?
14. How can Parameters be added to a query in Microsoft Access database?
15. What are the query types available in Microsoft Access database?
16. What is the way for summing up a column in a table in Microsoft Access database?
17. How can one get the deleted records in Microsoft Access database?
18. How can one implement the concept of triggers in Microsoft Access database?
19. What are the levels in which data validation can be done in Microsoft Access database?
20. What are the steps to be taken for changing the title of the Microsoft Access title bar?
21. How to spell check a field in Microsoft Access database?
22. What are the steps to be taken for repairing a corrupted Design Master?
23. What is the approach or method for implementing user-level security with replication in Microsoft Access database?
24. What are the objects present in the table MsysObjects of Microsoft Access database?
25. What are the steps for setting referential integrity between two tables present in the Microsoft Access database?
26. What is the way for finding out whether a table exists in the Microsoft Access database?
27. what are the advantages of an access database over an oracle database?
28. What is an Index, Primary Key and Foreign Key? When do one use index?
29. What are superior keys?How are they diferent from candidate keys
Data Access Interview Questions
1. How can Restrict the row through View.
2. How to find that when and which record inserted in the table ? Read / Answer
3. Define Transaction ?
4. How we can transform the columns of a table in rows ?
5. I am running a queue handler process which polls oracle table at a particular frequency. After some 'n' number of polls oracle drops connection, where n is very large integer value. Can any one reason out, why oracle drops the connection.
6. How do you connect Lotus Notes to Oracle Database using ODBC
7. how to choose between indexing and partitioning , to make query faster.
8. how to add data from excel sheet to oracle database?
9. What does COMMIT do ?
10. What is the function of Optimizer ?
11. What is Execution Plan ?
12. When does a Transaction end ?
13. What is SAVE POINT ?
14. What does ROLLBACK do ?
15. There is a field of type character in the table, but we are storing numeric values like (Roll number) in this field, so if we want to sort the field (in java) according to numbers.How?
16. can we delete tuples in a table based on date column? And how?
17. What is Read-Only Transaction ?
18. What are the values that can be specified for OPTIMIZER MODE Parameter ?
19.What are the different approaches used by Optimizer in choosing an execution plan ?
20. What are the factors that affect OPTIMIZER in choosing an Optimization approach ?
22. What is the effect of setting the value "CHOOSE" for OPTIMIZER_GOAL, parameter of the ALTER SESSION Command ?
23. What is the effect of setting the value "ALL_ROWS" for OPTIMIZER_GOAL parameter of the ALTER SESSION command ?
24. What is RULE-based approach to optimization ?
25. What is COST-based approach to optimization ?
No comments:
Post a Comment