3i Infotech Placement: Sample Questions 307 - 309 of 1245

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

Question 307

Question

MCQ▾

There was a circuit given using three NAND gates with two inputs and one output. Find the output

Choices

Choice (4)

a.

NOT

b.

AND

c.

OR

d.

XOR

Answer

c.

Explanation

Using 3 NAND Gate 2 Input and 1 Output is Or
  • In the question with the 3 NAND gates presumably the outputs of two of them are connected to the inputs of the third.
  • When we are use 3 NAND gate with 2 inputs then output is an OR gate.
    • To get a logic 1 output from a NAND gate, we need a logic 0 on both of its inputs.
    • Logic 1 at both inputs of the first two NAND gates will produce a logic 0 output from both of them.
    • The two logic 0′s are fed to the inputs of the third NAND gate producing a logic 0 output from the third NAND gate.

Question 308

Question

MCQ▾

What type of file is used for porting Forms 4.5 applications to various platforms?

Choices

Choice (4)

a.

. EXE file

b.

. FMB file

c.

. FMT file

d.

. FMX file

Answer

c.

Explanation

The Text and Documentation Files

In Forms 4.5 the PL/SQL code is in text form in the FMT file- allowing search for code, or export to FMB files.

Question 309

Edit

Describe in Detail

Essay▾

What is a Relation Schema and a Relation?

Explanation

Relation schema:

  • A set of attributes is called a relation schema (or relation scheme) .
  • A relation schema is also known as table schema (or table scheme) .
  • A relation schema can be thought of as the basic information describing a table or relation.
  • It is the logical definition of a table.
  • Relation schema defines what the name of the table is.
  • This includes a set of column names, the data types associated with each column.

A relation:

  • A relational database is a set of tables containing data fitted into predefined categories.
  • Each table (which is sometimes called a relation) contains one or more data categories in columns.
  • Each row contains a unique instance of data for the categories defined by the columns.

Developed by: