Q : Explain what is MongoDB? A : Mongo-DB is a document database which provides high performance, high availability and easy scalability. Q : What is sharding in MongoDB? A : The procedure of storing data records across multiple machines is referred as Sharding. It is a MongoDB approach to meet the demands of data growth. It is the horizontal partition of data in a database or search engine. Each partition is referred as shard or database shard. Q :
Q : List four possible ways (direct or indirect) to execute an SQL query against an Oracle Database? A : Using the SQL*Plus command line tool. With this tool, you can directly execute SQL commands. Using a GUI (Graphical User Interface) tool like SQL Developer. You can directly execute SQL commands with such tools. Using Oracle Enterprise Manager. This is an indirect way of executing an SQL query. When you perform certain operations with Oracle Enterprise Manager, they are converted
Q : What are the uses of APEX? A : 1. Builds professional looking web applications that are both fast and secure. 2. Runs on and lives in Oracle database. APEX framework and meta data are stored in Oracle tables. 3. It is FREE. No licensing required. 4. Fast learning curve for developers to build application. 5. Deployment of application is as simple as ‘Export and Import’ if hard coded references of values that change between environments are avoided. 6.
Q : What is an alias in SQL statements? A : Alias is a user-defined alternative name given to the column or table. By default column alias headings appear in upper case. Enclose the alias in a double quotation marks (“ “) to make it case sensitive. “AS” Keyword before the alias name makes the SELECT clause easier to read. For ex: Select empname AS name from employee; (Here AS is a keyword and “name” is an alias). Q :
Q : What is split brain? A : When database nodes in a cluster are unable to communicate with each other, they may continue to process and modify the data blocks independently. If the same block is modified by more than one instance, synchronization/locking of the data blocks does not take place and blocks may be overwritten by others in the cluster. This state is called split brain. Q : What is cache fusion? A : In a RAC environment,
Q : What is BCP? When is it used? A : It is a tool used to duplicate enormous quantity of information from tables and views. It does not facsimile the structures same as foundation to target. BULK INSERT command helps to bring in a data folder into a record, table or view in a user-specific arrangement. Q : When is the UPDATE_STATISTICS command used? A : This command is used, ones the processing of large data is done. When we
Q : What is the significance of the /oracle/product/Middleware/AIA/aia_instances/my_instance/ AIAMetaData/config/AIAConfigurationProperties.xml file? When an interface is migrated from Dev to Test, how do I make sure that this file is updated in Test instance? Is it by manually updating and running UpdateMetaData.xml? or the AID will take care of it? A : This file is absolutely key at runtime as services read certain properties (e.g. the actual endpoint of the services that are called) from that file. I would assume your
Q : What is Oracle Data Integrator (ODI)? A : Oracle acquired Sunopsis in 2006 and with it “Sunopsis Data Integrator”. Oracle Data Integrator (ODI) is an E-LT (Extract, Load and Transform) tool used for high-speed data movement between disparate systems. The latest version, Oracle Data Integrator Enterprise Edition (ODI-EE) brings together “Oracle Data Integrator” and “Oracle Warehouse Builder” as separate components of a single product with a single licence. Q : What components make up Oracle Data Integrator? A
Q : What is Caching? A : Caching is a technique used to cache site pages. Q : What is the difference between CSElement & Template & SiteEntry? A : CSElement is to execute common business logic & we cannot cache cselement SiteEntry is for caching the CSElement Template will create both the CSElement & SiteEntry Q : What is Satellite Server? A : Satellite Server is a caching application. 2 types of Satellite Server 1)co-resident co-resident Satellite Server is
Q : What is Oracle Webcenter Portal? A : Oracle WebCenter Portal provides design time and runtime tools for building enterprise portals, transactional web sites, and social networking sites. It provides portal-specific features such as page hierarchies, navigation models, delegated security, customization, and others. Portals can also include features like portlets, content management system integration, personalization, social computing services, search, analytics etc. Q : What is the difference between trinidad.config and trinidad.skins? A : trinidad.config file is ceated when you create a webcenter portal