Question No: 121 – (Topic 1)

You are creating a database for a student directory. The Students table contains the following fields:

Which statement will retrieve only the first name, last name, and telephone number for every student listed in the directory?

WHERE Students SELECT *

SELECT firstName, lastName, telephoneNumber FROM Students

SELECT firstName, lastName, telephoneNumber IN Students

SELECT * FROM Students

WHERE Students SELECT firstName, lastName, telephoneNumber

Answer: B

Explanation: Use SELECT…FROM and list the fields you want to retrieve.

Question No: 122 – (Topic 1)

Which language was designed for the primary purpose of querying data, modifying data, and managing databases in a Relational Database Management System?

Java

SQL

C

Visual Basic

Answer: B

Explanation: SQL is a special-purpose programming language designed for managing data held in a relational database management system (RDBMS).

Question No: 123 HOTSPOT – (Topic 1)

You are developing a web application.

You need to create the following graphic by using Cascading Style Sheets (CSS):

Use the drop-down menus to select the answer choice that completes each statement. Each correct selection is worth one point.

Answer:

Explanation:

C:\Users\Kamran\Desktop\image.jpg

Question No: 124 – (Topic 1)

You are creating an application for a help desk center. Calls must be handled in the same order in which they were received.

Which data structure should you use?

Binary tree

Stack

Hashtable

Queue

Answer: D

Explanation: A queue keeps the order of the items.

Question No: 125 – (Topic 1)

You need to create an application that processes data on a last-in, first-out (LIFO) basis. Which data structure should you use?

Queue

Tree

Stack

Array

Answer: C

Explanation: A stack implements LIFO.

Question No: 126 – (Topic 1)

An application presents the user with a graphical interface. The interface includes buttons that the user clicks to perform tasks. Each time the user clicks a button, a method is called that corresponds to that button.

Which term is used to describe this programming model?

Functional

Service oriented

Structured

Event driven

Answer: D

Question No: 127 – (Topic 1)

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

The benefit of using a transaction when updating multiple tables is that the update cannot fail.

Select the correct answer if the underlined text does not make the statement correct. Select quot;No change is neededquot; if the underlined text makes the statement correct.

No change is needed

succeeds or fails as a unit

finishes as quickly as possible

can be completed concurrently with other transactions

Answer: B

Explanation: The benefit of using a transaction when updating multiple tables is that the update succeeds or fails as a unit.

Question No: 128 – (Topic 1)

This question requires that you evaluate the underlined text to determine if it is correct. Converting an object to a more general type is called upcasting.

Select the correct answer if the underlined text does not make the statement correct. Select quot;No change is needed#39;#39; if the underlined text makes the statement correct.

No change is needed

downcasting

interfacing

flexing

Answer: A

Explanation: Casting up a hierarchy means casting from a derived object reference to a base object reference.

Question No: 129 – (Topic 1)

Which of the following must exist to inherit attributes from a particular class?

Public properties

A has-a relationship

An is-a relationship

Static members

Answer: A

Explanation: There must be some public properties that can be inherited.

Question No: 130 HOTSPOT – (Topic 1)

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