5 avg. rating (100% score) - 1 votes
Looking for Anz Sql server job? Prepare by practicing Anz Sql server job interview questions and answers page designed by wisdom jobs professional experts. The basic skills of a Anz Sql server developer includes, Reviewing query performance and optimizing code, Writing queries used for front-end applications (desktop applications or cloud apps, websites), Data modeling to envisage database structure, Coding and scheming of database tables to store the application’s data, Working with application developers to make optimized queries, Creating database triggers for computerization, e.g., automatic email notifications, Creating table indexes to enhance database performance, stored procedures, Programming views, and functions etc. There is a huge demand for Anz Sql server jobs in famous cities like Mumbai, Kolkata, Pune, Hyderabad Delhi etc.
Question 1. What Is A Foreign Key?
Answer :
A foreign key is one table which can be related to the primary key of another table. Relationship needs to be created between two tables by referencing foreign key with the primary key of another table.
Question 2. What Is Normalization?
Answer :
Normalization is the process of minimizing redundancy and dependency by organizing fields and table of a database. The main aim of Normalization is to add, delete or modify field that can be made in a single table.
Question 3. What Is Self-join?
Answer :
Self-join is set to be query used to compare to itself. This is used to compare values in a column with other values in the same column in the same table. ALIAS ES can be used for the same table comparison.
Question 4. What Is Sql Profiler?
Answer :
Question 5. How To Find Second Highest Salary Of An Employee?
Answer :
There are many ways to find second highest salary of Employees in SQ. You can either use SQL Join or Subquery to solve this problem.
Here is SQL query using Subquery :
Select MAX(Salary) from table1 WHERE Salary NOT IN ( select MAX(Salary)
from table1.
Question 6. What Is The Difference Between Truncate And Drop Statements?
Answer :
TRUNCATE removes all the rows from the table, and it cannot be rolled back. DROP command removes a table from the database and operation cannot be rolled back.
Question 7. What Are Aggregate And Scalar Functions?
Answer :
Aggregate functions are used to evaluate mathematical calculation and return single values. This can be calculated from the columns in a table. Scalar functions return a single value based on the input value.
Example -.
Aggregate – max(), count – Calculated with respect to numeric.
Scalar – UCASE(), NOW() – Calculated with respect to strings.
Question 8. Which Operator Is Used In Query For Pattern Matching?
Answer :
LIKE operator is used for pattern matching, and it can be used as -.
% – Matches zero or more characters.
_(Underscore) – Matching exactly one character.
Anz Sql Server Related Tutorials |
|
---|---|
SQL Server 2008 Tutorial | SAS Programming Tutorial |
Sql Server 2008 Overview
Sql Server Installation And Configuration
Policy Management
High Availability
Security
Sql Server Encryption
Automation And Monitoring
Service Broker
Integrated Full-text Search
New Datatypes In Sql Server 2008
T-sql Enhancements For Developers
T-sql Enhancements For Dbas
.net Integration
Programming Assemblies
Sql Server And Xml
Sql Server Xml And Xquery Support
Reporting Services
Analysis Services
Integration Services
Text Resumes
Visual Resumes
Social Resumes
Resume Quality
IT Resume Samples
MARKETING Resume Samples
HR Resume Samples
All rights reserved © 2018 Wisdom IT Services India Pvt. Ltd
Wisdomjobs.com is one of the best job search sites in India.