Searching for "Row"

Q:

Explain how to limit the rows that are retrieved by a query.

Answer

The number of rows returned by a select query can be restricted by the LIMIT clause.
Example:
SELECT * from employee
LIMIT 20

Report Error

View answer Workspace Report Error Discuss

Subject: Oracle

Q:

Explain Row level and statement level trigger.

Answer

Row Level Trigger :
Row Level Trigger is fired each time row is affected by Insert, Update or Delete command. If statement doesn’t affect any row, no trigger action happens.

Statement Level Trigger :
This kind of trigger fires when a SQL statement affects the rows of the table. The trigger activates and performs its activity irrespective of number of rows affected due to SQL statement.

Report Error

View answer Workspace Report Error Discuss

Subject: Oracle

Q:

What is the primary function of the Web browsers?

Answer

- Web browser functions are to provide the resources or information to the user when asked by them. 


- It processes the user inputs in the form of URL like https://www.google.com in the browser and allows the access to that page. 


- URL is used to identify the resources and fetch them from the server and displays it to the client. 


- It allows the user to interact with the web pages and dynamic content like surveys, forms, etc. 


- It also allows the user to navigate through the complete web page and see its source code in the HTML format. 


- It provides security to the data and the resources that are available on the web that is by using the secure methods.

Report Error

View answer Workspace Report Error Discuss

Subject: Web Technology

Q:

What are the ways to change the cookie setting using the web browser?

Answer

The cookie settings include the enabling and disabling of the services that are used with the web browsers.


The following steps are taken to set the cookies:


- The TOOLS menu is being opened on web browser and the privacy tab is selected from where the privacy of individual user can be managed. 


- Using the ADVANCED tab the options to set the cookies will be visible and it will allow the overriding of cookie. 


- The cookies can be accepted by checking the first party cookies or the third party cookies. Out of these choices the first party cookies provide more security. 


- Check the checkbox for "Always allow session cookies" so that the session cookies can be maintained. 

Report Error

View answer Workspace Report Error Discuss

Subject: Web Technology

Q:

What is the procedure to configure the web browser to accept or reject cookies?

Answer

- The web browser visits a website using the HTTP and then it keeps the track of the identity of the user visiting the web page.


- The cookies of HTTP get stored with the personal information of the user and it doesn’t accept the information. 


- Users accept the cookies as by rejecting all the cookies will load the web page in longer time and it will not be desired by the users. 


- Even if the cookie is being rejected a session cookie is being kept for use as it is the provision given to the web browser to use it. 


- The cookies gets stored temporary basis depending on the user of accepting or rejecting it and it basically saves the session so that the duration of the page load can be reduced.

Report Error

View answer Workspace Report Error Discuss

Subject: Web Technology

Q:

What are the different web browser tools available to accelerate the speed of the web page?

Answer

- Web accelerators are used to increase the loading of the web page faster and by providing extra features of caching, etc. 


- There are tools that are provided like internet accelerator of browser accelerator that provides security from the spyware and adware programs. 


- The security from the programs are required as they are harmful for the computer and the tools uses the strategies of pre-caching in which the data is automatically cached and when the website is opened again then the fetching is being done from the place where the content is saved. 


- Registry tweaks are used to improve the performance offering the risk management techniques for downloading the resources.

Report Error

View answer Workspace Report Error Discuss

Subject: Web Technology

Q:

What are the privacy and security features being provided by web browsers?

Answer

- Web browser supports HTTP secure method that allows more security for the sites that are involved in day to day basis transaction. 


- Security offers quick and easy way to remove the unwanted material or the things that are stored without permission like cache, cookies and history. 


- Security is being provided by the use of blockers that blocks unwanted access to the websites from the outside. 


- Web browser uses other features like disabling of JavaScript and pop up blockers to block any unwanted scripts or messages to run on the system.


- Web browser also uses the security concerns in regard of blocking the access to the secure sites that provides money transfer facilities, etc.

Report Error

View answer Workspace Report Error Discuss

Subject: Web Technology

Q:

What is the purpose of web browser?

Answer

- Web browser is used to run the software application that allows retrieving, presenting and traversing the information from one place to another. 


- Web browser provides the resources using the WWW (World Wide Web) this can be identified by URI (Uniform Resource Identifier).


- Web browser fetches the data like web page, image, video or other piece of content from the server and displays it accordingly. 


- Web browser uses hyperlinks to display the resources and allow the users to navigate their browsers according to the resources. 


- Web browser defines the application software that is designed for the user to access and retrieve the documents using the Internet.

Report Error

View answer Workspace Report Error Discuss

Subject: Web Technology