Correct 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

Correct 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

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

Correct 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

Correct 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

Correct Answer: LIKE operator

Explanation:

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

Correct Answer: residing in many computers linked together using HTML.

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

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

Correct Answer: SELECT COUNT(*), sex from Employees WHERE DOB BETWEEN ?01/01/1960 ' AND ?31/12/1975? GROUP BY sex;