|
Question |
Rating |
View Answer |
|
What does COMMIT do ? |
|
View Answer |
|
Explain what do you mean by Queries? |
|
View Answer |
|
What is Read-Only Transaction ? |
|
View Answer |
|
Define Transaction ? |
|
View Answer |
|
What is the function of Optimizer ? |
|
View Answer |
|
Name some of the file extension for MS Access? |
|
View Answer |
|
Can we delete tuples in a table based on date column? And how?
|
|
View Answer |
|
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?
|
|
View Answer |
|
Explain how you can import data from other sources into Access database? |
|
View Answer |
|
What is Execution Plan ? |
|
View Answer |
|
What things to be taken in consideration for lookup fields? |
|
View Answer |
|
Explain how you can export data in Excel format? |
|
View Answer |
|
What is the effect of setting the value "CHOOSE" for OPTIMIZER_GOAL, parameter of the ALTER SESSION Command ? |
|
View Answer |
|
What are the values that can be specified for OPTIMIZER MODE Parameter ? |
|
View Answer |
|
What are the values that can be specified for OPTIMIZER_GOAL parameter of the ALTER SESSION Command ? |
|
View Answer |
|
Explain what are Joins and how you can open the database in Access? |
|
View Answer |
|
What is COST-based approach to optimization ? |
|
View Answer |
|
What does ROLLBACK do ? |
|
View Answer |
|
Explain how you can create a table using MAOL (Microsoft Access Object Library)? |
|
View Answer |
|
Explain the use of WHERE clause in MS Access SQL? |
|
View Answer |