Tag: programming languages

Questions Related to programming languages

What two controls are needed when creating a toolbar ?
technology programming languages

  1. Only Toolbar control

  2. ImageList and Toolbar control

  3. Both 1 and 2

  4. All the above

Show answer
Correct Option: B
Explanation:

To create a toolbar, two controls are needed: an ImageList control and a Toolbar control.

Option A is incorrect because only a Toolbar control is not sufficient to create a toolbar.

Option B is correct because it accurately identifies the two controls needed to create a toolbar. An ImageList control is used to store the images that will be displayed on the toolbar buttons. A Toolbar control is used to create the actual toolbar, and it references the images in the ImageList control for the button icons.

Option C is incorrect because it is not a valid option.

Option D is incorrect because it includes option A which is incorrect.

Therefore, the correct answer is: B. ImageList and Toolbar control.

With SQL, how do you select all the records from a table named "Persons" where the value of the column "FirstName" starts with an "a"?
technology programming languages

  1. SELECT * FROM Persons WHERE FirstName='%a%'

  2. SELECT * FROmPersons WHERE FirstName LIKE '%a'

  3. SELECT * FROM Persons WHERE FirstName='a'

  4. SELECT * FROM Persons WHERE FirstName LIKE 'a%'

Show answer
Correct Option: D

The OR operator displays a record if ANY conditions listed are true. The AND operator displays a record if ALL of the conditions listed are true
technology programming languages

  1. True

  2. False

Show answer
Correct Option: B

Which SQL statement is used to return only different values?
technology programming languages

  1. SELECT UNIQUE

  2. SELECT DIFFERENT

  3. SELECT DISTINCT

  4. None of the above

Show answer
Correct Option: C

With SQL, how can you return the number of records in the "Persons" table?
technology programming languages

  1. SELECT COUNT() FROM Persons

  2. SELECT COLUMNS() FROM Persons

  3. SELECT COLUMNS(*) FROM Persons

  4. SELECT COUNT(*) FROM Persons

Show answer
Correct Option: D

How many clustered indexes can be created on single table
technology programming languages

  1. 1

  2. 128

  3. Up to number of columns in table

  4. 256

Show answer
Correct Option: A

Which is not the type of join in SQL SERVER
technology programming languages

  1. Inner

  2. Left

  3. Cross

  4. Multiple

  5. Right

Show answer
Correct Option: D

Which of the following is not valid constraint in SQL SERVER
technology programming languages

  1. Default

  2. Check

  3. Distinct

  4. Unique

Show answer
Correct Option: C

Which SQL keyword is used to sort the result-set?
technology programming languages

  1. ORDER BY

  2. ORDER

  3. SORT

  4. Distinct

Show answer
Correct Option: A

Which of following is not an aggregate function in SQL SERVER
technology programming languages

  1. MIN

  2. MAX

  3. AVG

  4. COUNT

  5. SUM

  6. GROUP

Show answer
Correct Option: F