Technology Questions

- The principle of least privilege is used to provide more security to the computer programs. 

- The principle allows the designing of the program such that any unauthorized access is not allowed and only the person who owns the program will be able to access it. 

- The services provided should be able to access only those products that need the services. 

- Web servers that are involved in responding the queries of the web users provide only accessing to the HTML files that will serve the purpose of the programs. 

- Computer programs should be made such that it provides secure features of logging into the program with proper authentication.

FIND_GROUP(function) FIND_COLUMN(function)

- FTP is used to upload the files on the server from the client side where it is installed on the computer of clients. 

- FTP client is checked for the installation of the software and according to that the appropriate directory is uploaded on the hosting server. 

- The hosting server uploads the files that is being created by the user and set the permissions for it so that public can access it. 

- Web hosting uses different directories like HTML that is used as var/www/html that is determined using the FTP client. 

- Initial local directory is being set up using FTP client and it is where the website gets stored. 

- The transfer mode is being determined for the files that need to be transferred either in ASCII or BINARY mode.

1) START- Used to run a SQL script.
2) ACCEPT- Accepts input from user.
3) GET- Gets the sql file from user to place in buffer.
4) LIST- Displays the last command executed.
5) RUN- Used to list and run the command in buffer
6) SHOW- Shows the environment settings. Example: SHOW PAGESIZE

The UTL_FILE database package can be used to read and write operating system files. You need to have read /write access rights in that directory before the package can be used.

Example to write file:

Fhandler is a variable of type UTL_FILE.FILE_TYPE

UTL_FILE.PUTF(fHandler, 'Im writing to a file\n');

Example to read file:

UTL_FILE.GET_LINE(fHandler, buf);

When creating a thread by extending the Thread class, it is not mandatory to override the run method (If we are not overriding the run method , it is useless), because Thread class have already given a default implementation for run method. But if we are implementing Runnable , it is mandatory to override the run method. The preferred way to create a thread is by implementing Runnable interface, because it give loose coupling.

With HTML5, it is possible for the web pages to store the data locally in the user's browser. This web storage is much faster and secured than the cookies. Also, a larger amount of data can be stored without causing any adverse effect to the performance of the website. 

The data here is not included with every server request. It is used ONLY when it is asked for. It is only that particular web page that can access the data stored by itself.

var obj = new Object(); or var obj = {};