• Placement Questions
• /
• Programming

Placement Papers with Solutions

(#M40154272) AMCAT QUESTION Computer science Keep an EYE

Choose the correct option.
Which of the given statements is/are true about the architecture of relational DBMS?
1. SDL is used to define conceptual schema.
2. VDL is used to define intemal schema.
3. Natural Language interface is used to take input from a naive user in english or standard language.
1)TTF
2)FTT
3)FFT
4)TFF

Asked In AMCAT dhritiman (10 years ago)

Unsolved Read Solution (1)

Is this Puzzle helpful?   (1)   (2) Submit Your Solution

(#M40154271) AMCAT QUESTION Computer science Keep an EYE

Ankit is a DBA(Database Administrator) in a multinational corporation He asks his juniors to merge data using common columns in multiple tables(more than 2) and generate an output report of that data for a meeting What command his junior should use to achieve the same?

1) View
2) Union
3) Join
4) Intersect

Asked In AMCAT dhritiman (10 years ago)

Unsolved Read Solution (2)

Is this Puzzle helpful?   (1)   (0) Submit Your Solution

(#M40154270) AMCAT QUESTION Computer science Keep an EYE

Which of the following statements is/are true about locks in database management’?
1. Livelock and Deadlock are same.
2. Phase Locking has 2 stages namely- Expanding phase and Contracting phase.
3. Read Lock can be assigned to infinite transactions simultaneously.
Options are:
1)TTF
2)FTT
3)FFT
4)TFT

Asked In AMCAT dhritiman (10 years ago)

Unsolved Read Solution (2)

Is this Puzzle helpful?   (0)   (0) Submit Your Solution Technical

(#M40154269) AMCAT QUESTION Computer science Keep an EYE

Which of the following statements is/are true about Unique Key?
1. Unique Key can have NULL values.
2. Every Altemate Key is a Unique Key.
3. Every Unique Key is a Primary Key.
Options are:
1)FFF
2)FTT
3)TFT
4)TTF

Asked In AMCAT dhritiman (10 years ago)

Unsolved Read Solution (1)

Is this Puzzle helpful?   (0)   (1) Submit Your Solution

(#M40154268) AMCAT QUESTION Computer science Keep an EYE

Choose the correct option.
Which of the following statements is/are incorrect?
1. Forwarding a packet is moving it from a router's input link to the appropriate output link.
2. Reverse path forwarding is used only when knowledge of a spanning tree is available.

3. In multicast routing, each router computes a spanning tree covering all other routers.
4. Routing is to determine end-trrend routes between sources and destinations.
1) OnIy2
2) Only 3 and 4
3) Both 1 and 4
4) Both 2 and 3
5)1. 3 and 4

Asked In AMCAT dhritiman (10 years ago)

Unsolved Read Solution (1)

Is this Puzzle helpful?   (15)   (7) Submit Your Solution

(#M40154267) AMCAT QUESTION Computer science Keep an EYE

Choose the correct option.
Which of the following statements are true about HTTP protocol?
1. lt is Hypertext Transition Protocol.
2. It is an application layer protocol.
3. It is a stateless protocol.
4. It is used for communication between web browsers and web servers.
Options are-
1)1,2and3
2)1,3and4
3)2,3and4
4)All-1,2,3and 4

Asked In AMCAT dhritiman (10 years ago)

Unsolved Read Solution (3)

Is this Puzzle helpful?   (25)   (25) Submit Your Solution

(#M40154266) AMCAT QUESTION Computer science Keep an EYE

Which of the following statements is incorrect?
1)SIMD machine executes one instruction on multiple data items at a time
2) MIMD Computer involves the execution of multiple instructions on multiple data stream
3)Array and Vector Processor are the examples of parallel processor
4) Parallel computing provides simultaneous data processing to decrease the computation speed of computer

Asked In AMCAT dhritiman (10 years ago)

Unsolved Read Solution (1)

Is this Puzzle helpful?   (0)   (0) Submit Your Solution

(#M40154265) AMCAT QUESTION Computer science Keep an EYE

A computer’s memoy is composed of 16K words of 8 bits each .How many bits are required for locating a word in memory, if the smallest addressable memory unit is a word?
1)13
2)14
3)15
4)16

Asked In AMCAT dhritiman (10 years ago)

Unsolved Read Solution (1)

Is this Puzzle helpful?   (1)   (0) Submit Your Solution

(#M40154264) AMCAT QUESTION Computer science Keep an EYE

To ensure serializability, transaction T can lock a data item in either shared or exclusive mode. Which of the following statements are true?
1. In shared mode, transaction T can read the data but can not write.
2. In exclusive mode, transaction T can read and write the data.
3. In exclusive mode, transaction T can only write the data but can not read.
4. ln shared mode, transaction T can read and write the data.
Options are-
1) Both 1 and 2
2) Both 3 and 4
3) Both 1 and 3
4) Both 2 and 4

Asked In AMCAT dhritiman (10 years ago)

Unsolved Read Solution (1)

Is this Puzzle helpful?   (0)   (0) Submit Your Solution

(#M40154263) AMCAT QUESTION Computer science Keep an EYE

Consider a schedule in which there are two consecutive operations 01 and 02 of transactions T1 and T2, respectively. In which of the following conditions, both operations O1 and 02 are said to conflict?

1)Both the operations operate on different data item and one of them is a write operation
2) Both the operations operate on same data item and one of them is a write operation
3) Both the operations operate on different data item and one of them is a read operation
4) Both the operations operate on same data item and one of them is a read operation

Asked In AMCAT dhritiman (10 years ago)

Unsolved Read Solution (1)

Is this Puzzle helpful?   (0)   (0) Submit Your Solution