Time: 00:00:00

Question #1

Logical Level of the database is also known as?
A
Sub Schema
Sub Schema
B
Schema
Schema
C
Attribte set
Attribte set
D
All of the above
All of the above
Once you attempt the question then PrepInsta explanation will be displayed.

Please login to submit your explanation

Start

Time: 00:00:00

Question #2

What is Physical Data Independency?
A
Changes at physical level of database does not reflect at logical level
Changes at physical level of database does not reflect at logical level
B
Changes at physical level of database reflects at logical level
Changes at physical level of database reflects at logical level
C
To view record using select statement
To view record using select statement
D
To implement normalization to remove data redundancy
To implement normalization to remove data redundancy
Once you attempt the question then PrepInsta explanation will be displayed.

Please login to submit your explanation

Start

Time: 00:00:00

Question #3

What is Logical Data Independency?
A
Changes at logical level of database does not reflect at view level
Changes at logical level of database does not reflect at view level
B
Changes at logical level of database reflects at view level
Changes at logical level of database reflects at view level
C
To handle multiple records
To handle multiple records
D
To create data dictionary
To create data dictionary
Once you attempt the question then PrepInsta explanation will be displayed.

Please login to submit your explanation

Start

Time: 00:00:00

Question #4

A --- key can be the primary key?
A
Foreign
Foreign
B
Primary
Primary
C
Candidate
Candidate
D
Composite
Composite
Once you attempt the question then PrepInsta explanation will be displayed.

Please login to submit your explanation

Start

Time: 00:00:00

Question #5

ER Model is used to represent?
A
Database structure
Database structure
B
Flow of a program
Flow of a program
C
Algorithm
Algorithm
D
None of these
None of these
Once you attempt the question then PrepInsta explanation will be displayed.

Please login to submit your explanation

Start

Time: 00:00:00

Question #6

Double diamond symbol is used for?
A
Entity relationship type
Entity relationship type
B
Attribute
Attribute
C
Week entity relationship type
Week entity relationship type
D
Tuple
Tuple
Once you attempt the question then PrepInsta explanation will be displayed.

Please login to submit your explanation

If diamond has double lines then it represents week entity relationship

Start

Time: 00:00:00

Question #7

Is derived attribute physically contained in relation?
A
Yes
Yes
B
No
No
C
Sometimes
Sometimes
D
None of these
None of these
Once you attempt the question then PrepInsta explanation will be displayed.

Please login to submit your explanation

Start

Time: 00:00:00

Question #8

If F is functional dependency then closure of F is represented by?
A
F+
F+
B
F*
F*
C
F-
F-
D
F#
F#
Once you attempt the question then PrepInsta explanation will be displayed.

Please login to submit your explanation

Start

Time: 00:00:00

Question #9

What is non-trivial functional dependency?
A
If A→B holds where B is not subset of A.
If A→B holds where B is not subset of A.
B
If A→B holds where B is subset of A.
If A→B holds where B is subset of A.
C
If A→B holds where B is not intersection of A.
If A→B holds where B is not intersection of A.
D
If A→B holds where B is intersection of A.
If A→B holds where B is intersection of A.
Once you attempt the question then PrepInsta explanation will be displayed.

Please login to submit your explanation

Start

Time: 00:00:00

Question #10

Which is the correct syntax to sort returned record set in Ascending Order by Column1 and Descending Order by Column2?
A
SELECT * FROM table_name ORDER BY ASC (column1), DESC (column2)
SELECT * FROM table_name ORDER BY ASC (column1), DESC (column2)
B
SELECT * FROM table_name ORDER BY ASC column1, DESC column2
SELECT * FROM table_name ORDER BY ASC column1, DESC column2
C
SELECT * FROM table_name ORDER BY column1 ASC, column2 DESC
SELECT * FROM table_name ORDER BY column1 ASC, column2 DESC
D
SELECT * FROM table_name column1 ASC, column2 DESC ORDER BY
SELECT * FROM table_name column1 ASC, column2 DESC ORDER BY
Once you attempt the question then PrepInsta explanation will be displayed.

Please login to submit your explanation

Start

["0","40","60","80","100"]
["Need more practice! \n","Keep trying! \n","Not bad! \n","Good work! \n","Perfect! \n"]

Your Quiz - 1 Percentile Percentile (0%)

You can check your score after Login/Signup

Your global Ranking

-

Your Ranking

-

Your Quiz - 1 Percentile Ranking

-

The percentile data will be refreshed at 11:59 PM everyday

Result

Result

Completed - 0/10

Average time Per Question - 0