A user can move the Available Fields to the Selected Fields in the Query Wizard by clicking the > button or by ________ on the Available Field

Case-Based Critical Thinking QuestionsCase 1-2John is trying to increase traffic through the Web site he created. He also would like to validate the code he developed. He posted several questions he had on one of the online forums and got clear answers from professional Web developers.The name and content within the tags are ____.

A. keywords B. values C. attributes D. labels

Consider the following query:

``` SELECT T.CrsCode, T.Grade FROM Transcript T, Student S WHERE T.StudId = S.Id AND S.Name = ’Joe’ ``` Assume that Id is the primary key of Student,(CrsCode, Semester, StudId) is the primary key of Transcript,andthatName is not unique. Set up a database containing these two tables on the DBMS available to you. Initialize the tables with a large number of rows. Write a program that measures the query execution time by reading the clock before and after submitting the query. Be sure to ?ush the cache between successive measurements (perhaps by executing a query that randomly reads a su?cient number of rows of a large dummy table). a. Test your understanding by making an educated guess of what query plan will be chosen by the DBMS assuming that there are no indices other than those for the primary keys. Run the query, output the query plan, and check your guess. Measure the response time. b. Now assume that an unclustered index on StudId on Transcript is added. What query plan would you expect? Run the query, check your answer, and measure the response time. Try the query under two conditions: Joe has taken very few courses; Joe has taken many courses. c. In addition to the index added in (b), assume that an unclustered index on Student on Name has been added and repeat the experiment.