Question 1

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

Accepted Answer

The reference "Home>SQL Workshop>SQL Scripts" near the top of the SQL Scripts page is a breadcrumb, which is a navigation element commonly used in websites or applications to show users their current location within the navigation hierarchy. It helps users to easily go back to previous pages or sections.

Question 2

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

Accepted Answer

The correct SQL command to list all columns in a table is "SHOW COLUMNS" or "DESCRIBE" depending on the SQL database system being used.

Question 3

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

Accepted Answer

The DROP TABLE command is used to delete an entire table in SQL. Once the table is dropped, it needs to be re-created if it is needed again.

Question 4

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

Accepted Answer

The correct SQL command to view data in a table is the SELECT statement, not the VIEW command. The VIEW command is used to create a virtual table based on the result-set of a SELECT query.

Question 5

In Oracle,dates have the format ____.​
A)DD-MON-YY
B)​MON-DD-YY
C)YYYY-MON-DD
D)​DD-MON-YYYY

Accepted Answer

The date format in Oracle is DD-MON-YYYY.

Question 6

You indicate the end of a command by typing a ____.​
A)column
B)​comma
C)semicolon
D)​period

Accepted Answer

Unlike commas, periods, or columns, semicolon is used to indicate the end of a command in programming.

Question 7

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

Accepted Answer

The Documenter tool in Access can be used to provide a detailed report about the database objects, including tables, queries, forms, and reports. It can be accessed from the Database Tools tab and can be used to analyze and document the structure, properties, and relationships of the tables in a database.

Question 8

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

Accepted Answer

To change a value in a table, you will use the UPDATE command, not the CHANGE command.

Question 9

Access does not use script files.

Accepted Answer

Access uses macros and VBA code modules instead of script files.

Question 10

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

Accepted Answer

The Oracle Database 11g Express edition supports the command history feature, which allows you to recall previous commands using the up arrow or typing history. You can also save a command to a file or buffer and execute it again without retyping it.

Question 11

Which of the following is a valid name for a table?​
A)TBL_1
B)​2_TBL
C)TBL 3
D)​4 tbl

Accepted Answer

Table names should not contain spaces or special characters, and should start with a letter. Therefore, TBL_1 is a valid option.

Question 12

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

Accepted Answer

Oracle does not have a special location called "Saved Commands" for storing script files. Script files are typically stored in the file system of the operating system where Oracle is running.

Question 13

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

Accepted Answer

The answer of If you added a row that should...

Question 14

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

Accepted Answer

The answer of In Access,dates are enclosed in number signs...

Question 15

SQL was developed in the mid-____.​
A)1960s
B)​1970s
C)1980s
D)​1990s

Accepted Answer

SQL was developed in the early 1970s by IBM researchers Donald Chamberlin and Raymond Boyce.

Question 16

The ____ data type is used to store integers.​
A)INTEGER
B)​NUMERAL
C)NUMBER
D)​INT

Accepted Answer

The INT data type is used to store integers in programming languages like Java, C++, and Python. The other options are not commonly used data types for integers.

Question 17

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

Accepted Answer

The DESCRIBE TABLE command is used to display a table's structure, including its columns, data types, and column lengths, but it does not define the table's structure.

Question 18

What is the original name of SQL?​
A)SEQUEL
B)​MYSEQUEL
C)DBase
D)​MySQL

Accepted Answer

The original name of SQL was SEQUEL (Structured English QUEry Language). It was later changed to SQL to avoid trademark conflicts.

Question 19

In SQL,table names cannot exceed ____ characters.​
A)12
B)​14
C)24
D)​30

Accepted Answer

In SQL, the maximum length for table names is typically 30 characters, although this can vary depending on the database system being used.

Question 20

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

Accepted Answer

The sp_columns command in SQL Server can be used to list all the columns in a table.

Quiz 3: Creating Tables

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

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

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

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

In Oracle,dates have the format ____.​

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

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

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

Access does not use script files.

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

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

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

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

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

SQL was developed in the mid-____.​

The ____ data type is used to store integers.​

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

What is the original name of SQL?​

In SQL,table names cannot exceed ____ characters.​

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

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

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

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

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

In Oracle,dates have the format ____.

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

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

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

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

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

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

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

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

SQL was developed in the mid-____.

The ____ data type is used to store integers.

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

What is the original name of SQL?

In SQL,table names cannot exceed ____ characters.