ZS Associate DBMS Questions and Answers Quiz-1

Question 1

Time: 00:00:00
The attribute name could be structured as an attribute consisting of first name, middle initial, and last name. This type of attribute is called

Simple attribute

Simple attribute

Composite attribute

Composite attribute

Multivalued attribute

Multivalued attribute

Derived attribute

Derived attribute

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

Please login to submit your explanation

Start

Question 2

Time: 00:00:00
Which of the following stores several gigabytes of data but usually lost when power failure?

Flash memory

Flash memory

Disk

Disk

Main Memory

Main Memory

Secondary Memory

Secondary Memory

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

Please login to submit your explanation

Start

Question 3

Time: 00:00:00
There are “record-once” versions of the compact disk and digital video disk, which can be written only once; such disks are also called __________ disks.

Write-once, read-many (WORM)

Write-once, read-many (WORM)

CD-R

CD-R

DVD-W

DVD-W

CD-ROM

CD-ROM

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

Please login to submit your explanation

Start

Question 4

Time: 00:00:00
Which statement is true regarding the PROD_ID_PK constraint?

It would be created only if a unique index is manually created first

It would be created only if a unique index is manually created first

It would be created and would use an automatically created unique index

It would be created and would use an automatically created unique index

It would be created and would use an automatically created no unique index

It would be created and would use an automatically created no unique index

It would be created and remains in a disabled state because no index is specified in the command

It would be created and remains in a disabled state because no index is specified in the command

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

Please login to submit your explanation

Start

Question 5

Time: 00:00:00
Evaluate the following CREATE SEQUENCE statement:







CREATE SEQUENCE seq1
START WITH 100
INCREMENT BY 10
MAXVALUE 200
CYCLE
NOCACHE;








The sequence SEQ1 has generated numbers up to the maximum limit of 200. You issue the following SQL statement:
SELECT seq1.nextval FROM dual;
What is displayed by the SELECT statement?

1

1

101

101

100

100

an error

an error

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

Please login to submit your explanation

Start

Question 6

Time: 00:00:00







SELECT *
FROM student JOIN takes USING (ID);








The above query is equivalent to
a)







   SELECT *
FROM student INNER JOIN takes USING (ID);








b)







   SELECT *
FROM student OUTER JOIN takes USING (ID);








c)







   SELECT *
FROM student LEFT OUTER JOIN takes USING (ID);








d) None of the mentioned

a)

a)

b)

b)

c)

c)

d)

d)

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

Please login to submit your explanation

Start

Question 7

Time: 00:00:00
Which of the following is used to access the database server at the time of executing the program and get the data from the server accordingly?

Embedded SQL

Embedded SQL

Dynamic SQL

Dynamic SQL

SQL declarations

SQL declarations

SQL data analysis

SQL data analysis

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

Please login to submit your explanation

Start

Question 8

Time: 00:00:00
There are similarities between the instructor entity set and the secretary entity set in the sense that they have several attributes that are conceptually the same across the two entity sets: namely, the identifier, name, and salary attributes. This process is called

Commonality

Commonality

Specialization

Specialization

Generalization

Generalization

Similarity

Similarity

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

Please login to submit your explanation

Start

Question 9

Time: 00:00:00
If an entity set is a lower-level entity set in more than one ISA relationship, then the entity set has

Hierarchy

Hierarchy

Multilevel inheritance

Multilevel inheritance

Single inheritance

Single inheritance

Multiple inheritance

Multiple inheritance

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

Please login to submit your explanation

Start

Question 10

Time: 00:00:00
Consider the employee work-team example, and assume that certain employees participate in more than one work team. A given employee may therefore appear in more than one of the team entity sets that are lower level entity sets of employee. Thus, the generalization is _____________

Overlapping

Overlapping

Disjointness

Disjointness

Uniqueness

Uniqueness

Relational

Relational

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%