Which SQL statement is used to update object in a database?

Which SQL statement is used to remove data in a database?

Which SQL statement is used to remove objects in a database?

Which SQL statement is used to create new data in a database?

is used to create objects in a database?

use to display current date and time of server

The codename of 2019 SQL Server version

SSMS stands for?

is an attribute of the Record or column of a table

Other Term for Record

It is collection of related facts and figures regarding one subject matter

It is a part of a database that contains data about one aspect of the subject of the database

It is the instance or row of a table.

It is an advance version of 3NF that’s why it is also referred as 3.5NF

It is a process of organizing the data in database to avoid data redundancy, insertion anomaly, update anomaly & deletion anomaly

is used to extract data from a database?

Which SQL statement is used to return only different values?

It is a Primary Key of another table

The number digits in a numeric column

The number  of digits to the right of a decimal point in a numeric column

It is use to create a column that contains system-generated sequential values to identify each row inserted into a table

Column or set of columns that uniquely identify each row in a table

It is an attribute that specifies the type of data that the column can store

can be attributed to what sql script

can be attributed to what scripting  command?

each record in Table A can have only one matching record in Table B, and each record in Table B can have only one matching record in Table A.

It is the number of records that can be related to each other

It is a key that is composed of two or more attributes

 A record in Table A can have many matching records in Table B, and a record in Table B can have many matching records in Table A

A record in Table A can have many matching records in Table B, but a record in Table B has only one matching record in Table A

an association established between common fields (columns) in two tables

A table design is said to be in this form if both the following conditions hold: Table must be in 2NF and Transitive functional dependency of non-prime attribute on any super key should be removed.

Normalization phase where Partial Dependency is focus to be removed

SQL server is case sensitive

Edgar Frank Codd published an academic paper on relational database that inspired the creation.

is used to define and manage all the objects in an SQL Server such as databases, tables and view.

All databases use primary keys and foreign keys to create relationships between tables

VARBINARY holds fixed binary strings and contains byte strings rather than character strings

CHAR  holds a fixed length character string

SQL Server is RDMBS

SQL is an industry-standard programming language used to insert, retrieve, modify, and delete data in a relational database.

SQL contains statements for defining and administering the objects in a database

SQL is the language supported by almost all database systems, and is the subject of published industry standards

developed by __while he was

working at the IBM research labs in

San Jose in 1971.

DDL stands for?

used to define and manage all the objects in an SQL Server such as databases, tables and view.

CREATE, ALTER and DROP statements is under of?

DML stands for?

used to SELECT, INSERT, UPDATE and DELETE data in the objects

DCL stands for?

Security commands such as GRANT, REVOKE, and DENY that control how a principal (user or role) can access a securable (object or data.)

is the language containing the commands used to administer SQL Server, to create and manage all objects in SQL Server, and to insert, retrieve, modify, and delete all data in tables.

T- SQL stands for?

is an installation of a SQL

Server database engine/service databases

Sql Server Instances can be a Default Instance or Named Instance

can install multiple instances of SQL

Server on the same computer

each instance is completely

independent of the others in terms of security, the data that it manages, and in all other respects

High-end edition with the advanced performance and availability features require to support thousands of connections and databases measured by terabytes

This edition includes all the right features, including Integration Services, Analysis Services, Web Services, database mirroring, and failover clustering.

perfectly suited for medium-size businesses that need all the primary features and can live without the very high- end high availability features of Enterprise Edition

Standard edition includes all the right features, including Integration Services, Analysis Services, Web Services, database mirroring, and failover clustering.

Intended as a departmental database server, Workgroup Edition includes the right mix of features for a small transactional database

new for SQL Server 2012 is licensed for hosting websites

Its small footprint of only 1MBof RAM means that it can actually run well on a mobile smart device

It’s a full version of the SQL Server database engine intended to serve as an embedded database within an application. It’s completely free.

Minimum:

x86 Processor: 1.0 GHz

x64 Processor: 1.4 GHz Recommended: 2.0 GHz or faster

Minimum:

Express Editions: 512 MB

All other editions: 1 GB

Recommended:

Express Editions: 1 GB

All other editions: At least 4 GB and should be increased as database size increases to ensure optimal performance.

is a requirement for SQL Server 2012 when you select Database Engine, Reporting Services, Master Data Services, Data Quality Services, Replication, or SQL Server Management Studio, and it is no longer installed by SQL Server Setup.

is a requirement for SQL Server 2012.

selected by default for the first installation of SQL Server on a machine

used when a default instance already installed

The name of this account is NT AUTHORITY\System. It is a powerful account that has unrestricted access to all local system resources.

The name of this account is NT AUTHORITY\__. It is available in Microsoft Windows XP and Microsoft Windows Server 2003.

Are authenticated to network resources as the local computer.

Used to create and manage T-SQL code templates. The __ are simply stored SQL scripts within a directory structure

is used to create, edit, and execute T-SQL

batches.

contains all information that is global to the server, including logins, error messages, system configuration, and the list of other databases that exist on the server

Master keeps the instance of SQL Server functioning. This database records all the system

information for the SQL Server instance

contains all temporarily created stored procedures and tables and is generally used as a work area by SQL Server

stores a complete template for creating new databases

assists in storing a collection of unprocessed data files on a hard drive.

DBMS offers a crash recovery mechanism while file systems do not.

File systems do not enable complex transactions, whereas complex transactions may be implemented with ease in DBMS systems using SQL.

name of field

Removes all rows from a table without deleting the table. Similar to the DELETE statement with no WHERE clause, but faster

returns a list of results that match search expressions listed in ()

returns results that are like given search string, uses _ and % to give a non specific search