Please login

Prime

Prepinsta Prime

Video courses for company/skill based Preparation

(Check all courses)
Get Prime Video
Prime

Prepinsta Prime

Purchase mock tests for company/skill building

(Check all mocks)
Get Prime mock

Cocubes DBMS Questions with Answers

Question 1

Time: 00:00:00
Logical Level of the database is also known as?

Sub Schema

Sub Schema

Schema

Schema

Attribte set

Attribte set

All of the above

All of the above

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

Please login to submit your explanation

Start

Question 2

Time: 00:00:00
What is Physical Data Independency?

Changes at physical level of database does not reflect at logical level

Changes at physical level of database does not reflect at logical level

Changes at physical level of database reflects at logical level

Changes at physical level of database reflects at logical level

To view record using select statement

To view record using select statement

To implement normalization to remove data redundancy

To implement normalization to remove data redundancy

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

Please login to submit your explanation

Start

Question 3

Time: 00:00:00
What is Logical Data Independency?

Changes at logical level of database does not reflect at view level

Changes at logical level of database does not reflect at view level

Changes at logical level of database reflects at view level

Changes at logical level of database reflects at view level

To handle multiple records

To handle multiple records

To create data dictionary

To create data dictionary

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 --- key can be the primary key?

Foreign

Foreign

Primary

Primary

Candidate

Candidate

Composite

Composite

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

Please login to submit your explanation

Start

Question 5

Time: 00:00:00
ER Model is used to represent?

Database structure

Database structure

Flow of a program

Flow of a program

Algorithm

Algorithm

None of these

None of these

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

Please login to submit your explanation

Start

Question 6

Time: 00:00:00
Double diamond symbol is used for?

Entity relationship type

Entity relationship type

Attribute

Attribute

Week entity relationship type

Week entity relationship type

Tuple

Tuple

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

Please login to submit your explanation

If diamond has double lines then it represents week entity relationship

Start

Question 7

Time: 00:00:00
Is derived attribute physically contained in relation?

Yes

Yes

No

No

Sometimes

Sometimes

None of these

None of these

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

Please login to submit your explanation

Start

Question 8

Time: 00:00:00
If F is functional dependency then closure of F is represented by?

F+

F+

F*

F*

F-

F-

F#

F#

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

Please login to submit your explanation

Start

Question 9

Time: 00:00:00
What is non-trivial functional dependency?

If A→B holds where B is not subset of A.

If A→B holds where B is not subset of A.

If A→B holds where B is subset of A.

If A→B holds where B is subset of A.

If A→B holds where B is not intersection of A.

If A→B holds where B is not intersection of A.

If A→B holds where B is intersection of A.

If A→B holds where B is intersection of A.

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

Please login to submit your explanation

Start

Question 10

Time: 00:00:00
Which is the correct syntax to sort returned record set in Ascending Order by Column1 and Descending Order by Column2?

SELECT * FROM table_name ORDER BY ASC (column1), DESC (column2)

SELECT * FROM table_name ORDER BY ASC (column1), DESC (column2)

SELECT * FROM table_name ORDER BY ASC column1, DESC column2

SELECT * FROM table_name ORDER BY ASC column1, DESC column2

SELECT * FROM table_name ORDER BY column1 ASC, column2 DESC

SELECT * FROM table_name ORDER BY column1 ASC, column2 DESC

SELECT * FROM table_name column1 ASC, column2 DESC ORDER BY

SELECT * FROM table_name column1 ASC, column2 DESC ORDER BY

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! \r\n","Keep trying! \r\n","Not bad! \r\n","Good work! \r\n","Perfect! \r\n"]
Hey ! Follow us on G+

One comment on “Cocubes DBMS Questions with Answers”


  • latin girlsesx

    How One Woman Found the Secret to dating foreign girls

    tenacity: If a sensational scene it, internet dating isn’t for you. Though match making websites may seem like a quick approach to meeting your one true love at a bar, Perusing pages of potential dates calls for some strength of mind. And if you have a deep appreciation for spreadsheets, in order to, additionally.

    armed with charts, Lists and recipes, Amy Webb used what she knew best to outsmart the international dating algorithms: business. Repeated failures at meeting her match spurred the digital strategy expert to crack the code, Leading straight to her future husband.

    Webb, CEO of WebbMedia company, Spent a month crunching numbers and analyzing keywords to optimize her JDate profile. She stories her journey in her new book, personal information, A Love plot. The concept of math and technology bringing people together first attracted her to online dating sites, But she quickly realized it was not going to work.

    “I’m pretty open about being not devout, Webb conveys Mashable. “some sites kept trying to match me up with Orthodox Jewish rabbis, Which could not have been even further away. I looked at the data and realized it was really going to be impossible for an algorithm to match me with somebody,

    Her initial suits were so bad, She took to sending mid date email updates to friends while hiding from her suitors in the bar’s bathroom. there were the guy who smoked a huge joint after dinner, The one who gave ongoing high fives, and definitely, The gotten married one.

    For those who’ve had their great number of awful matchmaker dates, the most important clich “actually you, dui lawyer las vegas me” truly rings true. It’s yours doing, Webb states. the internet in these sites’ databases are user generated, And most people don’t be ready to be 100% effective. Bad data explores the algorithm, So bad data quickly scans the blogosphere, causing you to be mismatched.

    individuals will pour hours into perfecting their rsum, But won’t invest the same amount of time into their digital presence. The persistence for your profile is necessary, tells Webb.

    “When you consider it, Online dating is sort of the supreme exercise in product marketing. Except you may be the product. colombia girls So how to leverage what you’ve got, How can you make sure you’re being seen by the most number of individuals, She answers. “awaken of (the software) As more of a catalog client base. As long as you know exactly what you desire, It’s no different from doing a search in a library or doing a search for shoes on Zappos,

    Therein lies the actual for most frustrated site users. Finding out what you want to is the first step, she says. Webb created a list of 72 different data points with timbers she wanted most in a mate.

    Next, She needed to assess competition. types of women were her dream men attracting? the only way to find out was the log back into JDate, But that time period as a man (an absense of catfishing, Just data package).

    After analyzing its competitors, Webb found a pattern in the normal women on JDate. Their profile prints showed some skin, They kept their bios short and optimists, And waited approximately 22 to 23 hours before responding to messages.

    One of the biggest mistakes people make, she says, Is over discussing, Over describing and using sarcasm. Women who were popular had typically 97 words in their summary section. Webb’s initial dating profile by contrast, Wasn’t as probable. She used her rsum as her bio and circulated three of her “the bare minimum bad” shots.

    once “in turn sends ing” Her JDate information, Webb swapped her photos (Including an unflattering picture with the fam dog) With new pictures in sunlight and in clothing she would typically wear on a date. She succeeded her copy pasted rsum with three, Succinct phrases. the very next day, She received 14 new messages and her super profile had 68 views right away.

    SEE sometimes: Dating internet site ‘High Season’ Means More Fish in the Sea

    “Within a few days I was legendary profile on the site. this became like I was the prom queen of JDate. I’ve never been that well-accepted before. I probably never will be again, Webb cracks.

    “Nobody wants to copy the experiment or do the math, But anyone can identify what they want and come up with a system, Webb relates. “I didn’t have to rely on the way that I look; I relied on my smarts. Nerds around the world are finally able to unite using math to find love.