Databases | SQL | Oracle | MS Access Answers

. What are the two extremes for technical architecture design? Which one is

better?

Explain in detail the concept of modeling the Business Data Warehousing 

(BDW)?

Ali is an IT expert working as a Database Administrator in an IT industry from 5 years.

He has 7 years aggregate experience of creating and managing the database. At the same time,

Ahmed is also working in same company as a Database Administrator but he can only insert and

can view the data, all other operation including creating, managing, applying different constraint

on data will be performed by Ali. Ali has created a database and that database has 100 tables.

There is a one table named EMPLOYEE which is empty and has no single record in that table.

Ahmed is trying to insert the record in that table but he is unable to insert the record in mentioned

table.

Now, in the light of database administration explain with suitable examples that why the record

is not inserted in employee table?

QUESTION 35

Which one of the following statements regarding operations on relations in a database is 

FALSE?

1. The difference operation is applied to two relations that do not necessarily have the same 

attributes.

2. The difference between the join and union operations is that with the join operation the two 

relations are combined based on common attributes, while with the union operation, the two 

relations must have exactly the same attributes.

3. The project operation creates another relation in which each tuple in the resulting relation has 

fewer attributes than the corresponding tuple in the original relation.

4. The intersection operation creates a new relation from two relations with the same attributes, 

where the new relation contains tuples which are members of both original relations.

QUESTION 33

In the ____________ database model, the entities are organised in a graph, in which some 

entities can be accessed through several paths.

1. network

2. distributed

3. relational

4. hierarchical 

QUESTION 34

Which one of the following operations is not a unary operation on a relational database?

1. Update

2. Select

3. Extract

4. Project

how can we load data from excel file into table through sql loader tool

How many times each user has engaged with the videos of "News for you" channel (id = 366).

Note:

• Consider engagement as LIKE or DISLIKE for a video uploaded by News for you channel.
• Ignore the users who did not engage with the channel at least once.
• Sort the output in the descending order of no_of_reactions, and then in the ascending order of user_id.

In subquries method

In the context of OODBMS, define the following with appropriate examples.

I) Object Class

II) Abstract Class

Describe the key characteristics of data warehouse and how it differs in content, structure and function from online transaction processing(OLTP). Support your answer with suitable diagrams and examples

Get all the distinct user_ids who liked at least one video uploaded by Android Authority channel (channel_id=364) but didn't like the video uploaded by Tech savvy channel with video_id =1005.

Note : consider reaction_type as liked

Sort the output in the ascending order of user_id by using subquries