Question 1

The SQL command used to avoid the selection of duplicate rows is

technology testing

UNIQUE
DISTINCT
EXCLUSIVE
DISCRETE

Answer

Correct Option: B

Question 2

How do you change the current directory to /usr/local/bin in UNIX?

technology testing

mv /usr/local/bin
cd /usr/local/bin
setdir /usr/localbin
cd usr/local/bin

Answer

Correct Option: B

Question 3

How do you list all the files that are in the current directory in UNIX?

technology testing

list all
ls -full
ls -a
ls -all

Answer

Correct Option: C

Question 4

Which of the following is not a valid -ve testing scenario for a job involving data load from a flat file to database table.

technology testing

Data file not present
Data file too large
Table is accessible to the user
Data in wrong format

Answer

Correct Option: C

Question 5

Which command will delete all data from a table and will not write to the rollback segment?

technology testing

DROP
DELETE
CASCADE
TRUNCATE

Answer

Correct Option: D

Question 6

Which of the following is/are NOT a typical characteristic of a batch run? select all that apply- multiple answers)

technology testing

It produces a log file
It take data from a text file
It takes some input and produces output
It is run in backend

Answer

Correct Option: B,C

Question 7

Which character function can be used to return a specified portion of a character string?

technology testing

INSTR
SUBSTRING
SUBSTR
POS

Answer

Correct Option: C

Question 8

Assuming today is Monday, 10 July 2000, what is returned by this statement: SELECT to_char(NEXT_DAY(sysdate, 'MONDAY'), 'DD-MON-RR') FROM dual;

technology testing

03-JUL-00
10-JUL-00
12-JUL-00
11-JUL-00
17-JUL-00
09-JUL-00

Answer

Correct Option: D

Question 9

How do you print the first 15 lines of all files ending by ".txt" in UNIX?

technology testing

print 15 .txt
cat *.txt -length=15
head -15 *.txt
tail -15 *.txt

Answer

Correct Option: C

Question 10

How do you rename file "new" in file "old" in UNIX?

technology testing

mv new old
cp new old
rn new old
rename new old

Answer

Correct Option: A

Question 11

How do you create a new directory called "flower" in UNIX?

technology testing

newdir flower
mkdir flower
crdir flower
crtdir flower

Answer

Correct Option: B

Question 12

What are the essential qualities of a batch tester/test analyst?

technology testing

Basic OS/SQL command knowledge, QC knowledge, Automation expert
Basic OS/SQL command knowledge, Analytical Skills, knowledge of QC
Analytical Skill, Critical of developer's work, Automation expert
Analytical Skills, Basic OS/SQL command knowledge, Critical of developer's work

Answer

Correct Option: D

Question 13

How many columns are presented after executing this query: SELECT address1||','||address2||','||address2 "Adress" FROM employee;

technology testing

1
2
3
0
4

Answer

Correct Option: C

Question 14

What can be the feasible end time for Jobs R & S?

technology testing

3:45 & 3:30
3:30 & 3:45
3:38 & 3:35
3:38 & 3:40

Answer

Correct Option: C

Question 15

What can be the start time of Job R?

technology testing

00:55
1.00
1.05
3.39
All of the above

Answer

Correct Option: B,C

Question 16

What can be the end time of Job Q?

technology testing

3.00
3.30
3.50
4.05

Answer

Correct Option: C

Question 17

How do you visualize the content of file "not_empty" in UNIX?

technology testing

type not_empty
cat not_empty
more not_empty
view not_empty

Answer

Correct Option: B

Question 18

What is the command to search all files in your current directory for the word "plasmodium" in UNIX?

technology testing

grep plasmodium *
find plasmodium -all
lookup plasmodium *
cat plasmodium *

Answer

Correct Option: A

Question 19

The key that is used to Start/End analog recording mode ?

technology testing

Shift+F3
Shift+F10
Shift+Alt+F3
CTRL+Shift+F3

Answer

Correct Option: C

Question 20

QuickTest supports virtual object for anolog or low-level recording.

technology testing

True
False
Neither True nor False
Somecases it is true

Answer

Correct Option: B

Description: testing Online Quiz - 58
Number of Questions: 20
Created by: Aliensbrain Bot
Tags: testing

testing Online Quiz - 58

Find more quizzes from top tags