C Interview Questions Interview question

1. Write a program in C to find the 3*3 matrix multiplication.

2. Write a program in C to find the complex number of a given number.

3. how to print all the combinations of a given integer.

4. what is the significance of following functions

• freopen()
• strtok()
• access()
• state()

5. what is the "escape hatch" provided by #pragma directive?

6. what is source code of this tringle ...
A
A N I
A N I R B
A N I R B A N
A N I R B A N P A
A N I R B A N P A U L

7. What happens when you overload the stack?

8. what do you mean by preprocessor directory?

9. What is byte offset of a field within a structure?

10. What is unabridged list?

11. How is structure passing and returning implemented?

12. Write sample code or algorithim to get all possible combinations of data that will be entered from keyboard.

13. Explian Floyd Cycle finding algorithm for circular link list?

14. Why is that a pointer is depicted by '*' in C?

15. Write a program to print an 2D array in spiral manner

16. #includevoid fun(int);void main(){ inta; a=3; fun(a); }void fun(int){ if(n>0) { fun(--n);...

17. Given the values of two nodes in a *binary search tree*, write a cprogram to find the lowest common ancestor.

18. Can we define an array without any constant expression? If Yes, How?

19. For what purpose pragma.h header file is used?

20. What is the advantage of zero filling in calloc() ?

Oracle Interview Questions - Part 13

1.What are the various types of Exceptions ?
User defined and Predefined Exceptions.

2.Can we define exceptions twice in same block ?
No.

3.What is the difference between a procedure and a function ?
Functions return a single variable by value whereas procedures do not return any variable by value. Rather they return multiple variables by passing variables by reference through their OUT parameter.

4.Can you have two functions with the same name in a PL/SQL block ?
Yes.

5.Can you have two stored functions with the same name ?
Yes.

6.Can you call a stored function in the constraint of a table ?
No.

7.What are the various types of parameter modes in a procedure ?
IN, OUT AND INOUT.

8.What is Over Loading and what are its restrictions ?
OverLoading means an object performing different functions depending upon the no. of parameters or the data type of the parameters passed to it.

9.Can functions be overloaded ?
Yes.

10.Can 2 functions have same name & input parameters but differ only by return datatype?
No.
11.What are the constructs of a procedure, function or a package ?
The constructs of a procedure, function or a package are : variables and constants cursors exceptions

12.Why Create or Replace and not Drop and recreate procedures ?
So that Grants are not dropped.

13.Can you pass parameters in packages ? How ?
Yes. You can pass parameters to procedures or functions in a package.

14.What are the parts of a database trigger ?
The parts of a trigger are:
A triggering event or statement
A trigger restriction
A trigger action

15.What are the various types of database triggers ?
There are 12 types of triggers, they are combination of :
Insert, Delete and Update Triggers.
Before and After Triggers.
Row and Statement Triggers.(3*2*2=12)

16.What is the advantage of a stored procedure over a database trigger ?
We have control over the firing of a stored procedure but we have no control over the firing of a trigger.

17.What is the maximum no. of statements that can be specified in a trigger statement ?
One.

18.Can views be specified in a trigger statement ?
No

19.What are the values of :new and :old in Insert/Delete/Update Triggers ?
INSERT : new = new value, old = NULL
DELETE : new = NULL, old = old value
UPDATE : new = new value, old = old value

20.What are cascading triggers? What is the maximum no of cascading triggers at a time?
When a statement in a trigger body causes another trigger to be fired, the triggers are said to be cascading. Max = 32.
21.What are mutating triggers ?
A trigger giving a SELECT on the table on which the trigger is written.

22.What are constraining triggers ?
A trigger giving an Insert / Update on a table having referential integrity constraint on the triggering table.

23.Describe Oracle database's physical and logical structure ?
Physical : Data files, Redo Log files, Control file.
Logical : Tables, Views, Tablespaces, etc.

24.Can you increase the size of a tablespace ? How ?
Yes, by adding datafiles to it.

25.Can you increase the size of datafiles ? How ?
No (for Oracle 7.0)Yes (for Oracle 7.3 by using the Resize clause ----- Confirm !!).

26.What is the use of Control files ?
Contains pointers to locations of various data files, redo log files, etc.

27.What is the use of Data Dictionary ?
Used by Oracle to store information about various physical and logical Oracle structures e.g. Tables, Tablespaces, datafiles, etc

