Saturday, May 25, 2019

Expected Questions Series 2

1) Which one of the following statements is / are true about SQL?
a. SQL permits attribute names to be repeated in the same relation
b. If there are no indexes on the relations then an SQL query will not work
c. Duplicates are automatically eliminated by an SQL query
d. None of the above 

2) What is the maximum possible size of the file in the index allocation scheme of blocks to a file depend on? (Database)
a. The size of the blocks and the size of the address of the blocks
b. The number of blocks used for the index, the size of the blocks and the size of the address of the blocks
c. The number of blocks used for the index and the size of the blocks 
d. None of the above

3)What is the pecularity of Red - black Trees?
a. In red-black trees, the root do not contain data.
b. In red-black trees, the leaf nodes are not relevant and do not contain data. 
c. In red-black trees, the leaf nodes are relevant but do not contain data.
d. Both a and c above

4) ________ is a tree where each parent node have only one associated child node. 
a. Balanced Binary Tree
b. Rooted Complete Binary Tree
c. Complete Binary Tree
d. Degenerate Tree

5)  Which of the following is a declaration for an HTML document? 
a. <!DOCTYPE html>
b. <html>.....</html>
c. <body>.....</body>
d. <p>.....</p>

6)  Which of the following statement is / are not  true about normal forms? (Database)
a. Any relation with two attributes is in BCNF
b. BCNF is stricter than 3NF
c. Lossless, dependency - preserving decomposition into 3NF is always possible
d. Lossless, dependency - preserving decomposition into BCNF is always possible

Answers:

1) d
2) c
3) b
4) d
5) a
6) d

Friday, May 24, 2019

Expected Questions Series 1

1) Database: Which is the make given to the database management system which is able to handle full text data, image data, audio and video?
a. full media
b. graphics media
c. multimedia
d. hypertext

2) Java: In which the JDBC type represents a "single precision" floating point number that supports seven digits of mantissa?
a. REAL
b. DOUBLE
c. FLOAT
d. INTEGER

3) Java: Generic pointers can be declared with__________
a. auto 
b. void 
c. asm 
d. None of these

4) C++: During a class inheritance in CPP, if the visibility mode or mode of derivation is not provided, then by default visibility mode is___________.
a. public 
b. protected 
c. private 
d. friend

5)  Software Engineering: Which model gives the overall reliability of the system that is projected and certified?
a. Sampling model
b. Component model
c. Certification model
d. Both A & B

6)  Software Engineering: What can static analysis NOT find? 
a. the use of a variable before it has been defined
b. unreachable (“dead”) code
c. memory leaks
d. array bound violations

Answers:
1) c
2) a
3) b
4) c
5) c
6) c

Wednesday, May 22, 2019

Most Frequently asked questions series 10

1)  Which is true about a method-local inner class? (Java)
a. It must be marked final.
b. It can be marked abstract.
c. It can be marked public.
d. It can be marked static.

2) Which constructs an anonymous inner class instance? (Java)
a. Runnable r = new Runnable() { };
b. Runnable r = new Runnable(public void run() { });
c. Runnable r = new Runnable { public void run(){}};
d. System.out.println(new Runnable() {public void run() { }})

3)  Which of the following allows the programmer to destroy an object x? (Java)
a. x.delete()
b. x.finalize()
c. Runtime.getRuntime().gc()
d. Only the garbage collection system can destroy an object.

4) Which of the following statements are correct? (Java)
a. If multiple listeners are added to a component only events for the last listener added will be processed
b. If multiple listeners are added to a component the events will be processed for all but with no guarantee in the order
c. Adding multiple listeners to a comnponent will cause a compile time error
d. You can not remove or add listeners to a component.

5) Which of the following methods are members of the Vector class and allow you to input a new element? (Java)
a. addElement
b. insert
c. append
d. addItem

6)  What is the default return-type of getchar()? (C programming)
a. char
b. int
c. char *
d. Reading character doesn't require a return-type

7) The Bedrock that supports software Engineering in layered technology.
a. Methods
b. Tools
c. Process
d. Quality Focus

Answers:
1) b
2) d
3) d
4) b
5) a
6) b
7) d

Friday, May 17, 2019

Most Frequently asked questions series 9

1) Which model depicts the profile of the end users of a computer system. (Software Engineering)
a. Spiral model
b. Iterative model
c. Waterfall model
d. User model

2) How many types of Prototype models are there? (Software Engineering)
a. 2
b. 3
c. 5
d. 4

3) Fanin in an OO context indicates. (Software Engineering)
a. Objects
b. Inheritance
c. Messages
d. Polymorphism

4) How many address lines are needed to address each memory location in a 2048 x 4 memory chip? (Networking)
a. 10 
b. 11
c. 8
d. 12

