Holmes works as a Programmer for HiTech Institute.

Vendor: GIAC
Product: GSSP-NET-CSHARP
Update on: Jul 25, 2025
Questions: 491

GIAC GSSP-NET-CSHARP Question Answer

Holmes works as a Programmer for HiTech Institute. He develops an ASP.NET application named LibraryRecord by using Visual Studio .NET. The LibraryRecord application uses a SQL Server database named Database1. Database1 contains two tables: Students and Books. The Students table comprises three columns: StudentID, StudentName, and BookID. The Books table comprises two columns: BooksID and BooksName. Holmes creates a stored procedure that returns the records of all students who borrowed books from the institute. What will Holmes do to retrieve the records of the issued books most efficiently?

Use the INNER JOIN keyword in his query.

Use the INNER JOIN keyword more than once in his query.

Use the LEFT OUTER JOIN keyword in his query.

Use the WHERE clause in his query.