- World's Largest Collection of Interview Questions & Answers, FAQs, queries, sample papers, exam papers, dumps, what, why, how, where, when questions
Our Services
Get 9,000 Interview Questions & Answers in an eBook.

Get it now !!
Send your Resume to 6000 Companies
Data Access Interview Questions & Answers - Learning Mode

Data Access Interview Questions & Answers - Learning Mode

Data access typically refers to software and activities related to storing, retrieving, or acting on data housed in a database or other repository. Oracle Data Provider for .NET (ODP.NET) features optimized ADO.NET data access to the Oracle database. ODP.NET allows developers to take advantage of advanced Oracle database functionality, including Real Application Clusters, XML DB, and self-updating client caches.

Try Data Access Interview Questions & Answers - Exam Mode

1 2 Next

Sort By : Latest First | Oldest First | By Rating

Data Access Interview Questions & Answers - Learning Mode
Try Data Access Interview Questions & Answers - Exam Mode
Question: What does COMMIT do ?

Answer: COMMIT makes permanent the changes resulting from all SQL statements in the transaction. The changes made by the SQL statements of a transaction become visible to other user sessions transactions that start only after transaction is committed. Source:
Question: Explain what do you mean by Queries?

Answer: Queries are the medium of manipulating the data to display in the form or report. Queries can join tables, update data, delete data, sort, calculate, filter, etc. Source:
Question: Define Transaction ?

Answer: A Transaction is a logical unit of work that comprises one or more SQL statements executed by a single user. Source:
Question: What is Read-Only Transaction ?

Answer: A Read-Only transaction ensures that the results of each query executed in the transaction are consistant with respect to the same point in time. Source:
Question: What is the effect of setting the value "CHOOSE" for OPTIMIZER_GOAL, parameter of the ALTER SESSION Command ?

Answer: The Optimizer chooses Cost_based approach and optimizes with the goal of best throughput if statistics for atleast one of the tables accessed by the SQL statement exist in the data dictionary. Otherwise the OPTIMIZER chooses RULE_based approach. Source:
Question: Name some of the file extension for MS Access?

Answer: Some of the file extension for MS Access are:-

Access database.accdb
Access project.adp
Access project.mdw
Access blank project template.adn
Access workgroup.mdw
Protected access database.accde Source:
Question: Explain how you can import data from other sources into Access database?

Answer: To import data into Access data-base

In the main menu, click on EXTERNAL DATA, in the Import and Link group
Choose the type of the file you want to import
To know which type of file can be import or link Access database, follow the instruction in the Get External Data wizard Source:
Question: Can we delete tuples in a table based on date column? And how?

Answer: Use this SQL query :delete from student_tab A where ROWID > ( select min(ROWID) from student_tab B where A.roll_number = B.roll_number);Note : Table Name = student_tab Key to table = roll_number Source:
Question: Explain how you can export data in Excel format?

Answer: From the toolbar click on the External Data tab
Click Excel on the Export group
It will open the export excel spreadsheet dialog box
Specify the destination of the file name and format
When you click OK, it will export the data to Excel spreadsheet Source:
Question: What things to be taken in consideration for lookup fields?

Answer: Ensure that you relate tables, links, etc. if you want to show look up values and not look up ids. For the display of lookup values, related table should be linked to the destination field. Source:
Question: 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?

Answer: select to_number(rollnumber) from tname order by rollnumber

Question: Explain what are Joins and how you can open the database in Access?

Answer: Joins determines the relationship between tables in Access by stating the details of the relationship between two tables. You can create joins on the database tools tab or by opening a query in design view. Source:
Question: Explain how you can build a relationship between the different databases in Access?

Answer: When you establish a relationship between two data, the first table for your data is referred as the primary key while the new field in another data is called a foreign key. Source:
Question: Explain the use of WHERE clause in MS Access SQL?

Answer: In the WHERE clause of a SELECT statement, you use query criteria. For example, you want to find the address of a particular customer, but you only remember his last name that is Harrison. Instead of searching all the fields in the table, you use where clause to retrieve the address of the customer. Source:
Question: Explain how we can do multi-join query in MS Access?

Answer: In Access, we can only join two tables, in order to join more tables you require to group the first join together by using parentheses, as if it was a newly derived table. After that, you can join another table to that group.




( ( Table 1

LEFT JOIN Table 2?




LEFT JOIN Table4? Source:
Question: What is COST-based approach to optimization ?

Answer: Considering available access paths and determining the most efficient execution plan based on statistics in the data dictionary for the tables accessed by the statement and their associated clusters and indexes. Source:
Question: Explain how you can create a form in Microsoft Access 2013?

Answer: Forms allow to insert data across multiple tables. There are different methods for creating forms but with Form Wizard method, you can always modify the form later using Design View. To create a form

From the main menu, click on CREATE and then choose the FORM option
It will create a new form in Layout view, based on the fields in the Customer table
Scroll the drop down arrow under the View icon and select Form View. This how the user will see the form.
On the form, you will se Source:
Question: What does ROLLBACK do ?

Answer: ROLLBACK retracts any of the changes resulting from the SQL statements in the transaction. Source:
Question: Explain how you can create a table using MAOL (Microsoft Access Object Library)?

Answer: To create a table using MAOL, you have to pronounce a variable of type object and then initialize it with the CreateTableDef() method of the recent database object. This technique takes argument as the name of the table. Source:
Question: What is the function of Optimizer ?

Answer: The goal of the optimizer is to choose the most efficient way to execute a SQL statement. Source:

1 2 Next

India News Network
Latest 20 Questions
Payment of time- barred debt is: (a) Valid (b) Void (c) Illegal (d) Voidable
Consideration is defined in the Indian Contract Act,1872 in: (a) Section 2(f) (b) Section 2(e) (c) Section 2(g) (d) Section 2(d)
Which of the following is not an exception to the rule, "No consideration, No contract": (a) Natural love and affection (b) Compensation for involuntary services (c) Completed gift (d) Agency
Consideration must move at the desire of: (a) The promisor (b) The promisee (c) The promisor or any other party (d) Both the promisor and the promisee
An offer which is open for acceptance over a period of time is: (a) Cross Offer (b) Counter Offer (c) Standing Offer (d) Implied Offer
Specific offer can be communicated to__________ (a) All the parties of contract (b) General public in universe (c) Specific person (d) None of the above
_________ amounts to rejection of the original offer. (a) Cross offer (b) Special offer (c) Standing offer (d) Counter offer
A advertises to sell his old car by advertising in a newspaper. This offer is caleed: (a) General Offer (b) Special Offer (c) Continuing Offer (d) None of the above
In case a counter offer is made, the original offer stands: (a) Rejected (b) Accepted automatically (c) Accepted subject to certain modifications and variations (d) None of the above
In case of unenforceable contract having some technical defect, parties (a) Can sue upon it (b) Cannot sue upon it (c) Should consider it to be illegal (d) None of the above
If entire specified goods is perished before entering into contract of sale, the contract is (a) Valid (b) Void (c) Voidable (d) Cancelled
______________ contracts are also caled contracts with executed consideration. (a) Unilateral (b) Completed (c) Bilateral (d) Executory
A offers B to supply books @ Rs 100 each but B accepts the same with condition of 10% discount. This is a case of (a) Counter Offer (b) Cross Offer (c) Specific Offer (d) General Offer
_____________ is a game of chance. (a) Conditional Contract (b) Contingent Contract (c) Wagering Contract (d) Quasi Contract
There is no binding contract in case of _______ as one's offer cannot be constructed as acceptance (a) Cross Offer (b) Standing Offer (c) Counter Offer (d) Special Offer
An offer is made with an intention to have negotiation from other party. This type of offer is: (a) Invitation to offer (b) Valid offer (c) Voidable (d) None of the above
When an offer is made to the world at large, it is ____________ offer. (a) Counter (b) Special (c) General (d) None of the above
Implied contract even if not in writing or express words is perfectly _______________ if all the conditions are satisfied:- (a) Void (b) Voidable (c) Valid (d) Illegal
A specific offer can be accepted by ___________. (a) Any person (b) Any friend to offeror (c) The person to whom it is made (d) Any friend of offeree
An agreement toput a fire on a person's car is a ______: (a) Legal (b) Voidable (c) Valid (d) Illegal
Cache = 0.007812 Seconds