Data Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

Topic :: Data

Data Interview Questions

Questions Answers Views Company eMail

If we create a column with data type VARCHAR(3), what would we expect to see in MySQL table?

2 6324

What does TIMESTAMP ON UPDATE CURRENT_TIMESTAMP data type do?

1 5345

Explain data type TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP .

2 10328

what if you really want to store the timestamp data, such as the publication date of the article?

2 5939

If you specify the data type as DECIMAL (5,2), what?s the range of values that can go in this table?

2 7540

If you?re not wanting any SAS output from a data step, how would you code the data statement to prevent SAS from producing a set?

1 6055

What is the one statement to set the criteria of data that can be coded in any step?

4 16506

When looking for data contained in a character string of 150 bytes, which function is the best to locate that data: scan, index, or indexc?

7 19777

If you have a data set that contains 100 variables, but you need only five of those, what is the code to force SAS to use only those variable?

16 20889

Code a PROC SORT on a data set containing State, District and County as the primary variables, along with several numeric variables?

3 7989

What is the Program Data Vector (PDV) and What are its functions?

9 17625

At compile time when a SAS data set is read, what items are created?

5 10728

Identify statements whose placement in the DATA step is critical?

11 25165

In the flow of DATA step processing, what is the first action in a typical DATA Step?

9 14318

What is the default property of data control?

2 6678