One reason to add an index is to:

You have a table that contains the following data.

Which database term is used to describe the relationship between ProductID and ProductCategory?

Which key uniquely identifies a row in a table?

Which statement creates a composite key?

At 3:00 P.M. (1500 hours), you create a backup of your database. At 4:00 P.M. (1600 hours), you create a table named Customer and import data into the table. At 5:00 P.M. (1700 hours), your server fails. You run a script to apply only the 3:00 P.M. backup to your database. What is the result of the script?

In which situation do you need to perform a restore on a database?

Which command should you use to give a user permission to read the data in a table?

You need to enable a new employee to authenticate to your database. Which command should you use?

Which keyword can be used in a create table statement?

You need to store product quantities, and you want to minimize the amount of storage space that is used. Which data type should you use?

Which statement will result in the creation of an index?

You have the following table definition:

CREATE TABLE Road

(RoadID INTEGER NOT NULL,

Distance INTEGER NOT NULL) ;

The Road table contains the following data: You execute the following statement:

INSERT INTO Road VALUES (1234, 36)

What is the result?

You need to store product names that vary from three to 30 characters.

You also need to minimize the amount of storage space that is used.

Which data type should you use?

One reason to create a stored procedure is to:

Which permission does a user need in order to run a stored procedure?

You have a table named Product. You create a view that includes all the products from the Product table that are in the Furniture category. You execute a statement on the Product table that deletes all the products in the Furniture category. After you execute the statement, the result set of the view is:

In SQL, an insert statement is used to add a:

You have two tables. Each table has three rows. How many rows will be included in the Cartesian product of these two tables?

You are writing an SQL statement to retrieve rows from a table. Which data manipulation language (DML) command should you use?

Which constraint ensures a unique value in the ID column for each customer?

The component that holds information for a single entry in a table is called a:

You execute the following statement:

SELECT EmployeeID, FirstName, DepartmentName

FROM Employee, Department ;

This type of operation is called a/an:

Which command should you use to add a column to an existing table?

You have the following table definition:

CREATE TABLE Product

(ID INTEGER PRIMARY KEY,

Name VARCHAR(20),

Quantity INTEGER) ;

The Product table contains the following data. You execute the following statement:

SELECT Name FROM Product WHERE Quantity IS NOT NULL

How many rows are returned?

You are writing a select statement to find every product whose name contains a specific character. Which keyword should you use in your where clause?

A database contains two tables named Customer and Order. You execute the following statement: DELETE FROM Order WHERE CustomerID = 209 What is the result?

You have a table named Product. The Product table has columns for ProductDescription and ProductCategory. You need to change the ProductCategory value for all the spoons in the Product table to 43. Which statement should you use?

You have a table that contains information about all students in your school. Which SQL keyword should you use to change a student's first name in the table?

You need to populate a table named EmployeeCopy with data from an existing table named Employee. Which statement should you use?

You execute the following statement:

This statement is an example of a/an:

Which keyword would you use in a select statement to return rows that meet a specific condition?

You have a table named Employee that includes the following columns:

EmployeeID

Smp1oyeeName

Which statement should you use to return the number of rows in the table?

The Product table contains the following data. You execute the following statement:

SELECT COUNT(*)

FROM Product

WHERE Quantity > 18

What is the value returned by this statement?

Which command should you use to remove a table from a database?

You need to store the contact information for each student in your school database.

You should store each student's information in a:

Which category of SQL statements is used to add, remove, and modify database structures?

You have a Customer table and an Order table.

You join the Customer table with the Order table by using the CusromerID column.

The results include: All customers and their orders Customers who have no orders

Which type of join do these results represent?

Data in a database is stored in:

You have a table named Student that contains 100 rows.

Some of the rows have a NULL value in the FirstName column.

You execute the following statement:

DELETE FROM Student What is the result?

You need to establish a set of permissions that you can routinely assign to new users.

What should you create?

Which database term is used to describe the process of applying a backup to a damaged or corrupt database?

Denormalization is performed in order to:

You have a table named Product that contains one million rows. You need to search for product information in the Product table by using the product's unique ID. What will make this type of search more efficient?

You have a table named Product that contains the following data. The PrcducrID column is the primary key. The CategoryID column is a foreign key to a separate table named Category.

You execute the following statement: INSERT INTO Product VALUES (3296, 'Table', 4444)

What is the result?

Which two keys establish a relationship between two tables? (Choose two.)

One difference between a function and a stored procedure is that a function:

Which keyword must be included in a create view statement?

You have a table named Customer. You need to add a new column named District.

Which statement should you use?

You need to remove a view named EmployeeView from your database.

Which statement should you use?

A named group of SQL statements that can be executed in a database is called a:

A view can be used to:

On which database structure does an update statement operate?

You need to list the name and price of each product, sorted by price from highest to lowest.

Which statement should you use?

You delete rows in a table named Order. The corresponding rows in the OrderItem table are automatically deleted. This process is an example of a/an:

Which statement deletes the rows where the employee's phone number is not entered

You need to insert two new products into the Product table. The first product is named Book and has an ID of 125. The second product is named Movie and has an ID of 126.

Which statement should you use?

Your Company stores customer social security numbers in a column SSN in a table named customers . New compliance laws prohibit your company from storing this information. Running the query below causes an error to occur.

ALTER TABLE Customers

REMOVE SSN;

What Changes are needed to the query above so that it removes the SSN column from the customer table.

You have a table named Employee that includes four columns.

You execute the following statement:

SELECT * FROM Employee

Which columns are returned?

Which two elements are required to define a column? (Choose two.)

What defines the amount of storage space that is allocated to a value in a column?

You are creating a table to store customer data.

The AccountNumber column uses values that always consist of one letter and four digits.

Which data type should you use for the AccountNumber column?

What is one difference between an update statement and a delete statement?

You have a Department table and an Employee table in your database.

You need to ensure that an employee can be assigned to only an existing department.

What should you apply to the Employee table?

You need to store the first name, last name, and student ID for 100 students.

This information will be stored in a table as:

What are three valid data manipulation language (DML) commands? (Choose three.)

You assign User1 a set of permissions that include the WITH GRANT OPTION. The WITH GRANT OPTION enables User1 to:

Which type of index changes the order in which the data is stored in a table?

Which statement should you use to remove a foreign key?

First normal form requires that a database excludes:

You execute a statement inside a transaction to delete 100 rows from a table. The transaction fails after only 40 rows are deleted. What is the result in the database?

You have a table that contains product IDs and product names. You need to write an UPDATE statement to change the name of a specific product to glass. What should you include in the update statement?

Your database contains a table named Customer.

You need to delete the record from the Customer table that has a CusromerID of 12345.

Which statement should you use?

On which database structure does an insert statement operate?

You have a table of products with fields for ProductID, Name, and Price.

You need to write an UPDATE statement that sets the value in the InStock field to Yes for a specific ProductID. Which clause should you use in your update statement?

You have the following table definition:

CREATE TABLE Product

(ProductID INTEGER,

Name VARCHAR(20)) ;

You need to insert a new product. The product's name is Plate and the product's ID is 12345.

Which statement should you use?

Instructions: For each of the following statements, select Yes if the statement is true. Otherwise, select No. Each correct selection is worth one point.

You have a database table named SongInformation as defined below:

You need to create a Structured Query Language (SQL) query to retrieve only the names of songs that sold more than 1000 compact discs (CDs).

Which query should you use?

You accept an IT internship at a local charity. The charity asks you to keep a record of its volunteers by using a database table named Volunteer.

The table has the following columns and rows:

When volunteer information changes, you must update the table. Y

ou need to change Tia's name to Kimberly.

Which statement should you choose?

This question requires that you evaluate the underlined text to determine if it is correct. Use the FROM keyword in a SELECT statement to return rows that meet a specific condition.

