Reliance Jio DBMS Quiz-1

Question 1

Time: 00:00:00
Which one of the following is a set of one or more attributes taken collectively to uniquely identify a record?

Candidate key

Candidate key

Sub key

Sub key

Super key

Super key

Foreign key

Foreign key

Once you attempt the question then PrepInsta explanation will be displayed.

Please login to submit your explanation

Start

Question 2

Time: 00:00:00
Consider attributes ID , CITY and NAME . Which one of this can be considered as a super key ?

NAME

NAME

ID

ID

CITY , ID

CITY , ID

CITY

CITY

Once you attempt the question then PrepInsta explanation will be displayed.

Please login to submit your explanation

Start

Question 3

Time: 00:00:00
The subset of super key is a candidate key under what condition ?

No proper subset is a super key

No proper subset is a super key

All subsets are super keys

All subsets are super keys

Subset is a super key

Subset is a super key

Each subset is a super key

Each subset is a super key

Once you attempt the question then PrepInsta explanation will be displayed.

Please login to submit your explanation

Start

Question 4

Time: 00:00:00
A _____ is a property of the entire relation, rather than of the individual tuples in which each tuple is unique.

Rows

Rows

Keys

Keys

Attribute

Attribute

Fields

Fields

Once you attempt the question then PrepInsta explanation will be displayed.

Please login to submit your explanation

Start

Question 5

Time: 00:00:00
A attribute in a relation is a foreign key if the _______ key from one relation is used as an attribute in that relation .

Candidate

Candidate

Primary

Primary

Super

Super

Sub

Sub

Once you attempt the question then PrepInsta explanation will be displayed.

Please login to submit your explanation

Start

Question 6

Time: 00:00:00
A _________ integrity constraint requires that the values appearing in specified attributes of any tuple in the referencing relation also appear in specified attributes of at least one tuple in the referenced relation.

Referential

Referential

Referencing

Referencing

Specific

Specific

Primary

Primary

Once you attempt the question then PrepInsta explanation will be displayed.

Please login to submit your explanation

Start

Question 7

Time: 00:00:00
The situation where the lock waits only for a specified amount of time for another lock to be released is

Lock timeout

Lock timeout

Wait-wound

Wait-wound

Timeout

Timeout

Wait

Wait

Once you attempt the question then PrepInsta explanation will be displayed.

Please login to submit your explanation

Start

Question 8

Time: 00:00:00
An ________ on an attribute of a relation is a data structure that allows the database system to find those tuples in the relation that have a specified value for that attribute efficiently, without scanning through all the tuples of the relation.

Index

Index

Reference

Reference

Assertion

Assertion

Timestamp

Timestamp

Once you attempt the question then PrepInsta explanation will be displayed.

Please login to submit your explanation

Start

Question 9

Time: 00:00:00
The user defined data type can be created using

Create datatype

Create datatype

Create data

Create data

Create definetype

Create definetype

Create type

Create type

Once you attempt the question then PrepInsta explanation will be displayed.

Please login to submit your explanation

Start

Question 10

Time: 00:00:00
 Values of one type can be converted to another domain using which of the following ?

Cast

Cast

Drop type

Drop type

Convert

Convert

Alter type

Alter type

Once you attempt the question then PrepInsta explanation will be displayed.

Please login to submit your explanation

Start

Question 11

Time: 00:00:00
Which of the following closely resembles Create view ?

Create table . . .like

Create table . . .like

Create table . . . as

Create table . . . as

With data

With data

Create view as

Create view as

Once you attempt the question then PrepInsta explanation will be displayed.

Please login to submit your explanation

Start

Question 12

Time: 00:00:00
In contemporary databases the top level of the hierarchy consists of ______, each of which can contain _____.

Catalogs, schemas

Catalogs, schemas

Schemas, catalogs

Schemas, catalogs

Environment, schemas

Environment, schemas

Schemas, Environment

Schemas, Environment

Once you attempt the question then PrepInsta explanation will be displayed.

Please login to submit your explanation

Start

Question 13

Time: 00:00:00
Which of the following statements creates a new table temp instructor that has the same schema as instructor.

create table temp_instructor;

create table temp_instructor;

Create table temp_instructor like instructor;

Create table temp_instructor like instructor;

Create Table as temp_instructor;

Create Table as temp_instructor;

Create table like temp_instructor;

Create table like temp_instructor;

Once you attempt the question then PrepInsta explanation will be displayed.

Please login to submit your explanation

Start

Question 14

Time: 00:00:00
The____condition allows a general predicate over the relations being joined

ON

ON

Using

Using

SET

SET

WHERE

WHERE

Once you attempt the question then PrepInsta explanation will be displayed.

Please login to submit your explanation

Start

Question 15

Time: 00:00:00
Which of the join operations do not preserve non matched tuples.

Left outer join

Left outer join

Right outer join

Right outer join

Inner join

Inner join

None

None

Once you attempt the question then PrepInsta explanation will be displayed.

Please login to submit your explanation

Start

Question 16

Time: 00:00:00
Which are the join types in join condition:

Cross join

Cross join

Natural join

Natural join

Join with USING clause

Join with USING clause

All of the mentioned

All of the mentioned

Once you attempt the question then PrepInsta explanation will be displayed.

Please login to submit your explanation

Start

Question 17

Time: 00:00:00
Which join refers to join records from the right table that have no matching key in the left table are include in the result set:

Left outer join

Left outer join

Right outer join

Right outer join

Full outer join

Full outer join

Half outer join

Half outer join

Once you attempt the question then PrepInsta explanation will be displayed.

Please login to submit your explanation

Start

Question 18

Time: 00:00:00
How non clustered index point to the data?

It never points to anything

It never points to anything

It points to a data row

It points to a data row

It is used for pointing data rows containing key values

It is used for pointing data rows containing key values

None of the mentioned

None of the mentioned

Once you attempt the question then PrepInsta explanation will be displayed.

Please login to submit your explanation

Start

Question 19

Time: 00:00:00
Which one is true about clustered index?

Clustered index is not associated with table

Clustered index is not associated with table

Clustered index is built by default on unique key columns

Clustered index is built by default on unique key columns

Clustered index is not built on unique key columns

Clustered index is not built on unique key columns

None of the mentioned

None of the mentioned

Once you attempt the question then PrepInsta explanation will be displayed.

Please login to submit your explanation

Start

Question 20

Time: 00:00:00
What are composite indexes ?

Are those which are composed by database for its internal use

Are those which are composed by database for its internal use

A composite index is a combination of index on 2 or more columns

A composite index is a combination of index on 2 or more columns

Composite index can never be created

Composite index can never be created

None of the mentioned

None of the mentioned

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!","Keep trying!","Not bad!","Good work!","Perfect!"]

Personalized Analytics only Availble for Logged in users

Analytics below shows your performance in various Mocks on PrepInsta

Your average Analytics for this Quiz

Rank

-

Percentile

0%

Completed

0/0

Accuracy

0%