Question 1

To create an index for the Customer table named RepBal with the keys RepNum and Balance and with the balances listed in descending order,the command is ____.
A)CREATE INDEX RepBal ON Customer (RepNum,Balance) ;
B)CREATE INDEX RepBal Customer (RepNum DESC) ;
C)CREATE INDEX ON Customer (RepNum,Balance ASC) ;
D)CREATE INDEX RepBal ON Customer (RepNum,Balance DESC) ;

Accepted Answer

The best choice is D because it specifies the name of the index as RepBal, the table as Customer and the keys as RepNum and Balance. Additionally, the DESC keyword is used to sort the balances in descending order.

Question 2

The ____ command will create an application program's or individual user's picture of the database.
A)CREATE SNAPSHOT
B)SELECT SNAPSHOT
C)SELECT VIEW
D)CREATE VIEW

Accepted Answer

The CREATE VIEW command creates a virtual table based on the result-set of SELECT statement. This virtual table is not a physical table, it is a view of data from one or more tables. By creating a view, an application program's or individual user's picture of the database is created. The CREATE SNAPSHOT option is not a valid SQL command. The SELECT SNAPSHOT option is not a valid SQL command either. The SELECT VIEW option is not a valid SQL command but can be used to retrieve data from a view that has already been created.

Question 3

The command DELETE INDEX CustList; would remove the index named CustList.

Accepted Answer

The correct SQL command to remove an index is DROP INDEX, not DELETE INDEX.

Question 4

Access 2010 supports data macros.

Accepted Answer

Access 2010 introduced data macros, which are similar to triggers in SQL databases and allow for automatic execution of actions based on data changes.

Question 5

Legal-values integrity is the property that states that no record can exist in the database with a value in the field other than one of the legal values.

Accepted Answer

Legal-values integrity ensures that only allowed values are stored in the database for a specific field. Any other value is not permitted and violates the integrity constraint.

Question 6

Once you add an index to a database,you cannot delete it.

Accepted Answer

You can delete an index from a database using appropriate syntax or commands.

Question 7

The SELECT command that creates the view,which is called the view query,indicates what to include in the view.

Accepted Answer

The answer of The SELECT command that creates the view,which...

Question 8

To change the field names in a view include the AS clause in the CREATE VIEW command.

Accepted Answer

This is true. The AS clause allows renaming of columns in a view. For example:
CREATE VIEW my_view AS SELECT column1 AS new_name1, column2 AS new_name2 FROM my_table;

Question 9

Views cannot be used to examine table data.

Accepted Answer

Views are used to provide a virtual representation of the data in one or more tables, but they can be used to examine the data just like selecting from a table.

Question 10

To create the primary key clause for the Customer table on the CustomerNum field,the correct statement is ____.
A)PRIMARY KEY (CustomerNum)
B)PRIMARY KEY (Customer,CustomerNum)
C)KEY (CustomerNum)
D)PRIMARY (CustomerNum)

Accepted Answer

The syntax for creating primary key clause is PRIMARY KEY (column_name). Therefore, in this case, the correct statement is PRIMARY KEY (CustomerNum) as it specifies that the primary key for the Customer table is CustomerNum. Option B is incorrect as it specifies two columns as the primary key. Option C is incorrect as it creates a key constraint but not a primary key constraint. Option D is incorrect as it is not a valid syntax.

Question 11

To create a view in Access,you simply create and then save a query.

Accepted Answer

To create a view in Access, you create and save a query. Access refers to this saved query as a view.

Question 12

An individual can use a view to create reports,charts,and other objects that show database data.

Accepted Answer

Views allow users to create custom reports and visualizations based on database data.

Question 13

When you create an index whose key has a single field,you have created what is called a primary index.

Accepted Answer

A primary index is typically associated with the primary key of a table, but an index on a single field is not necessarily a primary index unless it is specifically defined as the primary key.

Question 14

One advantage of a view is that different users can view the same data in different ways.

Accepted Answer

Views in a database allow users to customize the way they view certain data without affecting the underlying data itself. Therefore, different users can create different views that suit their specific needs and preferences.

Question 15

The following command will revoke the ability to retrieve Customer records from user Jones:
REVOKE GRANT ON Customer FROM Jones ;

Accepted Answer

The correct SQL command to revoke access would be "REVOKE SELECT ON Customer FROM Jones;". The provided command is incorrect in syntax and purpose.

Question 16

Information about tables in the database is kept in the system catalog.

Accepted Answer

The system catalog, also known as system tables or data dictionary, contains information about the database's metadata including tables, columns, indexes, and other objects.

Question 17

The ____ statement will take away user privileges to the database.
A)SELECT
B)INDEX
C)DEL
D)REVOKE

Accepted Answer

The REVOKE statement is used to take away user privileges to a database. It is used to revoke specified privileges on a specific object from a specific user or role. SELECT, INDEX, and DEL statements are not used for revoking user privileges.

Question 18

A stored procedure is placed on a client computer.

Accepted Answer

Stored procedures are typically stored on a database server, not on a client computer. Clients can execute the stored procedures through a database connection.

Question 19

The following command will enable Jones to retrieve data from the Customer table,but not to take any other action: GRANT SELECT ON Customer TO Jones ;

Accepted Answer

The GRANT SELECT command will grant the user Jones the ability to retrieve data from the Customer table, but not to modify or delete any data in the table.

Question 20

To create the primary key clause for the Orders table on the OrderNum and PartNum fields,the correct statement is ____.
A)PRIMARY KEY (Orders,OrderNum,PartNum)
B)KEY (OrderNum,PartNum)
C)PRIMARY KEY (OrderNum,PartNum)
D)PRIMARY (OrderNum,PartNum)

Accepted Answer

The PRIMARY KEY clause should be followed by the name of the table and then the fields that should be the primary key. Option C uses the correct syntax and specifies the OrderNum and PartNum fields as the primary key for the Orders table. The other options are incorrect syntax or use incorrect field names or table names.

Quiz 4: The Relational Model 3: Advanced Topics

To create an index for the Customer table named RepBal with the keys RepNum and Balance and with the balances listed in descending order,the command is ____.

The ____ command will create an application program's or individual user's picture of the database.