Database Design 4

Question 1

According to the next scenario try to identify 1 possible attribute: «A student has a large collection of music. Her music is stored in DVDs, CDs, Tapes, and Memory Sticks etc. All the various media in which music is stored is organized in a (physical) library. The library itself is organized into numbered columns and named shelves. The database should capture details of albums, songs, artists, production studios, prices and awards received, etc.»

Accepted Answer

Price

Answer

Artist

Answer

Songs

Answer

Albums

Question 2

According to the next scenario try to identify 1 possible attribute: «A student has a large collection of music. Her music is stored in DVDs, CDs, Tapes, and Memory Sticks etc. All the various media in which music is stored is organized in a (physical) library. The library itself is organized into numbered columns and named shelves. The database should capture details of albums, songs, artists, production studios, prices and awards received, etc.»

Accepted Answer

Albums

Answer

Student

Answer

Memory

Answer

DVD

Question 3

4.	According to the next scenario, which one of the given options is a possible M-to-M relationship between two entities: “A vehicles repair garage can handle vehicles of multiple types (e.g. cars, vans, trucks, etc). For billing purposes, the garage must record all details about a vehicle (e.g. registration, colour, number of wheel-axis, MOT, etc). Customers bring their vehicles to the garage and leave it there for repair. Once the repairs are done in different departments (e.g. paint, chassis integrity, electrics and electronics, engine, etc). Individual mechanics operate within one speciality only.  The garage manager keeps track of which mechanic works on which vehicle, because an employee salary depends on his/her basic salary plus an additional for each vehicle he/she repairs. Thus, the manager is interested in building a database that would allow him to calculate employees’ salaries based on the difficulty and number of the repairs done to vehicles. Recurring customers have preferred mechanics and this should also be reflected in the database”.

Accepted Answer

Customers M-to-M Mechanics

Answer

Vehicles M-to-M Customers

Answer

Mechanics M-to-M Department

Answer

Garage M-to-M Vehicles

Question 4

Which of the following statements concerning normal forms is true?

Accepted Answer

A relation that is in second normal form is also in first normal form

Answer

Each normal form contains a state of independent properties, unrelated to other normal forms

Answer

The lower the normal form number, the better the schema design is

Answer

Schemes that are in second normal form are considered the best

Question 5

«The use of null values in tuples» is a property of good relational schemas.

Answer

true

Question 6

The elimination of data redundancy to avoid update anomalies» is a property of good relational schemas.

Answer

true

Question 7

The grouping of as many attributes as possible into one main table» is a property of good relational schemas

Answer

true

Question 8

Which of the following is not a phase of database development?

Accepted Answer

DBMS Selection

Answer

Physical Design

Answer

Logical Design

Answer

Conceptual Design

Question 9

Which of the following is not a DDL statement?

Accepted Answer

INSERT

Answer

CREATE

Answer

DROP

Answer

ALTER

Question 10

Which of the following is not a SQL database manipulation statement?

Accepted Answer

CREATE TABLE

Answer

SELECT

Answer

DELETE

Answer

UPDATE

Question 11

Which of the following is not a SQL database manipulation statement?

Accepted Answer

ALTER TABLE

Answer

SELECT

Answer

UPDATE

Answer

DELETE

Question 12

Which one of the following sorts rows in SQL?

Accepted Answer

ORDER BY

Answer

GROUP BY

Answer

ALIGN BY

Answer

SORT BY

Question 13

Find all cities with temperature, condition and humidity whose humidity is in the range of 63 to 79

Accepted Answer

SELECT * FROM weather WHERE humidity BETWEEN 63 AND 79;

Answer

SELECT * FROM weather WHERE humidity NOT BETWEEN 63 AND 79;

Answer

SELECT * FROM weather WHERE humidity = 63 to 79;

Answer

SELECT * FROM weather WHERE humidity = 63 AND 79;

Question 14

With SQL, how can you return the number of records in the ‘Persons’ table?