Instructions: Review the underlined text. If it makes the statement correct, select "No change is needed." If the statement is incorrect, select the answer choice that makes the statement correct

You need to combine the results of two queries into a single result that contains all of the rows from both queries. Which Structured Query Language (SQL) statement should you use?

This question requires that you evaluate the underlined text to determine if it is correct. The CREATE TABLE command removes one or more table definitions and all data, indexes, triggers, constraints, and permission specifications for those tables.

Instructions: Review the underlined text. If it makes the statement correct, select "No change is needed." If the statement is incorrect, select the answer choice that makes the statement correct

You accept an IT internship at a local charity. The charity wants you to help them with compliance and auditing requirements. You need to ensure that a column or combination of columns uniquely identifies each row of a table. Which constraint should you define?

The following illustration shows the structure of a clustered index in a single partition.

1. 1. A clustered index improves the performance of queries that [answer choice]

2. 2. A clustered index improves the performance of queries on column that[answer choice]

Instructions: Select the answer choice that completes each statement Each correct selection is worth one point.

While attending college, you accept an IT internship at a local charity. The charity needs to report on data that is related and exists in two tables.

You need to establish a relationship between the data that is in the two tables.

Which constraint should you define?

This question requires that you evaluate the underlined text to determine if it is correct. A view can be used to ensure referential integrity. Instructions: Review the underlined text. If it makes the statement correct, select "No change is needed." If the statement is incorrect, select the answer choice that makes the statement correct

You have a database table that stores information about school attendance.

This question requires that you evaluate the underlined text to determine if it is correct. In a database table, each column represents a unique record.

Instructions: Review the underlined text.

If it makes the statement correct, select "No change is needed." If the statement is incorrect, select the answer choice that makes the statement correct

This question requires that you evaluate the underlined text to determine if it is correct. You have two tables. Each table has three rows. You create a SQL query that uses a cross join. The query does not include a WHERE clause. Nine rows will be included in the Cartesian product of these two tables. Instructions: Review the underlined text. If it makes the statement correct, select "No change is needed." If the statement is incorrect, select the answer choice that makes the statement corrector.

You have two tables named Salesperson and Sales. You need to ensure that each record in the Sales table has a valid associated salesperson record in the Salesperson table. Which database object should you add to the Sales table?

You have two tables named Salesperson and Sales. You need to ensure that each record in the Sales table has a valid associated salesperson record in the Salesperson table.

Which database object should you add to the Sales table?

This question requires that you evaluate the underlined text to determine if it is correct. Use the ALTER statement to add a new table in a database. Instructions: Review the underlined text. If it makes the statement correct, select "No change is needed." If the statement is incorrect, select the answer choice that makes the statement correct.

You need to rename a column in a database table. Which data definition language (DDL) statement should you use?

This question requires that you evaluate the underlined text to determine if it is correct. Use indexing to create, remove, or change database objects. Instructions: Review the underlined text. If it makes the statement correct, select "No change is needed." If the statement is incorrect, select the answer choice that makes the statement correct.

You need to add rows to a database table. Which Structured Query Language (SQL) keyword should you use?

This question requires that you evaluate the underlined text to determine if it is correct. The JOIN keyword combines the results of two queries and returns only rows that appear in both result sets. Instructions: Review the underlined text. If it makes the statement correct, select "No change is needed." If the statement is incorrect, select the answer choice that makes the statement correct

You work at a restaurant and they ask you to help them with a data issue. They provide you with the following recipe data

You need to normalize the data to third normal form. How many tables should you create?

You accept an IT internship at a local charity. The charity has two tables in their data model named Chapter and Language, as defined below: You create a third table named ChapterLanguage to relate the Chapter table and the Language table. You need to select columns from the Chapter and Language tables to create a composite primary key for the ChapterLanguage table. Which two columns should you select? (Choose two.)

Instructions: For each of the following statements, select Yes if the statement is true. Otherwise, select No. Each correct selection is worth one point.

This question requires that you evaluate the underlined text to determine if it is correct. You combine data from three tables into one table. The new table includes redundancy to optimize read performance. The data in the new table has been denormalized.

Instructions: Review the underlined text. If it makes the statement correct, select "No change is needed." If the statement is incorrect, select the answer choice that makes the statement correct.

This question requires that you evaluate the underlined text to determine if it is correct. Create a query that returns a set of table data by using the UPDATE statement.

Instructions: Review the underlined text. If it makes the statement correct, select "No change is needed." If the statement is incorrect, select the answer choice that makes the statement correct.

Your class project requires that you help a charity to create a website that registers volunteers. The website must store the following data about the volunteers: Given name Surname Telephone number Email address You need to recommend a correct way to store the data. What do you recommend?

This question requires that you evaluate the underlined text to determine if it is correct.

Truncate is a database term used to describe the process of applying a backup to a damaged or corrupt database. Instructions: Review the underlined text. If it makes the statement correct, select "No change is needed." If the statement is incorrect, select the answer choice that makes the statement corrector.

This question requires that you evaluate the underlined text to determine if it is correct. Use the ALLOW SELECT command to give a user permission to read the data in a table. Instructions: Review the underlined text. If it makes the statement correct, select "No change is needed." If the statement is incorrect, select the answer choice that makes the statement correct

You have a user that has server roles as defined below

Instructions: For each of the following statements, select Yes if the statement is true. Otherwise, select No. Each correct selection is worth one point

This question requires that you evaluate the underlined text to determine if it is correct. Views are database objects that contain all of the data in a database. Instructions: Review the underlined text. If it makes the statement correct, select "No change is needed." If the statement is incorrect, select the answer choice that makes the statement correct

You have two tables named Cars and Color as defined below. The two tables are related by ColorId

You accept an IT internship at a local charity. The charity asks you to keep a record of its volunteers by using a database table named Volunteer. When volunteers ask to be removed from mailing lists, the table must be updated. You need to use a transaction to ensure that the database has data integrity and referential integrity. Which statement should you use?

This question requires that you evaluate the underlined text to determine if it is correct. ALTER TABLE removes all rows from a table without logging the individual row deletions.

Instructions: Review the underlined text. If it makes the statement correct, select "No change is needed." If the statement is incorrect, select the answer choice that makes the statement correct.

You work at a coffee shop. They ask you to set up a website that stores charges on purchases. You need to recommend a data type in a database table to run financial functions against the charged amounts.

Which data type should you recommend?

This question requires that you evaluate the underlined text to determine if it is correct. A row holds information for a single record in a table.

Instructions: Review the underlined text. If it makes the statement correct, select "No change is needed." If the statement is incorrect, select the answer choice that makes the statement correct

Instructions: For each of the following statements, select Yes if the statement is true. Otherwise, select No. Each correct selection is worth one point.

This question requires that you evaluate the underlined text to determine if it is correct. Ports 20 and 21 are the default ports to secure a SQL Server. Instructions: Review the underlined text. If it makes the statement correct, select "No change is needed." If the statement is incorrect, select the answer choice that makes the statement correct.

You ate creating a database object named Student to store the following data:

Which syntax should you use to create the object?

You develop a database to store data about textbooks. The data must be stored to process at a later time. Which database object should you use to store the data?

This question requires that you evaluate the underlined text to determine if it is correct. First normal form requires that a database excludes repeating groups.

Instructions: Review the underlined text. If it makes the statement correct, select "No change is needed." If the statement is incorrect, select the answer choice that makes the statement correct.

You have two database tables as defined below. The StateID column is unique in the State table. The AddressID column is unique in the Address table. The two tables are related by the StateID column

You have the following SQL query

SELECT * FROM dbo.ProAthlete WHERE Salary > 500000

The query takes too much time to return data. You need to improve the performance of the query.

