MySQL Database Management System

1

What is output by the SQL below?
DROP TABLE IF EXISTS foo;
CREATE TABLE foo (a INT, b INT, c INT);
INSERT INTO foo VALUES (1,2,3);
INSERT INTO foo SELECT * FROM foo;
INSERT INTO foo SELECT * FROM foo;
SELECT sum(b) FROM foo;

1

The relationship between DEPARTMENT and EMPLOYEE is a

1

Which of the following terms does refer to the correctness and completeness of the data in a database?

1

Which of these field types would be best to hold a .jpg image?

1

The result of a SQL SELECT statement is a(n) ________ .

1

To remove duplicate rows from the results of an SQL SELECT statement, the ________ qualifier specified must be included.

1

What’s the default port for MySQL Server?

1

What is an index?

1

What is a view?

1

The difference between the DELETE and TRUNCATE SQL clauses is:

1

Which of the following statements gets the total value of the column 'Price' in the 'Sales' table?

1

A trigger belongs to...

1

A collection of related fields is called a:

1

Also known as online, this type of processing occurs at the same time as the transaction occurs.

1

Which of the following is correct:

1

The language used in application programs to request data from the DBMS is referred to as the

1

To delete a particular column in a relation the command used is:

1

_________ is a virtual table that draws its data from the result of an SQL SELECT statement.

1

A relational database contains two tables student and department.
Student table has columns (roll_no, name and dept_id )and Department table has columns (dept-id and dept-name).
Department table has 3 records and Student table has 2 records.
How many rows and columns will be retrived by the following SQL, statement?
Select * from student, department;

1

E-R model uses this symbol to represent weak entity set ?

1

Relational Algebra is

1

Key to represent relationship between tables is called

1

The conceptual model is

1

The RDBMS terminology for a row is

1

A set of possible data values is called

1

In E-R Diagram derived attribute are represented by

1

The default parameter type in stored procedures is

1

Consider a table OLD with few rows. The statement CREATE TABLE new AS SELECT * FROM OLD WHERE 1=2

1

Choose the correct pattern Matching sign for matching a single character

1

Rollback and Commit affect

1

What is the order of execution of SQL clauses
1. having 2. group by 3. where 4. orderby

ThirdYear Third Year Quiz on MySQL Database Management System, created by Faheem Ahmed on 26/03/2018.

MySQL Database Management System

What is output by the SQL below? DROP TABLE IF EXISTS foo; CREATE TABLE foo (a INT, b INT, c INT); INSERT INTO foo VALUES (1,2,3); INSERT INTO foo SELECT * FROM foo; INSERT INTO foo SELECT * FROM foo; SELECT sum(b) FROM foo;

The relationship between DEPARTMENT and EMPLOYEE is a

Which of the following terms does refer to the correctness and completeness of the data in a database?

Which of these field types would be best to hold a .jpg image?

The result of a SQL SELECT statement is a(n) ________ .

To remove duplicate rows from the results of an SQL SELECT statement, the ________ qualifier specified must be included.

What’s the default port for MySQL Server?

What is an index?

What is a view?

The difference between the DELETE and TRUNCATE SQL clauses is:

Which of the following statements gets the total value of the column 'Price' in the 'Sales' table?

A trigger belongs to...

A collection of related fields is called a:

Also known as online, this type of processing occurs at the same time as the transaction occurs.

Which of the following is correct:

The language used in application programs to request data from the DBMS is referred to as the

To delete a particular column in a relation the command used is:

_________ is a virtual table that draws its data from the result of an SQL SELECT statement.

E-R model uses this symbol to represent weak entity set ?

What is output by the SQL below?
DROP TABLE IF EXISTS foo;
CREATE TABLE foo (a INT, b INT, c INT);
INSERT INTO foo VALUES (1,2,3);
INSERT INTO foo SELECT * FROM foo;
INSERT INTO foo SELECT * FROM foo;
SELECT sum(b) FROM foo;

What is the order of execution of SQL clauses
1. having 2. group by 3. where 4. orderby