Discussion
Home ‣ Certification ‣ Oracle Certification Comments
- Question
A relational database developer refers to a record as
Options- A. a relation
- B. an attribute
- C. a criteria
- D. a tuple
- Correct Answer
- a tuple
ExplanationA relational database developer refers to a record as a tuple.
- 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 Discuss
- 2. What is the difference between oracle,sql and sql server? Discuss
- 3. Which among the following keys are used to identify each row of the table uniquely?
Options- A. Primary key
- B. Unique key
- C. Partial key
- D. None of the above Discuss
- 4. Explain Data Control Language Discuss
- 5. MOV extension refers usually to what kind of files?
Options- A. Audio
- B. Movies or other Videos
- C. Images
- D. Documents Discuss
- 6. Count function in SQL returns the number of
Options- A. groups
- B. values or rows
- C. columns
- D. distinct values Discuss
- 7. What is the purpose of SQL Profiler in SQL server? Discuss
- 8. What is XPath? Discuss
- 9. Explain Data Definition Language Discuss
- 10. What is Log Shipping? Discuss
Oracle Certification problems
Search Results
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.
Correct Answer: Oracle is based on RDBMS SQL is Structured Query Language SQL Server is another tool for RDBMS provided by MicroSoft
Correct Answer: Primary key
Explanation:
Primary key helps us to identify a row uniquely in a relation
Correct Answer: Data Control Language (DCL):-statements to take care of the security and authorization Examples: GRANT REVOKE
Correct Answer: Movies or other Videos
Explanation:
A .MOV file is a common multimedia container file format developed by Apple. It may contain multiple tracks that store different types of media data and is often used for saving movies and other video files.
Correct Answer: values or rows
Explanation:
Count function in SQL returns the number of values or rows.
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
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
Correct Answer: Data Definition Language (DDL):- are the SQL statements that define the database structure Example: CREATE ALTER DROP TRUNCATE COMMENT RENAME
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
Comments
There are no comments.Programming
Copyright ©CuriousTab. All rights reserved.