• technology Online Quiz - 1841
Back
0

technology Online Quiz - 1841

Description: technology Online Quiz - 1841
Number of Questions: 20
Created by:
Tags: technology
Start the Quiz
Attempted 0/20 Correct 0 Score 0
‹
›

What is the connection manager you should use to import an Excel 2007 file into SQL Server using SSIS?

technology

  1. Excel Connection Manager with Excel version 2007

  2. Microsoft Jet 2007 OLE DB Provider

  3. Microsoft Office 12.0 Access Database Engine OLE DB Provider with Extended property set to Excel 12.0

  4. File Connection Manager

Show answer
Correct Option: C

Which is the slowly changing dimension method that you can't us in a data flow task in SSIS?

technology

  1. Type 1 dimensions

  2. Type 2 dimensions

  3. Type 3 dimensions

  4. Inferred dimensions

Show answer
Correct Option: C

What is the data flow transformation that needs a sorted data stream?

technology

  1. Aggregate

  2. Merge Join

  3. Condition Split

  4. All need Sorted data streams

Show answer
Correct Option: B

What is a Checkpoint Restart?

technology

  1. Checkpoint information are saved in a file

  2. Checkpoint allows a package to restart without returning tasks that already successfully completed

  3. Any loop containers are started over from the beginning of the current loop

  4. Data flow tasks and Control flow define restart points

Show answer
Correct Option: D

How you can send HTML email messages from SSIS?

technology

  1. Using the Send Mail control task

  2. Using a script control task

  3. Using Database Mail

  4. You cannot send HTML mails from SSIS

Show answer
Correct Option: B

How can you set the value 2007-08-21 02:00 AM in a SSIS variable?

technology

  1. Define a datetime variable and assign the above value

  2. Define a date and time variables and add them together

  3. Define the date time variable and pass it to a script component and add time component

  4. You cannot set the above value from SSIS

Show answer
Correct Option: C

Which is NOT a method that you can use to configure package configurations in SSIS packages?

technology

  1. SQL Server Table

  2. HKEY_LOCAL_MACHINE hive in the windows Registry

  3. XML file

  4. Environment variable

Show answer
Correct Option: B

You are using SSIS to import a plain text file to SQL Server. You have found that some text files do not have a standard format. For example, the last field orderdate does not exist for some records. What is the best method you should use to import this file to SQL Server?

technology

  1. You cannot use SSIS to import non-standard text files

  2. Use a flat file connection and assign text file for the connection and get the data

  3. Use a flat file connection and Transformation option of the script component. The use some code get the orderdate

  4. Use fuzzy grouping and a flat file connection to get order date

Show answer
Correct Option: C

'Browser navigation timeout' is in which tab of Test Settings (File->Settings) window.
technology testing

  1. Properties

  2. Resources

  3. Web

  4. Web Settings

Show answer
Correct Option: C

How many tabs are there in Test Settings (File->Settings) window?
technology testing

  1. 7

  2. 6

  3. 5

  4. 8

Show answer
Correct Option: A

Identify the tabs in the Test Settings (File->Settings) window
technology testing

  1. Properties, Run, Resources, Parameters, Environment, Web, Recovery

  2. Properties, Run, Resources, Parameters, Environment, Web

  3. Properties, Run Options, Resources, Parameters, Environment, Web,

  4. Properties, Run, Resources, Input Parameters, Environment, Web, Recovery

Show answer
Correct Option: A

'Generate Script' is in which tab of Test Settings (File->Settings) window
technology testing

  1. Properties

  2. Web

  3. Resources

  4. Recovery

Show answer
Correct Option: A

The following are the four main columns in the Keyword view

technology testing

  1. Item, Operation, Value, Comments

  2. Item, Operation, Value, Documentation

  3. Item, Operation, Property, Documentation

  4. Number, Operation, Value, Documentation

Show answer
Correct Option: B

AI Explanation

To answer this question, we need to understand the structure and purpose of the Keyword view in a software testing tool.

The Keyword view is a component of a software testing tool that allows testers to create and manage test cases using a visual interface. It consists of columns that represent different aspects of a test case.

Let's go through each option to understand why it is correct or incorrect:

Option A) Item, Operation, Value, Comments - This option is incorrect because it includes the column "Comments" instead of "Documentation".

Option B) Item, Operation, Value, Documentation - This option is correct because it accurately represents the four main columns in the Keyword view.

Option C) Item, Operation, Property, Documentation - This option is incorrect because it includes the column "Property" instead of "Value".

Option D) Number, Operation, Value, Documentation - This option is incorrect because it includes the column "Number" which is not a standard column in the Keyword view.

The correct answer is B) Item, Operation, Value, Documentation. This option is correct because it accurately represents the four main columns in the Keyword view.

RFID stands for...

technology

  1. Radio Frequency Identifier

  2. Radio Frequency Identity Device

  3. Radio Frequency Infrared Device

  4. Radio Frequency Identification

Show answer
Correct Option: D

Capability of simultaneous reading of multiple tags is called

technology

  1. agility

  2. anti-collision

  3. multi path

  4. polarizations

Show answer
Correct Option: B

High Frequency (HF) RFID tags use

technology

  1. 125 kHz

  2. 915 MHz

  3. 2.54 GHz

  4. 13.56 MHz

Show answer
Correct Option: D

Which of the following has no effect on the read-range?

technology

  1. ambient RF noise

  2. transmitted power from the reader

  3. tag memory

  4. tag antenna size

Show answer
Correct Option: C

when was the First Email sent?

technology

  1. 1985

  2. 1990

  3. 1971

  4. 1975

Show answer
Correct Option: C

AI Explanation

To answer this question, we need to understand the history of email. Let's go through each option to understand why it is correct or incorrect:

Option A) 1985 - This option is incorrect because email was actually sent before 1985. Option B) 1990 - This option is incorrect because email was sent before 1990. Option C) 1971 - This option is correct because the first email was sent in 1971. Ray Tomlinson, an American computer programmer, is credited with sending the first email while working on the ARPANET (Advanced Research Projects Agency Network) system. Option D) 1975 - This option is incorrect because email was sent before 1975.

The correct answer is C. The first email was sent in 1971.

What two kinds of servers handle incoming e-mail messages?

technology

  1. POP3 and IMAP servers

  2. Web and FTP servers

  3. POP3 and FTP servers

  4. FTP servers and IMAP

Show answer
Correct Option: A

AI Explanation

To answer this question, you need to understand the different protocols used for handling incoming email messages.

Option A) POP3 and IMAP servers - This option is correct because both POP3 (Post Office Protocol version 3) and IMAP (Internet Message Access Protocol) servers are used to handle incoming email messages. POP3 servers store emails on the server until they are downloaded to the client device, while IMAP servers store emails on the server and allow the client device to access and manage the emails remotely.

Option B) Web and FTP servers - This option is incorrect because web servers and FTP (File Transfer Protocol) servers are not directly involved in handling incoming email messages. Web servers are used to host websites, while FTP servers are used for file transfers.

Option C) POP3 and FTP servers - This option is incorrect because while POP3 servers are used to handle incoming email messages, FTP servers are not directly involved in email handling. FTP servers are used for file transfers.

Option D) FTP servers and IMAP - This option is incorrect because while IMAP servers are used to handle incoming email messages, FTP servers are not directly involved in email handling. FTP servers are used for file transfers.

Therefore, the correct answer is A) POP3 and IMAP servers.

To which port does the SMTP server listen in order to accept incoming messages?

technology

  1. Port 15

  2. Port 115

  3. Port 110

  4. Port 25

Show answer
Correct Option: D
- Hide questions
ADVERTISEMENT

Find more quizzes from top tags

general knowledge
3615 Quizzes
119858 Questions
 technology
307 Quizzes
36705 Questions
 sports
963 Quizzes
19148 Questions
 history
1187 Quizzes
13475 Questions
 physics
598 Quizzes
13441 Questions
 biology
1160 Quizzes
12174 Questions
 science & technology
551 Quizzes
11015 Questions
 chemistry
490 Quizzes
9892 Questions
 maths
518 Quizzes
9324 Questions
 softskills
0 Quizzes
7131 Questions