Which item should you add to the Salary column?

You work for a small auto trading company. You need to remove a car from the company database. Information about the car is stored in the following tables.

All of the car’s parts are custom made, so they each have a row in every table. Cascading deletes are not enabled but referential integrity is. From which table must you first make your deletion?

You have a table that contains information about all students in your school. You use the INSERT SQL keyword to change a student’s given name in the table. Instructions: Review the underlined text. If it makes the statement correct, select “No change is needed.” If the statement is incorrect, select the answer choice that makes the statement correct.

You create the following table, which lists how many books you have on loan to your friends

Harry in San Francisco returns your books.

Which statement will update your table correctly?

You are developing a SQL query. Which two SQL constructs represent data manipulation language (DML) statements? Choose two.

You need to create a view to filter rows of data from an underling table. Which type of clause must be included in the CREATE VIEW statement?

This question requires that you evaluate the underlined text to determine if it is correct. A key defines the amount of storage space that is allocated to a value in a column.

Instructions: Review the underlined text. If it makes the statement correct, select "No change is needed." If the statement is incorrect, select the answer choice that makes the statement correct

This question requires that you evaluate the underlined text to determine if it is correct. A relational database management system employs the concept of an attribute to ensure that data entered into a field in a column is valid.

Instructions: Review the underlined text. If it makes the statement correct, select "No change is needed." If the statement is incorrect, select the answer choice that makes the statement correct.

You are structuring a table in a relational database.

Instructions: For each of the following statement, select Yes if the statement is true. Otherwise, select No. Each correct selection is worth one point.

You have a database that contains 10 terabytes of data. You need to back up the database every two hours. Which type of backup should you use?

This question requires that you evaluate the underlined text to determine if it is correct. The UNION keyword combines the results of two queries and returns only rows that appear in both result sets. Instructions: Review the underlined text. If it makes the statement correct, select "No change is needed." If the statement is incorrect, select the answer choice that makes the statement correct

Which query correctly returns a result set for all orders where the ship_state exclude Texas (TX) and Arizona(AZ)?

You need to create data in the student's table. The report must meet the following requirements:

1. 1. Display the students who enrolled on or after Januray 1,2020

2. 2. Display all students who graduated in 2020

3. 3. Return the result set in order of enrollment with the most recent enrollment date first.

4. enrollment_date specifies the enrollment date, graduation_date specifies the graduation date. An academic_status of Graduated indicates that a student has graduated.

You have a table named Customer that has columns named CustomerID, FirstName and DateJoined. CustomerID is the primary key.

You execute the following query

SELECT CustomerID, FirstName , DateJoined

FROM Customer

How are the rows organized in the result set?

The products table contains the following data.

Which query will increase the price of item 1 by 6 percent?

You have a table named product that contains million of rows. You need to search for product information using the following query:

SELECT ProductName, Price FROM Product WHERE Category = 'Science Books';

What will make this search more efficient?

The customers table includes the following data

You need to create a query that returns a result set contains the LastName, PhoneNumber and Extension for extensions that are valid numbers. The result set should be sorted by the LastLame.

A table named playerStat contains the following fields.

You need to display the number of points per player on the team whose ID is 1.

The following table named Building stores data about buildings and their most recent inspection dates.

The address filed stores the building's address, the InspectionDate stores the most recent inspection date . A value of NULL in the InspectionDate means a building has not yet been inspected.

You need to display the addresses of the earliest 10 buildings that have been inspected.

You create the following query to determine whether Sample Movie appear only once in the Movie table.

SELECT Title FROM Movie

WHERE Title = 'Sample Movie'

ORDER BY Title

GROUP BY Title

HAVING COUNT(*) =1;

When you run this query, it returns a syntax error.

You need to modify the query to run without error and return accurate results.

What should you do?

Which SQL statement will return the country and number of orders in each country where the number of orders if less than 50?

orderID represents an individual order, Country represents the country and Orders represents the number of orders.