vestino technologies Interview Report
- 0of 0 votes
AnswersWrite a Query to display employee details who is working in ECE department & who his having more than 3 years of exp?
- mythili.vestino April 30, 2021 in India for HR| Report Duplicate | Flag | PURGE
vestino technologies HR Executive SQL - 0of 0 votes
AnswersWrite a Query to display even records from the table?
- mythili.vestino April 30, 2021 in India for HR| Report Duplicate | Flag | PURGE
vestino technologies HR Executive SQL - 0of 0 votes
AnswersWhat is recursive stored procedure?
- mythili.vestino April 30, 2021 in India for HR| Report Duplicate | Flag | PURGE
vestino technologies HR Executive SQL - 0of 0 votes
AnswersWhat are aggregate and scalar functions?
- mythili.vestino April 30, 2021 in India for HR| Report Duplicate | Flag | PURGE
vestino technologies HR Executive SQL - 0of 0 votes
AnswersCan we write a distributed query and get some data which is located on other server and on Oracle Database ?
- mythili.vestino April 30, 2021 in India for HR| Report Duplicate | Flag | PURGE
vestino technologies HR Executive SQL - 0of 0 votes
AnswersHow do you generate file output from SQL?
- mythili.vestino April 30, 2021 in India for HR| Report Duplicate | Flag | PURGE
vestino technologies HR Executive SQL - 0of 0 votes
AnswersWrite a Query to display no.of males in each department?
- mythili.vestino April 30, 2021 in India for HR| Report Duplicate | Flag | PURGE
vestino technologies HR Executive SQL - 0of 0 votes
AnswersHow SQL Server executes a statement with nested subqueries?
- mythili.vestino April 30, 2021 in India for HR| Report Duplicate | Flag | PURGE
vestino technologies HR Executive SQL - 0of 0 votes
AnswersIf we drop a table, does it also drop related objects like constraints, indexes, columns, defaults, Views and Stored Procedures?
- mythili.vestino April 30, 2021 in India for HR| Report Duplicate | Flag | PURGE
vestino technologies HR Executive SQL - 0of 0 votes
AnswersHow important do you consider cursors or while loops for a transactional database?
- mythili.vestino April 30, 2021 in India for HR| Report Duplicate | Flag | PURGE
vestino technologies HR Executive SQL - 0of 0 votes
AnswersWhat is a trigger?
- mythili.vestino April 30, 2021 in India for HR| Report Duplicate | Flag | PURGE
vestino technologies HR Executive SQL - 0of 0 votes
AnswersWhat is collation?
- mythili.vestino April 30, 2021 in India for HR| Report Duplicate | Flag | PURGE
vestino technologies HR Executive SQL - 0of 0 votes
AnswersWrite a Query to display odd records from student table?
- mythili.vestino April 30, 2021 in India for HR| Report Duplicate | Flag | PURGE
vestino technologies HR Executive SQL - 0of 0 votes
AnswersWhat is a stored procedure?
- mythili.vestino April 30, 2021 in India for HR| Report Duplicate | Flag | PURGE
vestino technologies HR Executive SQL - 0of 0 votes
AnswersWhat is the Difference between COALESCE() & ISNULL()?
- mythili.vestino April 30, 2021 in India for HR| Report Duplicate | Flag | PURGE
vestino technologies HR Executive SQL - 0of 0 votes
AnswersWhat is the command used to fetch first 5 characters of the string?
- mythili.vestino April 30, 2021 in India for HR| Report Duplicate | Flag | PURGE
vestino technologies HR Executive SQL - 0of 0 votes
AnswersAdvantages and Disadvantages of Stored Procedure?
- mythili.vestino April 30, 2021 in India for HR| Report Duplicate | Flag | PURGE
vestino technologies HR Executive SQL - 0of 0 votes
AnswersWhat is Magic Tables in SQL Server?
- mythili.vestino April 30, 2021 in India for HR| Report Duplicate | Flag | PURGE
vestino technologies HR Executive SQL - 0of 0 votes
AnswersWrite down the general syntax for a SELECT statements covering all the options.
- mythili.vestino April 30, 2021 in India for HR| Report Duplicate | Flag | PURGE
vestino technologies HR Executive SQL - 0of 0 votes
AnswersWhat are all different types of collation sensitivity?
- mythili.vestino April 30, 2021 in India for HR| Report Duplicate | Flag | PURGE
vestino technologies HR Executive SQL - 0of 0 votes
AnswersWhat is OSQL utility ?
- mythili.vestino April 30, 2021 in India for HR| Report Duplicate | Flag | PURGE
vestino technologies HR Executive SQL - 0of 0 votes
AnswersWhat are user-defined data types and when you should go for them?
- mythili.vestino April 30, 2021 in India for HR| Report Duplicate | Flag | PURGE
vestino technologies HR Executive SQL - 0of 0 votes
AnswersWrite a Query to display student details along with the row_no order by student name?
- mythili.vestino April 30, 2021 in India for HR| Report Duplicate | Flag | PURGE
vestino technologies HR Executive SQL - 0of 0 votes
AnswersCan we add an identity column to decimal datatype?
- mythili.vestino April 30, 2021 in India for HR| Report Duplicate | Flag | PURGE
vestino technologies HR Executive SQL - 0of 0 votes
AnswersWhat Is the Difference Between OSQL And Query Analyzer?
- mythili.vestino April 30, 2021 in India for HR| Report Duplicate | Flag | PURGE
vestino technologies HR Executive SQL - 0of 0 votes
AnswersWhich operator is used in query for pattern matching?
- mythili.vestino April 30, 2021 in India for HR| Report Duplicate | Flag | PURGE
vestino technologies HR Executive SQL - 0of 0 votes
AnswersCan we disable a triger?, if yes HOW?
- mythili.vestino April 30, 2021 in India for HR| Report Duplicate | Flag | PURGE
vestino technologies HR Executive SQL