Prepare
- All Platforms
- Programming
- Aptitude
- Syllabus
- Interview Preparation
- Interview Exp.
- Off Campus
- Prime Video
- Prime Mock
PrepInsta Prime
OffCampus
The Job Company
Placement Stats

Prime Video
Prime Mock

⁰

Notifications Mark All Read

7 Day TCS NQT Crash Course is available at just 1999. Click here to Purchase
Login
Get Prime

Persistent Menu

Persistent Home
Previous Papers
Persistent Syllabus
Logical Reasoning
Verbal English
Computer Science
Automata Questions
Coding Questions
Advanced Coding
Super Achiever Test
Drona Interview
Recruitment process
Eligibility Criteria

Get Hiring Updates
Contact us

PrepInsta MockMock
Prime VideoVideo

Persistent DBMS Quiz-1

Question 1

Time: 00:00:00

Which one of the following is used to define the structure 

of the relation ,deleting relations and relating schemas ?

DML(Data Manipulation Langauge)

DDL(Data Definition Langauge)

Query

Relational Schema

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.

Answer: b
Explanation: Data Definition language is the language which performs all the operation in defining the structure of 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

The basic data type char(n) is a _____ length character 

string and varchar(n) is _____ length character.

Fixed, equal

Equal, variable

Fixed, variable

Variable, equal

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.

Answer: c
Explanation: Varchar changes its length accordingly whereas char has a specific length which has to be filled by either letters or spaces.

Please login to submit your explanation

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

Start

Question 3

Time: 00:00:00

Which one of the following deletes all the entries but 

keeps the structure of the relation .

Delete from r where P

Delete from instructor where dept name= ’Finance’

Delete from instructor where salary between 13000 and 15000

Delete from 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.

Answer: d
Explanation: Absence of condition deletes all rows.

Please login to submit your explanation

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

Start

Question 4

Time: 00:00:00

_________ are useful in SQL update statements,where they 

can be used in the set clause.

Multiple queries

Subqueries

Update

Scalar subqueries

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.

Answer: d
Explanation: None.

Please login to submit your explanation

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

Start

Question 5

Time: 00:00:00

 _______________ joins are SQL server default

Outer

Inner

Equi

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.

Answer: b
Explanation: Inner query joins only the rows that are matching.

Please login to submit your explanation

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

Start

Question 6

Time: 00:00:00

Which of the following is not the function of client?

Compile queries

Query optimization

Receive queries

Result formatting and presentation

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.

Answer: b
Explanation: Query optimization is used to improve quality.

Please login to submit your explanation

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

Start

Question 7

Time: 00:00:00

In magnetic disk ________ stores information on a sector 

magnetically as reversals of the direction of magnetization 

of the magnetic material.

Read–write head

Read-assemble head

Head–disk assemblies

Disk arm

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.

Answer: d
Explanation: Each side of a platter of a disk has a read-write head that moves across the platter to access different tracks.

Please login to submit your explanation

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

Start

Question 8

Time: 00:00:00

The current copy of the database is identified by a 

pointer,  called ____________ which is stored on disk.

Db-pointer

Update log

Update log records

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.

Answer: a
Explanation: Any page which is not updated by a transaction is not copied, but instead the new page table just stores a pointer to the original page.

Please login to submit your explanation

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

Start

Question 9

Time: 00:00:00

Two main measures for the efficiency of an algorithm are

Processor and memory

Complexity and capacity

Time and space

Data and space

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.

Answer: c
Explanation: Depending on the time and space complexity only the algorithm for sorting will be chosen.

Please login to submit your explanation

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

Start

Question 10

Time: 00:00:00

A system is in a ______ state if there exists a set of 

transactions such that every transaction in the set is 

waiting for another transaction in the set.

Idle

Waiting

Deadlock

Ready

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.

Answer: c
Explanation: When one data item is waiting for another data item in a transaction then the system is in deadlock.

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

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/10

Accuracy

Prime

Prime Mock

Topic wise Full Mock and much more

(For Persistent)

Get Prime Mock

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