Database [3i Infotech Placement]: Sample Questions 120 - 121 of 294

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

Question 120

Database

Question

MCQ▾

A set of Dictionary tables are created … .

Choices

Choice (4)

a.

Every time a user is created

b.

Once for the Entire Database

c.

Every time a Tablespace is created

d.

Question does not provide sufficient data or is vague

Answer

b.

Explanation

  • The most important parts of an oracle database is its data dictionary, which is a read-only set of tables
  • Provides information about the database.

    Data Dictionary Contains

    • The definitions of all schema objects in the database.
    • Space allocated for currently used schema objects
    • Default values for columns
    • Integrity constraint information
    • The names of oracle users
    • Privileges and roles each user has been granted
    • Auditing information
    • Other general database information

A set of Dictionary tables are created once for the entire database.

Question 121

Database

Question

MCQ▾

Dedicated server configuration is

Choices

Choice (4)

a.

Many server processes - One user process

b.

One server process - One user process

c.

One server process - Many user processes

d.

Many server processes - Many user processes

Answer

b.

Explanation

Diagrams of Dedicated Server Configration
  • Dedicated server configuration is one server process - one user process.
  • Here users have the ability to implement their own server configuration and modify and upgrade as needed.

Developed by: