Deck 3: Creating Tables

Question 1

Table names cannot contain spaces.​

Answer 1

True

Question 2

SQL was developed as the data manipulation language for IBM's prototype relational model DBMS,System R.​

Answer 2

True

Question 3

In SQL,you cannot enter an apostrophe into a column whose type is character (CHAR).

Answer 3

False

Question 4

In Oracle,the data type STRING(n)stores a character string n characters long.​

Question 5

The data type DECIMAL(5,2)represents a number with three places to the left and two places to the right of the decimal.​

Question 6

Unlike Oracle,Access does not support the DECIMAL data type.​

Question 7

Microsoft SQL Server is a DBMS designed for use in client-server applications.​

Question 8

When you enter a new row into a table or modify an existing row,the values for one or more columns can be unknown or unavailable.​

Question 9

In general,SQL is case-sensitive.​

Question 10

Dropping a table also deletes any data that you entered into the table.​

Question 11

When adding rows to character columns,make sure you enclose the values in single quotation marks.​

Question 12

In Access,it is common to create a table using SQL.​

Question 13

To create a table,type the command DESCRIBE TABLE followed by the name of the table to be created and then by the names and data types of the columns that will comprise the table.​

Question 14

To enter a null value into a table,you use a special format of the NULL command.​

Question 15

In SQL,there are special rules that specify that a particular word must begin in a particular position on the line.​

Question 16

The data type indicates the type of data that a column can contain.​

Question 17

To move back one or more pages in Oracle Database 11g Express,click the pages icon in the task bar.​

Question 18

In Oracle,the date,November 12,2015 would be stored as '12-NOV-2015'.​

Question 19

To run SQL commands in Access,you must first create a new query.​

Question 20

This text uses Oracle Database 11g Express Edition as the DBMS in which to create and run SQL commands.​

Question 21

If your screen displays the SQL Scripts page,the Home>SQL Workshop>SQL Scripts reference near the top of the SQL Scripts page is called a ____.​

A)command sequence
B)​page sequence
C)breadcrumb
D)​page trail

Question 22

To list all the columns in a table,use the LIST COLUMNS command.​

Question 23

To delete an entire table,use the ____ command and then re-create the table.​

A)REMOVE TABLE
B)​DELETE TABLE
C)ERASE TABLE
D)​DROP TABLE

Question 24

To view data in a table,use the VIEW command.​

Question 25

In Oracle,dates have the format ____.​

A)DD-MON-YY
B)​MON-DD-YY
C)YYYY-MON-DD
D)​DD-MON-YYYY

Question 26

You indicate the end of a command by typing a ____.​

A)column
B)​comma
C)semicolon
D)​period

Question 27

In Access,use the Documenter tool to describe the tables in a database.​

Question 28

To change a value in a table,use the CHANGE command.​

Question 29

Access does not use script files.

Question 30

The Oracle Database 11 g Express edition allows you to save a command so you can use it again without retyping it.​

Question 31

Which of the following is a valid name for a table?​

A)TBL_1
B)​2_TBL
C)TBL 3
D)​4 tbl

Question 32

Oracle stores script files is a special location called Saved Commands.​

Question 33

If you added a row that should not be in a table,use a REMOVE command to remove it.​

Question 34

In Access,dates are enclosed in number signs and are entered using the format ____.​

A)DD/MM/YY
B)​MM/DD/YYYY
C)YYYY/MON/DD
D)​DD/MON/YYYY

Question 35

SQL was developed in the mid-____.​

A)1960s
B)​1970s
C)1980s
D)​1990s

Question 36

The ____ data type is used to store integers.​

A)INTEGER
B)​NUMERAL
C)NUMBER
D)​INT

Question 37

The DESCRIBE TABLE command defines a table's structure by listing its columns,data types,and column lengths.​

Question 38

What is the original name of SQL?​

A)SEQUEL
B)​MYSEQUEL
C)DBase
D)​MySQL

Question 39

In SQL,table names cannot exceed ____ characters.​

A)12
B)​14
C)24
D)​30

Question 40

In SQL Server,execute the sp_columns command to list all the columns in a table.

Question 41

Use the ____ data type for columns that contain letters and special characters and for columns containing numbers that will not be used in calculations.​

A)CHAR
B)​CHARACTER
C)TEXT
D)​STRING

Question 42

A ____ file is a text file with a .sql extension that contains SQL commands.​

A)command
B)​batch
C)sequel
D)​script

Question 43

SQL is Structured ____________________ Language.​

Question 44

The correct data type for the BALANCE column in the CUSTOMER table is ____.​

A)CHAR
B)​INT
C)SMALLINT
D)​DECIMAL

Question 45

The data type DECIMAL(5,2)represents a number with ____________________ places to the left and two places to the right of the decimal.​

Question 46

In Oracle 11g Express,you enter and run commands using the SQL ____________________ tool.​

Question 47

You can delete the entire table using the ____________________ TABLE command.​

Question 48

In Oracle 11g Express,you enter a command in the SQL editor pane and then click the ____________________ button to execute the command.​

Question 49

The ____ command defines a table's structure by listing its columns,data types,and column lengths.​

A)NEW TABLE
B)​DEFINE TABLE
C)CREATE TABLE
D)​ADD TABLE

Question 50

Access does not support the ____ data type.​

A)DECIMAL
B)​CURRENCY
C)INT
D)​NUMBER

Question 51

You can use the ____________________ data type to store date data.​

Question 52

When a script file contains more than one command,each command must end with a(n)____.​

A)apostrophe
B)​semicolon
C)period
D)​colon

Question 53

For any column whose data type is CHAR,values must be enclosed in ____.​

A)double quotation marks
B)​parentheses
C)single quotation marks
D)​square brackets

Question 54

In this text,SQL commands are illustrated using ____________________.​

Question 55

The ____ data type stores only the actual character string.​

A)CHAR
B)​VARCHAR
C)TEXT
D)​STRING

Question 56

To display all the rows and columns in a table,type the word SELECT,followed by a(n)____,followed by the word FROM and then the name of the table containing the data you want to view.​

A)single quote
B)​asterisk
C)double quote
D)​slash

Question 57

You use the ____________________ command to describe the layout of a table.​

Question 58

In Oracle 11 g Express,the results of a SQL command appear in the ____________________ pane.​

Question 59

Which of the following commands changes the value in a column?​

A)UPDATE
B)​CHANGE
C)REPLACE
D)​ADD

Question 60

The ____________________ data type stores integers but uses less space than the INT data type.​

Question 61

You must enclose values in ____________________ quotation marks for any column whose type is character (CHAR),even when the data contains numbers.​

Question 62

What are the common restrictions placed on table and column names?​

Question 63

In Oracle,use the ____________________ command to list all columns in a table and their properties.​

Question 64

A file containing SQL commands is called a(n)____________________ file.​

Question 65

How can you correct errors in data?​

Question 66

Why does the POSTAL_CODE column in the REP table have a data type of CHAR,if a postal code is made up of numbers?​

Question 67

In Oracle,what is the script repository?​

Question 68

The ____________________ command adds rows to a table.​

Question 69

To indicate columns that cannot contain null values,use the ____________________ clause in a CREATE TABLE statement.​

Question 70

You can use the ____________________ command to update a value in a table.​

Question 71

You can use a special value to represent situations in which an actual value is unknown,unavailable,or not applicable.This special value is called a(n)____________________ data value.​

Question 72

If you need to delete a row from a table,you can use the ____________________ command.​

Question 73

Should a user be allowed to enter null values for the primary key?​

Question 74

To view the data in a table,you use the ____________________ command.​

Question 75

In Access,use the ____________________ tool to describe the tables and other objects in a database.​