Database-Oracle [3i Infotech Placement]: Sample Questions 85 - 86 of 132

Glide to success with Doorsteptutor material for competitive exams : get questions, notes, tests, video lectures and more- for all subjects of your exam.

Question 85

Oracle

Question

MCQ▾

Identify the Odd one of the following statements?

Choices

Choice (4)

a.

Poplist

b.

Tlist

c.

List of values

d.

Combo box

Answer

c.

Explanation

  • LOV is a static or dynamic set of values to display a specific type of page item, popup list of values, a select list, a check box, a radio group or multiple select lists.
  • LOV at the application-level, creates a shared component.

    Advantages

  • Can be added to any page within an application.
  • Definitions are stored in one location, making them easy to be located and update.
  • Easy to use
  • Increase accuracy and productivity.

Question 86

Oracle

Question

MCQ▾

What file is read by ODBC to load drivers?

Choices

Choice (4)

a.

ODBC. DLL

b.

ODBC. INI

c.

ODBCDRV. INI

d.

All of the above

Answer

b.

Explanation

  • ODBC. INI is used to load drivers.
  • Data source names for data sources in a database is in the odbc. ini file.
  • Open database provides a standard interface that allows one application to access many different data sources.
  • The application՚s source code does not have to be recompiled for each data source.
  • A database driver links the application to a specific data source.

Loading drivers:

  • Accessing device that is associated with a device driver- load drivers.
  • We can use modload command to load the driver into memory.
  • Modload does not call any routines.
  • This method opens the device.

The ODBC interface defines the following:

  • A library of ODBC function calls that allows an application to connect to a data source, execute structured query language statements, and retrieve results.
  • A standard set of error codes.
  • A standard way to connect to and log in to a data source.
  • A standard representation for data types.

Developed by: