Technical Interview Questions and Answers :: Virtusa
- Select All
- SQL
- C++
- .NET
- Oracle PLSQL
- Informatica
- WebMethod
- DBMS
- Soft. Engineering
- Data Structure
- Networking
- C
- Operating System
- HR Question in TR
- Java
61 / 221
A binder allows a two-argument function object to be used as a single-argument function by binding one argument is a value.
62 / 221
No Discussion on this question yet!
63 / 221
View created with base table, force view created without base table..
64 / 221
A View is a database object that is a logical representation of a table. It is derived from a table but has no storage space of its own and often may be used in the same manner as a table.
65 / 221
The are three levels of abstraction:
* Physical level: The lowest level of abstraction describes how data are stored.
* Logical level: The next higher level of abstraction, describes what data are stored in database and what relationship among those data.
* View level: The highest level of abstraction describes only part of entire database
66 / 221
A data base schema which is specified by a set of definitions expressed by a special language is called DDL. Data Definition Language (DDL) is used to define and manage all the objects in an SQL database.
67 / 221
It is a special language used to manipulate the Data. Data Manipulation Language (DML), which is used to select, insert, update, and delete data in the objects defined using DDL.
68 / 221
The PRIMARY KEY is the column(s) used to uniquely identify each row of a table.
69 / 221
A FOREIGN KEY is one or more columns whose values are based on the PRIMARY or CANDITATE KEY values from the database.
70 / 221
A UNIQUE KEY is one or more columns that must be unique for each row of the table.