Prepare
- All Platforms
- Programming
- Aptitude
- Syllabus
- Interview Preparation
- Interview Exp.
- Off Campus
- Prime Video
- Prime Mock
Prime Video
OffCampus Updates
Placement Stats

Prime Video
Prime Mock

⁰

Notifications Mark All Read

BLACK FRIDAY Sale is live Now!! Use Coupon FRIDAY to get 80% off
Login
Get Prime

Reliance Jio Menu

Placement Papers
Aptitude Questions
Logical Reasoning
Basic Programming Skills
Syllabus
Eligibility Criteria
Recruitment Process
How to Prepare

Get Hiring Updates
Contact us

PrepInsta MockMock

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

Sub key

Super key

Foreign key

Good Job!

Oops!

Report the answer

How to use PrepInsta Quiz

PrepInsta Explanation
User Explanation

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

Super key

Super key is the superset of all the keys in a relation.

Please login to submit your explanation

You can check your performance of this question after Login/SignupLogin

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

CITY , ID

CITY

Good Job!

Oops!

Report the answer

How to use PrepInsta Quiz

PrepInsta Explanation
User Explanation

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

Here the id is the only attribute which can be taken as a key. Other attributes are not uniquely identified

Please login to submit your explanation

You can check your performance of this question after Login/SignupLogin

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

All subsets are super keys

Subset is a super key

Each subset is a super key

Good Job!

Oops!

Report the answer

How to use PrepInsta Quiz

PrepInsta Explanation
User Explanation

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

No proper subset is a super key

The subset of a set cannot be the same set.Candidate key is a set from a super key which cannot be the whole of the super set

Please login to submit your explanation

You can check your performance of this question after Login/SignupLogin

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

Keys

Attribute

Fields

Good Job!

Oops!

Report the answer

How to use PrepInsta Quiz

PrepInsta Explanation
User Explanation

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

Key

Key is the constraint which specifies uniqueness.

Please login to submit your explanation

You can check your performance of this question after Login/SignupLogin

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

Primary

Super

Sub

Good Job!

Oops!

Report the answer

How to use PrepInsta Quiz

PrepInsta Explanation
User Explanation

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

Primary

The primary key has to be referred in the other relation to form a foreign key in that relatio

Please login to submit your explanation

You can check your performance of this question after Login/SignupLogin

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

Referencing

Specific

Primary

Good Job!

Oops!

Report the answer

How to use PrepInsta Quiz

PrepInsta Explanation
User Explanation

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

Referential

A relation, say r1, may include among its attributes the primary key of another relation, say r2. This attribute is called a foreign key from r1, referencing r2. The relation r1 is also called the referencing relation of the foreign key dependency, and r2 is called the referenced relation of the foreign key.

Please login to submit your explanation

You can check your performance of this question after Login/SignupLogin

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

Wait-wound

Timeout

Wait

Good Job!

Oops!

Report the answer

How to use PrepInsta Quiz

PrepInsta Explanation
User Explanation

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

Lock timeout

The timeout scheme is particularly easy to implement, and works well if transactions are short and if longwaits are likely to be due to deadlocks.

Please login to submit your explanation

You can check your performance of this question after Login/SignupLogin

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

Reference

Assertion

Timestamp

Good Job!

Oops!

Report the answer

How to use PrepInsta Quiz

PrepInsta Explanation
User Explanation

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

Index

Index is the reference to the tuples in a relation.

Please login to submit your explanation

You can check your performance of this question after Login/SignupLogin

Start

Question 9

Time: 00:00:00

The user defined data type can be created using

Create datatype

Create data

Create definetype

Create type

Good Job!

Oops!

Report the answer

How to use PrepInsta Quiz

PrepInsta Explanation
User Explanation

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

Create type

The create type clause can be used to define new types.Syntax : create type Dollars as numeric(12,2) final; .

Please login to submit your explanation

You can check your performance of this question after Login/SignupLogin

Start

Question 10

Time: 00:00:00

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

Cast

Drop type

Convert

Alter type

Good Job!

Oops!

Report the answer

How to use PrepInsta Quiz

PrepInsta Explanation
User Explanation

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

Cast

Example of cast :cast (department.budget to numeric(12,2)). SQL provides drop type and alter type clauses to drop or modify types that have been created earlier.

Please login to submit your explanation

You can check your performance of this question after Login/SignupLogin

Start

Question 11

Time: 00:00:00

Which of the following closely resembles Create view ?

Create table . . .like

Create table . . . as

With data

Create view as

Good Job!

Oops!

Report the answer

How to use PrepInsta Quiz

PrepInsta Explanation
User Explanation

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

Create table . . . as

The ‘create table . . . as’ statement closely resembles the create view statement and both are defined by using queries.The main difference is that the contents of the table are set when the table is created, whereas the contents of a view always reflect the current query result.

Please login to submit your explanation

You can check your performance of this question after Login/SignupLogin

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

Schemas, catalogs

Environment, schemas

Schemas, Environment

Good Job!

Oops!

Report the answer

How to use PrepInsta Quiz

PrepInsta Explanation
User Explanation

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

Catalogs, schemas

Please login to submit your explanation

You can check your performance of this question after Login/SignupLogin

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 like instructor;

Create Table as temp_instructor;

Create table like temp_instructor;

Good Job!

Oops!

Report the answer

How to use PrepInsta Quiz

PrepInsta Explanation
User Explanation

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

Create table temp_instructor like instructor;

Please login to submit your explanation

You can check your performance of this question after Login/SignupLogin

Start

Question 14

Time: 00:00:00

The____condition allows a general predicate over the relations being joined

Using

SET

WHERE

Good Job!

Oops!

Report the answer

How to use PrepInsta Quiz

PrepInsta Explanation
User Explanation

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

On gives the condition for the join expression.

Please login to submit your explanation

You can check your performance of this question after Login/SignupLogin

Start

Question 15

Time: 00:00:00

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

Left outer join

Right outer join

Inner join

None

Good Job!

Oops!

Report the answer

How to use PrepInsta Quiz

PrepInsta Explanation
User Explanation

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

nner join

INNER JOIN: Returns all rows when there is at least one match in BOTH tables

Please login to submit your explanation

You can check your performance of this question after Login/SignupLogin

Start

Question 16

Time: 00:00:00

Which are the join types in join condition:

Cross join

Natural join

Join with USING clause

All of the mentioned

Good Job!

Oops!

Report the answer

How to use PrepInsta Quiz

PrepInsta Explanation
User Explanation

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

All of the mentioned

There are totally four join types in SQL.

Please login to submit your explanation

You can check your performance of this question after Login/SignupLogin

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

Right outer join

Full outer join

Half outer join

Good Job!

Oops!

Report the answer

How to use PrepInsta Quiz

PrepInsta Explanation
User Explanation

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

RIGHT OUTER JOIN: Return all rows from the right table, and the matched rows from the left table.

Please login to submit your explanation

You can check your performance of this question after Login/SignupLogin

Start

Question 18

Time: 00:00:00

How non clustered index point to the data?

It never points to anything

It points to a data row

It is used for pointing data rows containing key values

None of the mentioned

Good Job!

Oops!

Report the answer

How to use PrepInsta Quiz

PrepInsta Explanation
User Explanation

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

It is used for pointing data rows containing key values

Nonclustered indexes have a structure separate from the data rows. A nonclustered index contains the nonclustered index key values and each key value entry has a pointer to the data row that contains the key value.

Please login to submit your explanation

You can check your performance of this question after Login/SignupLogin

Start

Question 19

Time: 00:00:00

Which one is true about clustered index?

Clustered index is not associated with table

Clustered index is built by default on unique key columns

Clustered index is not built on unique key columns

None of the mentioned

Good Job!

Oops!

Report the answer

How to use PrepInsta Quiz

PrepInsta Explanation
User Explanation

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

Clustered index is built by default on unique key columns

Please login to submit your explanation

You can check your performance of this question after Login/SignupLogin

Start

Question 20

Time: 00:00:00

What are composite indexes ?

Are those which are composed by database for its internal use

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

Composite index can never be created

None of the mentioned

Good Job!

Oops!

Report the answer

How to use PrepInsta Quiz

PrepInsta Explanation
User Explanation

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

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

A composite index is an index on two or more columns of a table.

Please login to submit your explanation

You can check your performance of this question after Login/SignupLogin

Start

["0","40","60","80","100"]

["Need more practice!","Keep trying!","Not bad!","Good work!","Perfect!"]

Please login to report

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

Start Preparing

Detailed performance

Completed

0/20

Accuracy

Related Banners

Prepinsta Prime

Get Prepinsta Prime

Get all 200+ courses offered by Prepinsta

Explore Prime or check Course List

Check out our instagram

Never Miss an OffCampus Update

Get OffCampus Updates on Social Media from PrepInsta

Instagram

Get Hiring Updates

Amazon,Google,Delottie & 30+companies are hiring ! Get hiring Updates right in your inbox from PrepInsta

PrepInsta Prime

Get over 200+ course One Subscription

Courses like AI/ML, Cloud Computing, Ethical Hacking, C, C++, Java, Python, DSA (All Languages), Competitive Coding (All Languages), TCS, Infosys, Wipro, Amazon, DBMS, SQL and others.

Get Prime Course List

PrepInsta Prime

Get over 200+ course One Subscription

Courses like AI/ML, Cloud Computing, Ethical Hacking, C, C++, Java, Python, DSA (All Languages), Competitive Coding (All Languages), TCS, Infosys, Wipro, Amazon, DBMS, SQL and others.

Get Prime Course List