Oracle Certification problems
- 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 Also asked in: Analyst, Database Administrator, IT Trainer, Network Engineer, Project Manager, Software Architect
Correct Answer: Keeps its physical structure hidden from users
Explanation:
DBMS :: Database Managemet System.
A DBMS which keeps its physical structure hidden from the user is known as a transparent DBMS.
- 2. A relational database developer refers to a record as
Options- A. a relation
- B. an attribute
- C. a criteria
- D. a tuple Also asked in: Database Administrator, IT Trainer, Project Manager, Software Architect
Correct Answer: a tuple
Explanation:
A relational database developer refers to a record as a tuple.
- 3. Count function in SQL returns the number of
Options- A. groups
- B. values or rows
- C. columns
- D. distinct values Also asked in: Database Administrator, IT Trainer
Correct Answer: values or rows
Explanation:
Count function in SQL returns the number of values or rows.
- 4. What is the purpose of SQL Profiler in SQL server? Also asked in: Database Administrator
Correct 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
- 5. What is XPath? Also asked in: Database Administrator
Correct Answer: XPath is an expressions to select a xml node in an XML document It allows the navigation on the XML document to the straight to the element where we need to reach and access the attributes
- 6. Explain Data Definition Language Also asked in: Database Administrator
Correct Answer: Data Definition Language (DDL):- are the SQL statements that define the database structure Example: CREATE ALTER DROP TRUNCATE COMMENT RENAME
- 7. What is Log Shipping? Also asked in: Database Administrator
Correct Answer: Log shipping defines the process for automatically taking backup of the database and transaction files on a SQL Server and then restoring them on a standby/backup server This keeps the two SQL Server instances in sync with each other In case production server fails, users simply need to be pointed to the standby/backup server Log shipping primarily consists of 3 operations: Backup transaction logs of the Production server Copy these logs on the standby/backup server Restore the log on standby/backup server
- 8. What is the difference between a Local and a Global temporary table? Also asked in: Database Administrator
Correct Answer: Local : Only available to the current Db connection for current user and are cleared when connection is closed Multiple users can?t share a local temporary table Global: Available to any connection once created They are cleared when the last connection is closed Can be shared by multiple user sessions
- 9. Which command is used to return maximum value from result set?
Options- A. MAX
- B. MIN
- C. MAXIMUM
- D. MAXI Also asked in: Database Administrator
Correct Answer: MAX
Explanation:
MAX command is used to return maximum value from result setMAX
- 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 Also asked in: Database Administrator
Correct Answer: TRUE
Explanation:
Because a table can have only one primary key
Programming
Copyright ©CuriousTab. All rights reserved.