Write SQL Query to display current date?

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: residing in many computers linked together using HTML.

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: 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: 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: SELECT COUNT(*), sex from Employees WHERE DOB BETWEEN ?01/01/1960 ' AND ?31/12/1975? GROUP BY sex;

Correct Answer: Client

Explanation:

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.

Correct Answer: document.write(

Correct Answer: call by reference

Explanation:

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.

Correct Answer: void