Tag: testing

Questions Related to testing

How do you get help about the command "cp" in UNIX?
technology testing

  1. help cp

  2. man cp

  3. cp ?

  4. all of the above

Show answer
Correct Option: B

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

  1. UNIQUE

  2. DISTINCT

  3. EXCLUSIVE

  4. DISCRETE

Show answer
Correct Option: B

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

  1. mv /usr/local/bin

  2. cd /usr/local/bin

  3. setdir /usr/localbin

  4. cd usr/local/bin

Show answer
Correct Option: B

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

  1. list all

  2. ls -full

  3. ls -a

  4. ls -all

Show answer
Correct Option: C

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

  1. Data file not present

  2. Data file too large

  3. Table is accessible to the user

  4. Data in wrong format

Show answer
Correct Option: C

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

  1. DROP

  2. DELETE

  3. CASCADE

  4. TRUNCATE

Show answer
Correct Option: D

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

  1. It produces a log file

  2. It take data from a text file

  3. It takes some input and produces output

  4. It is run in backend

Show answer
Correct Option: B,C

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

  1. INSTR

  2. SUBSTRING

  3. SUBSTR

  4. POS

Show answer
Correct Option: C

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

  1. 03-JUL-00

  2. 10-JUL-00

  3. 12-JUL-00

  4. 11-JUL-00

  5. 17-JUL-00

  6. 09-JUL-00

Show answer
Correct Option: D

AI Explanation

To determine the answer, let's break down the given statement and understand how it works:

The statement NEXT_DAY(sysdate, 'MONDAY') returns the date of the next occurrence of the day specified, which in this case is 'MONDAY'.

So, when we execute the statement SELECT to_char(NEXT_DAY(sysdate, 'MONDAY'), 'DD-MON-RR') FROM dual;, it will return the date of the next Monday.

Given that today is Monday, 10 July 2000, the next Monday will be on 17 July 2000.

Therefore, the correct answer is E) 17-JUL-00.

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

  1. print 15 .txt

  2. cat *.txt -length=15

  3. head -15 *.txt

  4. tail -15 *.txt

Show answer
Correct Option: C