Oracle Certification Questions

• A Transparent DBMS
• A relational database developer refers to a record as
• Count function in SQL returns the number of
• What is the purpose of SQL Profiler in SQL server?
• What is XPath?
• Explain Data Definition Language
• What is Log Shipping?
• What is the difference between a Local and a Global temporary table?
• Which command is used to return maximum value from result set?
• A column defined as UNIQUE can contain Nulls while a column defined as PRIMARY KEY can't contain Nulls
• Foreign key in DBMS is
• Difference between Union and Union all?
• Candidate Key in DBMS?
• The SQL keyword(s) ________ is used with wildcards.
• Which of the following is a comparison operator in SQL?
• Go command is a signal to execute the entire batch of SQL statements after previous Go
• Copying the logs on the standby/backup server is an operation of Log Shipping
• Multiple users can share a local temporary table
• STUFF and REPLACE are used to replace characters in a string
• Breaking of relationships is allowed once referential integrity on a database is enforced