Rdbms Archives - Page 2 of 37

Sign Up

Sign In

Forgot Password

Lost your password? Please enter your email address. You will receive a link and will create a new password via email.

You must login to ask a question.

You must login to add post.

Please briefly explain why you feel this question should be reported.

Please briefly explain why you feel this answer should be reported.

Please briefly explain why you feel this user should be reported.

Ask A Question

Vikrant Kailash Dash

Asked: 3 years agoIn: Rdbms

Which of the following set operations is not commutative?

(a) Union

(b) Intersection

(c) Set difference

(d) None of the mentioned

Nayan Vala

Asked: 3 years agoIn: Rdbms

The devices that store a lot of optical disks are called as

(a) Optical reservoirs

(b) Jukeboxes

(c) Karaoke machines

(d) Sequential access machines

Saurabh Siddharth D’Alia

Asked: 3 years agoIn: Rdbms

While operating with strings, what does “_ _ _%” match with?

(a) A string of three letters

(b) A string of at least three letters

(c) A string of three words

(d) A string of at least three words

Kalpana Anand Bail

Asked: 3 years agoIn: Rdbms

Statement 1: Cache storage is very fast

Statement 2: Cache storage is very cheap

(a) Both the statements are true

(b) Statement 1 is true but statement 2 is false

(c) Statement 1 is false but statement 2 is true

Alka Ibrahim Oommen

Asked: 3 years agoIn: Rdbms

What values does the count(*) function ignore?

(a) Repetitive values

(b) Null values

(c) Characters

(d) Integers

Krishna Dalal

Asked: 3 years agoIn: Rdbms

State true or false: We can update a view if it has multiple database relations in the from clause

(a) True

(b) False

The question was asked in exam.

Enquiry is from Views and Transactions topic in section Intermediate and Advanced Sql of RDBMS

Aisha Manda

Asked: 3 years agoIn: Rdbms

If a query is optimized without providing specific values for its parameters the technique is called __________

(a) Complex query handling

(b) Multi query optimization

(c) Complex query optimization

(d) Parametric query optimization

Pamela Kapoor

Asked: 3 years agoIn: Rdbms

X → Y holds on a schema k(K) if?

(a) At least one legal instance satisfies the functional dependency

(b) No legal instance satisfies the functional dependency

(c) Each and every legal instance satisfies the functional dependency

(d) None of the mentioned

Sushmita Kabra

Asked: 3 years agoIn: Rdbms

Which of the following are not a part of PL/SQL

(a) Triggers

(b) Packages

(c) Functions

(d) None of the mentioned

Kusum Ehsaan Hegde

Asked: 3 years agoIn: Rdbms

Which of the following is a disadvantage of the dynamic hashing structure

(a) Buckets can be allocated dynamically

(b) Lookup involves additional level of indirection

(c) It involves a lesser space overhead

(d) Hash structure can be modified dynamically

Load More Questions

Rdbms

Which of the following set operations is not commutative?

(a) Union

(b) Intersection

(c) Set difference

(d) None of the mentioned

The devices that store a lot of optical disks are called as

(a) Optical reservoirs

(b) Jukeboxes

(c) Karaoke machines

(d) Sequential access machines

While operating with strings, what does “_ _ _%” match with?

(a) A string of three letters

(b) A string of at least three letters

(c) A string of three words

(d) A string of at least three words

Statement 1: Cache storage is very fast

Statement 2: Cache storage is very cheap

(a) Both the statements are true

(b) Statement 1 is true but statement 2 is false

(c) Statement 1 is false but statement 2 is true

What values does the count(*) function ignore?

(a) Repetitive values

(b) Null values

(c) Characters

(d) Integers

State true or false: We can update a view if it has multiple database relations in the from clause

(a) True

(b) False

The question was asked in exam.

Enquiry is from Views and Transactions topic in section Intermediate and Advanced Sql of RDBMS

If a query is optimized without providing specific values for its parameters the technique is called __________

(a) Complex query handling

(b) Multi query optimization

(c) Complex query optimization

(d) Parametric query optimization

X → Y holds on a schema k(K) if?

(a) At least one legal instance satisfies the functional dependency

(b) No legal instance satisfies the functional dependency

(c) Each and every legal instance satisfies the functional dependency

(d) None of the mentioned

Which of the following are not a part of PL/SQL

(a) Triggers

(b) Packages

(c) Functions

(d) None of the mentioned

Which of the following is a disadvantage of the dynamic hashing structure

(a) Buckets can be allocated dynamically

(b) Lookup involves additional level of indirection

(c) It involves a lesser space overhead

(d) Hash structure can be modified dynamically

How to approach applying for a job at a company ...

How to handle personal stress caused by utterly incompetent and ...

What is a programmer’s life like?

Sign Up

Sign In

Forgot Password

Rdbms

mcqoptions.com Latest Questions