28.What are the advantages of clusters ?
Access time reduced for joins.

29.What are the disadvantages of clusters ?
The time for Insert increases.

30.Can Long/Long RAW be clustered ?
No.
31.Can null keys be entered in cluster index, normal index ?
Yes.

32.Can Check constraint be used for self referential integrity ? How ?
Yes. In the CHECK condition for a column of a table, we can reference some other column of the same table and thus enforce self referential integrity.

33.What are the min. extents allocated to a rollback extent ?
Two

34.What are the states of a rollback segment ? What is the difference between partly available and needs recovery ?
The various states of a rollback segment are :ONLINE, OFFLINE, PARTLY AVAILABLE, NEEDS RECOVERY and INVALID.

35.What is the difference between unique key and primary key ?
Unique key can be null; Primary key cannot be null.

36.An insert statement followed by a create table statement followed by rollback ? Will the rows be inserted ?
Yes.

37.Can you define multiple savepoints ?
Yes.

38.Can you Rollback to any savepoint ?
Yes.

40.What is the maximum no. of columns a table can have ?
256.

Data Warehousing Interview Questions

1) What is source qualifier?
2) Difference between DSS & OLTP?
3) Explain grouped cross tab?
4) Hierarchy of DWH?
5) How many repositories can we create in Informatica?
6) What is surrogate key?
7) What is difference between Mapplet and reusable transformation?
8) What is aggregate awareness?
9) Explain reference cursor?
10) What are parallel querys and query hints?
11) DWH architecture?
12) What are cursors?
13) Advantages of de normalized data?
14) What is operational data source (ODS)?
15) What is meta data and system catalog?
16) What is factless fact schema?
17) What is confirmed dimension?
18) What is the capacity of power cube?
19) Difference between PowerPlay transformer and power play reports?
20) What is IQD file?
21) What is Cognos script editor?
22) What is difference macros and prompts?
23) What is power play plug in?
24) Which kind of index is preferred in DWH?
25) What is hash partition?
26) What is DTM session?
27) How can you define a transformation? What are different types of transformations in Informatica?
28) What is mapplet?
29) What is query panel?
30) What is a look up function? What is default transformation for the look up function?
31) What is difference between a connected look up and unconnected look up?
32) What is staging area?
33) What is data merging, data cleansing and sampling?
34) What is up date strategy and what are th options for update strategy?
35) OLAP architecture?
36) What is subject area?
37) Why do we use DSS database for OLAP tools?
38) What is a universe?
39) Analysis in business objects?
40) Who launches the supervisor product in BO for first time?
41) How can you check the universe?
42) What are universe parameters?
43) Types of universes in business objects?
44) What is security domain in BO?
45) Where will you find the address of repository in BO?
46) What is broad cast agent?
47) In BO 4.1 version what is the alternative name for broadcast agent?
48) What services the broadcast agent offers on the server side?
49) How can you access your repository with different user profiles?
50) How many built-in objects are created in BO repository?
51) What are alertors in BO?
52) What are different types of saving options in web intelligence?
53) What is batch processing in BO?
54) How can you first report in BO by using broadcast agent?
55) Can we take report on Excel in BO?

VB Interview Questions

• Why do you use Option Explicit?
• What are the commonly used data types in VBScript?
• What is a session object?
• What are the three objects of ADO?
• What are the lock-types available in ADO?
• Explain. What are the cursor types available in ADO? Explain.
• What is a COM component? How do you register a COM component?
• What is a virtual root and how do you create one?
• What is a database index, how do you create one, discuss its pros and cons?
• How do you use multiple record sets(rs.NextRecordSet)?
• As soon as you fetch a record set, what operations would you perform?
• Define a transaction.
• What are ACID properties of a transaction?
• How would you remotely administer IIS?
• What is RAID? What is it used for?
• What is normalization? Explain normalization types.
• What is the disadvantage of creating an index in every column of a database table?
• What are the uses of source control software?
• You have a query that runs slowly, how would you make it better?
• How would you make it better in .NET environment?
• What is a bit datatype? What is it used for?
• How would you go about securing IIS and MS-SQL Server?
• What is the difference between Request("field") and Request.Form("field")?
• What versions of VB have you used? Have you also used VBA or VBScript?
• Have you ever used classes? If so, how have you used them?
• Have you ever created ActiveX DLLs? If so, why did you create the DLLs instead of using code in the main application?
• Have you ever created ActiveX controls? If so, what did they do?
• Have you ever created ActiveX EXEs? If so, what were they used for?
• Have you ever used Collections? Collection Classes?
• Have you ever used ADO? DAO? RDO? Any other database engines?
• What database backends have you worked with? Access? SQL Server? Oracle?
• Have you ever used resource files? If so, for what reason?
• Have you used the FileSystemObject? The Dictionary Object? Regular Expressions?
• Have you developed COM+ components? Any other types of server based components?
• What source code control systems have you used?
• What versions of Windows have you used? Have you used any other operating systems?
• What third party ActiveX controls have you used?
• Are there any other programming tools, such as database diagramming, UML, or CASE tools, that you've used?
• Have you developed components for IIS? Developed ASP pages?
• If you were writing a program, what method would you use to send information from the main form of the application to a modal popup form and then pass any changes to the data back to the main form when the popup form was closed?
• How would you center a form on the screen? How about centering it on another form?
• If an event, such as a tool bar button or menu click,occurs on a MDI parent how can it invoke an action on one or more MDI child forms?
• What are some methods you can use to send data from one VB executable to another one?
• What are the differences between a standard module and a class module?
• What do you have to do to make your class visible to programs other than your own?
• How can you tell what kind of object an object variable is holding?
• Describe the different scopes of variables in VB.
• Describe the difference between a public variable in a form and one in a standard code module.
• How do you handle error conditions in your code?
• What are some uses and misuses of variants?
• What are some of the steps you can take to determine why your program is crashing with "Invalid Page Fault" errors?
• What are the different ways you can use threading in VB? When are they appropriate?
• How many tabs in a tabbed dialog do you consider appropriate?
• How many items should you make available to users in a listbox or combo box?
• What are the three main differences between flexgrid control and dbgrid(Data bound Grid) control
  The Microsoft FlexGrid (MSFlexGrid) control displays and operates on tabular data. It allows complete flexibility to sort, merge, and format tables containing strings and pictures. When bound to a Data control, MSFlexGrid displays read-only data.Adaptation to existing Visual Basic code for the data-bound grid (DBGrid).
  
  Dbgrid is A spreadsheet-like bound control that displays a series of rows and columns representing records and fields from a Recordset object.
  
  The data grids are bound controls; that is, they require a data source that actually connects to a database and retrieves their data. And it seems that the root of the problem with DBGrid is that there's no data source that can be readily included along with the DBGrid control.In Visual Basic, the solution is simply to include the Data Control on the same form as DBGrid. But the Data Control is an intrinsic control; it's unavailable to anything outside of the Visual Basic environment itself. and VB 6.0 has a new set of data controls (DataGrid, DataList, DataCombo, MSHFlexGrid, MSFlexGrid) that once again are bound controls. Unlike DBGrid, though, they support OLE DB, and therefore rely on the an ADO Data Source (and in particular the ActiveX Data Objects Data Control, or ADO DC) for data access. Unlike the Data Control, the ADODC is a custom control (that is, an .OCX) that can be added to any project. In short, if you add ADO DC to your project along with theDataGrid control.
  
• ActiveX and Types of ActiveX Components in VB ?
  Standard EXE
  ActiveX EXE
  ActiveX DLL
  ActiveX document
  ActiveX Control
  
• What is difference between inprocess and out of process ?
  An in-process component is implemented as a DLL, and runs in the same process space as its client app, enabling the most efficient communication between client and component.Each client app that uses the component starts a new instance of it.
  An out of process component is implemented as an EXE, and unlike a dll, runs in its own process space. As a result, exe's are slower then dll'sbecause communications between client and component must be marshalled across process boundaries. A single instance of an out of process component can service many clients.
  
• Advantage of ActiveX Dll over Active Exe ?
  
  ACTIVEX DLL:An in-process component, or ActiveX DLL, runs in another application’s process. In-process components are used by applications or other in-process components. this allows you to wrap up common functionality (like an ActiveX Exe).
  
  ACTIVEX EXE:An out-of-process component, or ActiveX EXE, runs in its own address space. The client is usually an application running in another process.The code running in an ActiveX Exe is running in a separate process space. You would usually use this in N-Tier programming.
  
  An ActiveX EXE runs out of process while an ActiveX DLL runs in the same process space as VB app. Also, and ActiveX EXE can be run independent of your application if desired.
• Explain single thread and multithread thread apartments.
  All components created with Visual Basic use the apartment model, whether they’re single-threaded or multithreaded. A single-threaded component has only one apartment, which contains all the objects the component provides.
  This means that a single-threaded DLL created with Visual Basic is safe to use with a multithreaded client. However, there’s a performance trade-off for this safety. Calls from all client threads except one are marshaled, just as if they were out-of-process calls.
  
• What is a Component?
  If you compile an ActiveX dll, it becomes a component.If you compile an ActiveX Control, it becomes both a component and a control.
  Component is a general term used to describe code that's grouped by functionality. More specifically, a component in COM terms is a compiled collection of properties/methods and events.
  Typically a component is loaded into your project via the References whereas an ActiveX Control is loaded into your project via "components".
  
• What is meant by "Early Binding" and "Late Binding"? Which is better?
  Early binding and late binding refer to the method used to bind an interface's properties and methods to an object reference (variable). Early binding uses type library information at design time to reference procedures, while late binding handles this at run time. Late bindinghandles this by interrogating the reference before each call to insure that it supports a particular method. Since every call to a late boundobject actually requires two calls ("Do you do this?" followed by "Okay, do it then"), late binding is much less efficient than early binding. Except where early binding is not supported (ASP, scripting, etc.), late binding should only be used in very special cases.
  It is a common misconception that any code using the CreateObject function instead of
  Set = New is using late binding. This is not the case. The type declaration of the object variable determines whetherit is late or early bound, as in the following:
  
  Dim A As Foo
  Dim B As Foo
  Dim C As Object
  Dim D As Object
  Set A = New Foo 'Early Bound
  Set B = CreateObject("FooLib.Foo") 'Early Bound
  Set C = CreateObject("FooLib.Foo") 'Late Bound
  Set D = New Foo 'Late Bound

Technical Interview QuestionsI

1. A 2MB PCM(pulse code modulation) has

a) 32 channels
b) 30 voice channels & 1 signalling channel.
c) 31 voice channels & 1 signalling channel.
d) 32 channels out of which 30 voice channels, 1 signalling channel, & 1 Synchronizatio channel.

Ans: (c)

2. Time taken for 1 satellite hop in voice communication is

a) 1/2 second
b) 1 seconds
c) 4 seconds
d) 2 seconds

Ans: (a)

3. Max number of satellite hops allowed in voice communication is :

a) only one
b) more han one
c) two hops
d) four hops

Ans: (c)

4. What is the max. decimal number that can be accomodated in a byte.

a) 128
b) 256
c) 255
d) 512

Ans: (c)

5. Conditional results after execution of an instruction in a micro processor is stored in

a) register
b) accumulator
c) flag register
d) flag register part of PSW(Program Status Word)

Ans: (d)

6. Frequency at which VOICE is sampled is

a) 4 Khz
b) 8 Khz
c) 16 Khz
d) 64 Khz

Ans: (a)

7. Line of Sight is

a) Straight Line
b) Parabolic
c) Tx & Rx should be visible to each other
d) none

Ans: (c)

8. Purpose of PC(Program Counter) in a MicroProcessor is

a) To store address of TOS(Top Of Stack)
b) To store address of next instruction to be executed.
c) count the number of instructions.
d) to store base address of the stack.

Ans: (b)

9. What action is taken when the processor under execution is interrupted by a non-maskable interrupt?

a) Processor serves the interrupt request after completing the execution of the current instruction.
b) Processor serves the interupt request after completing the current task.
c) Processor serves the interupt request immediately.
d) Processor serving the interrupt request depends upon the priority of the current task under execution.

Ans: (a)

10. The status of the Kernel is

a) task
b) process
c) not defined.
d) none of the above.

Ans: (b)

11. To send a data packet using datagram , connection will be established

a) before data transmission.
b) connection is not established before data transmission.
c) no connection is required.
d) none of the above.

Ans: (c)

12. Word allignment is

a) alligning the address to the next word boundary of the machine.
b) alligning to even boundary.
c) alligning to word boundary.
d) none of the above.

Ans: (a)

13 When a 'C' function call is made, the order in which parameters passed to the function are pushed into the stack is

a) left to right
b) right to left
c) bigger variables are moved first than the smaller variales.
d) smaller variables are moved first than the bigger ones.
e) none of the above.

Ans: (b)

14 What is the type of signalling used between two exchanges?

a) inband
b) common channel signalling
c) any of the above
d) none of the above.

Ans: (a)

15 Buffering is

a) the process of temporarily storing the data to allow for small variation in device speeds
b) a method to reduce cross talks
c) storage of data within transmitting medium until the receiver is ready to receive.
d) a method to reduce routing overhead.

Ans: (a)

16. Memory allocation of variables declared in a program is

a) allocated in RAM.
b) allocated in ROM.
c) allocated on stack.
d) assigned to registers.

Ans: (c)

17. A software that allows a personal computer to pretend as a computer terminal is

a) terminal adapter
b) bulletin board
c) modem
d) terminal emulation

Ans: (d)

18. Find the output of the following program

int *p,*q;
p=(int *)1000;
q=(int *)2000;
printf("%d",(q-p));

Ans: 500

19. Which addressing mode is used in the following statements:

(a) MVI B,55
(b) MOV B,A
(c) MOV M,A

Ans. (a) Immediate addressing mode.
(b) Register Addressing Mode
(c) Direct addressing mode

20. RS-232C standard is used in _____________.

Ans. Serial I/O

21. Memory. Management in Operating Systems is done by

a) Memory Management Unit
b) Memory management software of the Operating System
c) Kernel

Ans: (b)

22. What is done for a Push opertion?

Ans: SP is decremented and then the value is stored.

23. Binary equivalent of 52

Ans. 110100


24. Hexadecimal equivalent of 3452

Ans. 72A


25. Explain Just In Time Concept ?

Ans. Elimination of waste by purchasing manufacturing exactly when needed


26. A good way of unit testing s/w program is

Ans. User test


27. OOT uses

Ans. Encapsulated of detect methods


28.EDI useful in

Ans. Electronic Transmission


29. MRPII different from MRP

Ans. Modular version of man redundant initials


30. Hard disk time for R/W head to move to correct sector

Ans. Latency Time


31. The percentage of times a page number bound in associate register is called

Ans. Bit ratio


32. Expand MODEM

Ans. Modulator and Demodulator


33. RDBMS file system can be defined as

Ans. Interrelated


34. Super Key is

Ans. Primary key and Attribute


35. Windows 95 supports

(a) Multiuser
(b) n tasks
(c) Both
(d) None

Ans. (a)


36.In the command scanf, h is used for

Ans. Short int


37.A process is defined as

Ans. Program in execution


38.A thread is

Ans. Detachable unit of executable code)


39.What is the advantage of Win NT over Win 95

Ans. Robust and secure

40.How is memory management done in Win95

Ans. Through paging and segmentation


41.What is meant by polymorphism

Ans. Redfinition of a base class method in a derived class


42.What is the essential feature of inheritance

Ans. All properties of existing class are derived


43.What does the protocol FTP do

Ans. Transfer a file b/w stations with user authentification


44.In the transport layer ,TCP is what type of protocol

Ans. Connection oriented


45.Why is a gateway used

Ans. To connect incompatible networks


46.How is linked list implemented

Ans. By referential structures


47.What method is used in Win95 in multitasking

Ans. Non preemptive check


48.What is a semaphore

Ans. A method synchronization of multiple processes


49.What is the precedence order from high to low ,of the symbols ( ) ++ /

Ans.( ) , ++, /

50.Preorder of A*(B+C)/D-G

Ans.*+ABC/-DG

51.What is the efficiency of merge sort

Ans. O(n log n)


52.In which layer are routers used

Ans.In network layer


53.Which of the following sorting algorithem has average sorting behavior --
Bubble sort,merge sort,heap sort,exchange sort

Ans. Heap sort


54.In binary search tree which traversal is used for getting ascending order values--Inorder ,post order,preorder

Ans.Inorder


55.What are device drivers used for

Ans.To provide software for enabling the hardware


56.What is fork command in unix

Ans. System call used to create process


57.What is make command in unix

Ans. Used forcreation of more than one file


58.In unix .profile contains

Ans. Start up program


