TCS SQL/ PLSQL Real Interview BY TCS Team Interview Recording Simulation SQL TCS Ninja Interview

PLSQL:-
1.
SQL is used in relational databases to execute various queries like create table, delete table, insert into table, etc.
PL/SQL is used to write program blocks, procedures, functions, cursors, triggers, and packages. SQL does not support data variables. PL/SQL provides support for variable constraints and data types.

2.
PL/SQL gives high productivity to programmers as it can query, transform, and update data in a database. PL/SQL saves time on design and debugging by strong features, such as exception handling, encapsulation, data hiding, and object-oriented data types. Applications written in PL/SQL are fully portable.

3.
PL/SQL allows you to create anonymous blocks (blocks of code that have no name) and named blocks, which may be packages, procedures, functions, triggers, or object types. A PL/SQL block has up to four different sections, only one of which is mandatory: Header. Used only for named blocks.

4.
Cursor:-A Cursor is a temporary memory that is allocated by the database server at the time of performing the Data Manipulation Language operations on a table.

The main function of the cursor is retrieval of rows from the result set one at a time (row by row).

5.exception:-An exception is a PL/SQL error that is raised during program execution, either implicitly by TimesTen or explicitly by your program.

6.
Implicit cursors are automatically created when select statements are executed. Explicit cursors needs to be defined explicitly by the user by providing a name.

7.
The main difference between procedure and a function is, a function must always return a value, and on the other hand a procedure may or may not return a value.

8.
PL/SQL functions can't able to return multiple values,it can return only one (single ) values using OUT parameters in their arguments. It is possible to obtain multiple values by creating procedures with multiple OUT parameters.

9.
SQL was initially developed by IBM.

ALTER is DDL

You can use varchar2(50) type datatype where it will only use needed space , suppose your name has 10 charector then it will automatically del 40 from size 50...

Alter update,,

Delete command is used to remove the rows from the table but it's not clear the table space.
For trunc it will also remove the rows from the table but it's clear the table space.
Drop command used for removing the entire table structure.

Print this info in your brains for DROP vs TRUNCATE vs DELETE

DROP: Deletes the entire table along with its structure

TRUNCATE: Deletes the entire table but not the structure

DELETE: Deletes the entire table but the changes are not saved until you perform COMMIT. So basically, if any DDL command like DROP or TRUNCATE is executed an auto COMMIT is performed but we have to explicitly run the COMMIT command to save the changes permanently after we have executed a DML command.

No other thing is required and interviewer will be satisfied. Thank you!

Thank u for this video..its very helpful to prepare for interview

Update
tablename
Set
Salary=1000
Where
catageroy=departmentname

How to apply TCS fresher Oracle developer job

good interview

I have been doing sql for years and sometimes I forget the actual definition of things, but I know how to use them. This is why for interviews I would just go over a DBMS cheat sheet.

Truncate basically drops the table and creates the structure back ..so it is ddl and dml both

We can use sp.rename to rename a column

Can anyone help me for a sql unique project ?? It will be a great help

alter command is ddl

Please tell me only oracle(sql/plsql)can we get the job

Useful..how much experience he hace?

Very nice interview questions 👌🏻

Alter command is a DDL command
For editing column name using alter command only using Alter table tablename change column old_name new_name;

This interview for freshers or experienced?

Sir I did my graduation art background can I learn SQL?

ALTER and CREATE is DDL command
INSERT,UPDATE AND DELETE are the DML command

Anyone please tell that can alone SQL lands you a job in any IT company.
Actually I want to join IT sector that's why.

Thanks

very good vedio helpful.

Basically !!

insert Command is not in ddl

basics should be brushed up well here ...

You can't ask scenarios in an interview that came across in your work

We have delete , truncate, drop command to delete data , table..

Rajesh gobinath ceo in tcs

Data recover from oracle database

Procedure is numerical method functions is varchar

Select from functions. Method

Complete table

Select. Update salary from employees;

saale laudu type question kiyon poochte ho bey ? it’s ddl or dml really ? get a life

Alter table customer modify(address char(10),
Phone N(20));

UPDATE table_name
SET column_name1 = new_value,
column_name2 = new_value,
...
[WHERE Condition];

An SQL UPDATE statement changes the data of one or more records in a table. Either all the rows can be updated, or a subset may be chosen using a condition. The UPDATE statement has the following form: UPDATE table_name SET column_name = value [, column_name = value ...] [ WHERE condition]

Implicit cursors are automatically created when select statements are executed. Explicit cursors needs to be defined explicitly by the user by providing a name.

The DELETE statement removes rows one at a time and records an entry in the transaction log for each deleted row. TRUNCATE TABLE removes the data by deallocating the data pages used to store the table data and records only the page deallocations in the transaction log. DELETE command is slower than TRUNCATE command. TRUNCATE is faster than DELETE , as it doesn't scan every record before removing it.
TRUNCATE TABLE locks the whole table to remove data from a table;
thus, this command also uses less transaction space than DELETE

The interview is about basic sql command

package is 15 years old and questions are also of same era

The alter table is DDL comand in sql

i want to ask a question that , fluent english is mandatory for interview bcoz sometime candidates has knowledge but they don't express front of interviewer bcoz he don't speak english fluently. bcoz i am one of them😊