All Free Software Engineering MCQs with Answers

• A. Type-1 driver
• B. Type-2 driver
• C. Type-3 driver
• D. Type-4 driver

Explanation: A Type-4 JDBC driver is written entirely in Java and communicates directly with the database, avoiding native libraries or an intermediate…

• A. getConnection()
• B. executeQuery()
• C. prepareCall()
• D. executeUpdate()

Explanation: `getConnection()` is the JDBC method used to obtain a database connection and is exposed as a static method through `DriverManager`.

• A. The DataSet schemas must match in order to merge
• B. The destination DataSet must be empty prior to merging
• C. A primary key must be defined on the DataTable objects
• D. A DataSet must be merged into the same DataSet that created it.

Explanation: During a merge, a primary key lets ADO.NET match modified source rows with their corresponding destination rows instead of treating them…

• A. DataBind
• B. DataList
• C. Fill( )
• D. Load ( )

Explanation: The DataAdapter's Fill method executes the select operation and places the returned rows into a DataSet or DataTable.

• A. Finds the difference in two objects
• B. Finds the difference in two files
• C. The one which renders the dataset object contents to XML
• D. None of the above

Explanation: A DiffGram is an XML representation of a .NET DataSet that can preserve its data and changes, including original and current values.

• A. Fill( )
• B. Read( )
• C. ExecuteQuery( )
• D. None of these

Explanation: The DataAdapter's Fill() method executes the associated query and loads the returned rows into a DataSet or DataTable.

• A. Character, record, field, file, database
• B. Character, field,record,file,database
• C. Character,file,record,field,database
• D. Database,file,record,field,character

Explanation: Data is organized from smallest to largest as character, field, record, file, and database.

• A. POS
• B. data mining
• C. data conversion
• D. data selection

Explanation: Data mining examines large collections of sales data to discover patterns, customer preferences, and market trends.

• A. System analysis
• B. DBMS
• C. Database
• D. DASD

Explanation: A DBMS is the software package used to create, store, organise, retrieve, and manage databases.

• A. Sequential file
• B. Indexed file
• C. Random file
• D. Serial file

Explanation: An indexed file contains an index that points to records, allowing the system to locate records directly instead of reading every…

• A. EPROM
• B. RAM
• C. ROM
• D. PROM

Explanation: ROM stores data permanently or semi-permanently and normally does not lose it when power is removed.

• A. retrieval technology
• B. input technology
• C. output technology
• D. storage technology

Explanation: Storage technology covers systems and devices used to save data and retrieve it later, such as hard drives, solid-state drives, and…

• A. processing data into information
• B. analysing the data or information
• C. storing the data or information
• D. gathering data

Explanation: The standard four data-processing functions are collecting or gathering data, processing it, storing it, and producing information or…

• A. Query
• B. Sales
• C. POS
• D. Data

Explanation: POS means Point of Sale, the terminal where a sale is recorded and payment is processed.

• A. sequential and random
• B. sequential and indexed
• C. direct and immediate
• D. on-line and realtime

Explanation: Sequential access reads records in their stored order, whereas random access goes directly to a required record.

• A. CD
• B. CD-RW
• C. DVD
• D. RPM

Explanation: CD-RW means Compact Disc ReWritable, indicating that the optical disc can be erased and recorded again.

• A. has a faster access than an internal disk
• B. is a form or optical disk, so it can only be written once
• C. holds less data than a floppy disk
• D. can be erased and rewritten

Explanation: The RW suffix means rewritable, so a CD-RW can have its contents erased and recorded again.

• A. Database management
• B. Data element
• C. Data entry
• D. Elementary data item

Explanation: An elementary data item is an indivisible data value that cannot be meaningfully split into smaller data units.

• A. name server records
• B. hostname-to-address records
• C. hostname aliases
• D. all of these

Explanation: DNS stores several types of mappings, including name-server records, hostname-to-address records, and aliases such as CNAME records.

• A. An alphanumeric field
• B. A numeric field
• C. A letter field
• D. A alphabetic field

Explanation: A six-digit ZIP code contains digits only, so it is classified as a numeric field in this basic data-field classification.