3i Infotech Papers: Sample Questions 726 - 727 of 1245

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

Question number: 726

» Database » Oracle

MCQ▾

Question

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

Choices

Choice (4) Response

a.

Simulates a One-dimensional array of unlimited size

b.

Can contain any no of columns

c.

Column datatype of any Scalar type

d.

Question does not provide sufficient data or is vague

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 number: 727

» Database » Oracle

MCQ▾

Question

We can create SNAPSHOTLOG for….

Choices

Choice (4) Response

a.

Complex snapshots

b.

Simple snapshots

c.

None of the above

d.

Question does not provide sufficient data or is vague

Answer

b.

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.