Prepare Interview with Confidence
What will you get by the cursor attribute SQL%ROWCOUNT? The cursor attribute SQL%ROWCOUNT will return the number of rows that are processed by a SQL statement. What is the maximum number of triggers, you can apply on a single table? 12 triggers. How many types of triggers exist in PL/SQL? There are 12 types of … Read more
Explain the remapping method calls in CodeIgniter. The Second segment of URI determines which method is being called. If you want to override it, you can use _remap() method. The _remap method always get called even if URI is different. It overrides the URI. For Example: public function _remap($methodName) { if ($methodName === ‘a_method’) { … Read more
Explain Alpha–Beta pruning. Alpha–Beta pruning is a search algorithm that tries to reduce the number of nodes that are searched by the minimax algorithm in the search tree. It can be applied to ‘n’ depths and can prune the entire subtrees and leaves. What is model accuracy and model performance? Model accuracy, a subset of … Read more
What does setAutoCommit(false) do A JDBC connection is created in auto-commit mode by default. This means that each individual SQL statement is treated as a transaction and will be automatically committed as soon as it is executed. If you require two or more statements to be grouped into a transaction then you need to disable … Read more
What are the components in Joomla? Components can be known as the main elements of Joomla’s functionality. The core elements are: Contents Banner Poll Information news feeds web link What are the most useful and advanced features or add-ons in Joomla? Joomla framework has some very useful and advanced features that facilitate developers to build … Read more
Can you explain Fourth Normal Form and Fifth Normal Form In fourth normal form it should not contain two or more independent multi-v about an entity and it should satisfy “Third Normal form”. Fifth normal form deals with reconstructing information from smaller pieces of information. These smaller pieces of information can be maintained with less … Read more
What is VPC peering connection? A VPC peering connection is a networking connection that allows you to connect one VPC with another VPC through a direct network route using private IP addresses. By using VPC peering connection, instances in different VPC can communicate with each other as if they were in the same network. You … Read more
How are view elements identified in the android program? View elements can be identified using the keyword findViewById. What is ADB? ADB stands for Android Debug Bridge. It is a command line tool that is used to communicate with the emulator instance. What is a portable wi-fi hotspot? The portable wi-fi hotspot is used to … Read more
How can you organize your code to make it easier to change the base class? You have to define an alias for the base class, assign the real base class to it before your class definition, and use the alias throughout your class. You can also use this method if you want to decide dynamically … Read more
What are magic constants in PHP? PHP magic constants are predefined constants, which change based on their use. They start with a double underscore (__) and end with a double underscore (__). What does isset() function? The isset() function checks if the variable is defined and not null. What is “echo” in PHP? PHP echo … Read more