92 Matching questions

1. DELETE ???
2. system tables/views ???
3. Three fundamental characteristics of databases:
4. This is known as a self-reference
5. Flat-type databases ???
6. When you use SSMS to perform an action or task, you are executing ___
7. A foreign key constraint in one table ___
8. A DBMS is a collection of ___
9. column ???
10. Each row corresponding to ___
11. Command sequence redefines the view to include the Price column ___
12. SQLCMD is a ___
13. sys.Objects ???
14. Flat-type databases are considered "flat" because ___
15. A table in a relational database can have ___
16. Database query is an ___
17. XQuery is a ___
18. SQL scripts are stored as ___
19. Three types of files to store databases (Microsoft SQL Server):
20. One popular database server:
21. Transact-SQL is the ___
22. Query Analyzer
23. DELETE FROM user; ???
24. self-join ???
25. A table is structured by ___
26. SSMS ???
27. Databases are organized by ___
28. You can install SQL Server Management Studio on any ___
29. if other objects are dependent on the object you are attempting to remove, this statement will ___
30. The primary key constraint ___
31. Don't confuse ALTER with UPDATE:
32. it may be impossible to verify the constraints if a foreign key consists of ___
33. DELETE FROM user WHERE id = 200; ???
34. A check constraint ___
35. Core DML statements include the following:
36. Data Manipulation Language (DML) is the language element that allows you to use the core statements (INSERT, UPDATE, DELETE, and MERGE) to ___
37. Extension of Primary data files ???
38. MERGE ???
39. DML?
40. Secondary data files ???
41. UPDATE ???
42. Data Definition Language (DDL) statements ___
43. A hierarchical database is similar to a ___
44. INSERT ???
45. A not null constraint ___
46. Remember to not confuse DROP, which removes an object from the database, with ___
47. Database
48. Extension of transaction log files ???
49. UPDATE Shirt SET Price = 13.50 WHERE ProductID = 2;
50. Each column corresponds to ___
51. ALTER TABLE Shirt ADD Price Money;
    GO
    ???
52. A unique constraint ___
53. Hierarchical Databases ???
54. SQL Server Management Studio, the primary tool for ___
55. Create a new table named Planets within a database named AdventureWorks ???
56. You can also use ALTER to change the definition of a ___
57. row ???
58. The central feature of SSMS is the ___
59. ALTER ???
60. USE ???
61. A query is ___
62. Each column stores data classified as ___
63. The main DDL statements are ___
64. SSMS can also be used to view and optimize ___
65. A default constraint ___
66. Types of databases ???
67. SQLCMD ___
68. When you use DML statements such as INSERT, UPDATE, DELETE, or MERGE, you need to realize that ___
69. DDL ?
70. DBMS ???
71. SELECT ???
72. Columns marked as foreign keys can ___
73. TRUNCATE ???
74. Scripts are stored as .sql files, and they are used either for ___
75. Database objects are divided into two categories:
76. Database servers ???
77. USE [AdventureWorks] ???
78. USE TESTDB ???
79. ...
    [IndvidualID] [int] NOT NULL, ???
    ...
80. GO command ???
81. Open SSMS by clicking Start > All Programs >
82. DROP ???
83. The disadvantage of indexes ???
84. Extension of secondary data files ???
85. Index ???
86. Primary data files ???
87. SQL Server, periodically analyze queries and create indexes as needed to ___
88. The Query Analyzer supports:
89. The SQL Server Management Studio can be used to perform most of the activities you are required to do and can be considered a ___
90. CREATE ???
91. Constraints are limitations ___
92. The CREATE TABLE [dbo].[Planets] command is used to ___

1. a Performs insert, update, or delete operations on a target table based on the results of a join with a source table.
2. b two or more columns and contains null values.
3. c SELECT, INSERT, UPDATE, DELETE, MERGE
4. d Flat-type, Hierarchical and relacional databases.
5. e Executes the previous set of commands.
6. f record
7. g view, stored procedure, trigger, or function.
8. h Contain user-defined objects, such as tables and views, as well as system tables that SQL Server requires for keeping track of the database
9. i databases most commonly used in plain-text formats.
10. j Entirely optimized to serve only the purposes of the database itself, usually using advanced hardware that can handle the high processing needs of the database.
11. k .ndf
12. l allows the administrator to limit the types of data a user can insert into the database.
13. m database performance, as well as to create and modify databases, tables, and indexes.
14. n Removes/delete rows from a table and frees the space used by those rows.
15. o .ldf
16. p tree structure
17. q managing the server and its databases using a graphical interface.
18. r A data structure that improves the speed of data retrieval operations on a database table.
19. s Adds one or more new rows to a table or a view in SQL Server.
20. t Removes an object from the database.
21. u Remove rows from a table (or view) but does not free the space used by those rows removed.
22. v Data Manipulation Language
23. w primary means of programming and managing SQL Server.
24. x Storage and programmability.
25. y Microsoft SQL Server 2008 > SQL Server
    Management Studio.
