QUESTION NO: 1
Mysql> SELECT count (emp_no) FROM titles WHERE title = 'senior staff';
Mysql> SELECT count (emp_no) FROM titles WHERE title = 'senior staff';
Correct Answer: B
Vote an answer
QUESTION NO: 2
CREATE TABLE department (
Department_ID int unsigned NOT NULL auto_increment PRIMARY KEY,
Department _Name varchar(12) NOT NULL
) ENGINE=InnoDB
CREATE TABLE employee (
Employee_Number int unsigned NOT NULL PRIMARY KEY,
Employee_Name varchar(10) NOT NULL,
Department_ID int unsigned DEFAULT NULL,
FOREIGN KEY (Department ID) REFERENCES Department (Department_ID)
ON UPDATE SET NULL ON DELETE CASCADE
)ENGINE= InnoDB
Department
REPLACE INTO department (Department_ID, Department_Name) VALUES (1, 'Admin');
CREATE TABLE department (
Department_ID int unsigned NOT NULL auto_increment PRIMARY KEY,
Department _Name varchar(12) NOT NULL
) ENGINE=InnoDB
CREATE TABLE employee (
Employee_Number int unsigned NOT NULL PRIMARY KEY,
Employee_Name varchar(10) NOT NULL,
Department_ID int unsigned DEFAULT NULL,
FOREIGN KEY (Department ID) REFERENCES Department (Department_ID)
ON UPDATE SET NULL ON DELETE CASCADE
)ENGINE= InnoDB
Department
REPLACE INTO department (Department_ID, Department_Name) VALUES (1, 'Admin');
Correct Answer: A
Vote an answer
QUESTION NO: 3
Mysql>SELECT dept_no, emp_no FROM employees JOIN dept _manager USING(emp_no) WHERE dept_no'd004';
4 rows in set (0.00 sec)
Mysql>EXPLAIN SELECT dept_no, emp_no FROM employees JOIN dept_manager USING (emp_no) WHERE
dept_no='d004';
2 rows in set (0.00 sec)
Mysql>SELECT dept_no, emp_no FROM employees JOIN dept _manager USING(emp_no) WHERE dept_no'd004';
4 rows in set (0.00 sec)
Mysql>EXPLAIN SELECT dept_no, emp_no FROM employees JOIN dept_manager USING (emp_no) WHERE
dept_no='d004';
2 rows in set (0.00 sec)
Correct Answer: A,C
Vote an answer
QUESTION NO: 6
DESCRIBE CountryLanguage;
SELECT Isofficial, COUNT (Isofficial) FROM CountryLanguage GROUP BY Isofficial;
DESCRIBE CountryLanguage;
SELECT Isofficial, COUNT (Isofficial) FROM CountryLanguage GROUP BY Isofficial;
Correct Answer: B,F
Vote an answer
QUESTION NO: 7
Correct Answer: B,C,D
Vote an answer
Explanation: Only visible for Actual4test members. You can sign-up / login (it's free).
QUESTION NO: 8
Mysql> desc city:
5 rows in set (0.00 sec)
SELECT -,-, city. * FROM city LIMIT 1
Mysql> desc city:
5 rows in set (0.00 sec)
SELECT -,-, city. * FROM city LIMIT 1
Correct Answer: C
Vote an answer
QUESTION NO: 9
SELECT col1 FROM t1 WHERE col1 <=100 UNION
SELECT col1 FROM t1 WHERE col1 >=900 ORDER BY col1 DESC
SELECT col1 FROM t1 WHERE col1 <=100 UNION
SELECT col1 FROM t1 WHERE col1 >=900 ORDER BY col1 DESC
Correct Answer: D
Vote an answer
Explanation: Only visible for Actual4test members. You can sign-up / login (it's free).
QUESTION NO: 10
Correct Answer: A
Vote an answer
Explanation: Only visible for Actual4test members. You can sign-up / login (it's free).