NAME

Question types


Start with


Question limit

of 92 available terms

Print test

92 True/False questions

  1. INSERT ???Adds one or more new rows to a table or a view in SQL Server.

          

  2. CREATE ???Changes existing data in one or more columns in a table or view.

          

  3. The main DDL statements are ___.sql files

          

  4. self-join ???When a self-reference is used to query a table

          

  5. DBMS ???Database management system.

          

  6. system tables/views ???To select a database named TESTDB

          

  7. DML?Data Manipulation Language

          

  8. The SQL Server Management Studio can be used to perform most of the activities you are required to do and can be considered a ___managing the server and its databases using a graphical interface.

          

  9. SQLCMD is a ___command-line application that comes with Microsoft SQL

          

  10. SQL Server Management Studio, the primary tool for ___Windows desktop operating system so that you can remotely connect to and manage a SQL server.

          

  11. Each column corresponds to ___One specific attribute or type of information you want to store in the database.

          

  12. When you use DML statements such as INSERT, UPDATE, DELETE, or MERGE, you need to realize that ___on the whole, they either succeed or fail.

          

  13. A check constraint ___allows the administrator to limit the types of data a user can insert into the database.

          

  14. Transact-SQL is the ___command-line application that comes with Microsoft SQL

          

  15. Flat-type databases ???databases most commonly used in plain-text formats.

          

  16. Flat-type databases are considered "flat" because ___Fields, records, and files

          

  17. Index ???A data structure that improves the speed of data retrieval operations on a database table.

          

  18. A not null constraint ___allows the database administrator to specifically identify which column should not contain duplicate values.

          

  19. ALTER TABLE Shirt ADD Price Money;
    GO
    ???
    .mdf

          

  20. DELETE FROM user; ???to delete all rows from a table named User

          

  21. The primary key constraint ___allows the database administrator to specifically identify which column should not contain duplicate values.

          

  22. MERGE ???Performs insert, update, or delete operations on a target table based on the results of a join with a source table.

          

  23. DatabaseAn organized collection of data, typically stored in electronic format.

          

  24. A table is structured by ___columns and rows

          

  25. Database objects are divided into two categories:Fields, records, and files

          

  26. Hierarchical Databases ???databases most commonly used in plain-text formats.

          

  27. A hierarchical database is similar to a ___tree structure

          

  28. SSMS ???SQL Server Management Studio

          

  29. Scripts are stored as .sql files, and they are used either for ___management of databases or to create the database schema during database deployment.

          

  30. sys.Objects ???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.

          

  31. Three fundamental characteristics of databases:• 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.

          

  32. This is known as a self-referenceIt is possible for a foreign key constraint to reference columns in the same table

          

  33. Query Analyzerquery and functional programming language that is designed to query collections of XML data.

          

  34. Secondary data files ???Database becomes too large and you run out of room on your first hard disk.

          

  35. DELETE ???Remove rows from a table (or view) but does not free the space used by those rows removed.

          

  36. column ???SQL Server Management Studio

          

  37. Data Definition Language (DDL) statements ___USE, CREATE, ALTER, DROP, TRUNCATE, DELETE

          

  38. UPDATE ???Changes existing data in one or more columns in a table or view.

          

  39. You can also use ALTER to change the definition of a ___view, stored procedure, trigger, or function.

          

  40. Open SSMS by clicking Start > All Programs >.mdf

          

  41. A DBMS is a collection of ___Programs that enables you to enter, organize, and select data in a database.

          

  42. TRUNCATE ???Removes/delete rows from a table and frees the space used by those rows.

          

  43. DELETE FROM user WHERE id = 200; ???to delete an employee with the identification number 200 from the User table

          

  44. if other objects are dependent on the object you are attempting to remove, this statement will ___ALTER VIEW Size AS
    SELECT ProductID, ProductName, Price FROM Shirt
    WHERE ProductType = 'Size';
    GO

          

  45. USE TESTDB ???Retrieves rows from the database and enables the selection of one or many rows or columns from one or many tables in SQL Server.

          

  46. You can install SQL Server Management Studio on any ___view, stored procedure, trigger, or function.

          

  47. The CREATE TABLE [dbo].[Planets] command is used to ___Object Explorer, which allows users to browse, select, and manage any of the objects within the server.

          

  48. Remember to not confuse DROP, which removes an object from the database, with ___...DELETE, which deletes data from within a table.

          

  49. Don't confuse ALTER with UPDATE:Remember, ALTER changes the object definition, but UPDATE changes the data in the table.

          

  50. Types of databases ???In this database, each "parent" table can have multiple "children," but each child can have only one parent.

          

  51. A query is ___query and functional programming language that is designed to query collections of XML data.

          

  52. Each column stores data classified as ___One specific attribute or type of information you want to store in the database.

          

  53. SQLCMD ___...allows SQL queries to be written and executed from the command prompt.

          

  54. Core DML statements include the following:They need to be created and updated, which requires processing resources and takes up disk space.

          

  55. Databases are organized by ___inquiry into the database that returns information back from the database.

          

  56. DDL ?Data Manipulation Language

          

  57. One popular database server:Flat-type, Hierarchical and relacional databases.

          

  58. Command sequence redefines the view to include the Price column ___ALTER VIEW Size AS
    SELECT ProductID, ProductName, Price FROM Shirt
    WHERE ProductType = 'Size';
    GO

          

  59. ...
    [IndvidualID] [int] NOT NULL, ???
    ...
    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.

          

  60. Primary data files ???Database becomes too large and you run out of room on your first hard disk.

          

  61. Constraints are limitations ___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.

          

  62. Each row corresponding to ___one record or one instance of each column.

          

  63. SQL scripts are stored as ___.sql files

          

  64. it may be impossible to verify the constraints if a foreign key consists of ___two or more columns and contains null values.

          

  65. Extension of secondary data files ???.ndf

          

  66. A foreign key constraint in one table ___points to a primary key in another table.

          

  67. The Query Analyzer supports:used to ask for information from a database.

          

  68. Database query is an ___inquiry into the database that returns information back from the database.

          

  69. XQuery is a ___provides a GUI-based interface to write and execute queries.

          

  70. Columns marked as foreign keys can ___contain null values.

          

  71. USE ???Changes the database context.
    (changes the database context to the specified database or database snapshot)

          

  72. A table in a relational database can have ___In this database, each "parent" table can have multiple "children," but each child can have only one parent.

          

  73. Data Manipulation Language (DML) is the language element that allows you to use the core statements (INSERT, UPDATE, DELETE, and MERGE) to ___manipulate data in any SQL Server tables.

          

  74. Extension of transaction log files ???.mdf

          

  75. ALTER ???Changes an existing object.
    (...statement changes an existing object; you can use it to add or remove columns from a table)

          

  76. row ???record

          

  77. A unique constraint ___allows the administrator to limit the types of data a user can insert into the database.

          

  78. SELECT ???Remove rows from a table (or view) but does not free the space used by those rows removed.

          

  79. Three types of files to store databases (Microsoft SQL Server):Primary data files, secondary data files, transaction log files.

          

  80. The disadvantage of indexes ???They need to be created and updated, which requires processing resources and takes up disk space.

          

  81. SQL Server, periodically analyze queries and create indexes as needed to ___optimize performance.

          

  82. DROP ???Removes an object from the database.

          

  83. The central feature of SSMS is the ___Object Explorer, which allows users to browse, select, and manage any of the objects within the server.

          

  84. Create a new table named Planets within a database named AdventureWorks ???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

          

  85. Database servers ???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.

          

  86. USE [AdventureWorks] ???changes the database context to AdventureWorks

          

  87. SSMS can also be used to view and optimize ___database performance, as well as to create and modify databases, tables, and indexes.

          

  88. GO command ???Executes the previous set of commands.

          

  89. When you use SSMS to perform an action or task, you are executing ___a data type.

          

  90. Extension of Primary data files ???.mdf

          

  91. A default constraint ___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.

          

  92. UPDATE Shirt SET Price = 13.50 WHERE ProductID = 2;.mdf