Sawaal

Database Administration Questions

Popular Latest Rated
Q:

Ctrl+F in MS Word for

A) Re do B) to find the word
C) Select all D) Center text
 
Answer & Explanation Answer: B) to find the word

Explanation:

Ctrl + F is a shorcut keyword and it is used for searching the word you want in the large document in the M.S. Word.

Report Error

View Answer Report Error Discuss

Filed Under: Computer
Exam Prep: AIEEE , Bank Exams , CAT
Job Role: Analyst , Bank Clerk , Bank PO , Database Administration , IT Trainer

2 2256
Q:

On BBC World News channel last night they showed an informative program about new innovations in medical imaging, which you would have found interesting.

A) there was an informative program about innovations in medical imaging, a program you would have found interesting. B) they showed an informative program about innovations in medical imaging, which you would have found interesting.
C) there was an informative program about new innovations in medical imaging, that you would have found interesting. D) they showed an informative program about new innovations in medical imaging, which you would have found interesting.
 
Answer & Explanation Answer: A) there was an informative program about innovations in medical imaging, a program you would have found interesting.

Explanation:

They is incorrect when talking of the television channel.

New is redundant.

And which must have a clear antecedent.

 

Hence, Only Option A satisfies and clears all the flaws in the given sentence.

Report Error

View Answer Report Error Discuss

Filed Under: Verification of Truth of the statement
Exam Prep: AIEEE , Bank Exams , CAT , GATE , GRE , TOEFL
Job Role: Analyst , Bank Clerk , Bank PO , Database Administration , IT Trainer , Project Manager

5 2251
Q:

APK full form in Android?

Answer

APK stands for Android Application Package.


 


Android Package (APK) is the package file format used by the Android operating system for distribution and installation of mobile apps and middleware.

Report Error

View answer Workspace Report Error Discuss

Subject: Application Development
Job Role: Database Administration , IT Trainer , Software Architect

3 2238
Q:

Zip files use what type of compression?

A) Lossless B) Lossy
C) Any of the above D) None of the above
 
Answer & Explanation Answer: A) Lossless

Explanation:

ZIP file is an archive file format that supports lossless data compression. Lossless is a fairly popular data compression method that is used in a number of different applications. Files can become corrupted when they are transferred over the internet in an uncompressed format. It enables devices to transmit or store the same amount of data in fewer bits.

Report Error

View Answer Report Error Discuss

Filed Under: Computer
Exam Prep: AIEEE , Bank Exams , CAT
Job Role: Analyst , Bank Clerk , Bank PO , Database Administration , IT Trainer , Network Engineer

4 2235
Q:

What is the purpose of SQL Profiler in SQL server?

Answer

SQL profiler is a tool to monitor performance of various stored procedures. It is used to debug the queries and procedures. Based on performance, it identifies the slow executing queries. Capture any problems by capturing the events on production environment so that they can be solved.

Report Error

View answer Workspace Report Error Discuss

Subject: Oracle Certification
Job Role: Database Administration

1 2223
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

Subject: Oracle Certification
Job Role: Analyst , Database Administration , IT Trainer , Software Architect

10 2219
Q:

Explain Data Definition Language

Answer

Data Definition Language (DDL):- are the SQL statements that define the database structure.


Example:



  1.  CREATE

  2.  ALTER

  3.  DROP

  4.  TRUNCATE

  5.  COMMENT

  6.  RENAME

Report Error

View answer Workspace Report Error Discuss

Subject: Oracle Certification
Job Role: Database Administration

1 2212
Q:

A database is used to

A) store data B) modify data
C) extract data D) All of the above
 
Answer & Explanation Answer: D) All of the above

Explanation:

A database is used to store, modify, extract and to search for the data within it.

Report Error

View Answer Report Error Discuss

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

7 2204