Prepare Interview with Confidence
What are stored procedures? How is it useful A stored procedure is a set of statements/commands which reside in the database. The stored procedure is pre-compiled and saves the database the effort of parsing and compiling sql statements every time a query is run. Each database has its own stored procedure language, usually a variant … Read more
What is synchronization and why is it important? With respect to multithreading, synchronization is the capability to control the access of multiple threads to shared resources. Without synchronization, it is possible for one thread to modify a shared object while another thread is in the process of using or updating that object’s value. This often … Read more
In which types of websites, Joomla is frequently used? It is used in following type of websites Corporate web portals Online media websites NGO Websites Personal pages Social Media portals Explain drawbacks of Joomla. Provide limited options Plugin compatibility may cause an issue. Its websites are heavy Limited server resources and efficiency How to link … Read more
Can you explain the SELECT INTO Statement SELECT INTO statement is used mostly to create backups. The below SQL backsup the Employee table in to the EmployeeBackUp table. One point to be noted is that the structure of pcdsEmployeeBackup and pcdsEmployee table should be same. SELECT * INTO pcdsEmployeeBackup FROM pcdsEmployee What is SQL SQL … Read more
What is Power BI Desktop? Power BI Desktop is a free desktop application which can be installed on your computers. Power BI Desktop works with the Power BI service by providing advanced data exploration, shaping, modeling, and creating a report with highly interactive visualizations. You can save the work to a file or publish your … Read more
What is application Widgets in Android? Application widgets are miniature application views that can be embedded in other applications and receive periodic updates. What is intent? It is a kind of message or information that is passed to the components. It is used to launch an activity, display a web page, send SMS, send email, … Read more
What is CloudFront? CloudFront is a computer delivery network which consists of distributed servers that delivers web pages and web content to a user based on the geographic locations of a user. What is VPC? VPC stands for Virtual Private Cloud. It is an isolated area of the AWS cloud where you can launch AWS … Read more
What is Pass in Python? Pass specifies a Python statement without operations. It is a placeholder in a compound statement. If we want to create an empty class or functions, this pass keyword helps to pass the control without error. # For Example class Student: pass # Passing class class Student: def info(): pass # Passing function How can you … Read more
What was the old name of PHP? The old name of PHP was Personal Home Page. What is the use of count() function in PHP? The PHP count() function is used to count total elements in the array, or something an object. Which programming language does PHP resemble to? PHP has borrowed its syntax from … Read more
What are the advantages of Selecetion Sort? It is simple and easy to implement. It can be used for small data sets. It is 60 per cent more efficient than bubble sort. List the types of tree. There are six types of tree given as follows. General Tree Forests Binary Tree Binary Search Tree Expression … Read more