Database Design 5

Question 1

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 2

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 3

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 4

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 5

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 6

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

Accepted Answer

Locate

Answer

Select

Answer

Project

Answer

Join

Question 7

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

Accepted Answer

WHERE

Answer

EQUALS

Answer

WHAT

Answer

CONDITIONS

Question 8

The NULL SQL keyword is used to…

Accepted Answer

Represent a missing or unknown value. NULL in SQL represents nothing.

Answer

Represent 0 value

Answer

Represent positive infinity

Answer

Represent negative infinity

Question 9

Which of the following is a legal expression in SQL?

Accepted Answer

SELECT name FROM Employee;

Answer

SELECT NULL FROM Employee;

Answer

SELECT name FROM Employee WHEN salary = NULL;

Answer

None of the given

Question 10

What does the following SQL statement do: SELECT Customer, COUNT(Order) FROM Sales GROUP BY Customer HAVING COUNT(Order) > 5?

Accepted Answer

Selects all customers with number of orders from table Sales that have made more than 5 orders

Answer

Selects the total number of orders from the Sales table, if this number is greater than 5

Answer

Selects all customers from the Sales table

Answer

None of the given

Question 11

Which SQL statement will select all rows from a table called «Customers» and orders the result by «customer name»?

Accepted Answer

SELECT * FROM Customers ORDER BY customer_name;

Answer

SELECT * FROM Customers ORDER ON customer_name;

Answer

SELECT * FROM Customers ORDER customer_name;

Answer

SELECT * FROM Customers ORDERED customer_name;

Question 12

SQL query and data modification commands make up a(n) _______ .

Accepted Answer

DML

Answer

DCL

Answer

DDL

Answer

TCL

Question 13

To eliminate duplicate values in a column _____ is used

Accepted Answer

DISTINCT

Answer

ELIMINATE

Answer

NODUPLICATE

Answer

None of these

Question 14

Which of the following is an SQL aggregate function?

Accepted Answer

MIN

Answer

ALTER

Answer

BETWEEN

Answer

CREATE

Question 15

Which of the following is an SQL aggregate function?

Accepted Answer

AVG

Answer

SELECT

Answer

JOIN

Answer

DISTINCT

Question 16

What type of join is needed when you wish to include rows that do not have matching values?

Accepted Answer

Outer join

Answer

Equi-joins

Answer

Natural join

Answer

All of the mentioned

Question 17

Which of the following is not DML statement?

Accepted Answer

ALTER TABLE

Answer

UPDATE

Answer

INSERT

Answer

DELETE

Question 18

Which of the following is DML statement?

Accepted Answer

SELECT

Answer

CREATE TABLE

Answer

ALTER TABLE

Answer

GRANT

Question 19

To define what columns should be displayed in an SQL SELECT statement:

Accepted Answer

Use FROM to name the source table(s) and list the columns to be shown after SELECT

Answer

Use USING to name the source table(s) and list the columns to be shown after SELECT

Answer

Use SELECT to name the source table(s) and list the columns to be shown after SUSING

Answer

Use USING to name the source table(s) and list the columns to be shown after WHERE

Question 20

You can add a row using SQL in a database with which of the following?

Accepted Answer

INSERT

Answer

ADD

Answer

CREATE

Answer

MAKE

Question 21

Which of the following is considered as DBMS?

Accepted Answer

All of these

Answer

MS SQL Server

Answer

Oracle

Answer

PostgreSQL

Question 22

Which of the following is a valid SQL type?

Accepted Answer

All of the given

Answer

NUMERIC

Answer

CHARACTER

Answer

DATE

Question 23

Which of the following SQL statements can be used to create a relational table?

Accepted Answer

CREATE

Answer

ADD

Answer

APPEND

Answer

INSERT

Question 24

A table that satisfies 2NF:

Accepted Answer

Always satisfies 1NF

Answer

Always satisfies 3NF

Answer

May violate 1NF

Answer

None

Question 25

An entity relationship diagram is a tool to represent:

Accepted Answer

Data model

Answer

Process model

Answer

Customer model

Answer

Event model

Database Design 5

Create a free account to finish this quiz

Questions in this quiz (25)

Information

Feedback

What do you think of the new look?