Database [3i Infotech Placement]: Sample Questions 230 - 232 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 230

Database
Edit

Describe in Detail

Essay▾

What is degree of a Relation?

Explanation

Degree of a Relationship with Types
  • The degree of a relation is the number of attributes n of its relational schema.
  • An example of a relational schema for a relation of degree seven, which describes university students, is the following:
    • STUDENTS (Name, Ssn, Home_phone, Address, Office_phone, Age, Gpa) ″

    The main three relational degrees are:

  • Ornary (one relational connection)
  • Binary (two relational connection)
  • Ternary (three relational connection)

Question 231

Database

Question

MCQ▾

The packaged procedure that makes data in form permanent in the database is

Choices

Choice (4)

a.

Post

b.

Commit form

c.

Post form

d.

Question does not provide sufficient data or is vague

Answer

b.

Explanation

  • The packaged procedure that makes data in form permanent in the database is commit form.
  • Commit form is a form built-in function to save the data to the database.
  • Commit is a command for committing all the transactions that have been performed.

Question 232

Database

Question

MCQ▾

What is TERM?

Choices

Choice (4)

a.

TERM is the terminal definition file that describes the terminal from which you are using R20DES (Reports designer)

b.

There is no Parameter called TERM in Reports 2.0

c.

TERM is the terminal definition file that describes the terminal from which you are using R20RUN (Reports run time)

d.

None of the above

Answer

c.

Explanation

  • The term is terminal definition file describing the terminal using R20RUN.
  • This corresponds to oracle report functions.

Developed by: