Explore topic-wise InterviewSolutions in Current Affairs.

Triggers are stored and controlled in the DBMS. A trigger is executed automatically when a condition is met (INSERT, UPDATE, or DELETE). A procedure is also stored in a database. A procedure is not executed automatically.

An outer join includes the records that match and those that do not have a matching value in another table. Outer joins can be a LEFT outer join (includes all records from the first table listed) or a RIGHT outer join (includes all records from the second table listed). Outer joins are not easily used with more than two tables.

A subquery is a query that is composed of two queries. The first query (inner query) is within the WHERE clause of the other query (outer query). In some cases the inner query provides results for the outer query to process. In other cases, the outer query results provide results for the inner query (correlated subquery).

Embedded SQL is the process of including hard coded SQL statements. These statements do not change unless the source code is modified. Dynamic SQL is the process of generating SQL on the fly. The statements generated do not have to be the same each time.

ADO.NET is a new, improved, and greatly expanded version of ADO that was developed for the Microsoft .NET initiative. ADO.NET incorporates all of the functionality of ADO, but adds much more. In particular, ADO.NET facilitates the transformation of XML documents to and from database data. Most importantly, ADO.NET introduces the concept of datasets, which are in-memory, full-function, independent databases.

A three-tier architecture includes a client and two server layers. The application code is stored on the application server and the database is stored on the database server. A two-tier architecture includes a client and one server layer. The database is stored on the database server.

Simple elements have only one data value. Complex Type elements can have multiple elements nested within them. Complex Types may also have attributes. The elements contained in a complex Type may be simple or other complex Types. Complex Types may also define element sequences.

You can perform more complex functions and error handling can be accommodated by VBA. VBA code will execute faster since code runs faster than macros and maintenance is easier because VBA modules are stored with the forms and reports. Reading VBA is easier because you can see the entire code. Finally, you can pass parameters and use OLE automation better.

DTD (Document Type Declarations) and XML Schemas. An XML document that conforms to its DTD is called type-valid. A document can be well-formed and not be type-valid, either because it violates the structure of its DTD or because it has no DTD. However, DTDs have limitations and to overcome these limits XML Schemas were created. XML Schemas are XML documents that are the preferred method for defining document structure.

QBE is a direct-manipulation database language that uses a graphical approach to query construction. Some database systems translate QBE queries into SQL. QBE does not adhere to a standard but SQL does. Both SQL and QBE are relational database languages.

A fat client is a PC that is responsible where most processing occurs on the client rather than the server. Some of the fat client activities include processing, presentation logic, and business rules logic. A thin client is a PC where only limited processing occurs. In these cases, more processing should occur on the application server.

XML is a better markup language than HTML, primarily because XML provides a clear separation between document structure, content, and materialization. Symbols cannot be used ambiguously with XML.

ODBC is a standard that contains an interface that provides a common language for application programs to access and process SQL databases. In order to use ODBC, a driver, server name, database name, user id, and password are required. ODBC is important for Internet applications and has gained wide acceptance.

By breaking the features and the functions of a DBMS into COM objects, OLE DB characteristic overcomes a major disadvantage of ODBC. With ODBC, a vendor must create an ODBC driver for almost all DBMS features and functions in order to participate in ODBC at all. This is a large task that requires a substantial initial investment. With OLE DB, however, a DBMS vendor can implement portions of their product.

An OLE DB interface is specified by a set of objects, and the properties and methods that they expose, and OLE DB defines standardized interfaces. An object need not expose all of its properties and methods in a given interface. An OLE DB implementation defines how the object supports the interface. The implementation is completely hidden from the user. Thus developers of an object are free to change the implementation whenever they want, but they should not change the interface without consulting their users.

Silver Idol plays an important role in our life because it has positive energy which can help us a lot. And there is a lot of importance of silver idols in our life. In Hindu religion it is known that if you have silver idols then there are more chances to get success in life.  If you want a life where you get peace then you must have property, happiness and good health and these three things can bring peace in your life. Silver Idols have the power to give you strength and make your life easy.

Whatever field you are in, whatever work you do, wherever you live, you must have silver idols of any god. Because indirectly it helps you a lot and always gives you happiness and wealth. And for this we all know that silver laxmi plays a important role in our life to make it more wealthy because it is known that silver laxmi is the sign of wealth and if you do the worship of laxmi with positivity then whatever business or work you do there are high chance that you will get success in this. The silver standing laxmi is the most powerful idol which can make you wealthy. On dhanteras many people bring silver laxmi idols in their house so that goddess laxmi can make them capable of earning money. And like this, silver idols have the power to do everything for us, whatever we want to do. Bring silver idols at your home and let them change your life.

So, these are the importance of silver idols. If you think that you should really have one of them then you can visit and explore all the silver idols and can make your life happy and peaceful. And also, the silver standing laxmi which can really help you and give the right direction to you. Really silver idols bring positivity in your home by removing negative energy.

The major goals of OLE DB are to: 

(1) Create object interfaces for DBMS functionality pieces; 

(2) Increase flexibility for developers and users; 

(3) provide an object interface over any type of data; and 

(4) do not force data to be converted or moved from where it is.

An ODBC file data source is a file that can be shared among database users. A ODBC system data source is one that is local to a single computer. A ODBC user data source is only available to the user who created it.

Following are the critical components of planning your retail store layout -

• Traffic flow
• Economy in handling
• Lighting
• Display space
• Minimum movement
• Reduced discomfort
• Adherence to statutory regulations
• Preservation of material and equipment

Developed first, the ODBC standard is for relational databases; while the OLE DB standard provides functionality for both relational and other databases. Finally, ADO was developed to provide easier access to OLE DB data for the non-objectoriented programmer.

SQL Server 2000 supports INSTEAD OF and AFTER triggers only. There is no SQL Server support for BEFORE triggers. A table may have one or more AFTER triggers for insert, update and delete actions; AFTER triggers may not be assigned to views. A view or table may have at most one INSTEAD OF trigger for each triggering action of insert, update or delete.

With a clustered index, the data are stored in the bottom level of the index and in the same order as that index. With a non clustered index, the bottom level of an index does not contain data; it contains pointers to the data. For data retrieval, clustered indexes are faster than non clustered indexes.

A complete backup makes a copy of the entire database. A differential backup makes a copy of the changes that have been made to the database since the last complete backup. A complete backup must be made before the first differential backup. Because differential backups are faster, they can be taken more frequently and the chance of data loss is reduced. Complete backups take longer but are slightly simpler to use for recovery.

With the simple recovery model, no logging is done. The only way to recover a database is to restore the database to the last backup. With full recovery, all database changes are logged. With bulk-logged database recovery, all changes are logged except those that cause large log entries.

\(\underset{initially}\,\,\,\;\underset{80cm^3}{CH_4(g) }+ \underset{200cm^3}{2O_2(g)} \longrightarrow CO_2(g) + 2H_2 O(l)\)

∵ Temperature and pressure as constant, from the above chemical equation we can conclude that -

1 volume of CH₄ react with 2 volume of pure oxygen (O₂) to form 1 volume CO₂.

(Volume of H₂O(l) is negligible to compare volume of gaseous molecules)

∴ Here, CH₄ is limiting reagent.

∴ Volume of pure O₂ unreacted = (200 - 160)cm³ = 40 cm³

∴ Volume of CO₂ formed = 80 cm³

Hence, mixture contain 40 cm³ O₂ and 80 cm³ CO₂.

Convenience food is any item of food that is prepared before you purchase it. It also involves some kind of packaging and made available in food stores. There are certain preservatives, chemicals and ingredients added to them to enable them to last longer because it might take a long time before anyone buys them. In other words, they are prepared for prolonged shelf life but this might mean they are not as nutritious as you would have hoped.

The strictest isolation level is SERIALIZABLE. With it, SQL Server places a range lock on the rows that have been read. This level is the most expensive to use and should only be used when absolutely required. The next most restrictive level is REPEATABLE READ, which means SQL Server places and holds locks on all rows that are read. It is possible to make dirty reads by setting the isolation level to READ UNCOMMITTED, which is the least restrictive level. READ COMMITTED is the default isolation level.

This type of cell is known as electrolyte concentration cell. For this type of cell \(E^0_{cell} =0.\)

At anode 

\(2Ag(s) \longrightarrow \underset{c_1 = 0.02 M} {2Ag^+}(aq) + 2e^- \; \text{oxidation}\)

At cathode

\(\underset{c_2 = 0.042 m}{Ag^\oplus_2SO_4}(aq) + 2e^-\longrightarrow 2Ag(s) + SO_4 ^{-2}(aq) \;\text{reduction}\)

Cell representation-

\(Ag(s)/Ag_2SO_4(0.02M) // Ag_2SO_4(0.042M)/Ag(s)\)

Overall cell reaction-

\(Ag^\oplus_2 SO_4 (C_2) \longrightarrow Ag_2SO_4 (C_1)\)

or \(Ag^+(c_2) \longrightarrow Ag^+ (c_1)\) 

\(\therefore E_{cell} = E^0_{cell} -\frac{RT}{nf}ln \frac{c_1}{c_2}\)

⇒ \(E_{cell} = 0 - \frac{0.0591}1log\frac{0.02}{0.042}\)

\(\therefore E_{cell} = -0.0591 \times log(0.4762)\)

\(= -0.0591 \times (-0.322)\)

\(= 0.019\)

\(E_{cell} = 0.02V\)

\(E_{cell} = 20\, mV\)

Oracle supports read committed, serializable, and read-only transaction isolation levels. Because of the way Oracle System Change Number (SCN) values are processed, Oracle never reads dirty data. Serializable isolation is possible, but the application program must be written to process the "Cannot serialize" exception. Applications can place locks explicitly using SELECT FOR UPDATE commands but this is not recommended.

1. Sodium is soft and reactive metal.

2. Calcium

3. Mercury

So, the increasing order of their reactivity is
Hg < Ca < Na or Mercury < Calcium < Sodium

Potassium metabisulphite and Sodium Benzoate.

Preserve and candy

Urban peri-urban horticulture : Growing of horticultural crops in towns and cities is called as urban horticulture whereas growing of horticultural crops on the periphery of towns and cities is called as peri-urban horticulture.

Lycopersicon esculentum.

Side veneer grafting, epicotyl grafting and soft wood grafting

Preservation by salt, preservation by sugar, preservation by heat, preservation by low temperature, preservation by acids, preservation by antibiotics etc.

Aonla and guava.