Skip to main content

Posts

Showing posts from May, 2020

RDBMS(relational database management system) Quiz

RDMS (Relational Database Management System) Index => RDMS (Relational Database Management System) Quiz Show all questions <=   => _________converts the value of a character data-type into NUMBER type. ?   TO_NUMBER() ?   TO_CHAR( ) ?   TO_DATE( ) _________function converts the value of ‘NUMBER’ data-type into character type. ?   TO_NUMBER() ?   TO_CHAR( ) ?   TO_DATE( ) TO_CHAR( [, ]) this syntax applies to which function. ?   TO_NUMBER() ?   TO_DATE( ) ?   TO_CHAR( ) , Number Conversion ?   TO_CHAR( ) , Date Conversion The default format of ‘DATE’ type in Oracle is HH:MM:SS, DD- MON-YY. ?   True ?   TO_DATE( ) ?   TO_CHAR( ) , Number Conversion ?   TO_CHAR( ) , Date Conversion This function return the next date after given date value for a day of the week ?   LAST_DAY( ) ?   NEXT_DAY( ) ?   ADD_MONTHS( ) In order to further filter the grouped rows of a table the condition can