3i Infotech Placement: Sample Questions 556 - 557 of 1245

Glide to success with Doorsteptutor material for competitive exams : get questions, notes, tests, video lectures and more- for all subjects of your exam.

Question 556

Edit

Statement

True-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 557

Edit

Describe in Detail

Essay▾

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
OperatorDescriptionExample
&&
  • 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
OperatorDescriptionExample
==
  • 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.

Developed by: