Bissoy.com
Doctors Medicines MCQs Q&A

Related Questions

Assuming Z and Y are the two control variables, the following are the constraints laid out for maximizing the profit: Maximize profit (P) = 8X – 5Y Subject to Constraint-1: 2X + Y ≤ 1000 Constraint-2: 3X + 4Y ≤ 2400 Constraint-3: X + Y ≤ 800 Constraint-4: X – Y ≤ 350 Constraint-5: X ≥ 0 Constraint-6: Y ≥ 0 Which of the above constraints is a redundant one and does not have any effect on the solution?
In SQL, the NOT NULL constraint can be written as a table level constraint.
A company paid Rs. 6,00,000 as bonus to its employees at different levels A, B and C. Each employee at level A receives one and half times of the amount that was paid to each employee at level B and each employee at level B was paid twice the amount paid to the employee at level C. If 50 employees were on level A, 75 on level B and 100 on level C, how much amount was paid to each employee of level A ?
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 table T containing two columns X and Y each of type integers. After the creation of the table, one record (X= 1, Y=l) is inserted in the table. Let MX and MY denote the respective maximum values of X and Y among all records in the table at any point in time. Using M X and MY, new records are inserted in the table 128 times with X and Y values being MX + 1, 2*MY + 1 respectively. It may be noted that each time after the insertion, values of MX and MY change. What will be the output of the following SQL query after the steps mentioned above are carried out? SELECT Y FROM T WHERE X=7;
In SQL, which of the following constraint cannot be applied at the table level?
In SQL, the PRIMARY KEY constraint can be defined while creating a table and also while altering the table’s structure.
When they had a meeting seven company executives __ T, U, V, W, X, Y and Z ___ sit at a rectangular table .Three executives sit along one side of the table , and three sit along the other side, each directly opposite one of the other three. The seventh sits at the head of the table . There is no seat at the foot of the table . Ualways sits in one of te two seats farthest from the head of the table. Y and V always sit next to each other .V never sits next to Z . If Z does not sit at the head of the table, W sits there. If W sits directly opposite T, X must sit next to which of the following excutives?
Two particles of equal masses are connected by an inextensible string of length L. One of the masses is constrained to moves on the surface of a horizontal table. The string passes through a small hole in the table and the other mass is hanging below the table. The only constraint is that the first mass moves on the surface of the table. The number of degree of freedom of the masses string system is
In the following SQL query, what does "person_id" stands for?
CREATE TABLE person(person_ id SMALLINT UNSIGNED,fname VARCHAR(20),lname VARCHAR(20),CONSTRAINT pk_person PRIMARY KEY (person_id));