• Placement Questions
• /
• Programming

Placement Papers with Solutions

(#M40154252) AMCAT QUESTION Computer science Keep an EYE

Threads are -----------------, while processes are---------------------
1)light weight, heavy weight
2) heavy weight, light weight
3) live, dead
4) dead, live

Asked In AMCAT dhritiman (10 years ago)

Unsolved Read Solution (1)

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

(#M40154251) AMCAT QUESTION Computer science Keep an EYE

Which of the following keywords is used to remove duplicate values from a column in the result set of a query?
1) Unique
2) Distinct
3) Delete
4) Remove

Asked In AMCAT dhritiman (10 years ago)

Unsolved Read Solution (2)

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

(#M40154250) AMCAT QUESTION Computer science Keep an EYE

Which of the following options is defined as the time required for a signal pulse or packet to travel from a specific source to a specific destination and acknowledge back to the source?
1)Round TripTime
2) PingTime
3)Round Trip Delay
4)All of the above

Asked In AMCAT dhritiman (10 years ago)

Unsolved Read Solution (1)

Is this Puzzle helpful?   (4)   (3) Submit Your Solution

(#M40154249) AMCAT QUESTION Computer science Keep an EYE

A program P reads and processes 1000 consecutive records from a sequential file F stored on device D without using any file system facilities
Given the following:
1. Size of each record=2800 bytes
2. Access time of D=10 ms
3. Data transfer rate of D = 400*10^3 bytes/sec
4. CPU time to process each record = 2 ms
What is the elapsed time of P, if F contains unblocked records and P does not use buffering?
1)10s
2)12s
3) 17s
4)19s

Asked In AMCAT dhritiman (10 years ago)

Unsolved Read Solution (2)

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

(#M40154248) AMCAT QUESTION Computer science Keep an EYE

Which of the following System Calls is used by a process to create a new process?
1) exec()
2)pipe()
3)fork()
4)process()

Asked In AMCAT dhritiman (10 years ago)

Unsolved Read Solution (1)

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

(#M40154247) AMCAT QUESTION Computer science Keep an EYE

Which of the following statements is/are true related to the system call?
1. It is written in High Level Language.
2. It allows users to request OS services.
3. Exit() and fork() are the examples of system calls.
1) Only 1
2) Only2
3) Only3
4) Both 2 and 3
5)All-1, 2 and 3

Asked In AMCAT dhritiman (10 years ago)

Unsolved Read Solution (3)

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

(#M40154246) AMCAT QUESTION Computer science Keep an EYE

Which of the following options is incorrect about unshielded twisted pair(UTP) and shielded twisted pair(STP)?
1) STP prevents crosstalk whereas UTP does not
2) STP is costlier than UTP
3)STP and UTP use same UTP connectors
4)STP can carry signals of higher frequency than UTP

Asked In AMCAT dhritiman (10 years ago)

Unsolved Read Solution (1)

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

(#M40154245) AMCAT QUESTION Computer science Keep an EYE

Fill in the blank.
A database can have infinite number of different-----------------
1) logical views
2) intenal views
3) physical views
4)external views

Asked In AMCAT dhritiman (10 years ago)

Unsolved Read Solution (1)

Is this Puzzle helpful?   (38)   (30) Submit Your Solution

(#M40154241) AMCAT QUESTION Computer science Keep an EYE

How many different address are required by the memory that contains 20 k words-
Options-
1)20,000
2)20,480
3)20,000
4)32,000

Asked In AMCAT dhritiman (10 years ago)

Unsolved Read Solution (2)

Is this Puzzle helpful?   (6)   (4) Submit Your Solution

(#M40154240) AMCAT QUESTION Computer science Keep an EYE

Places(location,name, type)
Choose the correct option

Which of the following queries can be used to retrieve name and type from table “Places”(given in the passage), where column ‘location” has value Delhi and output should be in alphabetically increasing order of column “name’?
1)SELECT name, type FROM Places WHERE locationDelhi SORT BY 1;
2)SELECT name,type FROM Places WHERE location’Delhi’ SORT BY name;
3) SELECT name, type FROM Places WHERE location=’Delhi’ ORDER BY 1;
4) SELECT name, type FROM Places WHERE location=’Delhi’ ORDER BY 2;
5)SELECT name, type FROM Places WHERE location’Delhi SORT BY 2;

Asked In AMCAT dhritiman (10 years ago)

Unsolved Read Solution (6)

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