Database-Oracle [3i Infotech Placement]: Sample Questions 116 - 117 of 132

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

Question 116

Oracle

Question

MCQ▾

Which of the following is not correct about the “TABLE” datatype?

Choices

Choice (4)

a.

Simulates a One-dimensional array of unlimited size

b.

Can contain any no of columns

c.

Column datatype of any Scalar type

d.

All of the above

Answer

b.

Explanation

  • TABLE Data type is suitable for column-oriented or tabular data and is often stored as columns in a text file or in a spreadsheet.
  • Consist of rows and column-oriented variable.
  • TABLE combines different data types and size with the one restriction- all variables must have same number of rows.
  • TABLE datatype can contain any no of columns.
  • Represent a single entity to track within our system.

Designing Tables

  • Use name for table, column and cluster.
  • Table names, columns names can contain maximum of 30 characters and they should start with an alphabet.
  • The use of singular and plural forms of table name and columns.
  • Select the datatype for each column.
  • Arrange column that can contain NULL values in the last, to save storage space.

Question 117

Oracle

Question

MCQ▾

We can create SNAPSHOTLOG for … .

Choices

Choice (4)

a.

Simple snapshots

b.

Complex snapshots

c.

None of the above

d.

All of the above

Answer

a.

Explanation

  • We can create SNAPSHOTLOG for simple snapshot
  • A dump file is important to the master table, it already exists for the database which is imported as it has a snapshot log.
  • Stores in the same database as the table.
  • One master table stores only one snapshot log.

Developed by: