Database Concepts Test

Result

Database Concepts Test - 4

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

The database management system can be considered as the collection of ______ that enables us to create and maintain the database.

A
Translators

B
Programs

C
Keys

D
Language activity

Solution

The Database management system can also considered as the set of programs that enables users to create and maintain the database.
Question 2
1 / -0.25

Which one of the following commands is used to restore the database to the last committed state?

A
Savepoint

B
Rollback

C
Commit

D
Both A &B

Solution

As we all know that while working with the Transactions, the Transaction Control Language is used. To restore the database to the last committed state ( or to undo the latest changes), the "rollback "command is used that belongs to the Transaction Control Language.
Question 3
1 / -0.25

Which of the following refers collection of the information stored in a database at a specific time?

A
Independence

B
Instance of the database

C
Schema

D
Data domain

Solution

The collection of data (or information) stored in a database at a particular moment is known as the instance of the database. Therefore the correct answer is B.
Question 4
1 / -0.25

The term "DFD "stands for?

A
Data file diagram

B
Data flow document

C
Data flow diagram

D
None of the above

Solution

The term "DFD "stands for the Data Flow Diagram, and to represent the flow of the data( or information), the data flow diagram is used. The data flow diagram also helps in understanding how the data is managed in the application. Therefore the correct answer is C.
Question 5
1 / -0.25

The term "Data independence "refers to____

A
Data is defined separately and not included in the programs

B
Programs are not dependent on the logical attributes of the data

C
Programs are not dependent on the physical attributes of the data

D
Both B &C

Solution

The term "Data independence "refers that the program should not be dependent on either the logical attributes of data or physical attributes of data.
Question 6
1 / -0.25

The term "SQL "stands for

A
Standard query language

B
Sequential query language

C
Structured query language

D
Server-side query language

Solution

The term "SQL "stands for the structured query language, which is one of the most widely, used programming languages for relational databases. It can also be used for managing and organizing data in all sorts of systems in which different data relationships exist. Therefore the correct answer is C.
Question 7
1 / -0.25

Which one of the following refers to the total view of the database content?

A
Conceptual view

B
Physical view

C
Internal view

D
External view

Solution

The conceptual view refers to the total view of the content available in the database. Therefore the correct answer is A.
Question 8
1 / -0.25

What is the relation calculus?

A
It is a kind of procedural language

B
It is a non-procedural language

C
It is a high-level language

D
It is Data Definition language

Solution

In database management systems, relation calculus is a type of non-procedural query language that describes what data needs to be retrieved. However, it does not explain how to retrieve the data.
Question 9
1 / -0.25

The term "ODBC "stands for_____

A
Oral database connectivity

B
Oracle database connectivity

C
Open database connectivity

D
Object database connectivity

Solution

The term "ODBC "refers to the Open Database Connectivity that is a SQL based programming interface introduced by Microsoft.
Question 10
1 / -0.25

For what purpose the DML is provided?

A
Addition of new structure in the database

B
Manipulation &processing of the database

C
Definition of the physical structure of the database system

D
All of the above

Solution

The term "DML "refers to the data manipulation language, which is commonly used to perform basic operations such as insert data, delete, and update data in a database. So the correct answer will be B.
Question 11
1 / -0.25

In the relation model, the relation are generally termed as ________

A
Tuples

B
Attributes

C
Rows

D
Tables

Solution

In the relation model, the relations are also referred to as the tables because the relations are considered as the technical name of the table. So the correct answer is D.
Question 12
1 / -0.25

The architecture of a database can be viewed as the ________

A
One level

B
Two-level

C
Three-level

D
Four level

Solution

A database 's architecture can be viewed as the three levels of abstraction that are named as the internal level, external level, and the conceptual level. Therefore the correct answer is C.
Question 13
1 / -0.25

Which of the following keys is generally used to represents the relationships between the tables?

A
Primary key

B
Foreign key

C
Secondary key

D
None of the above

Solution

To represent the relationships between the various tables in the database, generally, the foreign key is used. Therefore the correct answer is the foreign key.
Question 14
1 / -0.25

Which of the following levels is considered as the level closed to the end-users?

A
Internal Level

B
External Level

C
Conceptual Level

D
Physical Level

Solution

The database 's external level is the one and only level that is considered the closest level to the end-users. So the correct answer will be the B.
Question 15
1 / -0.25

The Database Management Query language is generally designed for the _____

A
Support end-users who use English like commands

B
Specifying the structure of the database

C
Support in the development of the complex applications software

D
All of the above

Solution

The database management query language is generally designed by keeping in mind that it must support the end-users who are familiar with the English-like commands. It should also boost the process of development of the complex applications software and helps in specifying the structure of the database.

User

Question Analysis

Correct -
Wrong -
Skipped -

My Perfomance

Score
-
out of -
Rank
-
out of -

Re-Attempt Weekly Quiz Competition

Database Concepts Test - 4

Result

Database Concepts Test - 4

Score

-

Rank

-

SHARING IS CARING

Question 1

Translators

Programs

Keys

Language activity

Solution

Question 2

Savepoint

Rollback

Commit

Both A &B

Solution

Question 3

Independence

Instance of the database

Schema

Data domain

Solution

Question 4

Data file diagram

Data flow document

Data flow diagram

None of the above

Solution

Question 5

Data is defined separately and not included in the programs

Programs are not dependent on the logical attributes of the data

Programs are not dependent on the physical attributes of the data

Both B &C

Solution

Question 6

Standard query language

Sequential query language

Structured query language

Server-side query language

Solution

Question 7

Conceptual view

Physical view

Internal view

External view

Solution

Question 8

It is a kind of procedural language

It is a non-procedural language

It is a high-level language

It is Data Definition language

Solution

Question 9

Oral database connectivity

Oracle database connectivity

Open database connectivity

Object database connectivity

Solution

Question 10

Addition of new structure in the database

Manipulation &processing of the database

Definition of the physical structure of the database system

All of the above

Solution

Question 11

Tuples

Attributes

Rows

Tables

Solution

Question 12

One level

Two-level

Three-level

Four level

Solution