3i Infotech Papers: Sample Questions 481 - 483 of 1245

Examrace Placement Series prepares you for the toughest placement exams to top companies.

Question number: 481

» Database » MySQL

Essay Question▾

Describe in Detail

How do you communicate with an RDBMS?

Explanation

Structure of a relational database.

Structure of a Relational Database.

Structure of a relational database.

  • You can communicate RDBMS by structural query language (SQL).

  • The SQL is used for inserting/modifying/deleting & retrieving data from Database.

  • You can also use SQL for Access controls & Administration.

  • SQL is classified into three categories, those categories are listed below.

Question number: 482

» Languages » C & C Plus Plus

Essay Question▾

Describe in Detail

What is the output of the following program?

  1. #define FALSE-1
  2. #define TRUE 1
  3. #define NULL 0
  4. main ()
  5. {
  6.     if (NULL)
  7.     puts ( “NULL” );
  8.     else
  9.     if (FALSE)
  10.     puts ( “TRUE” );
  11.     else
  12.     puts ( “FALSE” );
  13. }

Explanation

  • The input program sent to the compiler after processing by thepreprocessor is, main () {if (0) puts (“NULL”); else if (-1) puts (“TRUE”); elseputs (“FALSE”); }

  • Preprocessor does not replace the values given inside thedouble quotes.

Table shows the program

Table shows the program

if (NULL)

puts (“NULL”);

If condition is boolean false so it goes to else.

else

if (FALSE)

puts (“TRUE”);

In second if -1 is Boolean value true hence “TRUE” is printed.

Question number: 483

» Database » MySQL

Essay Question▾

Describe in Detail

What is SQL * Loader?

Explanation

Image of the SQL loader

Image of the SQL Loader

Image of the SQL loader

  • SQL * loader is one of the Oracle tool which will be used to transfer the data from Flat-File to oracle Database table.

  • It has a powerful data-parsing engine that puts little limitation on the format of the data in the data file.

Use of SQL * Loader

  • Load data across a network if your data files are on a different system than the database.

  • Load data from multiple data files during the same load session.

  • Load data into multiple tables during the same load session.

  • Specify the character set of the data.

  • Selectively load data (you can load records based on the records’ values).

  • Manipulate the data before loading it, using SQL functions.

  • Generate unique sequential key values in specified columns.

  • Use the operating system’s file system to access the data files.

  • Load data from disk, tape, or named pipe.

  • Generate sophisticated error reports, which greatly aid troubleshooting.

  • Load arbitrarily complex object-relational data.

  • Use secondary data files for loading LOBs and collections.