Tag: programming languages

Questions Related to programming languages

The boss says he doesn’t care if it’s extra work. He wants that information at the end of this week and if he likes it he’s going to want it every week. What is the best choice for this situation?

technology programming languages

  1. Derived Table

  2. Volatile Table

  3. Global Temporary Table

  4. None of the above

Show answer
Correct Option: C

This query requires me to denormalize information in three different tables and then join the results. Fortunately, I only need to do it one time. What is the best choice for this situation?
technology programming languages

  1. Global Temporary Table

  2. Derived Table

  3. Volatile Table

  4. All of the above

Show answer
Correct Option: B

Is the following SQL statement True or False? CREATE TABLE dept_new7(a,b,c) AS (SELECT department_number , department_name FROM dept_new) WITH DATA;
technology programming languages

  1. True

  2. False

Show answer
Correct Option: B

A COUNT Window cannot be done in a SELECT involving MIN or MAX functions.

technology programming languages

  1. True

  2. False

Show answer
Correct Option: B

Which C# Keyword Signals To The Compiler That The Method In Which It Appears Is An Iterator Block?

technology programming languages

  1. Signal

  2. Yield

  3. Iterator

  4. sealed

Show answer
Correct Option: B

How can you UPDATE a table without using UPDATE? (Select 2)

technology programming languages

  1. By Using a Self Join.

  2. By Using a Nested Join.

  3. By using a Volatile Temporary Table.

  4. By using a View.

Show answer
Correct Option: A,D

Which Method Notifies A Thread In The Waiting Queue Of A Change In The Locked Object's State?
technology programming languages

  1. Thread.GetData

  2. Monitor.Pulse

  3. Thread.SpinWait

  4. Monitor.Wait

Show answer
Correct Option: B

______ Gives The Compiler Special Instructions For The Compilation Of The File In Which It Appears?
technology programming languages

  1. #fcompile

  2. #file

  3. #pragma

  4. #instruct

Show answer
Correct Option: C

Which Class Limits The Number Of Threads That Can Access A Resource Or Pool Of Resources Concurrently?

technology programming languages

  1. Semaphore

  2. Monitor

  3. SynchronizationContext

  4. TimeOut

Show answer
Correct Option: A

What’s The Implicit Name Of The Parameter That Gets Passed Into The Class’ Set Method?
technology programming languages

  1. Value

  2. Default

  3. Object

  4. Param

Show answer
Correct Option: A