logo

CuriousTab

Oracle Certification (Certification) Question and Answers-Page 3

Oracle Certification problems


Share: 
  • 1. A Transparent DBMS

  • Options
  • A. Keep its logical structure hidden from users
  • B. Can access control
  • C. Keeps its physical structure hidden from users
  • D. Can not hide sensitive information from users

  • Tags: Analyst, Database Administrator, IT Trainer, Network Engineer, Project Manager, Software Architect

  •           Discuss     


  • 3. Count function in SQL returns the number of

  • Options
  • A. groups
  • B. values or rows
  • C. columns
  • D. distinct values

  • Tags: Database Administrator, IT Trainer

  •           Discuss     

  • 4. What is the purpose of SQL Profiler in SQL server?

  • Tags: Database Administrator

  •           Discuss     

  • 5. What is XPath?

  • Tags: Database Administrator

  •           Discuss     

  • 6. Explain Data Definition Language

  • Tags: Database Administrator

  •           Discuss     

  • 7. What is Log Shipping?

  • Tags: Database Administrator

  •           Discuss     

  • 8. What is the difference between a Local and a Global temporary table?

  • Tags: Database Administrator

  •           Discuss     

  • 9. Which command is used to return maximum value from result set?

  • Options
  • A. MAX
  • B. MIN
  • C. MAXIMUM
  • D. MAXI

  • Tags: Database Administrator

  •           Discuss     

  • 10. A column defined as UNIQUE can contain Nulls while a column defined as PRIMARY KEY can't contain Nulls

  • Options
  • A. TRUE
  • B. FALSE

  • Tags: Database Administrator

  •           Discuss     


First 2 3 4 5