Technology Questions

Q:

What operator tests column for the absence of data?

A) NOT operator B) IS NULL operator
C) EXISTS operator D) All of the above
 
Answer & Explanation Answer: B) IS NULL operator

Explanation:

SELECT "column_name"


FROM "table_name"


WHERE "column_name" IS NULL.

Report Error

View Answer Report Error Discuss

1 4491
Q:

Server control events are handled in the server whereas HTML control events are handled in the page

A) TRUE B) FALSE
Answer & Explanation Answer: A) TRUE

Explanation:

Server control events can be handled inside a server itself

Report Error

View Answer Workspace Report Error Discuss

Subject: Web Technology
Job Role: Software Architect

0 4488
Q:

How can you generate debugging output from PL/SQL?

Answer

Use the DBMS_OUTPUT package. Another possible method is to use the SHOW ERROR command.

Report Error

View answer Workspace Report Error Discuss

Subject: SQL

0 4481
Q:

Explain when to use GET or POST. Provide example for both the ways.

Answer

Both GET and POST are used to collect data from a form. However, when security is desired $_POST should be used. When the $_ POST variable is used, all variables used are NOT displayed in the URL. Also, they have no restrictions to the length of the variables. GET should be used when the interaction with the form is more like a question. For e.g. firing a query etc. POST should be used more often when the interaction is more like an order or the interaction changes the state of the resource.


POST example:


<form action="sample.php" method="post">


Name: <input type="text" name="name" />


Age: <input type="text" name="age" />


<input type="submit" />


</form>


On clicking submit the URL resembles to: https://www.mysamplesite.com/sample.php


The sample.php file can be used for catching the form data using $_POST 


Hello <?php echo $_POST["name"]; ?>.<br />


You are <?php echo $_POST["age"]; ?> years old!


 


GET EXAMPLE


<form action="sample.php" method="get">


Name: <input type="text" name="name" />


Age: <input type="text" name="age" />


<input type="submit" />


</form>


On clicking submit the URL resembles to : https://www.mysamplesite.com/sample.php?name=jim&age=37


The sample.php file can be used for catching the form data using $_GET 


Hello <?php echo $_GET["name"]; ?>.<br />


You are <?php echo $_GET["age"]; ?> years old!

Report Error

View answer Workspace Report Error Discuss

Subject: PHP

0 4472
Q:

How the different permutations are ordered in c++?

A) Compare lexicographicaly to each other elements B) By finding the highest element in the range
C) By finding the lowest element in the range D) None of the mentioned
 
Answer & Explanation Answer: A) Compare lexicographicaly to each other elements

Explanation:
Report Error

View Answer Report Error Discuss

Filed Under: C++

1 4471
Q:

What is meant by template specialization?

A) It will have certain data types to be fixed. B) It will make certain data types to be dynamic.
C) Certain data types are invalid D) None of the mentioned
 
Answer & Explanation Answer: A) It will have certain data types to be fixed.

Explanation:

In the template specialization, it will make the template to be specific for some data types.

Report Error

View Answer Report Error Discuss

Filed Under: C++

1 4448
Q:

When should we use container classes instead of arrays?

Answer

It is advisable to use container classes of the STL so that you don’t have to go through the pain of writing the entire code for handling collisions, making sure its working well, testing it repeatedly with an overhead of time consumption.


Suppose you have some data that has values associated with strings and its fields consist of grades> in this situation you can directly use hash table instead of having it created by yourself.

Report Error

View answer Workspace Report Error Discuss

Subject: C++

8 4447
Q:

Inside an interface when should the variables be initialized?

A) Globally B) Whenever required
C) Inside a function D) During the time of declaration
 
Answer & Explanation Answer: D) During the time of declaration

Explanation:

They should be initialized during the time of declaration itself otherwise it is a compilation eror

Report Error

View Answer Report Error Discuss

Filed Under: Java
Job Role: IT Trainer

0 4444