Tag: technology

Questions Related to technology

In a Join, when is the ON clause required?
technology databases

  1. If the Join is a SELF JOIN.

  2. Only if the WHERE clause is not used.

  3. If the keyword INNER is specified.

  4. all the time.

Show answer
Correct Option: C

What is the result of the following SQL statement? SELECT INDEX (SUBSTRING ('RALPH JOHNSON' FROM 6 FOR 5), 'OHN');
technology databases

  1. 3

  2. 5

  3. 6

  4. 2

Show answer
Correct Option: A

Which type of table provides the DDL, but does not share the data
technology databases

  1. Global Temporary

  2. Permanent

  3. Derived

  4. Volatile

Show answer
Correct Option: A

Which is the top most file system in the file system hierarchy?
technology operating systems

  1. /boot

  2. /bin

  3. /

  4. /etc

Show answer
Correct Option: C

From the below which one is not a file system in unix ?
technology operating systems

  1. iso9660

  2. proc

  3. FFS

  4. MFS

Show answer
Correct Option: D

Which file system holds add-on application software packages
technology operating systems

  1. /sbin

  2. /opt

  3. /mnt

  4. /dev

Show answer
Correct Option: B

What is the command used to repair the file systems?
technology operating systems

  1. rpfs

  2. fsck

  3. fsrp

  4. repair

Show answer
Correct Option: B

Which commands do the same thing?
technology databases

  1. HAVING and GROUP BY

  2. HAVING and QUALIFY

  3. QUALIFY and QUANTIFY

  4. QUALIFY and ORDER BY

Show answer
Correct Option: B

Which operator works like an OUTER JOIN?
technology databases

  1. Minus

  2. Except

  3. Intersect

  4. Union

Show answer
Correct Option: D

Which file contains information about currently mounted file systems ...
technology operating systems

  1. /etc/inittab

  2. /etc/filesystems

  3. /etc/mtab

  4. /etc/fstab

Show answer
Correct Option: C