3i Infotech Papers: Sample Questions 440 - 441 of 1245

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

Question number: 440

» Database » Oracle

True-False▾

Question

Is the Following Statement True or False?

Data dictionary can span across multiple Tablespaces

Answer

FALSE

Explanation

  • Data dictionary cannot span multiple Tablespaces

  • The most important parts oracle database is its data directory

  • The data directory is a read-only set of table providing information about database

Data Directory Contains:

  • The definition of all objects in the database.

  • Default values for columns

  • Integrity constrain information

  • Privileges and roles each user granted

  • The data dictionary is structured in tables and views, like other database data.

  • All data directory table and view for a database that is store system tablespace.

  • SQL statement to access the data directory.

Tablespace

  • A table space is a logical group of data files in a database.

  • Indicate the database storage location, not the logical database structure or schema

  • Using table space admin can control the disk layout of an installation.

  • DB contains at least one table space and usually two or more.

  • Database program automatically create a table space- SYSTEM.

  • A table space is made one or more data files.

Question number: 441

» Languages » C & C Plus Plus

Essay Question▾

Describe in Detail

Explain following operators.

Logical operators

Relational operators

Conditional operators

Explanation

Logical operators

  • Supported by C language.
  • Assume variable A holds 1 and variable B holds)

Table showing the logical operators

Table showing the logical operators

Operator

Description

Example

&&

  • Called Logical AND operator.
  • If both the operands are non-zero, then the condition becomes true.

(A&&B) is false

||

  • Called Logical OR Operator.
  • If any of the two operands is non-zero, then the condition becomes true.

(A|| B) is true

!

  • Called Logical NOT Operator.
  • It is used to reverse the logical state of its operand. If a condition is true, then Logical NOT operator will make it false.

! (A&&B) is true.

Rational operator:

  • Assume variable A holds 10 and variable B holds 20

Table showing the rational operators

Table showing the rational operators

Operator

Description

Example

==

  • Checks if the values of two operands are equal or not.
  • If yes, then the condition becomes true.

(A==B) is not true

! =

  • Checks if the values of two operands are equal or not.
  • If the values are not equal, then the condition becomes true.

(A! =B) is true

>

  • Checks if the value of left operand is greater than the value of right operand.
  • If yes, then the condition becomes true.

(A > B) is not true

<

  • Checks if the value of left operand is less than the value of right operand.
  • If yes, then the condition becomes true.

(A < B) is true

> =

  • Checks if the value of left operand is greater than or equal to the value of right operand.
  • If yes, then the condition becomes true.

(A > =B) is not true

< =

  • Checks if the value of left operand is less than or equal to the value of right operand.
  • If yes, then the condition becomes true.

(A < =B) is true

Conditional Operators

  • Return one value if condition is true and returns another value is condition is false.
  • Also called ternary operator.
  • Syntax: (Condition? true_value: false_value);
  • Example: (A > 100? 0: 1);

If A is greater than 100,0 is returned else 1 is returned.

Equal to if else conditional statements.