IS Lab Prelims (Module 3 - 7) [Skipped M5] Flashcards
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
SQL Server
The system is designed to manage and store data. Like other Relational Database Management Software,
Sql server
SQL Server is based on ____, a programming language for accessing and manipulating relational databases.
SQL
There are 5 SQL Server Editions, which are
Standard
Web
Enterprise
Developer
Express
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.
Standard edition
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.
Enterprise edition
unlike the Standard one
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.
Web edition
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.
Developer Edition
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.
Express
ACID properties of DBMS. Meaning of ACID:
- Atomicity (all transations commited)
Consistency (trans. complete or returned)
Isolation (trans. isolated)
Durability (transaction secured)
_____ 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.
Relational Database Management Systems (RDBMS)
READ ONLY:
Advantages of using SQL Server
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
____ 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.
SSMS or
SQL Server management Studio
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.
database engine
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.
SQL Operation SYStem
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.
SQL Server Integration Services (SSIS)
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.
Data Quality Services
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.
Master Data ServiceS
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
Business Intelligence Development Studio (BIDS)
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.
SQL Server Management Studio (SSMS)
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
Visual Studio
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.
SSAS
It supports three different types of storage: MOLAP, ROLAP, and HOLAP, which are the methods of storing the cubes.
____ 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.
SQL Commands
SQL COMMANDS ARE MAINLY CATEGORIZED INTO FIVE CATEGORIES:
- DDL-Data Definition Language
- DQL Data Query Language
- DML-Data Manipulation Language
- DCL-Data Control Language
- TCL-Transaction Control Language
_____ 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
DDL or Data Definition Language
Create
Drop
Alter
Truncate
Comment
Rename
____ 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.
DQL Statements
Select
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.
DML or Data Manipulation Language
Insert
Update
Delete
Lock
Call
Explain Plan
_____ 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.
DCL (Data Control Language)
Grant
Revoke
___ : 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.
Transaction Control Language (TCL)
Begin Transaction
Commit
Rollback
Savepoint
____ 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.
SQL Server Management Studio (SSMS)
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
Query Editor
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.
OBJECT EXPLORER
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.
EXECUTE BUTTON
A dropdown that allows the use of the user in order to select the database to run the query from.
DATABASE SELECTOR DROPDOWN
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.
SQL TOP clause
The ___ keyword is used in conjunction with the SELECT statement to fetch unique records from a table.
SQL DISTINCT
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.
SQL Sub query
