SQL Chapters 1-4 Word Scramble
|
Embed Code - If you would like this activity on your web page, copy the script below and paste it into your web page.
Normal Size Small Size show me how
Normal Size Small Size show me how
Question | Answer |
Which is the main tool used on a QL Server to manage databases? | SQL Server Management Studio |
Which tool is used to run a query on a database? | sQL Server Management Studio |
Which component within the SQL Management Studio allows you to look at databases, tables, and views? | Object Browser |
What tools do you use to start and stop Windows Services and enable and disable network protocols? | SQL Server Configuration Manager |
What enables you to query metadata aout SQL Server database objects? | catalog view |
What returns information about the databases and database objects? | system stored procedures |
What routines help you maintain your database? | DBCC |
What is a specification for the way SQL Server stores data in a table? | data type |
What stores you data and is organized as rows and columns? | table |
What do you call data types that users define? | Alias data types |
What is the maximum number of length of characters for a char data type? | 8,000 |
What can restrict the type of data that can be inserted? | data type |
Which data type is used to contain a 1 or 0 value? | bit |
Which data type should be used to hold values of taxes collected? | money |
Which data type is used to store large numbers with decimal point values? | float |
How many bytes does TinyInt use? | 1 |
How many bytes does SmallInt use? | 2 |
How many bytes is a single character (char) data type? | 1 |
Which is the preferred method to create a SQL Alias Types? | CREATE TYPE |
How large is a page? | 8 KB or 8,192 bytes |
Created by:
1592245141
Popular Computers sets