3i Infotech Placement: Sample Questions 681 - 682 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 681

Question

MCQ▾

SNAPSHOT is used for … .

Choices

Choice (4)

a.

System server

b.

Synonym

c.

Table space

d.

Dynamic data

Answer

d.

Explanation

  • Snapshot is used for dynamic data.
  • Staged copy of the data in a data store used in one or more processes.
  • The storage statement is mostly used to speedily create point-in-time of data- valid “backup solution” .

Use of Snapshots

  • Easy network loads:
    • To reduce network load- use snapshots to distribute corporate data.
    • Efficient batch process from a single master site.
  • Mass deployment:
    • Temples to quickly and easily use snapshot environments to support mass deployment.
  • Disconnecting computing:
    • One of the solutions for sales applications running on a laptop.
    • A developer can integrate the duplicate management API for refresh on-demand into the sales application.

Question 682

Edit

Describe in Detail

Essay▾

RDBMS file system can be defined as

Explanation

Understanding of RDBMS
  • In general a Database Management System (DMS) is a collection files and programs that allow users to access and modify data- providing convenient and efficient way to store, retrieve and modify information.
  • Application programs request DBMS to retrieve, modify, insert, delete data providing abstraction between the application programs and the file system.
  • Users interact with DBMS using structured query language.
  • Relational database management system is based on a relational database- RDBMS refers of the database program itself.
  • It is software that executes queries on the data, including adding, updating, and searching for values in a relational database.
  • RDMS also provided a visual representation of the data.
  • Relational database is one where data is organized in table.

Developed by: