Bissoy.com
Doctors Medicines MCQs Q&A

Related Questions

Match the following with respect to RDBMS: A. Entity integrity 1. enforces some specific business rule that do not fall into entity or domain B. Domain integrity 2. Rows can’t be deleted which are used by other records C. Referential integrity 3. enforces valid entries for a column D. User defined integrity 4. No duplicate rows in a table
When building a database from an existing set of tables, we may safely assume that referential integrity constraints have been enforced on the data we are given.
Referential integrity can be enforced if both _______________ belong to the same Microsoft Access database.
Compare the following sentences: (1) He is a man of high professional integrity. (2) Our defense forces are determined to preserve our national Integrity. (3) His personal integrity is beyond question. Identify sentence (s) in which the word integrity implies the quality of honesty and strong moral principles.
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?
Referential integrity cannot be set for _______________ relationships.
You are the database administrator of a SQL Server 2000 computer. The server contains your company's Accounts database. Hundreds of users access the database each day.Because you have had power interruptions in the past, you want to protect the physical integrity of the Accounts database. You do not want to slow down server operations.What should you do?
Identify the correct option with reference to Software Quality Metrics. * (1 – security) b) Integrity = * (1 – security) c) Integrity = . d) Integrity = Sigma.
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?
The question below consists of a set of labelled sentences. These sentences, when properly sequenced form a coherent paragraph. Select the most logical order of sentences from among the options. P: This is the same whether you are at work or in your personal life. Q: Relationships are easy until there is an emotional turmoil. R: When you can change the interpretation in your mind of what you think you can change your emotions and shift the emotional quality of your relationships. S: When you can change the emotions in your relationships you open up entirely new possibilities in your life.