Question types

Start with

Question limit

of 92 available terms

Print test

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;
  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.
  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]
    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]
  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.
  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';
  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.