Database Administration Questions


Q:

Which of the following statements is true concerning subqueries?

A) Does not start with the word SELECT. B) Involves the use of an inner and outer query.
C) Cannot return the same result as a query that is not a subquery. D) All of the above
 
Answer & Explanation Answer: B) Involves the use of an inner and outer query.

Explanation:
Report Error

View Answer Report Error Discuss

Filed Under: SQL
Job Role: Analyst , Database Administration , IT Trainer

0 2097
Q:

What turns everything around without moving?

Answer

The Mirror can turn everything around without moving.

Report Error

View answer Workspace Report Error Discuss

2 2045
Q:

Candidate Key in DBMS?

Answer

A candidate key is a column, or set of columns, in a table that can uniquely identify any database record without referring to any other data. Each table may have one or more candidate keys, but one candidate key is unique, and it is called the primary key.

Report Error

View answer Workspace Report Error Discuss

1 2013
Q:

Foreign key in DBMS is

Answer

Foreign keys are the columns of a table that points to the primary key of another table. They act as a cross-reference between tables.


 


In detail : A Foreign key is a field (or collection of fields) in one table that uniquely identifies a row of another table or the same table. In simpler words, the foreign key is defined in a second table, but it refers to the primary key or a unique key in the first table.

Report Error

View answer Workspace Report Error Discuss

1 1982
Q:

What interests you about the position offered?

Answer

A seemingly simple question that is often difficult to answer, it can result in a great interview going disastrously wrong.


Here "What interests you about the position offered?" is a problematic question for anyone, even the most prepared interview candidate. It is one of those questions that might decide between selected individuals who have the same qualifications and experience.


When asked "what about this job interests you", the interviewer wants to know why you decided to apply specifically for this job and why do you consider this position fitting you and your career plans.


The best bet is to take the most important element of the said job and talk about it.


For example if the job requires effective team work capabilities, you may construct your answer in this way:


Question: What is the 'thing' that interests you about this job?


Answer: One of the things that are of my best interests in this job is the opportunity to work in a team environment. I always wanted to work with hard-working, professional, experienced people. I love contributing the team effort, bringing out the best in myself and in my teammates for fulfilling our work goals and reaching top results.


I trust that I can perform great by applying sound principles of teamwork as I did in my previous jobs. I seek timely and consistent feedback designed to improve not only my performance as well but the team’s performance as well. I consult with people, try my best and treat everyone positively/equally.


 


Tips to follow while answering this question ::



1. Be Specific


2. Be Truthful


3. Be Real

Report Error

View answer Workspace Report Error Discuss

2 1959
Q:

Which three amendments were passed shortly after the civil war?

Answer

The three major amendments that were passed shortly after the Civil War are the reconstruction amendments that were the 13th, 14th, and 15th amendments.


 


The 13th Amendment abolished slavery,


The 14th granted African American citizenship and equal protection before the law, (and)


The 15th Amendment attempted to secure the right to vote for newly freed slaves. 

Report Error

View answer Workspace Report Error Discuss

0 1917
Q:

You will always find me in the past. I can be created in the present, But the future can never taint me.

What am I?

Answer

I am History.


 


Yes, history refers to all the past, but we can create history in the presentand it cannot be polluted in the future.

Report Error

View answer Workspace Report Error Discuss

1 1908
Q:

The celebrated novel the godfather was authored by

A) Mario Puzo B) John Milton
C) Vito Corleone D) Harold Robbins
 
Answer & Explanation Answer: A) Mario Puzo

Explanation:

The_celebrated_novel_the_godfather_was_authored_by1556169940.jpg image

 

The celebrated novel the godfather was authored by Mario Puzo.

Report Error

View Answer Report Error Discuss

4 1876