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)

DML(Data Manipulation Langauge)

DDL(Data Definition Langauge)

DDL(Data Definition Langauge)

Query

Query

Relational Schema

Relational Schema

Good Job!

Oops!

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

Please login to submit your explanation

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

Fixed, equal

Equal, variable

Equal, variable

Fixed, variable

Fixed, variable

Variable, equal

Variable, equal

Good Job!

Oops!

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

Please login to submit your explanation

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 r where P

Delete from instructor where dept name= ’Finance’

Delete from instructor where dept name= ’Finance’

Delete from instructor where salary between 13000 and 15000

Delete from instructor where salary between 13000 and 15000

Delete from instructor

Delete from instructor

Good Job!

Oops!

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

Please login to submit your explanation

Question 4

Time: 00:00:00
_________ are useful in SQL update statements,where they 

can be used in the set clause.

Multiple queries

Multiple queries

Subqueries

Subqueries

Update

Update

Scalar subqueries

Scalar subqueries

Good Job!

Oops!

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

Please login to submit your explanation

Question 5

Time: 00:00:00
 _______________ joins are SQL server default

Outer

Outer

Inner

Inner

Equi

Equi

None of the Mentioned

None of the Mentioned

Good Job!

Oops!

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

Please login to submit your explanation

Question 6

Time: 00:00:00
Which of the following is not the function of client?

Compile queries

Compile queries

Query optimization

Query optimization

Receive queries

Receive queries

Result formatting and presentation

Result formatting and presentation

Good Job!

Oops!

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

Please login to submit your explanation

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–write head

Read-assemble head

Read-assemble head

Head–disk assemblies

Head–disk assemblies

Disk arm

Disk arm

Good Job!

Oops!

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

Please login to submit your explanation

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

Db-pointer

Update log

Update log

Update log records

Update log records

All of the mentioned

All of the mentioned

Good Job!

Oops!

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

Please login to submit your explanation

Question 9

Time: 00:00:00
Two main measures for the efficiency of an algorithm are

Processor and memory

Processor and memory

Complexity and capacity

Complexity and capacity

Time and space

Time and space

Data and space

Data and space

Good Job!

Oops!

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

Please login to submit your explanation

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

Idle

Waiting

Waiting

Deadlock

Deadlock

Ready

Ready

Good Job!

Oops!

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

Please login to submit your explanation

["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

0%

Start Preparing
Detailed performance

Get over 200+ Courses under One Subscription

Get Prime Course List
mute
Limitless Learning

One Subscription access everything

Job Assistance

Get Access to PrepInsta Prime

Top Faculty

from FAANG/IITs/TOP MNC's

Get Prime

Don’t settle Learn from the Best with PrepInsta Prime Subscription

manish-prepinsta

Manish Agarwal

Ex- Accenture

Trained 3.2L+ students

Rushikesh-prepinsta

Rushikesh Konapure

Data Science & Full Stack Mentor

Trained 35k+ students

atulya-prepinsta

Atulya Kaushik

Ex- Google & Instamojo

Trained 3.2L+ students

Aashay-prepinsta

Aashay Mishra

Ex- Sapient

Trained 83k+ students

Janvi-prepinsta

Janvi Jain

Lead Verbal Mentor

Trained 46k+ students

Learn from Top 1%
Get Prime
prepinsta
prepinsta
prepinsta
prepinsta
prepinsta
prepinsta
prepinsta

One Subscription, For Everything

The new cool way of learning and upskilling -

Limitless Learning

One Subscription access everything

Job Assistance

Get Access to PrepInsta Prime

Top Faculty

from FAANG/IITs/TOP MNC's

Get 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
Get Prime Course List

Comments

August 31, 2020