Database Concepts Test

Result

Database Concepts Test - 1

Score
-
out of -
Rank
-
out of -

TIME Taken - -

SHARING IS CARING

If our Website helped you a little, then kindly spread our voice using Social Networks. Spread our word to your readers, friends, teachers, students & all those close ones who deserve to know what you know now.

Weekly Quiz Competition

Question 1
1 / -0.25

Which of the following provides the ability to query information from the database and insert tuples into, delete tuples from, and modify tuples in the database?

A
DML(Data Manipulation Language)

B
DDL(Data Definition Language)

C
Query

D
Relational Schema

Solution

The term "DML "stands for the Data Manipulation Language used to perform the required changes in the relation 's values.
Question 2
1 / -0.25

Which of the following is generally used for performing tasks like creating the structure of the relations, deleting relation?

A
DML(Data Manipulation Language)

B
Query

C
Relational Schema

D
DDL(Data Definition Language)

Solution

The term "DDL "stands for Data Definition Language, used to perform all other essential tasks such as deleting relation and related schemas in defining the structure relation.
Question 3
1 / -0.25

Which one of the following given statements possibly contains the error?

A
select * from emp where empid = 10003;

B
select empid from emp where empid = 10006;

C
select empid from emp;

D
select empid where empid = 1009 and Lastname = 'GELLER ';

Solution

The Query given in option D does not contain the "from "clause, which specifies the relation from which the values have to be selected or fetched. Therefore the correct answer is D.
Question 4
1 / -0.25

The given Query can also be replaced with_______:
SELECT name, course_id
FROM instructor, teaches
WHERE instructor_ID= teaches_ID;

A
Select name,course_id from teaches,instructor where instructor_id=course_id;

B
Select name, course_id from instructor natural join teaches;

C
Select name, course_id from instructor;

D
Select course_id from instructor join teaches;

Solution

Join clause joins two tables by matching the common column
Question 5
1 / -0.25

What do you mean by one to many relationships?

A
One class may have many teachers

B
One teacher can have many classes

C
Many classes may have many teachers

D
Many teachers may have many classes

Solution

We can understand the "one to many "relationship as a teacher who may have more than one class to attend.
Question 6
1 / -0.25

Ready the Query carefully:
SELECT emp_name
FROM department
WHERE dept_name LIKE ' _____ Computer Science ';
In the above-given Query, which of the following can be placed in the Query 's blank portion to select the "dept_name "that also contains Computer Science as its ending string?

A
&

B
_

C
%

D
$

Solution

In the above-given Query, the "%"(like) operator will be used, which is generally used while searching for a certain pattern in the strings. It represents the single and multiple characters. In this case, it used with "Where "louse to select the "dept_name "that contains the Computer Since as its ending string. To understand it more clearly, consider the following syntax:

Syntax
SELECT column1, column2, ...
FROM table_name
WHERE columnN LIKE pattern;
Question 7
1 / -0.25

The given Query can be replaced with ____________:
SELECT name
FROM instructor1
WHERE salary <= 100000 AND salary >= 90000;

A
SELECT name
FROM instructor1
WHERE salary BETWEEN 100000 AND 90000

B
SELECT name
FROM instructor|
WHERE salary BETWEEN 90000 AND 100000;

C
SELECT name
FROM instructor1
WHERE salary BETWEEN 90000 AND 100000;

D
SELECT name
FROM instructor!
WHERE salary <= 90000 AND salary >=100000;

Solution

The "SQL "contains a comparison known as the "BETWEEN,"which is also used in one of the given queries, as you can see. The "BETWEEN "operator is generally used to simplify the "WHERE "clause that is used to specify that the value is greater than one value or greater than some values, less than one or more values.
Question 8
1 / -0.25

In the following Query, which of the following can be placed in the Query 's blank portion to display the salary from highest to lowest amount, and sorting the employs name alphabetically?
SELECT *
FROM instructor
ORDER BY salary ____, name ___;

A
Ascending, Descending

B
Asc, Desc

C
Desc, Asc

D
All of the above

Solution

To sort the salary from highest to lowest amount and display the employee 's name alphabetically, one can use the "Desc and Asc "in the above-given Query.
Question 9
1 / -0.25

The term "FAT "is stands for_____

A
File Allocation Tree

B
File Allocation Table

C
File Allocation Graph

D
All of the above

Solution

The term "FAT "can be described as a file structure (or file architecture). In which all the information about the files where they are stored and where all these files need to be stored or in which directory, all that information generally stored in the file structure. Therefore the Operating system creates a table in which all the files and clusters are stored, known as the file allocation table.
Question 10
1 / -0.25

A Database Management System is a type of _________software.

A
It is a type of system software

B
It is a kind of application software

C
It is a kind of general software

D
Both A and C

Solution

The DBMS (or Database Management System) is a kind of system software used for several operations such as creating tables/databases, storing data, managing databases. It also allows modifying the data stored in the database as well.

User

Question Analysis

Correct -
Wrong -
Skipped -

My Perfomance

Score
-
out of -
Rank
-
out of -

Re-Attempt Weekly Quiz Competition

Database Concepts Test - 1

Result

Database Concepts Test - 1

Score

-

Rank

-

SHARING IS CARING

Question 1

DML(Data Manipulation Language)

DDL(Data Definition Language)

Query

Relational Schema

Solution

Question 2

DML(Data Manipulation Language)

Query

Relational Schema

DDL(Data Definition Language)

Solution

Question 3

select * from emp where empid = 10003;

select empid from emp where empid = 10006;

select empid from emp;

select empid where empid = 1009 and Lastname = 'GELLER ';

Solution

Question 4

Select name,course_id from teaches,instructor where instructor_id=course_id;

Select name, course_id from instructor natural join teaches;

Select name, course_id from instructor;

Select course_id from instructor join teaches;

Solution

Question 5

One class may have many teachers

One teacher can have many classes

Many classes may have many teachers

Many teachers may have many classes

Solution

Question 6

&

_

%

$

Solution

Question 7

SELECT name FROM instructor1 WHERE salary BETWEEN 100000 AND 90000

SELECT name FROM instructor| WHERE salary BETWEEN 90000 AND 100000;

SELECT name FROM instructor1 WHERE salary BETWEEN 90000 AND 100000;

SELECT name FROM instructor! WHERE salary <= 90000 AND salary >=100000;

Solution

Question 8

Ascending, Descending

Asc, Desc

Desc, Asc

All of the above

Solution

Question 9

File Allocation Tree

File Allocation Table

File Allocation Graph

All of the above

Solution

Question 10

It is a type of system software

It is a kind of application software

It is a kind of general software

Both A and C

Solution

User

Question Analysis

My Perfomance

Score

-

Rank

-

Results Announcement on: coming Monday

Stay Tuned: We’ll update you on your result via email or SMS.

SELECT name
FROM instructor1
WHERE salary BETWEEN 100000 AND 90000

SELECT name
FROM instructor|
WHERE salary BETWEEN 90000 AND 100000;

SELECT name
FROM instructor1
WHERE salary BETWEEN 90000 AND 100000;

SELECT name
FROM instructor!
WHERE salary <= 90000 AND salary >=100000;