Database Administration Questions

FIND_GROUP(function) FIND_COLUMN(function)

Canvas views are the back ground objects on which you place the interface items (Text items), check boxes, radio groups etc.,) and boilerplate objects (boxes, lines, images etc.,) that operators interact with us they run your form . Each canvas views displayed in a window.

The Bulk Copy Program (BCP) is a command-line utility that ships with Microsoft SQL Server. It is a tool used to duplicate enormous quantity of information from tables and views. It does not facsimile the structures same as foundation to target.
BULK INSERT command helps to bring in a data folder into a record, table or view in a user-specific arrangement. With BCP, you can import and export large amounts of data in and out of SQL Server databases quickly and easily. Any DBA who has utilized this functionality will agree that BCP is an essential tool.

An user account is not a physical structure in Database but it is having important relationship to the objects in the database and will be having certain privileges. 95. When will the data in the snapshot log be used? - We must be able to create a after row trigger on table (i.e., it should be not be already available) After giving table privileges. We cannot specify snapshot log name because oracle uses the name of the master table in the name of the database objects that support its snapshot log. The master table name should be less than or equal to 23 characters. (The table name created will be MLOGS_tablename, and trigger name will be TLOGS name).

UPDATE and DELETE Restrict - A referential integrity rule that disallows the update or deletion of referenced data. DELETE Cascade - When a referenced row is deleted all associated dependent rows are deleted.

Use the DBMS_SESSION.SET_SQL_TRACE or

Use ALTER SESSION SET SQL_TRACE = TRUE;

A DBA is a Database Administrator, and this is the most common job that you find a database specialist doing. There are Development DBAs and Production DBAs.

- A Development DBA usually works closely with a team of developers and gets more involved in design decisions, giving advice on performance and writing good SQL.

  That can be satisfying at a human level because you are part of a team and you share the satisfaction of the teams accomplishments.

- A Production DBA (on the other hand) is responsible for maintaining Databases within an organization, so it is a very difficult and demanding job. He or she, often gets involved when all the design decisions have been made, and has simply to keep things up and running.

  Therefore, of course, it is also a rewarding job, both financially and in terms of job satisfaction. But it is a more "lonely" job than being a Development DBA.

. 

A Control file records the physical structure of the database. It contains the following information. Database Name ,Names and locations of a database’s files and redolog files. Time stamp of database creation.