SQL Query

1. Insert multiple rows into a database table.
INSERT INTO department (dep_id, dept_name) VALUES (4,'PME'), (5,'PST'), (6, 'ECE');

2.

Microprocessor

Which bus is a bidirectional bus?

A. address bus
B. data bus
C. address bus and data bus
D. none of the above
Answer: Option B

Which of the following buses is primarily used to carry signals that direct other ICs to find out what type of operation is being performed?

A. data bus
B. control bus
C. address bus
D. address decoder bus
Answer: Option B

What kind of computer program is used to convert mnemonic code to machine code?

A. debug
B. assembler
C. C++
D. Fortran
Answer: Option B

Which of the following are the three basic sections of a microprocessor unit?

A. operand, register, and arithmetic/logic unit (ALU)
B. control and timing, register, and arithmetic/logic unit (ALU)
C. control and timing, register, and memory
D. arithmetic/logic unit (ALU), memory, and input/output
Answer: Option B

The 8085A is a(n):

A. 16-bit parallel CPU
B. 8-bit serial CPU
C. 8-bit parallel CPU
D. none of the above
Answer: Option C

What type of circuit is used at the interface point of an output port?

A. decoder
B. latch
C. tristate buffer
D. none of the above
Answer: Option B

What type of circuit is used at the interface point of an input port?

A. decoder
B. latch
C. tristate buffer
D. none of the above
Answer: Option C

I/O mapped systems identify their input/output devices by giving them a(n) ________.

A. 8-bit port number
B. 16-bit port number
C. 8-bit buffer number
D. 8-bit instruction
Answer: Option A

The register in the 8085A that is used to keep track of the memory address of the next op-code to be run in the program is the:

A. stack pointer
B. program counter
C. instruction pointer
D. accumulator
Answer: Option B

How many bits are used in the data bus?

A. 7
B. 8
C. 9
D. 16
Answer: Option B

Single-bit indicators that may be set or cleared to show the results of logical or arithmetic operations are the:

A. flags
B. registers
C. monitors
D. decisions
Answer: Option A

The technique of assigning a memory address to each I/O device in the computer system is called:

A. memory-mapped I/O
B. ported I/O
C. dedicated I/O
D. wired I/O
Answer: Option A

The software used to drive microprocessor-based systems is called:

A. assembly language
B. firmware
C. machine language code
D. BASIC interpreter instructions

How many buses are connected as part of the 8085A microprocessor?

A. 2
B. 3
C. 5
D. 8
Answer: Option B

The ________ ensures that only one IC is active at a time to avoid a bus conflict caused by two ICs writing different data to the same bus.

A. control bus
B. control instructions
C. address decoder
D. CPU
Answer: Option C