59.In unix 'ls 'stores contents in

Ans.inode block

60. Which of the following involves context switch,

(a) system call
(b) priviliged instruction
(c) floating poitnt exception
(d) all the above
(e) none of the above

Ans: (a)

61. In OST, terminal emulation is done in

(a) sessions layer
(b) application layer
(c) presentation layer
(d) transport layer

Ans: (b)

62. For 1 MB memory, the number of address lines required,

(a)11
(b)16
(c)22
(d) 24

Ans. (b)

63. Semaphore is used for

(a) synchronization
(b) dead-lock avoidence
(c) box
(d) none

Ans. (a)

64. Which holds true for the following statement

class c: public A, public B

a) 2 member in class A, B should not have same name
b) 2 member in class A, C should not have same name
c) both
d) none

Ans. (a)

65.Preproconia.. does not do which one of the following

(a) macro
(b) conditional compliclation
(c) in type checking
(d) including load file

Ans. (c)

66. Piggy backing is a technique for

a) Flow control
b) Sequence
c) Acknowledgement
d) retransmition

Ans. (c)

67. Which is not a memory management scheme?

a) buddy system
b) swapping
c) monitors
d) paging

Ans : c

68. There was a circuit given using three nand gates with two inputs and one output.
Find the output.

a) OR
b) AND
c) XOR
d) NOT

Ans. (a)

69.Iintegrated check value(ICV) are used as:

Ans. The client computes the ICV and then compares it with the senders value.

70. When applets are downloaded from web sites , a byte verifier performs _________?

Ans. Status check.

71. An IP/IPX packet received by a computer using... having IP/IPX both how the packet is handled.

Ans. Read the, field in the packet header with to send IP or IPX protocol.

72. The UNIX shell ....

a) does not come with the rest of the system
b) forms the interface between the user and the kernal
c) does not give any scope for programming
d) deos not allow calling one program from with in another
e) all of the above

Ans. (b)

73. In UNIX a files i-node ......?

Ans. Is a data structure that defines all specifications of a file like the file size,
number of lines to a file, permissions etc.

74. The very first process created by the kernal that runs till the kernal process is halts is

a) init
b) getty
c) both (a) and (b)
d) none of these

Ans. (a)

75. In the process table entry for the kernel process, the process id value is

(a) 0
(b) 1
(c) 2
(d) 255
(e) it does not have a process table entry

Ans. (a)

76. Which of the following API is used to hide a window

a) ShowWindow
b) EnableWindow
c) MoveWindow
d) SetWindowPlacement
e) None of the above

Ans. (a)

77. Which function is the entry point for a DLL in MS Windows 3.1

a) Main
b) Winmain
c) Dllmain
d) Libmain
e) None

Ans. (b)

78. The standard source for standard input, standard output and standard error is

a) the terminal
b) /dev/null
c) /usr/you/input, /usr/you/output/, /usr/you/error respectively
d) None

Ans. (a)

79. The redirection operators > and >>

a) do the same function
b) differ : > overwrites, while >> appends
c) differ : > is used for input while >> is used for output
d) differ : > write to any file while >> write only to standard output
e) None of these

Ans. (b)

80. The command grep first second third /usr/you/myfile

a) prints lines containing the words first, second or third from the file /usr/you/myfile
b) searches for lines containing the pattern first in the files
second, third, and /usr/you/myfile and prints them
c) searches the files /usr/you/myfiel and third for lines containing the words first or second and prints them
d) replaces the word first with the word second in the files third and /usr/you/myfile
e) None of the above

Ans. (b)

81. You are creating a Index on EMPNO column in the EMPLOYEE table. Which statement will you use?
a) CREATE INdEX emp_empno_idx ON employee, empno;
b) CREATE INdEX emp_empno_idx FOR employee, empno;
c) CREATE INdEX emp_empno_idx ON employee(empno);
d) CREATE emp_empno_idx INdEX ON employee(empno);

Ans. c

82. Which program construct must return a value?
a) Package
b) Function
c) Anonymous block
d) Stored Procedure
e) Application Procedure

Ans. b

