Question types

Start with

Question limit

of 92 available terms

Print test

92 Multiple choice questions

  1. command-line application that comes with Microsoft SQL
  2. database performance, as well as to create and modify databases, tables, and indexes.
  3. changes the database context to AdventureWorks
  4. databases most commonly used in plain-text formats.
  5. Object Explorer, which allows users to browse, select, and manage any of the objects within the server.
  6. Programs that enables you to enter, organize, and select data in a database.
  7. In this database, each "parent" table can have multiple "children," but each child can have only one parent.
  8. manipulate data in any SQL Server tables.
  10. Executes the previous set of commands.
  11. provides a GUI-based interface to write and execute queries.
  12. they are two-dimensional tables consisting of rows and columns.
  13. This statement allows you to create a variety of SQL Server database objects, including tables, views, and stored procedures.
  14. 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.
  15. Changes an existing object.
    (...statement changes an existing object; you can use it to add or remove columns from a table)
  16. When a self-reference is used to query a table
  17. They need to be created and updated, which requires processing resources and takes up disk space.
  18. Performs insert, update, or delete operations on a target table based on the results of a join with a source table.
  19. allows the administrator to limit the types of data a user can insert into the database.
  20. tree structure
  21. optimize performance.
  22. 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.
  23. inquiry into the database that returns information back from the database.
  24. primary means of programming and managing SQL Server.
  25. used to ask for information from a database.
  26. Individual ID cannot be NULL.
  27. Database becomes too large and you run out of room on your first hard disk.
  28. management of databases or to create the database schema during database deployment.
  29. Microsoft SQL Server.
  30. two or more columns and contains null values.
  31. Database management system.
  32. Flat-type, Hierarchical and relacional databases.
  33. to delete an employee with the identification number 200 from the User table
  34. on the whole, they either succeed or fail.
  35. ...DELETE, which deletes data from within a table.
  36. field
  37. columns and rows
  39. • 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.
  40. points to a primary key in another table.
  41. To select a database named TESTDB
  42. Changes existing data in one or more columns in a table or view.
  43. Used to add a Price column to the Shirt table.
  44. 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]
  45. 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.
  46. "one-stop" tool.
  47. Adds one or more new rows to a table or a view in SQL Server.
  48. .mdf
  49. fail and an error will be raised.
  50. 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.
  51. Fields, records, and files
  52. Remember, ALTER changes the object definition, but UPDATE changes the data in the table.
  53. managing the server and its databases using a graphical interface.
  54. ...allows SQL queries to be written and executed from the command prompt.
  55. create the Planets table.
  56. Windows desktop operating system so that you can remotely connect to and manage a SQL server.
  57. Remove rows from a table (or view) but does not free the space used by those rows removed.
  58. 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. It is possible for a foreign key constraint to reference columns in the same table
  60. SQL Server Management Studio
  61. .ndf
  62. query and functional programming language that is designed to query collections of XML data.
  63. Data Definition Language
  64. sys.Tables, sys.Columns, sys.Databases, sys.Constraints, sys.Views, sys.Procedures, sys.Indexes, sys.Triggers, sys.Objects
  65. Data Manipulation Language
  66. multiple parents.
  67. Retrieves rows from the database and enables the selection of one or many rows or columns from one or many tables in SQL Server.
  68. Microsoft SQL Server 2008 > SQL Server
    Management Studio.
  69. to delete all rows from a table named User
  70. One specific attribute or type of information you want to store in the database.
  71. 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.
  72. ALTER VIEW Size AS
    SELECT ProductID, ProductName, Price FROM Shirt
    WHERE ProductType = 'Size';
  73. ... or rules placed on a field or column to ensure that data that is considered invalid is not entered.
  74. contain null values.
  75. Transact-SQL commands.
  76. XQuery, SQLCMD, Transact-SQL
  77. .ldf
  78. a data type.
  79. Contain user-defined objects, such as tables and views, as well as system tables that SQL Server requires for keeping track of the database
  80. Removes an object from the database.
  81. Storage and programmability.
  82. Primary data files, secondary data files, transaction log files.
  83. A data structure that improves the speed of data retrieval operations on a database table.
  84. Changes the database context.
    (changes the database context to the specified database or database snapshot)
  85. view, stored procedure, trigger, or function.
  86. allows the database administrator to specifically identify which column should not contain duplicate values.
  87. one record or one instance of each column.
  88. record
  89. An organized collection of data, typically stored in electronic format.
  90. If you then wanted to set the prices
  91. Removes/delete rows from a table and frees the space used by those rows.
  92. .sql files