Bissoy.com
Doctors Medicines MCQs Q&A

A relational database system needs to maintain data about the relations, such as the schema of the relations. This is called

A relational database system needs to maintain data about the relations, such as the schema of the relations. This is called Correct Answer Metadata

Each side of a platter of a disk has a read–write head that moves across the platter to access different tracks.

Related Questions

Consider the following four relational schemas. For each schema, all non-trivial functional dependencies are listed. The underlined attributes are the respective primary keys. Schema I: Field ‘courses’ is a set-valued attribute containing the set of courses a student has registered for. Non-trivial functional dependency: rollno → courses Schema II: Non-trivial functional dependencies: rollno, courseid → email email → rollno Schema III: Non-trivial functional dependencies: rollno, courseid → marks, grade marks → grade Schema IV: Non-trivial functional dependencies: rollno, courseid → credit courseid → credit Which one of the relational schemas above is in 3NF but not in BCNF?
Maslow's need-hierarchy theory of motivation has classified the human needs into five categories as follows. Arrange the following needs in ascending order given by Maslow
1. Safety needs
2. Esteem needs
3. Social needs
4. Physiological needs
5. Self-actualisation needs
What is the sequence of domtion of these needs?
Statement 1: We can create foreign key constraints on relational schema derived from ER diagram Statement 2: Relational schema cannot be derived from an ER diagram
In the hierarchical theory of Maslow, the needs are classified as 1. physiological needs 2. self - actualization needs 3. needs of belong 4. esteem needs 5. safety needs Which of the following is the correct sequence of the hierarchy of these needs from bottom to the top according to Maslow?
Which of the following is the correct order of human needs as formulated in Maslow's hierarchy of needs? a) Safety needs b) Love and belonging needs c) Physiological needs d) Self-actualisation needs e) Esteem needs Choose the most appropriate answer from the options given below:
A database of research articles in a journal uses the following schema. (VOLUME, NUMBER, STARTPAGE, ENDPAGE, TITLE, YEAR, PRICE) The primary key is (VOLUME, NUMBER, STARTPAGE, ENDPAGE) and the following functional dependencies exist in the schema. (VOLUME, NUMBER, STARTPAGE, ENDPAGE) → TITLE (VOLUME, NUMBER) → YEAR (VOLUME, NUMBER, STARTPAGE, ENDPAGE) → PRICE The database is redesigned to use the following schemas. (VOLUME, NUMBER, STARTPAGE, ENDPAGE, TITLE, PRICE) (VOLUME, NUMBER, YEAR) Which is the weakest normal form that the new database satisfies, but the old one does not?  
Arrange the elements of Maslow's hierarchy of needs according to their arrangement of importance starting from the bottom of hierarchy.
1. Need for positive self image and recognition
2. Needs related to security, money, workplace
3. Psychological needs and basic needs
4. Needs of realising one's potential, continued growth
5. Needs related to love, affection, belongingness, acceptance
You are the administrator of a SQL Server 2000 computer. The server contains a database named FinanceData that is used by a client/server application. Each employee has a SQL Server login that the application uses to access the server.Your company hires a new employee named Andrew. You create a SQL Server login named Andrew. You also create a database user named Andrew in the database and grant the database user full permissions in the database.Whenever Andrew runs the client/server application, he receives the following error message: "Invalid object name." Andrew also reports that he cannot access the database by using the application.You need to ensure that Andrew can use the application. Which Transact-SQL statement should you execute?
Which of the following statements are true?
Statement I Big data refers to no precise quantity, but generally refers to data in the range of Petabytes and Exabyte, i.e. billions to trillions of records, all from various sources. Big data is generated much faster. than traditional data in much larger quantities.
Statement II Big data interests industries because they are able to learn more patterns and curious variances than smaller data sets, with the capability to provide valuable insights into consumer behaviour, weather systems, financial market activity, or other phenomena.
Statement III Various departments and product lines use various applications within most organisations and store data in separate datasets. These separate databases may contain similar data, but data from one data base to another is not always consistent. This is called data silo.
You are an administrator of a SQL Server 2000 computer. The server contains a database that stores inventory data. Another database administrator has created a number of scheduled jobs to maintain the inventory database. Each weeknight the following jobs occur.
- A BULK INSERT job imports data at 10:00 P.M
- Indexes are rebuilt at 10:15 P.M
- Data integrity checks are performed at 10:30 P.M
- A differential backup is performed at 10:45 P.M
- A DBCC SHRINKDATABASE job runs at 11:00 P.M.
You notice that the final job often fails and returns the following error message: "Server: Msg 3140, Level 16, State 3. Could not adjust the space allocation for file 'inventory_data'."You need to ensure that the final job runs without errors. What should you do?