Database-Oracle [3i Infotech Placement]: Sample Questions 100 - 101 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 100

Oracle

Question

MCQ▾

Find the ODD one out of the following

Choices

Choice (4)

a.

FETCH

b.

CLOSE

c.

OPEN

d.

INSERT

Answer

d.

Explanation

  • “Insert” is the ODD one out, others do not change the table

INSERT Statement

  • Adds one or more new rows of data to a database table.
  • Must have the INSERT object privilege on the view.
  • Inserts data into a table, partition, or view in two ways:
    • Conventional INSERT
    • Direct-path INSERT
  • If we exclude a column from the INSERT statement, then column list is mandatory because database needs to match the value to the columns.
  • We can have multiple direct-path INSERT statements in a single transaction, with or without other DML statements.

Question 101

Oracle
Edit

Describe in Detail

Essay▾

Name the three major set of files on disk that compose a database in Oracle.

Explanation

  • Three major sets of files on disk that compose a database.
    • Database files
    • Control files
    • Redo logs
  • The most important of these are the database files where the actual data resides.
  • The control files and the redo logs support the functioning of the architecture itself.
  • All three sets of files must be present, open, and available to Oracle for any data on the database to be useable.
  • Without these files, you cannot access the database, and the database administrator might have to recover some or all of the database using a backup, if there is one.

Developed by: