IS Lab Prelims (Module 3 - 7) [Skipped M5]

Question 1

is one of the most widely deployed relational database management systems, or RDBMS, today. It runs on various operating systems. AWS. It is used for data storage, query, and analysis. It’s a powerful, high-performance database engine that provides a consistent programming model. It boasts high performance, reliability, scalability, security, and manageability and offers a set of powerful tools for data warehousing, analysis, reporting, ETL, and OLAP.

It is a relational database management system (RDBMS), a part of the Microsoft Enterprise Library. It

Answer 1

SQL Server

Question 2

The system is designed to manage and store data. Like other Relational Database Management Software,

Answer 2

Sql server

Question 3

SQL Server is based on ____, a programming language for accessing and manipulating relational databases.

Answer 3

SQL

Question 4

There are 5 SQL Server Editions, which are

Answer 4

Standard
Web
Enterprise
Developer
Express

Question 5

One of the 5 SQL Server Editions,

____ includes the CORE functionality required for most applications. This includes COMMON development, data management, and database administration tools for effective database management with minimal resources.

Answer 5

Standard edition

Question 5

One of the 5 SQL Server Editions,

_______, it supports a wide array of data WAREHOUSE features, adds support for more users, databases, and transactions. It also includes several other advanced features such as data compression, enhanced security, and support for large database sizes. It is a perfect choice for COMPANIES focusing on scalability and performance.

Answer 5

Enterprise edition

unlike the Standard one

Question 6

One of the 5 SQL Server Editions,

____ edition presents a LOW-COST option and differs from the Standard edition primarily in terms of maximum memory for the buffer pool and maximum compute capacity.

Answer 6

Web edition

Question 7

One of the 5 SQL Server Editions,

____ edition is designed for DEVELOPERS who need to create application products that will run on top of SQL Server. It provides the ability to create stored procedures, functions, and views. In fact, it contains all the functionality of the ENTERPRISE edition but is licensed for use as a DEVELOPMENT and test system, not as a production one.

Answer 7

Developer Edition

Question 8

One of the 5 SQL Server Editions,

____ edition is the MOST LIMITED edition of SQL Server. It is only for use by individuals or SMALL ORG. It does not include any of the advanced functionality of the other four editions. It is the most accessible edition, but it is also the least functional.

Answer 8

Express

Question 9

ACID properties of DBMS. Meaning of ACID:

Answer 9

• Atomicity (all transations commited)

Consistency (trans. complete or returned)

Isolation (trans. isolated)

Durability (transaction secured)

Question 10

_____ provide sSTRUCTURED means for STORING MANIPULATING, and RETRIEVING large amounts of information. Like others, SQL Server is essentially built around a row-based table structure that joins related data elements in various tables to one another, avoiding the need to store data in various places within a database redundantly. The relational model also stores referential integrity and other integrity constraints to keep data accurate. Adherence to the ACID principles guarantees that database transactions are processed reliably.

Answer 10

Relational Database Management Systems (RDBMS)

Question 11

READ ONLY:

Advantages of using SQL Server

Answer 11

Install different versions in 1 machine

Reduced cost

Maintain prod and devel, and test separately

Reduce temporary database probs

separate security priveleges

maintain standby server

Question 12

____ is a comprehensive Integrated Development Environment (IDE) offered by Microsoft for managing SQL Server databases. This user-friendly and freely available tool offers all the necessary features for standard database-related tasks in SQL Server.

Answer 12

SSMS or

SQL Server management Studio

Question 13

One of the Main Components of SQL Server

Microsoft SQL Server is a _____ that stores, processes, and secures data and makes it accessible to users. It includes a relational engine used to process commands and queries and a storage engine that manages the database file, tables, pages, indexes, data buffers, and transactions. Stored procedures, triggers, views, and other database objects are also created and executed by the Database Engine.

Answer 13

database engine

Question 14

One of the Main Components of SQL Server

____ lies at the heart of all database FUNCTIONALITY. It manages memory and I/O resources, jobs and processes that access databases, and the TDS protocol that uses streams to transfer data from server to client. Network interfaces handle communication between database servers and clients.

Answer 14

SQL Operation SYStem

Question 15

One of the Main Components of SQL Server

_____ provide ETL (Extract, Transform, and Load) capabilities for data import, data INTEGRATION, and warehousing needs. It also provides tools to create workflow tasks, including Data Flow Tasks, Control Flow Tasks, Script Tasks, Batch Data Operations, Data Conversion, and Data Loading.

Answer 15

SQL Server Integration Services (SSIS)

Question 16

One of the Main Components of SQL Server

_____ is a KNOWLEDGE-driven product. It allows you to build a KNOWLEDGE base and use it to perform various critical data quality tasks, such as correction, enrichment, and standardization.

Answer 16

Data Quality Services

Question 17

One of the Main Components of SQL Server

____ can be used to manage a master set of your company’s data. You can control who updates the data, organize the data into models, and create rules for updating the data. The master data set can be shared with other users within the organization.

Answer 17

Master Data ServiceS

Question 18

One of the Main Components of SQL Server

Microsoft’s ____ is used for developing data ANALYSIS and BUSINESS intelligence solutions. It is based on the Visual Studio development environment but has different extensions and project types for the database server

Answer 18

Business Intelligence Development Studio (BIDS)

Question 19

One of the Main Components of SQL Server

It is the GUI tool for configuring, managing, and administering any SQL infrastructure. The tool presents a graphic interface for working with SQL Server database servers and includes a bunch of script editors and graphical tools for working with objects on the server.

Answer 19

SQL Server Management Studio (SSMS)

Question 20

One of the Main Components of SQL Server

Native support for data programming can be found in Microsoft ____. It can be used to write code executed by a database. A data designer that can be used to create, view or edit database schemas graphically is also included. There are two ways to create queries: using code and visually

Answer 20

Visual Studio

Question 21

One of the Main Components of SQL Server

____ adds OLAP and data mining capabilities to SQL Server. It also supports the XML for Analysis (XMLA) standard as the underlying communication protocol. The Data Mining API, DMX, enables data mining-specific functionality. It includes Decision trees, clustering algorithms, naive Bayes, time-series, sequence clustering, linear and logistic regression, and neural networks.

Answer 21

SSAS

It supports three different types of storage: MOLAP, ROLAP, and HOLAP, which are the methods of storing the cubes.

Question 22

____ are like instructions to a table. It is used to interact with the database with sor operations. It is also used to perform specific tasks, functions, and queries of data. SQL can perform varic tasks like creating a table, adding data to tables, dropping the table, modifying the table, set permission users.

Answer 22

SQL Commands

Question 23

SQL COMMANDS ARE MAINLY CATEGORIZED INTO FIVE CATEGORIES:

Answer 23

1. DDL-Data Definition Language
2. DQL Data Query Language
3. DML-Data Manipulation Language
4. DCL-Data Control Language
5. TCL-Transaction Control Language

Question 24

_____ actually consists of the SQL commands that can be used to defining, altering, and deleting database structures such as tables, indexes, and schemas. It simply deals with descriptions of the database schema and is used to create and modify the structure of database objects in the database

Answer 24

DDL or Data Definition Language Create Drop Alter Truncate Comment Rename

Question 25

____ are used for performing queries on the data within schema objects. The purpose of the DQL Command is to get some schema relation based on the query passed to it. This command allows getting the data out of the database to perform operations with it. When a SELECT is fired against a table or tables the result is compiled into a further temporary table, which is displayed or perhaps received by the program.

Answer 25

DQL Statements Select

Question 26

The SQL commands that deal with the manipulation of data present in the database belong to _____ and this includes most of the SQL statements. It is the component of the SQL statement that controls access to data and to the database. Basically, DCL statements are grouped with DML statements.

Answer 26

DML or Data Manipulation Language Insert Update Delete Lock Call Explain Plan

Question 27

_____ includes commands such as GRANT and REVOKE which mainly deal with the rights, permissions, and other controls of the database system. These commands are used. to control access to data in the database by granting or revoking permissions.

Answer 27

DCL (Data Control Language) Grant Revoke

Question 28

___ : Transactions group a set of tasks into a single execution unit. Each transaction begins with a specific task and ends when all the tasks in the group are successfully completed. If any of the tasks fail, the transaction fails. Therefore, a transaction has only two results: success or failure.

Answer 28

Transaction Control Language (TCL) Begin Transaction Commit Rollback Savepoint

Question 29

____ is an essential tool for effectively managing SQL Server databases. Developed by Microsoft, SSMS provides a comprehensive, integrated environment where database administrators, developers, and other users can efficiently work with their SQL Server instances.

Answer 29

SQL Server Management Studio (SSMS)

Question 30

This part sent all your QUESTIONS. MS SQL Server substantially reduces query creation effort and adoption of other features by offering interactive advices on the backing tables, columns, and so on

Answer 30

Query Editor

Question 31

This utility processes in a manner where you can CHECK the DATABASE OBJECTS of the server that you are connected to in a tree format i.e. by using the tabular view. In a nutshell, this part shall show you the database, security, and server objects lest you need to refer to them quickly. After clicking onto the label icon to your left, you can view the object to explore details about its parts.

Answer 31

OBJECT EXPLORER

Question 32

The addition of a button named Run that lets users to run their queries and get results. Use our Al to write for you about any topic! Be it homework help or just casual application-we are here to help.

Answer 32

EXECUTE BUTTON

Question 33

A dropdown that allows the use of the user in order to select the database to run the query from.

Answer 33

DATABASE SELECTOR DROPDOWN

Question 34

While we are retrieving data from an SQL table, the _____ is used to restrict the number of rows returned by a SELECT query in SQL server. In addition, we can also use it with UPDATE and DELETE statements to limit (restrict) the resultant records.

Answer 34

SQL TOP clause

Question 35

The ___ keyword is used in conjunction with the SELECT statement to fetch unique records from a table.

Answer 35

SQL DISTINCT

Question 36

An ___ is a SELECT query within another query. It is also known as Inner query or Nested query and the query containing it is the outer query.

Answer 36

SQL Sub query