98-364 Exam Questions

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

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

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

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

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

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

You need to retrieve data from two related database tables based on a column that exists in both tables. Which command should you use in a query?

You have a database table that contains the following columns: You must insert the following record into the table: Which two Structured Query Language (SQL) statements can 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 i...

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

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

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

You need to delete a database table. Which data definition language (DDL) keyword should you use?

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

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

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

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

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: Rev...

You have two tables named Cars and Color as defined below. The two tables are related by ColorId. You run the following SQL statement: select: How many rows does the SQL statement...

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

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

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

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

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

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: Revi...

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

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

This question requires that you evaluate the underlined text to determine if it is correct. You have a table that contains information about all students in your school. You use th...

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

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

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

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