5)  Which one of the following statement is true for a layer-4 firewall which is a device that can look at all protocol headers up to the transport layer? (Networking)
a. It cannot block TCP traffic from a specific user on a multiple-user system during 9.00pm and 5.00pm
b. It cannot stop incoming traffic from a specific IP address but allow outgoing traffic to the same IP address.
c. It cannot block entire HTTP traffic during 9.00 pm and 5.00pm
d. It cannot block all ICMP traffic.

6) C programming:  What function should be used to free the memory allocated by calloc() ?
a. dealloc();
b. malloc(variable_name, 0)
c. free();
d. memalloc(variable_name, 0) 

7) A transparent DBMS? (Database)
a. Can not hide sensitive information from users
b. Keep its logical structure hidden from users
c. Keeps its physical structure hidden from users
d. Both B and C

8) An unnormalized relation contains values ? 
a. Atomic
b. Non - Atomic
c. Classified
d. None of these

9) Primitive operations common to all record management system include ? (Database)
a. Print
b. Sort
c. Look up
d. All of above

Answers

1) d
2) d
3) b
4) b
5) c
6) c
7) c
8) c
9) c

Thursday, May 16, 2019

Most Frequently asked questions series 8

1) Algorithms: Consider a B-tree of order 4 and is built from scratch by 10 successive insertions. What would be the maximum number of node splitting operations that take place?
a. 6
b. 3
c. 4
d. 2

2)  Which is used for Java Virtual Machine "assembly language", its opcodes and operands, as well as items in the Java Virtual Machine's run-time data areas?
a. ASCII
b. Italic
c. Latin
d. Greek

3) Which specification that provides runtime environment in which java byte code can be executed?
a. JDK
b. JVM
c. JRE
d. None of the above

4) C++: When a copy of an entire object is passed to a function, then it is referred to as
a. Pass-by-reference
b. Pass-by-pointer
c. Pass-by-value
d. None of the above

5) PL/SQL: Which datatypes can be used with a RECORD Type?
a. NUMBER,VRCHAR2
b. %TYPE,OR %ROWTYPE
c. REF,CURSOR
d. BOTH A & B
e. BOTH B & C

6) C Programming: Queue can be used to implement
a. Radix sort
b. Quick sort 
c. Recursion 
d. Depth first search

7)  C programming: Which of the following is TRUE about argv?
a. It is an array of character pointers
b. It is a pointer to an array of character pointers 
c. It is an array of strings 
d. None of above

8)  Networking: What flavor of Network Address Translation can be used to have one IP address allow many users to connect to the global Internet?
a. 32 bits 
b. 128 bytes 
c. 64 bits 
d. 128 bits

Answers:
1) c
2) b
3) b
4) c
5) d
6) a
7) b
8) b

Friday, May 3, 2019

Most frequently asked questions series 7

1) A pointer in c which has not been initialized is known as
a. far pointer
b. void pointer
c. null pointer 
d. wild pointer

2) In C++, dynamic memory allocation is achieved with the operator 
a. new 
b. this
c. malloc( ) 
d. calloc()

3)  Which protocol has flow control, but not error control?
a. Simplest
b. Selective-Repeat ARQ
c. Go-Back-N ARQ
d. Stop-and-Wait

4) Operating System: Which RAID level refers to disk mirroring?
a. 0
b. 1
c. 2
d. 3

5) Networking: Why Piggybacking technique is used?
a. To take the backup of data packets.
b. To improve the efficiency of the unidirectional protocols.
c. To improve the efficiency of the bidirectional protocols.
d. None of the above.

6) Networking: Which of the following addresses is used to deliver a message to the correct application program running on a host?
a. Port
b. IP
c. Logical
d. Physical

Answers:
1) d
2) a
3) d
4) b
5) c
6) a

Tuesday, April 30, 2019

Most frequently asked questions series 6

1) C++: Which of the following keywords allows the method resolution at run time?
a. abstract
b. override
c. virtual
d. None of the above.

2) OS: If the disk head is located initially at 32, find the number of disk moves required with FCFS if the disk queue of I/O blocks requests are 98, 37, 14, 124, 65, 70.
a. 320
b. 321
c. 324
d. None of the above

3) OS: Which scheduler performs the "swapping out" or "swapping in"?
a. Long-term scheduling
b. Medium-term scheduling
c. Short-term scheduling
d. None of the above.

4) Evaluate the postfix expression 3574-2^*+
a. 41
b. 45
c. 48
d. None of the above.

5) Which OSI layer is responsible for delivery of data packets from source to destination?
a. Transport layer.
b. Network layer.
c. Data layer.
d. None of the above.

Answers:
1) d
2) c
3) b
4) c
5) b