Bissoy.com
Doctors Medicines MCQs Q&A

Related Questions

In the following MySQL command how many rows will be deleted?
DELETE personWHERE person_id<10;/*person_id is a primary key */
What is the meaning of "EMPTY SET" in the following MySQL command?
SELECT fname, lname, person_idFROM personWHERE lname=’s’;/* after Execution*/ Mysql tool RETURN EMPTY SET 0:00sec
In the following MySQL command how many rows will be updated?
UPDATE personSET lname=’s’,Fname=’p’,WHERE person_id<10;/* person_id is a primary key */
In the following MySQL command how many rows will be updated?
UPDATE personSET lname=’s’,Fname = ’p’,WHERE person_id = 1;/* person_id is a primary key */
Public key encryption uses multiple keys.ne key is used to encrypt data, while another is used to decrypt data.he key used to encrypt data is called the _______ key, while the key used to decrypt data is called the ________ key.
Given the following statements: S1: A foreign key declaration can always be replaced by an equivalent check assertion in SQL. S2: Given the table R (a, b, c) where a and b together form the primary key, the following is a valid table definition. CREATE TABLE S (                 a INTEGER,                 d INTEGER,                 e INTEGER,                 PRIMARY KEY (d)                 FOREIGN KEY (a) references R) Which one of the following statements is CORRECT?
When all the students in a school are made to stand in rows of 54, 30 such rows are formed. If the students are made to stand in rows of 45, how many such rows will be formed ?
The following MySQL statement belongs to which condition types?
SELECT fnameFROM personWHERE dept_id= (SELECT dept_id FROM department WHERE names=’s’);
The following MySQL query belongs to which condition types?
SELECT fnameFROM personWHERE title=’TELLER’;
The following MySQL statement belongs to which condition types?
SELECT fnameFROM personWHERE fed_id=’111-11-111’;