Interview Questions.

Question 1. What Is Dbase?

Answer :

dBase turned into one of the first database control systems for microcomputers, and the maximum a hit in its day. The dBase gadget consists of the core database engine, a query gadget, a paperwork engine, and a programming language that ties all of these components collectively.

Question 2. What Is A Dbase File?

Answer :

DBF is a record format normally utilized by database software program. DBF stands for DataBase File. DBF documents had been initially used in dBase II and endured thru to dBase Version IV.

Sybase Interview Questions
Question three. How Do You Open A Dbf File?

Answer :

Launch Microsoft Excel. Press "Ctrl-O" or click on on the "File" tab and pick out "Open." Set the "Files of Type" drop-down menu within the Open dialog box to "dBase Files (.Dbf)." Navigate to the area of the database document you need to open.

Question four. What Is A Dbf File Extension?

Answer :

DBF files were at the beginning utilized in dBase II and continued via to dBase Version IV. The DBF report layout originated by means of Ashton-Tate, however is understood by Act!, Clipper,FoxPro, Arago, Wordtech, xBase, and similar database ordatabase-associated products. DBF files also can be opened with the aid of Microsoft Excel and Microsoft Access.

MongoDB Tutorial
Question 5. How Do I Open A Dbf File In Access?

Answer :

Open Access: Click on the Start button, select Programs, Microsoft Office, then click on on Microsoft Access. Select clean database. The "File New Database" window will seem. Select Desktop (or listing in which you stored the .Dbf report) within the "Save in" container at the top of the window.

SSRS(SQL Server Reporting Services) Interview Questions
Question 6. What Are The Instruction To Open A Dbf In Excel?

Answer :

Instructions to open a DBF report in Excel :

Below are simple commands for beginning a DBF document in Excel. For more specific instructions, view Instructions for Opening a Database File in Excel (DOC; 1MB).

Right click on on pubschls.Dbf link and pick out "Save target as." When the "SAVE AS" Window seems, fill inside the 3 bins as directed beneath:    

Save in: Desktop or directory of desire
File Name: pubschls.Dbf  
Save as Type: All
Close the "Download Complete" Window after the record is finished downloading.
Open Excel.
Select File, Open.

In the "Look In" drop down box, select the computer or directory in that you saved the file and in the Files of Type drop down container, pick: All Files (*.*).

Double click on at the report call.The .Dbf document will now open in Excel.

Question 7. What If I Cannot See A List Of Tables With As/400 Iseries Driver Connection?

Answer :

With connection to an iSeries motive force via ODBC….

In the ODBC Administrator - choose to adjust the DSN.
Under the 'Catalog' tab of the 'iSeries get right of entry to for Windows ODBC setup' conversation- there's a setting known as 'Enable seek styles' 
If this putting isn't checked then the tables will not be seen within the 'Databases and Tables' listing in dQuery. 
If this setting is checked (enabled) then you need to see the tables.
Oracle Data Integrator (ODI) Interview Questions
Question eight. How To Create An Odbc Dsn For Dbase File?

Answer :

Click Start -> Control panel -> Administrative gear ->Data assets (ODBC) 
Click ‘Add’, Select ‘Microsoft dBase Driver’ from the motive force listing, Click ‘Finish’. 
A new dialog window will seem, supply a call to Datasource call, eg “Dbase” 
Now take a look at off ‘Use Current Directory’, Click on ‘Select Directory’ and provide the route wherein your dbase file is living. 
Click ‘OK’, Click ‘OK’, Click ‘OK’. 
Now open Crystal Reports.
Click ‘Blank Report ‘, you may see a ‘Database Expert’ conversation field. 
Double click on on ‘ODBC(RDO)’ 
A ‘ODBC(RDO)’ dialog container will appear, pick your DSN from the list. 
Click ‘Finish’ 
Now you may see the ‘Table’ beneath your DSN call. 
Now pick tables you want for reporting. 
Click ‘Finish’.
Question nine. Can Newer Versions Of Crystal Reports Use Level 7 Tables?

Answer :

Users have determined that newer variations of the Microsoft dBASE ODBC Driver (version three.Zero or more recent) may be used to read stage 7 tables in more recent versions of Crystal Reports. (Even although it isn't always 'officially' mentioned as such.)

Therefore you ought to be capable of use the Microsoft dBASE ODBC Driver to connect with facts via Crystal Reports.

Before growing a DSN to your Dbase tables, please ensure that your ODBC Driver is 3.0 or higher.

Oracle RAC/ASM Interview Questions
Question 10. How To Check The Odbc Driver Version?

Answer :

Start -> Control panel -> Administrative tools ->Data assets (ODBC) -> ‘Driver’ Tab.

 From the ODBC Administrator (the same conversation that configures your datasource),

pick out the "Drivers" tab.
Highlight the "Microsoft dBase Driver"
The version column lists the modern model as a 4 component range. Leading zeros in every part are not large.
Question eleven. How To Get Dquery Or Dbase (or Their Installers) To Run On Windows 2003 Server?

Answer :

Log on as system admin and trade the Data Execution Prevention on for "All packages and services except those I pick" after which add the name of every executable to the list. For instance ... Plusrun.Exe, plus.Exe, dQuery.Exe., (or for the installers plus-setup.Exe or dqsa-setup.Exe)

Steps :

Right-click on on "My Computer" and pick the Properties page. 
On the Properties web page, pick the "Advanced" tab, and click on at the "Settings" button within the "Performance" phase. 
On the Performance Options web page, pick out the "Data Execution Prevention" tab. 
Use the "Add" button in this page to add the affected services to the choose out listing. 
Click "OK" on each of the pages when completed and reboot the gadget.
Database Administration Interview Questions
Question 12. What Is Dep (records Execution Prevention)?

Answer :

Data Execution Prevention is a mechanism constructed into a few CPU's to test whether or not or no longer the statistics within a selected chew of reminiscence is tagged as code or as data before permitting any deal with in that chunk of memory to be used by the CPU to execute any commands.

Sybase Interview Questions
Question thirteen. How Can I Export Records With Memo?

Answer :

To export statistics, select menu "File/Save As". You can choose the fields to be exported and specify their order. DBF Viewer permits you export facts with memo to Excel(xls, xlsx), CSV, TXT, XML, SQL and HTML file formats.

Question 14. How Can I Edit A Memo Field?

Answer :

To edit a memo field, choose file within the list and double-click at the "Memo". Memo editor permits you view, edit, print and export to text record.

Question 15. How Can I Edit A Dbf File?

Answer :

To edit a dbf document, choose report in the listing and double-click or press Enter

Oracle GoldenGate Interview Questions
Question 16. What Is The History Of Dbase?

Answer :

DBase records may be traced again to 1978, while it turned into created with the aid of Wayne Ratliff and to start with named the "Vulcan." In the Nineteen Eighties, Ashton-Tate purchased Vulcan and advertised it as DBase II, that's taken into consideration to be the first DBase model.

Question 17. What Is The File Extension Od Dbase File?

Answer :

.Dbf

MongoDB Interview Questions
Question 18. How To Repair Corrupted Dbf Files?

Answer :

DBF Recovery empowers its users with the potential to get better a damaged database back to its pristine situation while not having the understanding to perform the sort of venture or requiring the extra fee of employed healing offerings. When this system runs, you see a simple interface with  primary fields. Select the report for healing within the first discipline and the folder for the output inside the second.

As an added choice, you may pick to recover deleted information in the database. Once the entirety is ready, you click on on the Start button. DBF Repair Tool does the rest. It maintenance the headers and records systems in an automatic process that includes no interplay with the user. After all you could not need to sit round and watch the procedure. With DBF Recovery, you'll sincerely have a lean, mean DBF repairing system with out practical fluff.

SSRS(SQL Server Reporting Services) Interview Questions
Question 19. What Is Code Signing?

Answer :

dBASE Plus, starting with model 2.61.Four, supports jogging utility exe's which have been code signed.

Code Signing is a way of figuring out who the writer of an executable record is and ensuring that the record has no longer been altered given that publication.

It works via including a digital signature to the give up of an executable file which can then be checked at runtime for its authenticity.

A digital signature consists of a virtual certificates at the side of a publisher's public key that has been issued by way of a certification authority (inclusive of VeriSign, Thawte, or Comodo). A part of the digital certificates is encrypted using the publisher's personal key.

Question 20. Can Dbase Compile Visual Foxpro Source Code?

Answer :

Most of the vintage XBASE instructions that run on VFP will even run on dBASE besides in cases where FoxPro diverged from the dBASE syntax or invented new syntax.

However, the more recent object orientated functions in VFP, together with Forms, Entryfields, PushButton's and many others are very one-of-a-kind from the equivalent dBASE capabilities.

At this time there are no conversion equipment to be had to convert from VFP to dBASE Plus.

However, we've compiled 3 text documents that display how Visual FoxPro commands map to dBASE Plus. 

VFP2dBMatchingCmd.Txt - incorporates a listing of VFP commands whose names map to exact or almost precise dBASE Plus equivalents
VFP2dBEquivCmd.Txt - incorporates a list of VFP commands that may be treated in another way in dBASE Plus. The second column suggests a way to search for the dBASE Plus equivalent.
VFP2dBNoMatch.Txt - carries a listing of VFP commands that don't have a close equal in dBASE Plus.
Some of these gadgets can be replicated in dBASE through the use of upload-on libraries or with the aid of custom coding.

Oracle Data Guard Interview Questions
Question 21. Why, In Xp, Are Some Form Object's Colornormal Properties Being Ignored?

Answer :

The XP show up report is used to have your shape objects seem like the new XP not unusual controls. Because of this, pushbuttons; rectangles; notebooks and likely different objects have their colour settings all or in part overwridden.

The pushbutton has a belongings called systemTheme which when set to false (the default is true) will ignore the take place document and use the antique common controls thereby permitting the color settings to show.

Question 22. How Can We Import Data From Widespread File Formats?

Answer :

Use integrated import wizard for uploading statistics from xls, txt, csv, xlsx, xml, dbf file codecs.

Question 23. Why Is Table Structure Designer Used?

Answer :

You can easy add, rename, and delete fields for your dbf files by means of using table structure designer.

Sql Server Dba Interview Questions
Question 24. Write About .Ndx, .Cdx, .Ntx, .Mdx Index Files?

Answer :

The .Cdx, .Mdx, .Ndx, .Ntx index files include and preserve guidelines to statistics within the desk (.Dbf) document and is prepared in line with the index key values. An index document is cut loose but related to a .Dbf report. So, you ought to open a .Dbf record first of all after which associated index record(s) if wanted.

Unlike .Cdx/.Mdx documents that open mechanically whilst the related desk is opened, you have to open a .Ndx/.Ntx document explicitly using program's Index Manager dialog container (File->Index manager menu item).

Index documents are most effective applicable for looking in the DBF - you surely do not need them (i.E. You CAN examine the .Dbf records report with out the index document). Removing the index record would possibly break you utility though.

Oracle Data Integrator (ODI) Interview Questions
Question 25. How Can We Generate Powerful Enterprise-stage Reports?

Answer :

The business customers can use the visual file clothier (with a entire set of format and design controls), to layout exceedingly formatted, interactive, and professional looking reports. Reports can be exported and repurposed to the electronic formats utilized by maximum stop users (e.G. PDF and Excel).