# 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

Choice (4)

a.

NOT

b.

AND

c.

OR

d.

XOR

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?

Choice (4)

a.

. EXE file

b.

. FMB file

c.

. FMT file

d.

. FMX file

c.

### Explanation

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: