Jobs By Abekus

It is not possible to drop multiple tables in the same statement.

1

TRUE

2

FALSE

Solution:

What represents a ‘tuple’ in a relational database?

1

Table

2

Row

3

Column

4

Object

Solution:

Which Clause is used to select a particular table in Mysql?

1

WHERE

2

FROM

3

SELECT

4

ALTER

Solution:

Which storage engine in MySQL provides foreign key support?

1

TRANSACTION

2

InnoDB

3

MyISAM

4

MEMORY

Solution:

Which search mode uses natural language search as a subroutine?

1

Natural Language

2

Boolean Mode

3

Query expansion

4

Cross mode

Solution:

What is the meaning of “REFERENCES” in table definition?

1

Primary Key

2

NULL

3

Foreign Key

4

a "foreign key" belong to this particular table

Solution:

Suppose a stored function named PI() is written in the database ‘sampledb’. How would it be called?

1

PI

2

sampledb.PI()

3

MySQL.PI()

4

database.PI()

Solution:

In the following query, what does “person” stands for:

INSERT INTO person (person_id, fname, lname) VALUES (1,’S’,’P’);

1

Composite attributes

2

Multivalued attributes

3

Table name

4

None of the mentioned

Solution:

What will be the result of the query given below?

SELECT emp_id, ‘ACTIVE’ STATUS, emp_id * 3.14 emp_pi, UPPER (lname) last_name FROM employee;

1

emp_id, ACTIVE, emp_id * 314, UPPER(lname)

2

emp_id, Status, emp_pi, last_name

3

Error

4

None of the mentioned

Solution:

What will be the output of the query given below?

SELECT emp_id, fname, lname FROM employee WHERE title=’HEAD TELLER’ AND start_date=2008-11-24;

1

All columns

2

Only those columns which are mention with “SELECT” clause

3

Columns mention with “SELECT” clause and only those rows which contain ‘HEAD TELLER’ as a “title” and start_date as 2008-11-24

4

None of the mentioned

Mysql Questions Set 9:

It is not possible to drop multiple tables in the same statement.

Solution:

What represents a ‘tuple’ in a relational database?

Solution:

Which Clause is used to select a particular table in Mysql?

Solution:

Which storage engine in MySQL provides foreign key support?

Solution:

Which search mode uses natural language search as a subroutine?

Solution:

What is the meaning of “REFERENCES” in table definition?

Solution:

Suppose a stored function named PI() is written in the database ‘sampledb’. How would it be called?

Solution:

In the following query, what does “person” stands for:

INSERT INTO person (person_id, fname, lname) VALUES (1,’S’,’P’);

Solution:

What will be the result of the query given below?

SELECT emp_id, ‘ACTIVE’ STATUS, emp_id * 3.14 emp_pi, UPPER (lname) last_name FROM employee;

Solution:

What will be the output of the query given below?

SELECT emp_id, fname, lname FROM employee WHERE title=’HEAD TELLER’ AND start_date=2008-11-24;

Solution:

Related Question Sets:

Related Topics:

Mysql Questions Set 9:

It is not possible to drop multiple tables in the same statement.

Solution:

What represents a ‘tuple’ in a relational database?

Solution:

Which Clause is used to select a particular table in Mysql?

Solution:

Which storage engine in MySQL provides foreign key support?

Solution:

Which search mode uses natural language search as a subroutine?

Solution:

What is the meaning of “REFERENCES” in table definition?

Solution:

Suppose a stored function named PI() is written in the database ‘sampledb’. How would it be called?

Solution:

In the following query, what does “person” stands for: INSERT INTO person (person_id, fname, lname) VALUES (1,’S’,’P’);

Solution:

What will be the result of the query given below? SELECT emp_id, ‘ACTIVE’ STATUS, emp_id * 3.14 emp_pi, UPPER (lname) last_name FROM employee;

Solution:

What will be the output of the query given below? SELECT emp_id, fname, lname FROM employee WHERE title=’HEAD TELLER’ AND start_date=2008-11-24;

Solution:

Related Question Sets:

Related Topics:

In the following query, what does “person” stands for:

INSERT INTO person (person_id, fname, lname) VALUES (1,’S’,’P’);

What will be the result of the query given below?

SELECT emp_id, ‘ACTIVE’ STATUS, emp_id * 3.14 emp_pi, UPPER (lname) last_name FROM employee;

What will be the output of the query given below?

SELECT emp_id, fname, lname FROM employee WHERE title=’HEAD TELLER’ AND start_date=2008-11-24;