crackyourinterview.com offers sql interview questions and some query

Hi Guest

MobileUser

:) Latest Topic

AJAX

VB.NET

SQL Query

UDDI

CLASS

JavaScript Questions

SharePoint Interview

SilverLight

WCF

general knowledge

ASP.NET

:) Topic of Day

:) Hot Jobs

ASP.NET Developer(2-5 years)(Location:-Gurgaon(http://www.amadeus.co.in))

Software Developer(0-3 years)(Location:-ZENITH SERVICE.Plot 2N-67 BUNGALOW PLOT NEAR 2-3 CHOWK, NEAR APOORVA NURSING HOME N.I.T. FARIDABAD)

Dot Net Developer(6-7 years)(Location:-Chennai)

Software Developer(3-8 years)(Location:-Bengaluru/Bangalore)

:)

:) Most Searchable

What is Gulpjs and some multiple choice questions on Gulp

Different questions on Docker Container Orcas

In Master-Slave databases, all writes are written to the ____________.

Which of the following services is free?

cache Interview Questions Part1

Cassandra Interview Questions Part

Identify the correct statement in the following in secure programming questions

Which of the following is cloud computing key enabling technologies?

Classification problems aid in predicting __________ outputs.

SaaS supports multiple users and provides a shared data model through ________ model.

DaaS is utilized for provisioning critical data on demand.

Multiple choice questions on Javascript

Developers and organizations all around the world leverage ______ extensively.

More 53 questions on azure

__________ aids in identifying associations, correlations, and frequent patterns in data.

:) Quiz System

Computer Quiz

Science Quiz

Banking Quiz

Sports Quiz

GK Quiz

Query to get values from XML field in SQL Server? View:-131
Question Posted on 08 Mar 2023

Query to get values from XML field in SQL Server?
Below is the query to get values from XML field in SQL ....

ADS Posted In : DataBase | SQL Query

Different method to convert string to date explicitly? View:-658
Question Posted on 22 Aug 2022

Different method to convert string to date explicitly?
When we sayabout the explicit conversion which is ....

ADS Posted In : DataBase | SQL Query

Number of row comparison operator used while doing with a subquery? View:-660
Question Posted on 05 Aug 2022

Number of row comparison operator used while doing with a subquery?
There are mainly three row comparison....

ADS Posted In : DataBase | SQL Query

Write dynamic Query to accept dynamic variable and dynamic column in SQL? View:-688
Question Posted on 17 Jul 2022

Write dynamic Query to accept dynamic variable and dynamic column in SQL?
Below are the two example to wr....

ADS Posted In : DataBase | SQL Query

Name the table and query and store procedure which is used to hold the stored procedure scripts? View:-693
Question Posted on 27 Jun 2022

Name the table and query and store procedure which is used to hold the stored procedure scripts?
TableNam....

ADS Posted In : DataBase | SQL Query

Write a query to get list of triggers in database? View:-732
Question Posted on 27 Jun 2022

Write a query to get list of triggers in database?
Query to get list of triggers in database is written b....

ADS Posted In : DataBase | SQL Query

SQL Query to find ColumnName in any table? View:-739
Question Posted on 27 May 2022

SQL Query to find ColumnName in any table?
Below is the query is used to test that column is exists or no....

ADS Posted In : DataBase | SQL Query

Query to insert SQL carriage return and line break in query? View:-866
Question Posted on 20 May 2022

Query to insert SQL carriage return and line break in query?
Below query will helps you to insert carriag....

ADS Posted In : DataBase | SQL Query

Write a query to get jobs working in SQL Server Database? View:-741
Question Posted on 17 May 2022

Write a query to get jobs working in SQL Server Database?
Below are the two query which helps you to get ....

ADS Posted In : DataBase | SQL Query

Create a Role in SQL and assign to user with syntax Revoke Drop Grant? View:-742
Question Posted on 23 Apr 2022

Create a Role in SQL and assign to user with syntax Revoke Drop Grant?
Basically role is created in SQL t....

ADS Posted In : DataBase | SQL Query

Update table with Select Update, CTE, Merge and from Select statement? View:-764
Question Posted on 21 Apr 2022

Update table with Select Update, CTE, Merge and from Select statement?
We can update table from another t....

ADS Posted In : DataBase | SQL Query

How to get Random Number for specific range in SQL Query? View:-777
Question Posted on 20 Apr 2022

How to get Random Number for specific range in SQL Query?
To apply Rand() function to a specific range yo....

