How do you get help about the command "cp" in UNIX?
help cp
man cp
cp ?
all of the above
The SQL command used to avoid the selection of duplicate rows is
UNIQUE
DISTINCT
EXCLUSIVE
DISCRETE
How do you change the current directory to /usr/local/bin in UNIX?
mv /usr/local/bin
cd /usr/local/bin
setdir /usr/localbin
cd usr/local/bin
How do you list all the files that are in the current directory in UNIX?
list all
ls -full
ls -a
ls -all
Which of the following is not a valid -ve testing scenario for a job involving data load from a flat file to database table.
Data file not present
Data file too large
Table is accessible to the user
Data in wrong format
Which command will delete all data from a table and will not write to the rollback segment?
DROP
DELETE
CASCADE
TRUNCATE
Which of the following is/are NOT a typical characteristic of a batch run? select all that apply- multiple answers)
It produces a log file
It take data from a text file
It takes some input and produces output
It is run in backend
Which character function can be used to return a specified portion of a character string?
INSTR
SUBSTRING
SUBSTR
POS
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;
03-JUL-00
10-JUL-00
12-JUL-00
11-JUL-00
17-JUL-00
09-JUL-00
How do you print the first 15 lines of all files ending by ".txt" in UNIX?
print 15 .txt
cat *.txt -length=15
head -15 *.txt
tail -15 *.txt