Discussion
Home ‣ Certification ‣ Oracle Certification Comments
- Question
Explain Data Control Language
- Correct Answer
- Data Control Language (DCL):-statements to take care of the security and authorization Examples: GRANT REVOKE
- 1. MOV extension refers usually to what kind of files?
Options- A. Audio
- B. Movies or other Videos
- C. Images
- D. Documents Discuss
- 2. what will be the output of the following code? class Value { public int i = 15; } public class Test { public static void main(String argv[]) { Test t = new Test(); t.first(); } public void first() { int i = 5; Value v = new Value(); v.i = 25; second(v, i); System.out.println(v.i); } public void second(Value v, int i) { i = 0; v.i = 20; Value val = new Value(); v = val; System.out.println(v.i + " " + i); } }
Options- A. 15 0 2
- B. 15 0 0
- C. 15 20 0
- D. 15 0 20 Discuss
- 3. What is the default return value of a function?
Options- A. int
- B. char
- C. string
- D. None of the above Discuss
- 4. What is an Oracle index? Discuss
- 5. What command would you use to create a backup control file? Discuss
- 6. 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
- 7. What is the difference between oracle,sql and sql server? Discuss
- 8. 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
- 9. A relational database developer refers to a record as
Options- A. a relation
- B. an attribute
- C. a criteria
- D. a tuple Discuss
- 10. Count function in SQL returns the number of
Options- A. groups
- B. values or rows
- C. columns
- D. distinct values Discuss
Oracle Certification problems
Search Results
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: 15 0 20
Correct Answer: int
Explanation:
The default return value from a function is int. In other words, unless explicitly specified the default return value by compiler would be integer value from function.
Correct Answer: An index is an optional structure associated with a table to have direct access to rows, which can be created to increase the performance of data retrieval Index can be created on one or more columns of a table
Correct Answer: Alter database backup control file to trace
Correct Answer: Primary key
Explanation:
Primary key helps us to identify a row uniquely in a relation
Correct Answer: Oracle is based on RDBMS SQL is Structured Query Language SQL Server is another tool for RDBMS provided by MicroSoft
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: a tuple
Explanation:
A relational database developer refers to a record as a tuple.
Correct Answer: values or rows
Explanation:
Count function in SQL returns the number of values or rows.
Comments
There are no comments.Programming
Copyright ©CuriousTab. All rights reserved.