Question 1

What is RDBMS? Explain its features.

Accepted Answer

RDBMS is a database management system based on relational model defined by EFCodd Data is stored in the form of rows and columns The relations among tables are also stored in the form of the table Features: - Provides data to be stored in tables - Persists data in the form of rows and columns - Provides facility primary key, to uniquely identify the rows - Creates indexes for quicker data retrieval - Provides a virtual table creation in which sensitive data can be stored and simplified query can be applied(views) - Sharing a common column in two or more tables(primary key and foreign key) - Provides multi user accessibility that can be controlled by individual users

Question 2

What is function prototyping? What are its advantages?

Accepted Answer

Function prototyping is a function declaration statement that tells the compiler about the return type of the function and the number as well as type of arguments required by the function at the time of calling it Syntax: return_type function_name( type1 arg1, type 2 arg2, ); Advantages of function prototype : - It helps the compiler in determining whether a function is called correctly or not Each time when a function is called, its calling statement is compared with its prototype In case of any mismatch, compiler reports an error - A function must be defined before calling it But prototyping allows a function to be called before defining it

Question 3

Which of the following can't be done with client-side JavaScript?

Accepted Answer

Storing the form's contents to a database file on the server

Question 4

What is DHTML? What are the features of DHTML?

Accepted Answer

DHTML stands for Dynamic HTML The first thing that we need to clear about DHTML is that it is neither a language like HTML, JavaScript etc nor a web standard It is just a combination of HTML, JavaScript and CSS It just uses these languages features to build dynamic web pages DHTML is a feature of Netscape Communicator 40, and Microsoft Internet Explorer 40 and 50 and is entirely a "client-side" technology Features of DHTML: - Simplest feature is making the page dynamic - Can be used to create animations, games, applications, provide new ways of navigating through web sites - DHTML use low-bandwidth effect which enhance web page functionality - Dynamic building of web pages is simple as no plug-in is required - Facilitates the usage of events, methods and properties and code reuse

Question 5

What is the difference between stack and array?

Accepted Answer

Stack: - Stack is a ordered collection of items - Stack is a dynamic object whose size is constantly changing as items are pushed and popped - Stack may contain different data types Array: - Array is an ordered collection of items - Array is a static object ie no of item is fixed and is assigned by the declaration of the array - It contains same data types

Question 6

Which operator performs pattern matching ?

Accepted Answer

LIKE is a keyword that is used in the WHERE clause. Basically, LIKE allows us to do a search based operation on a pattern rather than specifying exactly what is desired (as in IN) or spell out a range (as in BETWEEN). The syntax is as follows: SELECT "column_name" FROM "table_name" WHERE "column_name" LIKE {PATTERN} {PATTERN} often consists of wildcards. In SQL, there are two wildcards: % (percent sign) represents zero, one, or more characters. _ (underscore) represents exactly one character. More :: Certification Questions on SQL

Question 7

A world wide web contains web pages

Accepted Answer

residing in many computers linked together using HTML.

Question 8

What are the types of Collision Resolution Techniques and the methods used in each of the type?

Accepted Answer

Open addressing (closed hashing), The methods used include: Overflow block, Closed addressing (open hashing) The methods used include: Linked list, Binary tree…

Question 9

Write SQL Query to display current date?

Accepted Answer

The built in function called GetDate() returns the time stamp

Question 10

Write an SQL Query find number of employees according to gender whose DOB is between 01/01/1960 to 31/12/1975.

Accepted Answer

SELECT COUNT(*), sex from Employees WHERE DOB BETWEEN ‘01/01/1960 ' AND ‘31/12/1975’ GROUP BY sex;

Question 11

Javascript is interpreted by

Accepted Answer

JavaScript is an interpreted language, not a compiled language. A program such as C++ or Java needs to be compiled before it is run. The source code is passed through a program called a compiler, which translates it into bytecode that the machine understands and can execute.

Question 12

What is the correct JavaScript syntax to write “Hello World”?

Accepted Answer

document.write(

Question 13

Which is more effective while calling the functions?

Accepted Answer

In the call by reference, it will just copy the address of the variable to access it, so it will reduce the memory in accessing it.

Question 14

What is the default return type of a function ?

Accepted Answer

void

Question 15

What do you mean by friend function in C++ ?

Accepted Answer

Friends can be either functions or other classes The class grants friends unlimited access privileges * The declaration of the function should be preceded by the keyword 'friend' * The function definition will not use the keyword or the scope operator '::' Thus, a friend function is an ordinary function or a member of another class

Question 16

Which of the following is not the member of class?

Accepted Answer

Friend function

Question 17

Should a main() method be compulsorily declared in all java classes?

Accepted Answer

No not required main() method should be defined only if the source class is a java application

Question 18

What is the importance of finally block in exception handling ?

Accepted Answer

A finally block will always be executed, whether or not an exception is actually thrown Even in the case where the catch statement is missing and an exception is thrown, the finally block will still be executed Last thing to mention is that the finally block is used to release resources like I/O buffers, database connections, etc

Question 19

How can you make sure the web application is fit for release ?

Accepted Answer

1 We can operate majority of test cases, but importantly we can make use testing techniques such as Pair-wise testing to reduce combinations, and/or model based testing to plan user journeys to ensure major functionality of web application works or not 2 We can also use analytics to get insight into what users do on the website, which page is most popular and which feature is most used by the users

Question 20

What is the difference between Tags and HTML Elements ?

Accepted Answer

* HTML elements communicate with the Browser how to represent the text * HTML elements become HTML tags when enclosed within the angular brackets as "<>"

Technology Questions