Accepted Answer

SELECT COUNT(*) FROM Persons;

Answer

SELECT COLUMNS (*) FROM Persons;

Answer

SELECT COUNT( ) FROM Persons;

Answer

SELECT COLUMNS ( ) FROM Persons;

Question 15

With SQL, how do you select all the records from a table named «Persons», where the value of the column «FirstName» is «Peter»?

Accepted Answer

SELECT * FROM Persons WHERE FirstName = ‘Peter’;

Answer

SELECT [all] FROM Persons WHERE FirstName = ‘Peter’;

Answer

SELECT [all] FROM Persons WHERE FirstName LIKE ‘Peter’;

Answer

SELECT * FROM Persons WHERE FirstName <> ‘Peter’;

Question 16

With SQL, how do you select all the records from a table named «Persons», where the «FirstName» is «Peter» and the «LastName» is «Jackson»?

Accepted Answer

SELECT * FROM Persons WHERE FirstName = ‘Peter’ AND LastName = ‘Jackson’;

Answer

SELECT * FROM Persons WHERE LastName = ‘Jackson’;

Answer

SELECT FirstName = ‘Peter’, LastName = ‘Jackson’ FROM Persons;

Answer

SELECT * FROM Persons WHERE FirstName <> ‘Peter’ AND LastName <> ‘Jackson’;

Question 17

With SQL, how can you return all the records from a table named «Persons» sorted descending by «FirstName»?

Accepted Answer

SELECT * FROM Persons ORDER BY FirstName DESC;

Answer

SELECT * FROM Persons SORT BY ‘FirstName’ DESC;

Answer

SELECT * FROM Persons ORDER FirstName DESC;

Answer

SELECT * FROM Persons SORT ‘FirstName’ DESC;

Question 18

With SQL, how do you select all the columns from a table named «Persons»?

Accepted Answer

SELECT * FROM Persons

Answer

SELECT * .Persons

Answer

SELECT [all] FROM Persons

Answer

SELECT Persons

Question 19

How to select all data from student table starting the name from letter ‘r’?

Accepted Answer

SELECT * FROM student WHERE name LIKE ‘r%’;

Answer

SELECT * FROM student WHERE name LIKE ‘%r%’;

Answer

SELECT * FROM student WHERE name LIKE ‘%r’;

Answer

SELECT * FROM student WHERE name LIKE ‘_r%’;

Question 20

Which of the SQL statements is correct?

Accepted Answer

SELECT Username, Password FROM Users

Answer

SELECT Username AND Password FROM Users

Answer

SELECT Username, Password WHERE Username = ‘user1’

Answer

None of the given

Question 21

Which of the following SQL statements deletes all rows in table called SalesData?

Accepted Answer

DELETE FROM SalesData

Answer

DELETE SalesData

Answer

DELETE * FROM SalesData

Answer

DELETE ALL SalesData

Question 22

Which of the following SQL statements will select all records with all their columns from a table called Sales?

Accepted Answer

SELECT * FROM Sales

Answer

SELECT * FROM SALES WHERE OrderID < 1;

Answer

DELETE FROM Sales

Answer

DELETE * FROM Sales

Question 23

What will be the result of the following SQL statement SELECT * FROM Table1 HAVING Column1 > 10?

Accepted Answer

The SQL statement will generate an error.

Answer

The result will be all rows from Table1 which have Column1 values greater than 10.

Answer

The result will be empty data set.

Answer

None of the given

Question 24

Which of the following is NOT a relational algebra operators used in basic queries?

Accepted Answer

Locate

Answer

Select

Answer

Project

Answer

Join

Question 25

What is the keyword you would use before adding conditions to your query?

Accepted Answer

WHERE

Answer

EQUALS

Answer

WHAT

Answer

CONDITIONS

Database Design 4

Create a free account to finish this quiz

Questions in this quiz (25)

Information

Feedback

What do you think of the new look?