Posts

Showing posts from July, 2021

SAP ABAP Interview Questions

  1) What is SAP ABAP? SAP is a type of software known as ERP (Enterprise Resource Planning) that large company use to manage their day to day affairs. ABAP (Advanced Business Application Programming) is the coding language for SAP to develop RICEFW objects. (Reports, Interfaces, Extensions, Forms and Workflows). 2) What do you mean by an ABAP data dictionary? To describe the logical structures of the objects that are used in application development ABAP 4 data dictionary is used. It is also used to show the underlying relational database in tables. know more at SAP ABAP online training 3) Explain the difference between pool tables and transparent tables? Transparent tables: It has one to one relation with the table in the database. Its structure corresponds to single database field. Pooled tables: It has many to one relation with the table in the database. Pooled tables are stored at the database level. a) Basic List: For simple reports b) Statistics: For Percentage, Average etc. c) R

Power BI Interview Questions

  1. What is Power BI? Power BI is a developed by Microsoft that helps you turn multiple unrelated sources of data into valuable and interactive insights. These data may be in the form of an Excel spreadsheet or cloud-based/on-premises hybrid data warehouses. You can easily connect to all your data sources and share the insights with anyone. know more at Power bi online training 2. List out some benefits of using Power BI. Here are some benefits of using Power BI: It helps build interactable data visualization in data centres It allows users to transform data into visuals and share them with anyone It establishes a connection for Excel queries and dashboards for fast analysis It provides quick and accurate solutions It enables users to perform queries on reports using simple English words  3. List out some drawbacks/limitations of using Power BI. Here are some limitations of using Power BI: It does not accept file sizes larger than 1 GB and also doesn’t mix imported data, which is acce

SQL Server DBA Interview Questions

  Q.What are the different types of backups? Answer:  The SQL server offers 4 types of backups to suit the need of the administrator. Complete backup  :The complete back up is just zipping the content of the entire database in terms of the different tables and procedures etc. This back up can server as an independent entity that can be restored in different systems with just the base SQL server installed. Transaction log backup:  This is the mechanism of backing up the transaction logs that have been maintained in the server. This way the details of the database getting updated is obtained. This cannot be a stand-alone back up mechanism. But can save a lot of time if we already have the file system related to the DB backed up on the new deployment server. Differential backup:  This is a subset of the complete backup, where only the modified datasets are backed up. This can save the time when we are just trying to maintain a backup server to main server. File backup:  This is the quicke

Python Interview Questions

  1.  What are the key features of Python? Python is one of the most popular programming languages used by data scientists and AIML professionals. This popularity is due to the following key features of Python: Python is easy to learn due to its clear syntax and readability Python is easy to interpret, making debugging easy Python is free and Open-source It can be used across different languages It is an object-oriented language which supports concepts of classes It can be easily integrated with other languages like C++, Java and more 2.  What are Keywords in Python? Keywords in Python are reserved words which are used as identifiers, function name or variable name. They help define the structure and syntax of the language.  There are a total of 33 keywords in Python 3.7 which can change in the next version, i.e., Python 3.  What are Literals in Python and explain about different Literals? Literals in Python refer to the data that is given in a variable or constant. Python has various