26. z create the Planets table.
27. aa SQL Server Management Studio
28. ab Used to add a Price column to the Shirt table.
29. ac USE [AdventureWorks]
    GO
    CREATE TABLE [dbo].[Planets](
    [IndvidualID] [int] NOT NULL,
    [PlanetName] [varchar](50) NULL,
    [PlanetType] [varchar](50) NULL,
    [Radius] [varchar](50) NULL,
    [TimeCreated] [datetime] NULL
    ) ON [PRIMARY]
    GO
30. ad XQuery, SQLCMD, Transact-SQL
31. ae provides a GUI-based interface to write and execute queries.
32. af to delete an employee with the identification number 200 from the User table
33. ag .sql files
34. ah Database becomes too large and you run out of room on your first hard disk.
35. ai Retrieves rows from the database and enables the selection of one or many rows or columns from one or many tables in SQL Server.
36. aj on the whole, they either succeed or fail.
37. ak Changes an existing object.
    (...statement changes an existing object; you can use it to add or remove columns from a table)
38. al Data Definition Language
39. am ...DELETE, which deletes data from within a table.
40. an management of databases or to create the database schema during database deployment.
41. ao columns and rows
42. ap Programs that enables you to enter, organize, and select data in a database.
43. aq To select a database named TESTDB
44. ar If you then wanted to set the prices
45. as optimize performance.
46. at Changes the database context.
    (changes the database context to the specified database or database snapshot)
47. au to delete all rows from a table named User
48. av Microsoft SQL Server.
49. aw inquiry into the database that returns information back from the database.
50. ax manipulate data in any SQL Server tables.
51. ay One specific attribute or type of information you want to store in the database.
52. az sys.Tables, sys.Columns, sys.Databases, sys.Constraints, sys.Views, sys.Procedures, sys.Indexes, sys.Triggers, sys.Objects
53. ba .mdf
54. bb View contains a row for every object in the database with key column names of name, object_id, type_desc, type, create_date, and modify_date.
55. bc Fields, records, and files
56. bd they are two-dimensional tables consisting of rows and columns.
57. be one record or one instance of each column.
58. bf form part/subset of the Transact-SQL portion of SQL Server and can be used to create database objects such as tables, views, constraints, and stored procedures.
59. bg uniquely identifies each record in a database table. The primary key must contain unique values and it cannot contain NULL values. Each table should have a primary key, and each table can have only one primary key.
60. bh Individual ID cannot be NULL.
61. bi USE, CREATE, ALTER, DROP, TRUNCATE, DELETE
62. bj allows the database administrator to specifically identify which column should not contain duplicate values.
63. bk is used to insert a default value into a column. If no other value is specified, the default value will be added to all new records.
64. bl ALTER VIEW Size AS
    SELECT ProductID, ProductName, Price FROM Shirt
    WHERE ProductType = 'Size';
    GO
65. bm multiple parents.
66. bn Database management system.
67. bo In this database, each "parent" table can have multiple "children," but each child can have only one parent.
68. bp field
69. bq Remember, ALTER changes the object definition, but UPDATE changes the data in the table.
70. br command-line application that comes with Microsoft SQL
71. bs Transact-SQL commands.
72. bt An organized collection of data, typically stored in electronic format.
73. bu ...allows SQL queries to be written and executed from the command prompt.
74. bv ... or rules placed on a field or column to ensure that data that is considered invalid is not entered.
75. bw fail and an error will be raised.
76. bx When a self-reference is used to query a table
77. by points to a primary key in another table.
78. bz a data type.
79. ca query and functional programming language that is designed to query collections of XML data.
80. cb contain null values.
81. cc • They are designed to store billions of rows of data.
    • They are limited to the computer's available hard disk space.
    • They are optimized to use all a computer's available memory to improve performance.
82. cd ensures that data is entered into a cell. In other words, the cell cannot be blank. It also means that you cannot insert a new record or update a record without adding a value to this field.
83. ce Object Explorer, which allows users to browse, select, and manage any of the objects within the server.
84. cf This statement allows you to create a variety of SQL Server database objects, including tables, views, and stored procedures.
85. cg Windows desktop operating system so that you can remotely connect to and manage a SQL server.
86. ch "one-stop" tool.
87. ci Changes existing data in one or more columns in a table or view.
88. cj used to ask for information from a database.
89. ck It is possible for a foreign key constraint to reference columns in the same table
90. cl Primary data files, secondary data files, transaction log files.
91. cm changes the database context to AdventureWorks
92. cn They need to be created and updated, which requires processing resources and takes up disk space.