83. Which Statement would you use to remove the EMPLOYEE_Id_PK PRIMARY KEY constraint and all depending constraints fromthe EMPLOYEE table?
a) ALTER TABLE employee dROP PRIMARY KEY CASCAdE;
b) ALTER TABLE employee dELETE PRIMARY KEY CASCAdE;
c) MOdIFY TABLE employee dROP CONSTRAINT employee_id_pk CASCAdE;
d) ALTER TABLE employee dROP PRIMARY KEY employee_id_pk CASCAdE;
e) MOdIFY TABLE employee dELETE PRIMARY KEY employee_id_pk CASCAdE;

Ans. a

84. Which three commands cause a transaction to end? (Chosse three)
a) ALTER
b) GRANT
c) DELETE
d) INSERT
e) UPdATE
f) ROLLBACK

Ans. a ,b ,f

85. Under which circumstance should you create an index on a table?
a) The table is small.
b) The table is updated frequently.
c) A columns values are static and contain a narrow range of values
d) Two columns are consistently used in the WHERE clause join condition of SELECT
statements.

Ans.d

86. What was the first name given to Java Programming Language.

a) Oak - Java
b) Small Talk
c) Oak
d) None

Ans.a

87.When a bicycle is in motion,the force of friction exerted by the ground on the two wheels is such that it acts

(a) In the backward direction on the front wheel and in the forward direction on the rear wheel.
(b) In the forward direction on the front wheel and in the backward direction on the rear wheel.
(c) In the backward direction on both the front and rear wheels.
(d) In the backward direction on both the front and rear wheels.

Ans. (d)

88. A certain radioactive element A, has a half life = t seconds.
In (t/2) seconds the fraction of the initial quantity of the element so far decayed is nearly

(a) 29%
(b) 15%
(c) 10%
(d) 45%

Ans. (a)

89. Which of the following plots would be a straight line ?

(a) Logarithm of decay rate against logarithm of time
(b) Logarithm of decay rate against logarithm of number of decaying nuclei
(c) Decay rate against time
(d) Number of decaying nuclei against time

Ans. (b)

90. A radioactive element x has an atomic number of 100.
It decays directly into an element y which decays directly into element z.
In both processes a charged particle is emitted.
Which of the following statements would be true?

(a) y has an atomic number of 102
(b) y has an atomic number of 101
(c) z has an atomic number of 100
(d) z has an atomic number of 101

Ans. (b)

91. If the sum of the roots of the equation ax2 + bx + c=0 is equal to the sum of the squares of their reciprocals
then a/c, b/a, c/b are in

(a) AP
(b) GP
(c) HP
(d) None of these

Ans. (c)

92. A man speaks the truth 3 out of 4 times.
He throws a die and reports it to be a 6.
What is the probability of it being a 6?

(a) 3/8
(b) 5/8
(c) 3/4
(d) None of the above

Ans. (a)

93. If cos2A + cos2B + cos2C = 1 then ABC is a

(a) Right angle triangle
(b) Equilateral triangle
(c) All the angles are acute
(d) None of these

Ans. (a)

94. Image of point (3,8) in the line x + 3y = 7 is

(a) (-1,-4)
(b) (-1,4)
(c) (2,-4)
(d) (-2,-4)

Ans. (a)

95. The mass number of a nucleus is

(a) Always less than its atomic number
(b) Always more than its atomic number
(c) Sometimes more than and sometimes equal to its atomic number
(d) None of the above

Ans. (c)

96. The maximum KE of the photoelectron emitted from a surface is dependent on

(a) The intensity of incident radiation
(b) The potential of the collector electrode
(c) The frequency of incident radiation
(d) The angle of incidence of radiation of the surface

Ans. (c)

97. Which of the following is not an essential condition for interference

(a) The two interfering waves must be propagated in almost the same direction or
the two interfering waves must intersect at a very small angle
(b) The waves must have the same time period and wavelength
(c) Amplitude of the two waves should be the same
(d) The interfering beams of light must originate from the same source

Ans. (c)

98. When X-Ray photons collide with electrons

(a) They slow down
(b) Their mass increases
(c) Their wave length increases
(d) Their energy decreases

Ans. (c)

99. An electron emits energy

(a) Because its in orbit
(b) When it jumps from one energy level to another
(c) Electrons are attracted towards the nucleus
(d) The electrostatic force is insufficient to hold the electrons in orbits

Ans. (b)

100. How many bonds are present in CO2 molecule?

(a) 1
(b) 2
(c) 0
(d) 4