Database [3i Infotech Placement]: Sample Questions 153 - 154 of 294

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

Question 153

Database

Question

MCQ▾

Oracle precompile translates the EMBEDDED SQL statements into

Choices

Choice (4)

a.

Oracle LIBRARY

b.

Oracle REPORTS

c.

Oracle FORMS

d.

None of the above

Answer

d.

Explanation

Understanding of Embedded SQL
  • The engine translates the embedded SQL statements into standard oracle runtime library call.
  • Generated modified source program can compile, link, and execute in the usual way.
  • Client-server program written using Precompiler.

Ex.

  • The Pro ⚹ C Precompiler used for C
  • Pro ⚹ Cobol used for Cobol, SQLJ for Java etc.
  • Programming tools enable SQL statements in high-level programs.
  • Client-server program written using Precompiler.

    Benefit of Precompiler

  • Increases productivity.
  • Creates performant and customized application.
  • Allows monitoring of resource use, SQL statement execution, and various run-time indicators.
  • Provides compile time type checking of object types and collections, and automatic type conversion from database types to C data types.

Question 154

Database
Edit

Write in Short

Short Answer▾

What is an Entity?

Explanation

Entities with Example and Its Type
  • Entity set is a entities of the same type that share the same properties.
  • For example, a STUDENT entity may have a Name, Roll number, Class, Marks etc. where STUDENT is the entity and name roll number class marks are the attributes.

Developed by: