Ques:- What is Referential Integrity ?
Asked In :-
Twilio, Cumulations Technologies, Newgen Software Technologies, greenway health, vanenburg software,
Ques:- What is the diff between Dynamic queries and static queries
Asked In :-
Angular Minds, Iprimed Education Solutions, EvolveWare, cleartrail technologies, vanenburg software, quantstamp, inc.,
Ques:- Any three PL/SQL Exceptions
Ques:- To view installed Oracle version information
Asked In :-
Walkover Web Solutions, Girmiti Software, Panamax Infotech, kaizen technologies, vanenburg software, z2data,
Ques:- How you define which session run and how long time ?
Ques:- When does Oracle stop adding rows to a block?
Ques:- The initialization parameter file has LOG_CHECKPOINT_INTERVAL = 60; What does this mean?
Asked In :-
Invensis Technologies, vertisystem, capa - centre for aviation, vanenburg software, scii,
Ques:- What are the Referential actions supported by FOREIGN KEY integrity constraint ?
Right Answer:
The referential actions supported by FOREIGN KEY integrity constraint are:
1. CASCADE
2. SET NULL
3. SET DEFAULT
4. NO ACTION
5. RESTRICT
The referential actions supported by FOREIGN KEY integrity constraint are:
1. CASCADE
2. SET NULL
3. SET DEFAULT
4. NO ACTION
5. RESTRICT
Ques:- From which designation is it preferred to send the output to the printed?
Asked In :-
vanenburg software,
Ques:- How to use online payment on our web portal
Asked In :-
Aakit Technologies, Velocity Software Solutions, Elite Software Solutions, Atidan Technologies, CrimsonLogic India, PrimeSoft Solutions, Corient Business Solutions, Gibots, Paxcom, OmnePresent Technologies,
Ques:- Sql queries on Join, C, Data Structures (Mostly linked list, stack, queues), Basics of SDLC and Testing.
Asked In :-
Anand Rathi IT, Verticurl Marketing, Network Labs, HARITA TECHSERV, Quantified Commerce, Mobiveil, C-Zentrix, Trak Global, Kira Talent, Key Computer Applications,
Right Answer:
To answer SQL queries on joins, you can use the following examples:
1. **Inner Join**:
```sql
SELECT a.column1, b.column2
FROM tableA a
INNER JOIN tableB b ON a.common_column = b.common_column;
```
2. **Left Join**:
```sql
SELECT a.column1, b.column2
FROM tableA a
LEFT JOIN tableB b ON a.common_column = b.common_column;
```
3. **Right Join**:
```sql
SELECT a.column1, b.column2
FROM tableA a
RIGHT JOIN tableB b ON a.common_column = b.common_column;
```
4. **Full Outer Join**:
```sql
SELECT a.column1, b.column2
FROM tableA a
FULL OUTER JOIN tableB b ON a.common_column = b.common_column;
``
To answer SQL queries on joins, you can use the following examples:
1. **Inner Join**:
```sql
SELECT a.column1, b.column2
FROM tableA a
INNER JOIN tableB b ON a.common_column = b.common_column;
```
2. **Left Join**:
```sql
SELECT a.column1, b.column2
FROM tableA a
LEFT JOIN tableB b ON a.common_column = b.common_column;
```
3. **Right Join**:
```sql
SELECT a.column1, b.column2
FROM tableA a
RIGHT JOIN tableB b ON a.common_column = b.common_column;
```
4. **Full Outer Join**:
```sql
SELECT a.column1, b.column2
FROM tableA a
FULL OUTER JOIN tableB b ON a.common_column = b.common_column;
``
Ques:- What is a VIEW? How to get script for a view?
Asked In :-
Sumedha Softech, Qualminds Technologies, FIN Infocom, Softeon India, Shadowfax Technologies, KSB Tech, Polus Software, Thryve Digital, Busy Infotech, RWE Supply & Trading,
Right Answer:
A VIEW is a virtual table in SQL that is based on the result of a SELECT query. It does not store data itself but provides a way to present data from one or more tables in a specific format.
To get the script for a view in SQL Server, you can use the following command:
```sql
EXEC sp_helptext 'view_name';
```
Replace `view_name` with the name of the view you want to script.
A VIEW is a virtual table in SQL that is based on the result of a SELECT query. It does not store data itself but provides a way to present data from one or more tables in a specific format.
To get the script for a view in SQL Server, you can use the following command:
```sql
EXEC sp_helptext 'view_name';
```
Replace `view_name` with the name of the view you want to script.
Ques:- Why to use ‘OUTPUT’ clause in Sql Server?
Asked In :-
Helical It Solutions, DhruvSoft, Maruti Techlabs, Sarjen Systems, Volansys, Lekha Wireless Solutions, Mechlin Technologies, SADA, Lemon Technomist, Gridlex,
Ques:- What are the advantages of referential integrity?
Asked In :-
eGain Communications, SimpleMinds Technologies LLP, Qseap Technologies, Acrotrend Solutions, Sevya IT, Fullerton India, Argil DX, Tayana Software Solutions, Alcor Solutions, Napier Healthcare Solutions (India),
Ques:- What is .gitignore and why is it used?
Asked In :-
Hummingbird Web Solutions, LiteBreeze Infotech, Zentron Labs, Sarvaha Systems, BillDesk, Xtreme Softech, InfoObjects, Appscrip, Xoriant Solutions, Digite Infotech,
Right Answer:
.gitignore is a file used in Git to specify which files or directories should be ignored by version control. It prevents certain files, like temporary files or sensitive information, from being tracked and included in commits.
Ques:- What is Git and why is it used
Asked In :-
Xoriant Solutions Pvt Ltd, Hummingbird Web Solutions, TRICON INFOTECH PVT, Velocity Software Solutions, Ribbon Communications Inc, Appscrip, C E I India, Aris Global Software, Smart Cube India, WebDirekt India,
Right Answer:
Git is a distributed version control system used to track changes in source code during software development. It allows multiple developers to collaborate, manage code versions, and maintain a history of changes efficiently.
Ques:- What is git cherry-pick and when would you use it?
Asked In :-
Indocosmo Systems, Tredence Analytics Solutions, Sarvaha Systems, Techathalon Software Solutions, Ribbon Communications Inc, WebDirekt India, Chella Software, EY GDS, CareerNet, RoboSoft,
Right Answer:
Git cherry-pick is a command that allows you to apply the changes from a specific commit in one branch to another branch. You would use it when you want to selectively apply certain commits without merging the entire branch, such as when you need a bug fix or feature from another branch without bringing in all other changes.
Ques:- How do you undo a commit that hasn’t been pushed yet?
Asked In :-
LiteBreeze Infotech, TRICON INFOTECH PVT, Tredence Analytics Solutions, InfoObjects, C E I India, Hexaview Technologies private, AQM Technologies, Solugenix India, Bristlecone India, Smart Cube India,
Right Answer:
You can undo a commit that hasn’t been pushed yet by using the command `git reset HEAD~1`. This will remove the last commit while keeping your changes in the working directory.
Ques:- How do Git internals work (objects, refs, trees, blobs)?
Asked In :-
Xoriant Solutions Pvt Ltd, Indocosmo Systems, Happiest Minds Technologies Pvt., Angular Minds, Appscrip, ANR Software, Innodata, Zenon, Surya Software, SimpleMinds Technologies LLP,
Right Answer:
Git internals consist of four main components:
1. **Objects**: Git stores data as objects, which include blobs, trees, commits, and tags. Each object is identified by a SHA-1 hash.
2. **Blobs**: These are binary large objects that store the content of files. Each file's content is stored as a blob.
3. **Trees**: Trees represent directories and contain references to blobs (files) and other trees (subdirectories). They maintain the structure of the repository.
4. **Refs**: Refs are pointers to commits. They include branches and tags, allowing Git to track different versions of the project.
Together, these components enable Git to efficiently manage version control and track changes in a repository.
