3i Infotech Papers: Sample Questions 495 - 496 of 1245

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

Question number: 495

» Languages » C & C Plus Plus

Short Answer Question▾

Write in Short

  1. main ()
  2. {
  3.     printf ( “%x” -1<<4);
  4. }

Explanation

  • In a program They are asking to print (“%x” -1 < < 4);

  • Let’s take this answer given written the 1 in 16 bits

    0000 0000 0000 0001

  • -1 can be written in 2’s complement no system as

    1111 1111 1111 1111

  • ” < < ” this operator is called Binary Left Shift Operator, so we have to left shift four times the least significant 4 bits are filled with 0’s

    1111 1111 1111 0000

  • Here (1111 = F, 1111 = F, 1111, F0000 = 0)

  • So the Answer is FFF0

Question number: 496

» Database » Oracle

True-False▾

Question

Is the Following Statement True or False?

Multiple Tablespaces can share a single datafile

Answer

FALSE

Explanation

Understanding of data storage with table space

Understanding of Data Storage with Table Space

Understanding of data storage with table space

  • Tablespaces can however be split across multiple files- improve concurrency of multiple sort operation- reduce and avoid oracle database space management operation.

  • Tablespace can be assigned to users with the create user or alter user statement and shared by multiple users.

When a database has multiple tablespaces:

  • Separate user data from data dictionary data to reduce I/O contention.

  • Store the datafiles of different tablespaces on different disk drives to reduce I/O contention.

  • Take individual tablespaces offline while others remain online, providing better availability.

  • Back up individual tablespaces.

Advantages of multiple tablespace for a single application:

  • Deciding the space allocation of each tablespace

  • Managing what is created in which tablespace

  • Multiple tablespaces of similar size, promote parallelization.