Docsity
Docsity

Prepare for your exams
Prepare for your exams

Study with the several resources on Docsity


Earn points to download
Earn points to download

Earn points by helping other students or get them with a premium plan


Guidelines and tips
Guidelines and tips

Microsoft SQL Server Exam Questions and Answers, Exams of Nursing

A series of questions and answers related to microsoft sql server database management. The questions cover various topics such as stored procedures, table-valued functions, views, subqueries, data structures, and data definition language (ddl) statements. Insights into how to create and modify database objects, optimize data retrieval performance, and ensure data integrity through the use of features like the with check option clause in views. By studying this document, students can gain a deeper understanding of sql server concepts and prepare for exams or interviews related to database administration and development.

Typology: Exams

2023/2024

Available from 09/17/2024

studyclass
studyclass 🇺🇸

1.6K documents

1 / 4

Toggle sidebar

Related documents


Partial preview of the text

Download Microsoft SQL Server Exam Questions and Answers and more Exams Nursing in PDF only on Docsity! Microsoft Exam You need to create a module that performs the following tasks: *Accepts an order number *Sets the value of the Status column in the Orders table for that order number to Shipped *Retrieves a tracking number to the Shipping table *Returns the number of items shipped and the customer's e-mail address What should you create? - correct answer ✔✔Stored procedure Using a stored procedure: - correct answer ✔✔improves performance because parsing is not required with each execution. An inline table-valued function: - correct answer ✔✔includes only a single SELECT statement. You can retrieve data sorted by the LastName column by using a: - correct answer ✔✔SELECT statement with a GROUP BY clause. Which statement shows a valid use of the CREATE VIEW statement? - correct answer ✔✔CREATE VIEW TopStudents AS SELECT TOP 10 FirstName, LastName, Grade FROM Grades ORDER BY Grades You execute the following query: SELECT LoanNumber, OriginalLoanAmt, InterestRate FROM Loan WHERE BorrowerID IN (SELECT BorrowerID WHERE BorrowerState='TX') What is this an example of? - correct answer ✔✔a subquery What data structure physically stores the data in a relational database table that has a single nonclustered index? - correct answer ✔✔Heap You have created a view using the statement shown in the exhibit. You need to modify the view so that only movies with a rating of G or PG are visible through the view. What should you use? - correct answer ✔✔An ALTER VIEW statement with a WHERE clause At a minimum, what is required within a column definition a CREATE TABLE statement? - correct answer ✔✔A column name and data type You are creating a relational database that will store information about physicians and their patients. Each patient may have more than one physician. Each physician may have multiple patients. What should you include? - correct answer ✔✔Three tables and two one-to-many relationships What statement is a data definition language (DDL) statement? - correct answer ✔✔ALTER You are creating a relational database that will be used to track car rentals. Each renter can rent multiple cars. A car can be rented by multiple drivers. You need to reduce the amount of redundant data. How should you store the car rental data? - correct answer ✔✔Create a Cars table, a Renters table, and a CarRentals table.