ADS Posted In : DataBase | SQL Query

A simple example of Pivot table in SQL Server(Column into Row)? View:-1017
Question Posted on 20 Jan 2022

A simple example of Pivot table in SQL Server(Column into Row)?
Below is the example to create a output i....

ADS Posted In : DataBase | SQL Query

How to set query to apply paging in SQL Query to get records? View:-998
Question Posted on 20 Jan 2022

How to set query to apply paging in SQL Query to get records?
We can use SQL Query which helps us to appl....

ADS Posted In : DataBase | SQL Query

SQL Query to find the date when new column is added or modified in sql table? View:-1137
Question Posted on 01 Dec 2021

SQL Query to find the date when new column is added or modified in sql table?
Below is the SQL query to g....

ADS Posted In : DataBase | SQL Query

SQL Query to disable or unable foreign key constraints temporarily by using TSQL? View:-1120
Question Posted on 23 Nov 2021

SQL Query to disable or unable foreign key constraints temporarily by using TSQL?
There are certain condi....

ADS Posted In : DataBase | SQL Query

Query to get last occurrence of any character from any string? View:-1149
Question Posted on 23 Nov 2021

Query to get last occurrence of any character from any string?
Below is the query which will helps you to....

ADS Posted In : DataBase | SQL Query

Code to handle and delete Node from XML with childnode values? View:-1096
Question Posted on 22 Nov 2021

Code to handle and delete Node from XML with childnode values?
Below is the code to handle Node values fr....

ADS Posted In : DataBase | SQL Query

Get last 4 charcters of string in SQL Server query? View:-1020
Question Posted on 18 Nov 2021

Get last 4 charcters of string in SQL Server query?
Below are the two sql query to get the last 4 charact....

ADS Posted In : DataBase | SQL Query

Different SQL query to get details of every column in table with details? View:-1080
Question Posted on 16 Nov 2021

Different SQL query to get details of every column in table with details?
Below are the 3 main query to f....

ADS Posted In : DataBase | SQL Query

Write a SQL in built function which will return the count of active transactions? View:-1092
Question Posted on 04 Nov 2021

Write a SQL in built function which will return the count of active transactions?
Below is the syntax whi....

ADS Posted In : DataBase | SQL Query

Query to repeat rows N times as per the column Value in SQL Server? View:-2581
Question Posted on 04 Nov 2021

Query to repeat rows N times as per the column Value in SQL Server?
To Repeat Rows n times according to c....

ADS Posted In : DataBase | SQL Query

What action plan you create when SQL Server is not responding? View:-1349
Question Posted on 26 Oct 2021

What action plan you create when SQL Server is not responding?
Once SQL Server is not responding we will ....

ADS Posted In : DataBase | SQL Query

How to retrieve unsaved SQL query script or files? View:-1319
Question Posted on 25 Oct 2021

How to retrieve unsaved SQL query script or files?
There are many situation when SQL server Management St....

ADS Posted In : DataBase | SQL Query

Can store procedure be recursive if yes then its level? View:-1150
Question Posted on 27 Sep 2021

Can store procedure be recursive if yes then its level?
A stored procedure can be recursive and referenci....

ADS Posted In : DataBase | SQL Query

Write a query to get all even and odd number if we have some id column? View:-1305
Question Posted on 26 Sep 2021

Write a query to get all even and odd number if we have some id column?
Below is the query to get all eve....

ADS Posted In : DataBase | SQL Query

How to use xp_cmdshell in SQL? View:-1165
Question Posted on 26 Sep 2021

How to use xp_cmdshell in SQL?
We use xp_cmdshell in SQL to run DOS command. But before use of this we ne....

ADS Posted In : DataBase | SQL Query

Can we execute DOS command from SQL. View:-1329
Question Posted on 25 Sep 2021

Can we execute DOS command from SQL.
Yes we can execute DOS command by using xp_cmdshell. And to execute....

ADS Posted In : DataBase | SQL Query

How to change schema name of the Table in SQL Like dbo to crackuser? View:-1232
Question Posted on 12 Sep 2021

How to change schema name of the Table in SQL Like dbo to crackuser?
TO change schema name of the table w....

ADS Posted In : DataBase | SQL Query

We have define nchar(3) and char(3) what is difference? View:-1122
Question Posted on 11 Sep 2021

We have define nchar(3) and char(3) what is difference?
We have created a Table and define two column Cou....

ADS Posted In : DataBase | SQL Query

Use of try catch and in store procedure and display error too in details? View:-1478
Question Posted on 06 Sep 2021

Use of try catch and in store procedure and display error too in details?
We can use try catch in SQL que....

ADS Posted In : DataBase | SQL Query

Can you differentiate between LEN() and DATALENGTH() in SQL? View:-1106
Question Posted on 05 Sep 2021

Can you differentiate between LEN() and DATALENGTH() in SQL?
LEN():- LEN() function will returns the leng....

ADS Posted In : DataBase | SQL Query

1 2 3 4 5 6 7

:) Categoriese

BigData(502)
HDP | CDH | Data Lakes | CouchDB | Hadoop | Cassandra | MongoDB | Hive | Cassandra Data Handling | MapReduce | Riak | NoSQL Database Revolution | Apache NiFi | Cognos | NoSQL Gnosis | Apache Pig | BigData Faq | YARN | MongoDB Perpetuus | Apache Phoenix | BigData Questions | Amazon Databases | HDFS | Hadoop MCQ |

Science Technology(373)
Electrical Machine MCQ | Chemistry Quiz | Physics Quiz | Biology Quiz | Solar System Quiz | Science Quiz | Physics | Biology | Chemistry Questions | Fun Facts |

SEO(20)
Ranking | Keywords | SEO Tools | Searches | Keyword Research | Mobile SEO | Technical SEO | SEO Tips | Google Adwords |

Agile(72)
Beginners | Agile Questions | Scrum | Kanban | Agile manifesto | Agile Teams | Agile methodology | Agile Model | Agile process | Agile Project |

Mathematics(347)
Complex numbers | Problem Solving | Algebra | Regression | Math Quiz |

Server(24)
Rack | Nginx | Mainframe | Application | Dedicated | Mail | Blade |

Important Topics(1147)
Linear Algebra | Data Visualization | Cybersecurity | docker container orcas | Secure Programming | Wireframing | Birst | Art of Cryptography | Bitcoin | Infrastructure as Code | ML Exploring the Model | Enlightenment Machine Learning | Conversational Systems | Authentication | Service Discovery | Redux Async | Digital Primer | English Quiz | ServiceNow | Salesforce | EMC | Service Deployment Concepts | Digital for Industries | Security Assessment | Leading And Managing Teams | Kibana Data Exquisites | Ingression Deep Learning | Statistics and Probability | Hybrid Apps | Wireless Mobile | Data Science | Keycloak | Internet of Things Prime | APIGEE Developer Services | Digital Marketing Primer | Data Analysis | Apache Druid | Telemarketing | Full Stack Developer | Memcached | Growth and Transformation | Image Classification | CyberArk | Saviynt | Zipkin and Jaeger | OAuth | SAML | OKTA | NLP Learning Deep Learning | OWASP MCQ | Traefik | Full Stack Development | Endpoint Security | Software Engineering | Azure Synapse Analytics | Consul |

CMS(27)
CodeIgniter | Typo3 | Magento | WordPress | Joomla | Drupal | CakePHP | Zend | Opencart | VirtueMart | Kohana | Neos | October | Webmull | SilverStripe | Phalcon | Symphony |

Software(99)
Easy Git | Fossil | monotone | CVS | Bazaar | Darcs | Perforce | Veracity | TFS | Pijul | BitKeeper | Mercurial | Apache SVN | Secure Code Review | Git | Tibco | Kibana | Blue Prism |

Microsoft InfoPath(4)
Development | InfoPath Basics |

Repository Questions(156)
Rhodecode | SourceForge | Launchpad | Phabricator | Gogs | Beanstalk | GitKraken | Launchpad | AWS CodeCommit | Gitea | GitLab | Bitbucket | Artifactory | Prodigious Git | Git Slack Integration | Git Questions | Interstellar Git |

TPF(2)
TPF Questions | Galileo | Apache Allura |

Cloud(319)
AWS | Google Cloud | IBM Cloud | SaaS | PaaS | laaS | Private Cloud | Hybrid Cloud | AWS Essentials | Public Cloud | Amazon VPC | Watson AI | Informatica | AWS Access Management | Google Cloud Essential | Cloud Foundry | Openshift | Chef Mimas |

Frameworks(427)
RASA | Vue JS Prolificacy | FuelPHP | Grok | Yesod | Padrino | Stripes | Seaside | Web Framework | Spring Boot | Lift | Mason | Mojolicious | JHipster | Flutter | Seam | Apache Storm | Quixote | RichFaces | Grails | Bottle | Catalyst | Wt | PRADO | Bootstrap Framework | Apache Drill | PyTorch | Microsoft Bot Framework | JSF | Django Web Framework | Jest | Workfusion SPA | Xamarin | IONIC | Spring | WPF | Laravel | WCF |

Placement Paper(10)
HCL Papers | TCS Papers | Group Discussion | Wipro Papers | SAP Company | Accenture Paper | IBM | CTS |

Government Private Jobs(34)
SBI Bank PO | IDBI Bank | Bank Interview | Banking Quiz |

API(215)
API Questions | PouchDB | PySpark | Web API | GraphQL | Apigee API | APIGEE Analytics Services | Java API | REST API MCQ | Postman | API Gateway | Composite API | Open API | Internal API | Composite API | Soap API | FullContact API | Amazon S3 API | Partner API | Mobile Testing Qsn |

Tutorial(84)
SQL | Regex | HTML | C Language | AngularJS |

Programming Languages(288)
C | Perl | COBOL | Pascal | FORTRAN | BASIC | Ada | C++ | Scala | R Basic | Ruby | Go | Julia | LUA | Swift | TypeScript | Matplotlib | Machine Learning Axioms | Phython | Lisp | Scala Constructs | Programming | Coding | C++ Quiz | C MCQ | Dart | Octave |

PowerShell(13)
Powershell Script | PowerShell |

Operating System(48)
Linux | Unix | Solaris | macOS | Windows | Operating System MCQ | Linux MCQ |

Tools(614)
RPA with Pega | SoapUI | Burp Suite | Google Data Studio | Selenium WebDriver | Apache Sqoop | Pega | Apache Flume | Nomad | Cucumber | Terraform | Tableau The Prequel | Tableau The Sequel | Automation with Grunt | JIRA | UI Design | Automatix | Gradle | K8s | Hcatalog | Maven | ECMAScript |

DotNet(588)
Entity Framework | Cache | ADO.NET | C# | MVC | LINQ | RDLC | ASP.NET | VB.NET | DotNet Quiz | DotNet MCQ | ASP.NET Core |

DataBase(859)
Unstructured Data Classification | SQL DBA MCQ | SQL Quiz | PostgreSQL | Blockchain Intermedio | DataBase Term | ArangoDB | Amazon Neptune | DB2 | MarkLogic | Storytelling with Data | Database Security | Teradata | Structured Data Classification | SQL Query | SQL Certification | SQL DBA Questions | DBMS | DataWarehousing | sql questions | MySQL | SQLite | Redis | Blockchain | Data Mining Nostos | SSIS | NoSQL | Data Mining |

WebServices(44)
WebServices | UDDI | Amazon Storage (S3) |

OOPS(9)
CLASS | Functions | oops questions |

WEB(441)
AJAX | JQuery | VBScript | IIS Questions | Cloud Computing | HTML5 | Regex Questions | Wamp Server | Onsen UI | NativeScript | Node.js | Bundling With Webpack | BackboneJS | Web Security | HTML Questions | JSON | HTML MCQ Quiz | Styling With CSS3 | Handlebars.js | Safari | JQuery Mobile | Elasticsearch |

SharePoint(41)
Powershell Questions | SharePoint SourceCode | SharePoint Interview |

SilverLight(7)
SilverLight |

Artificial Intelligence(102)
MFDM | Neural Networks | AI MCQ | Automation Anywhere |

Java(268)
Java Quiz | AWT | Java Questions | JSP | Apache Lucene | Java MCQ | Java8 Innards | Swing | Struts | Servlet | J2EE | EJB | Hibernate | JDBC | Core Java | beans |

Gernal Knowledge(1189)
general knowledge | Interview Questions | Logical Puzzle | Number Puzzle | Verbal Analogies | Logo Quiz | Animal Quiz | ISRO GK Questions | Company Quiz | Sports Quiz | Aviation | Plant Quiz | GK Quiz |

PHP(86)
PHP MCQ | Example | PHP Questions |

Biztalk(0)
Biztalk Questions |

Testing(132)
Testing Questions | Manual | Automation | Selenium | SonarQube | Bugzilla | SAP Testing | Agile Testing | Mobile Testing | Database Testing | LoadRunner Testing | Manual Testing | JS Qualis | Performance Testing | SOAtest | API Testing | TestNG | Risk Based Testing | Jenkins | JMeter |

SAP(158)
SAP BODS | SAP FICO | SAP Security | SAP ABAP Data Dictionary | SAP HANA Quiz | SAP CRM | SAP Basic | HBase | SAP HR | SAP Payroll | SAP BI | SAP ABAP | SAP Hana | FICO | SAP MM | SAP | SAP Interview |

HR(14)
HR Questions | Interview Tips |

XML(9)
Xml Questions | SVG | XPath |

Test and Papers(202)
Continuous Integration with Jenkins | Blockchain Potentes Nexus | IAS Panel | Ansible Automation Sibelius | Continuous deployment | Bower | Deep Learning | Docker | Microservices | Spark SQL | Gulp | Weaveworks | Aptitude Test | Puzzle | Logical Reasoning | Mathematical Rules | Continuous Integration | Ansible |

Android(71)
Android Interview Questions | Android Quiz |

Python Programming(171)
Python Questions | Stats with Python | NLP Using Python | Python Pandas | Python 3 | Python Quiz | NumPy |

Applications(56)
TIBCO EMS | Kafka Premiera Ola |

Trending Technologies(7)
CAT |

iOS(8)
PhoneGap |

Computer(187)
RPA | Robotics |

Apache Hadoop(49)
Apache Knox | Hadoop Security |

Angular(167)
AngularJS Packaging and Testing | Angular 2 Building Blocks | Angular 8 | Angular Routes and Forms | Angular 2 Game of states | Angular Oriana | Angular FAQ |

JavaScript(250)
ReactJS | JavaScript Questions | Redux state management | KnockoutJS | Backbone | React Native | JavaScript Quiz | Javascript Code |

Networking(20)
DevOpsSec | DevOps Culture | Devops Security | DevSecOps | DevOps Questions | Devops |

Style Sheet(27)
Network Security | Networking Faq | Firewall |

Quantitative Aptitude(27)
iOS Questions |

BigQuery(38)
SASS | CSS MCQ Quiz | CSS |

Protocol(12)
Aptitude Quiz | Reasoning Quiz | Average Aptitude | Number Quiz |

Application Server(2)
Computer Quiz | Hardware |

Roles and Responsibilities(3)
Google BigQuery |

Oracle(4)
FTP | SNMP MCQ | SNMP |

Hosting and Domain(1)
Talend |

Azure Topics(219)
JBoss |

Business Intelligence(6)
Business Analyst |

Accounting(12)
OBIEE | Oracle Faq | Oracle Cloud |

Competitive Exams(1)
Hosting Faq |

Mobile APP(34)
Microsoft Excel | MSWord | Microsoft Teams MCQ | Microsoft Word MCQ |

Microsoft Products(62)
Threat Hunting | Threat Modeling |

VBA(1)
Azure Databases | Azure Data Factory | Exam AZ-104 | Azure Identity Management | Azure Virtual Networks | Azure Continuum | Azure MCQ | VSTS | Azure Virtual Machines | Azure |

REST(4)
VBA in Excel |

GDS(3)
Pentaho BI | BI Questions | Power BI |

Reporting Services(1)
Financial Management MCQ |

SQL Server(3)
REST Questions |

Microsoft Certifications(3)
GDS Questions |

DevOps Certifications(2)
SSRS |

Certifications(0)
Indian Laws |

Devops(114)
SSMS |

ETL(6)
AZ204 |

Threat and vulnerability(45)
SAFe 5 DevOps Practitioner |

Laws(4)
Black Belt Certification | Google PCA Exam | GCP Certification Dumps |

:) Most Visited Questions

Deep Learning Questions Answers
Below are the different Deep Leaning Questions and answer a More...

Continuous Integration Questions Answers
Below are the 20 odd questions for CI or Continuous Integra More...

Microservices Architecture Questions Answers
Below are the different questions on Microservices Architec More...

Derived relationships in Association Rule Mining are represented in the form of __________.
Derived relationships in Association Rule Mining are repres More...

50 Latest questions on Azure
Below are the latest 50 odd questions on azure. These are m More...

Top Searches:asp net questions vb net questions sql query uddl questions class javascript Questions sharepoint interview questions and concept silverlight questions and concept wcf questions beans general knowledge ajax questions

PHP | Biztalk | Testing | SAP | HR |

Privacy policy | Terms and Conditions | Blog

If the copyright of any wallpaper or content or photo belong to you email us we will remove that(info@crackyourinterview.com or crackyourinterview2018@gmail.com)