Bissoy.com
Doctors Medicines MCQs Q&A

Related Questions

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?
Consider a database that has the relation schemas EMP(EmpId, EmpName, DeptId), and DEPT(DeptName, DeptId) Note that the deptId can be permitted to be NULL in the relation EMP. Consider the following queries on the database expressed in tuple relational calculus. (I) { t |∃u ∈ EMP(tEmpName] = u[EmpName] ∧ ∀ v∈ DEPT(t[DeptId] ≠ v[DeptId]))} (II) {t |∃ u ∈ EMP(t[EmpName] = u[EmpName] ∧ ∃ v ∈ DEPT(t[DeptId] ≠ v[DeptId]))} (III) {t | ∃ u∈ EMP(t[EmpName] = u[EmpName] ∧ ∃ v ∈ DEPT(t[DeptId] = v[DeptId]))} Which of the above queries are safe?
What represents a 'tuple' in a relational database?
In relational database schema each tuple is divided into fields known as?
Which of the following represents a query in the tuple relational calculus?
Consider the following three relations in a relational database. Employee(eId, Name), Brand(bId, bName), Own(eId, bId) Which of the following relational algebra expressions return the set of eIds who own all the brands? 
In the following figure, square represents the people who use the product of Colorbar, the triangle represents the people who use products of NYX, the circle represents people who use products of M.A.C., the rectangle represents people who use products of Maybelline and semi-circle represents the people who use the products of Lakme. Which set of letter(s) represents people who use more than one product?
In the following figure, square represents the people who use the product of Colorbar, the triangle represents the people who use products of NYX, the circle represents people who use products of M.A.C., the rectangle represents people who use products of Maybelline and semi-circle represents the people who use the products of Lakme. Which set of letter(s) represents people who use products of M.A.C. and NYX only?
In the following figure, square represents the people who use the product of Colorbar, the triangle represents the people who use products of NYX, the circle represents people who use products of M.A.C., the rectangle represents people who use products of Maybelline and semi-circle represents the people who use the products of Lakme. Which set of letters represents people who use only products of Colorbar?
The values appearing in given attributes of any tuple in the referencing relation must likewise occur in specified attributes of at least one tuple in the referenced relation, according to _____________________ integrity constraint.