In a Join, when is the ON clause required?
If the Join is a SELF JOIN.
Only if the WHERE clause is not used.
If the keyword INNER is specified.
all the time.
What is the result of the following SQL statement? SELECT INDEX (SUBSTRING ('RALPH JOHNSON' FROM 6 FOR 5), 'OHN');
3
5
6
2
Which type of table provides the DDL, but does not share the data
Global Temporary
Permanent
Derived
Volatile
Which is the top most file system in the file system hierarchy?
/boot
/bin
/
/etc
From the below which one is not a file system in unix ?
iso9660
proc
FFS
MFS
Which file system holds add-on application software packages
/sbin
/opt
/mnt
/dev
What is the command used to repair the file systems?
rpfs
fsck
fsrp
repair
Which commands do the same thing?
HAVING and GROUP BY
HAVING and QUALIFY
QUALIFY and QUANTIFY
QUALIFY and ORDER BY
Which operator works like an OUTER JOIN?
Minus
Except
Intersect
Union
Which file contains information about currently mounted file systems ...
/etc/inittab
/etc/filesystems
/etc/mtab
/etc/fstab