Searching for "RDBMS"

Q:

What is RDBMS? Explain its features.

Answer

RDBMS is a database management system based on relational model defined by E.F.Codd. Data is stored in the form of rows and columns. The relations among tables are also stored in the form of the table.

Features:
- Provides data to be stored in tables
- Persists data in the form of rows and columns
- Provides facility primary key, to uniquely identify the rows
- Creates indexes for quicker data retrieval
- Provides a virtual table creation in which sensitive data can be stored and simplified query can be applied.(views)
- Sharing a common column in two or more tables(primary key and foreign key)
- Provides multi user accessibility that can be controlled by individual users

Report Error

View answer Workspace Report Error Discuss

Subject: Oracle

Q:

You are the administrator of a SQL Server 2000 computer. Your company uses the server to store service contract information for its customers. You are also the administrator of an Oracle relational database management system (RDBMS) server. This server is used to store your company's financial information. The financial information is updated frequently throughout the day.You need to create a series of reports that combine the service contract information and the financial information. These reports will be updated several times a day.You want to create these reports on the SQL Server computer by using the minimum amount of disk space. What should you do?

A) Set up SQL Server replication to replicate the data from the Oracle server to the SQL Server computer. B) Set up the Oracle server as a linked server. Create a view that joins the service contract information and the financial information.
C) Set up a Microsoft ActiveX script that connects to the Oracle server and imports the financial information into a SQL Server temporary table. Create a view that joins the service contract information and the temporary table. D) Set up a Data Transformation Services (DTS) package that imports and transforms the data from the Oracle server to the SQL Server computer. Use SQL Server Agent to execute the DTS package throughout the day as needed.
 
Answer & Explanation Answer: B) Set up the Oracle server as a linked server. Create a view that joins the service contract information and the financial information.

Explanation:

SQL Server 2000 permits the creation of links to OLE DB data sources called linked servers. After linking to an OLE DB data source, it is possible to reference rowsets from the OLE DB data sources as tables in Transact-SQL statements and to pass commands to the OLE DB data sources and include the resulting rowsets as tables in Transact-SQL statements. Each distributed query can reference multiple linked servers and can perform either update or read operations against each individual linked server. A single distributed query can perform read operations against some linked servers and update operations against other linked servers. The Microsoft OLE DB Provider for Oracle allows distributed queries to query data in Oracle databases.

Report Error

View Answer Report Error Discuss

Q:

In RDBMS, what is the efficient data structure used in the internal storage representation?

A) Stack B) Queue
C) B+ tree structure D) AVL tree Structure
 
Answer & Explanation Answer: C) B+ tree structure

Explanation:

B+ tree. Because in B+ tree, all the data is stored only in leaf nodes, that makes searching easier. This corresponds to the records that shall be stored in leaf nodes

Report Error

View Answer Report Error Discuss

Filed Under: Java