Question 1

Table names cannot contain spaces.​

Accepted Answer

Table names in databases cannot contain spaces. If you want to use multiple words, you can use underscores (_) or capitalize each word without any spaces.

Question 2

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

Accepted Answer

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

Question 3

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

Accepted Answer

In SQL, you can enter an apostrophe into a CHAR column by using an escape character, typically another apostrophe, to indicate that it is part of the data.

Question 4

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

Accepted Answer

There is no data type called STRING in Oracle. The commonly used data types for storing character strings are VARCHAR2(n) and CHAR(n), where n represents the maximum length of the string.

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.​

Accepted Answer

The DECIMAL(5,2) data type allows for a total of 5 digits, with 2 digits after the decimal point, leaving 3 digits for the integer part.

Question 6

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

Accepted Answer

Access does not support the DECIMAL data type. It supports the NUMBER data type which is similar to DECIMAL in other databases.

Question 7

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

Accepted Answer

Microsoft SQL Server is a relational DBMS that is designed to be used in client-server applications to store and manage data. It can be used with a wide range of applications and programming languages and is known for its scalability, security, and reliability.

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.​

Accepted Answer

This statement is true. It is possible to have unknown or unavailable values in one or more columns when entering or modifying a row in a table. These values can be represented as NULL values in the database.

Question 9

In general,SQL is case-sensitive.​

Accepted Answer

SQL is generally case-insensitive for keywords and identifiers, but it can be case-sensitive for data depending on the database system and settings.

Question 10

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

Accepted Answer

Dropping a table removes the entire table, including any data that was stored in it.

Question 11

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

Accepted Answer

Character values should always be enclosed in single quotation marks when inserting new rows in a character column.

Question 12

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

Accepted Answer

The answer of In Access,it is common to create a...

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.​

Accepted Answer

The command to create a table is CREATE TABLE, not DESCRIBE TABLE. The syntax for creating a table is:

CREATE TABLE table_name (
     column1 datatype,
     column2 datatype,
     column3 datatype,
     ....
);

Question 14

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

Accepted Answer

To enter a null value into a table, you typically use the keyword NULL directly in the SQL statement, not 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.​

Accepted Answer

SQL does not have special rules for word position on a line. The syntax is flexible and allows for formatting and line breaks as long as the statement is complete and valid.

Question 16

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

Accepted Answer

This statement is true. The data type of a column determines what type of data can be stored in that column. For example, a column with a data type "integer" can only accept whole numbers, while a column with a data type "text" can accept any text character.

Question 17

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

Accepted Answer

Oracle Database 11g Express does not have a "pages icon" in the task bar for navigation. Navigation is typically done through SQL commands or the application interface, not through a task bar icon.

Question 18

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

Accepted Answer

In Oracle, the standard date format is 'dd-MON-yyyy', where MON represents the three-letter abbreviation for the month. Therefore, 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.​

Accepted Answer

To run SQL commands in Access, you need to create a new query, either in Design or SQL view.

Question 20

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

Accepted Answer

The text explicitly states that Oracle Database 11g Express Edition is used as the DBMS for SQL commands.

Quiz 3: Creating Tables

Table names cannot contain spaces.​

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

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

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

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

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

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

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.​

In general,SQL is case-sensitive.​

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

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

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

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.​

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

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

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

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

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

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

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

Table names cannot contain spaces.

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

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

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

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

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

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.

In general,SQL is case-sensitive.

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

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

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

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.

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

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

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

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

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

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

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