Database Administration Questions

Q:

The database schema is written in

A) DDL B) HLL
C) DCL D) DML
 
Answer & Explanation Answer: A) DDL

Explanation:

The database schema is written in DDL. A data definition language or data description language (DDL) is a syntax similar to a computer programming language for defining data structures, especially database schemas.

Report Error

View Answer Report Error Discuss

3 5867
Q:

What is BCP ? When is it used ?

Answer

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.

Report Error

View answer Workspace Report Error Discuss

3 1320
Q:

Give the sequence of execution of the various report triggers?

Answer

Before form , After form , Before report, Between page, After report.

Report Error

View answer Workspace Report Error Discuss

2 1514
Q:

A table is classified as a parent table and you want to drop and re-create it. How would you do this without affecting the children tables?

Answer

Disable the foreign key constraint to the parent, drop the table, re-create the table, enable the foreign key constraint.

Report Error

View answer Workspace Report Error Discuss

1 1809
Q:

What is WHEN-Database-record trigger?

Answer

Fires when oracle forms first marks a record as an insert or an update. The trigger fires as soon as oracle forms determines through validation that the record should be processed by the next post or commit as an insert or update. Generally occurs only when the operators modifies the first item in the record, and after the operator attempts to navigate out of the item.

Report Error

View answer Workspace Report Error Discuss

1 2681
Q:

What are the responsibilities of a Database Administrator?

Answer

- Installing and upgrading the Oracle Server and application tools.


- Allocating system storage and planning future storage requirements for the database system.


- Managing primary database structures (tablespaces)


- Managing primary objects (table, views, indexes)


- Enrolling users and maintaining system security.


- Ensuring compliance with Oracle license agreement


- Controlling and monitoring user access to the database.


- Monitoring and optimizing the performance of the database.


- Planning for backup and recovery of database information.


- Maintain archived data on tape


- Backing up and restoring the database.


- Contacting Oracle Corporation for technical support.

Report Error

View answer Workspace Report Error Discuss

0 1208
Q:

What is relation between the window and canvas views?

Answer

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.

Report Error

View answer Workspace Report Error Discuss

0 1322
Q:

What are the database administrators utilities available?

Answer

SQL * DBA - This allows DBA to monitor and control an ORACLE database. SQL * Loader - It loads data from standard operating system files (Flat files) into ORACLE database tables. Export (EXP) and Import (imp) utilities allow you to move existing data in ORACLE format to and from ORACLE database.

Report Error

View answer Workspace Report Error Discuss

0 1175