#SQL SERVER INTERVIEW QUESTIONS, #TRICKY SQL INTERVIEW QUESTION How to Generate Sequence without using Ranking functions in SQL Server? Ans: Spose you have a temp table with only one column 'A' as above, Now you can use following query to generate sequence SELECT COUNT (*) OVER ( 01:06 Share
#MS SQL SERVER, #PERFORMANCE TUNING What is Spool Operator in SQL Server: SQL Server Performance Tuning Spool operator scans the input and places a copy of each row in a hidden spool table that is stored in the tempdb database and existing only for the 11:27 Share
#DATABASE INTERVIEW QUESTIONS, #DATABASE TESTING INTERVIEW QUESTIONS What are joins in database and mention different types of joins? Join is used to display results(combined rows) from two or more than two table . Below are the types of joins are: Natural Join Inner Join Cross Join Out 10:25 Share
#DATABASE TESTING INTERVIEW QUESTIONS, #TESTING INTERVIEW QUESTIONS What is Database testing? Data base Testing is segmented into below four different categories. Data validity testing Data integrity testing Performance related to data base Testin 10:18 Share
#TESTING INTERVIEW QUESTIONS What are different types of errors? Explain each. Syntax errors Execution errors Logic Errors Syntax errors: The syntax errors are those that appear as you type the code. Visual Basic checks your code wh 10:05 Share
#TESTING INTERVIEW QUESTIONS Explain what is Alpha and Beta testing? When custom software is built for a customer, a series of acceptance tests is performed to allow the customer to validate all requirements. Most soft 09:59 Share
#TESTING INTERVIEW QUESTIONS What do you understand by Integration testing? Integration testing (sometimes called I & t integration and testing) is the software testing phase in which individual software modules are combi 09:53 Share
#TESTING INTERVIEW QUESTIONS What is the exact difference between debugging and testing? When a test is performed and a defect has been identified, it is the duty of the developers to first locate the defect in the code and then fix it. T 09:51 Share
#TESTING INTERVIEW QUESTIONS What do you understand by Unit testing? In programming, a unit test is a way to test the correct functioning of a code module. This is to ensure that each of the modules functions properly 09:46 Share
#TESTING INTERVIEW QUESTIONS Explain Software Testing? Software testing is the process of verifying and revealing the quality of a software product. They are used to identify possible implementation failu 09:44 Share
#TESTING INTERVIEW QUESTIONS What is the difference between validation and verification? Testing Verify: It consists of verifying the implementation of the requirements. This involves providing objective evidence that an element meets the specifie 09:36 Share
#DATABASE, #DATABASE INTERVIEW QUESTIONS What do you understand by dirty read in terms of database? Dirty reads occur when a transaction is allowed to read a row that was modified by another transaction that has not yet committed. Non-commit reading 09:01 Share
#DATABASE, #DATABASE TESTING INTERVIEW QUESTIONS What do you ensure by database code scalability test? Evaluate how applications work when real activities are implemented. Perform load tests on SQL scripts, PL / SQL, T-SQL code, and stored procedures o 08:57 Share
#TESTING INTERVIEW QUESTIONS What do you understand by scalability testing? Scalability is a performance benchmark that investigates a system's ability to grow by increasing the workload per user, or the number of concurr 08:53 Share
#DATABASE, #DATABASE INTERVIEW QUESTIONS What is the objective of database testing? Database testing objective is to be ensure that access methods and processes work properly and without causing data corruption. 08:32 Share
#DATABASE, #DATABASE INTERVIEW QUESTIONS How are some best practices you follow for testing a database, that should every one follow? Create your own queries: In order to test the operation in a database in a proper and accurate manner, first a tester must have very good knowledge of 08:23 Share
#DATABASE, #DATABASE INTERVIEW QUESTIONS What should be tested in a database? Explain Data mapping in a database: It should be ensured that regardless of the visual (front-end) part of the application, all CRUD operations must work corr 08:16 Share
#DATABASE, #DATABASE INTERVIEW QUESTIONS What is the CRUD model in a database? C : Create - When the user "saves" any new transaction or information to the database. A : Retrieve - When the action of 'Search' o 08:13 Share
#DATABASE, #DATABASE TESTING INTERVIEW QUESTIONS What do you understand by ACID properties in Database? Atomicity, Consistency, Isolation and Durability(ACID) are a set of properties necessary for a set of instructions to be considered as a transaction 08:02 Share
#DATABASE, #DATABASE TESTING INTERVIEW QUESTIONS Write a SQL query to display all employee name start with "a"? Click here for answer 07:53 Share
#DATABASE, #DATABASE TESTING INTERVIEW QUESTIONS Name any three database testing tool available in market? AnyDbTest DBFit DBUnit NDbUnit SQLUnit TSQLUnit(for testing T-SQL in SQL Server) 07:49 Share
#DATABASE, #DATABASE TESTING INTERVIEW QUESTIONS What do you understand by RDBMS? Relational database management system (RDBMS) is a database management system (DBMS) that is based on the relational model as invented by E. F. Codd, 07:45 Share
#DATABASE TESTING INTERVIEW QUESTIONS What are your Database testing approaches? Gather database requirements Create test scenarios against each requirements Test schema data and test scenarios Positive and negative testing Valid a 07:39 Share
#SSRS, #SSRS INTERVIEW QUESTIONS ANSWERS What is Report Parameter and Query Parameter in SSRS? The Query Parameter will filter your data in the DataSource level. We can use these parameters in dataset of SSRS report to filter the corresponding 21:52 Share
#SSRS, #SSRS INTERVIEW QUESTIONS ANSWERS What are Different types of SSRS Reports? What are Different types of SSRS Reports? There are basically following types of different SSRS Reports-- •Parameterized reports •Sub-reports •Snapshot 21:19 Share
#BI, #SISENSE BI What is In-Chip technology over In-Memory? In April 2013, Sisense introduced an alternative to in-memory technology called In-Chip analytics, designed to maximize the disk, memory and CPU with 00:16 Share
#SSRS, #SSRS INTERVIEW QUESTIONS ANSWERS What are DataSource and DataSets in SSRS? Benefits Of Shared DataSource And Shared Datasets? What are DataSource and DataSets in SSRS? Benefits Of Shared DataSource and Shared Datasets? If you need to show information from the database to yo 00:03 Share
#BI, #SISENSE BI How you relate Sisense with Hadoop / Hive? Sisense works with Hive–the data warehouse system designed for Big Data analytics. works well, but it is a developer tool, not a business user tool: 00:03 Share
#BI, #SISENSE BI Whats the advantage of Sisense over in-memory software? As you know with previous generation in-memory BI software the amount of data that you can analyze is limited by the number of RAM Gigabytes of your 00:01 Share
#BI, #SISENSE BI Whats the advantage of Sisense over visualization software? Most data visualization and business intelligence tools allow you to visually explore data sets. They work well if you have a few data sources (1-2 t 23:58 Share
#BI, #SISENSE BI Can you install Sisense on Linux? Not at this time, however Sisense only needs to be installed on a centralized Windows machine to pull data from multiple data sources, and then dashb 23:49 Share
#BI, #SISENSE BI Explain, What is a build? A build is a process that pulls the data from the sources and prepares it to be used in your dashboards. Before you use the data for the first time a 23:47 Share
#BI, #SISENSE BI What is the difference between the Elasticube Manager, the Elasticube Server, and the Elasticube Server Console? The Elasticube Manager is component of the Prism suite that helps you design the Elasticube (connect to tables, build relationships, etc.), while the 23:46 Share
#BI, #SISENSE BI What is the difference between .ecdata and .ecube data files? The Elasticube Manager stores the design of the data schema in a .ecube file. It is not the data itself, but actually a “blueprint” of your data stru 23:44 Share
#BI, #SISENSE BI How do I connect to data with Elasticube Manager? Connecting to data with Elasticube Manager is very easy, and it supports many data source types: Excel files, databases, and even web services hosted 23:43 Share
#Stored Procedure Importent Procedure for Performance Tuning SELECT OBJECT_NAME([PS].[object_id], [PS].[database_id]) AS [ProcedureName], [PS].[execution_count] AS [ProcedureExecutes], [QS].[plan_generation_num 23:27 1 Share
#BI, #SISENSE BI Explain Sisense Architecture? Sisense Architecture The Sisense system is comprised of the following components. Sisense Web Application: The Sisense Web application is an interacti 22:53 Share
#BI, #SISENSE BI Why Sisense? What makes it unique? In today IT world companies had two options for data analytics: complex and pricey BI tools that can handle big and complex data, or lower cost tools 23:48 Share
#BI, #SISENSE BI What is Sisense? Sisense is a BI tool that was developed for all types of user, even those with little or no prior experience with BI software. Sisense's tools ma 23:44 Share
#BI, #SISENSE BI Top 50 SISENSE BI Interview Questions Answers What do you understand by Sisense BI? Why Sisense? What makes it unique? How do I connect to data with Elasticube Manager? What is the difference between 23:42 Share
#MSBI, #SSRS What IS SSRS and What reports can we make using SSRS? SSRS interview Question; What Is SSRS and What reports can we make using SSRS? SSRS is a Server based Report generating System. We can Build Tabular 21:24 Share
#SQL SERVER INTERVIEW QUESTIONS, #TCS SQL INTERVIEW QUESTIONS Concat NULL value in SQL Server? TCS Interview Questions SQL Server interview question asked in TCS interview. Q: What would be the output of following script? Ans: Q: So how you will print FullName as &qu 22:46 Share