Database Administration Questions


Q:

Which planet is known as the Morning Star or the Evening Star?

A) Jupiter B) Venus
C) Mercury D) Saturn
 
Answer & Explanation Answer: B) Venus

Explanation:

Venus planet is known as the Morning Star or the Evening Star.

Report Error

View Answer Report Error Discuss

5 1823
Q:

A search engine is a program to search

A) files in the www B) documents in the www
C) Both A & B D) None of the above
 
Answer & Explanation Answer: C) Both A & B

Explanation:

A search engine is a set of programs which enables users to search documents and files ihe world wide web.

 

Common search engines are Google, Yahoo, Bing,...

Report Error

View Answer Report Error Discuss

1 1798
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 1794
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 1778
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 1752
Q:

Difference between Union and Union all?

Answer

The difference between Union and Union all is that Union all will not eliminate duplicate rows, instead it just pulls all rows from all tables fitting your query specifics and combines them into a table. A UNION statement effectively does a SELECT DISTINCT on the results set.

Report Error

View answer Workspace Report Error Discuss

1 1743
Q:

You can use display planner to

A) add ads B) research keywords
C) display network D) All of the above
 
Answer & Explanation Answer: C) display network

Explanation:

Display Planner is a free Google Ads tool you can use to plan your Display Network ad campaigns.

Report Error

View Answer Report Error Discuss

0 1739
Q:

Which of the following topologies has the highest reliability?

A) Mesh B) Ring
C) Bus D) Star
 
Answer & Explanation Answer: A) Mesh

Explanation:

In the mesh topology, each computer is connected to the other with a separate physical link in a network. It is most reliable topology as the network does not get down in case one of the nodes is failed.

Report Error

View Answer Report Error Discuss

1 1739