Discussion
Home ‣ Interview ‣ Technology Comments
- Question
Write an SQL Query find number of employees according to gender whose DOB is between 01/01/1960 to 31/12/1975.
- Correct Answer
- SELECT COUNT(*), sex from Employees WHERE DOB BETWEEN ?01/01/1960 ' AND ?31/12/1975? GROUP BY sex;
- 1. Write SQL Query to display current date? Discuss
- 2. What are the types of Collision Resolution Techniques and the methods used in each of the type? Discuss
- 3. A world wide web contains web pages
Options- A. residing in many computers linked together using HTML.
- B. with links to other web pages.
- C. residing in many computers.
- D. created using HTML. Discuss
- 4. Which operator performs pattern matching ?
Options- A. LIKE operator
- B. EXISTS operator
- C. BETWEEN operator
- D. None of these Discuss
- 5. What is the difference between stack and array? Discuss
- 6. Javascript is interpreted by
Options- A. Server
- B. Object
- C. Client
- D. None of the above Discuss
- 7. What is the correct JavaScript syntax to write ?Hello World??
Options- A. System.out.println(
- B. println (
- C. document.write(
- D. response.write( Discuss
- 8. Which is more effective while calling the functions?
Options- A. call by value
- B. call by reference
- C. call by pointer
- D. none Discuss
- 9. What is the default return type of a function ?
Options- A. int
- B. void
- C. float
- D. char Discuss
- 10. What do you mean by friend function in C++ ? Discuss
Technology problems
Search Results
Correct Answer: The built in function called GetDate() returns the time stamp
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: 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
Correct 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
Comments
There are no comments.More in Interview:
Programming
Copyright ©CuriousTab. All rights reserved.