Discussion
Home ‣ Certification ‣ Oracle Certification Comments
- Question
What command would you use to create a backup control file?
- Correct Answer
- Alter database backup control file to trace
- 1. How many joining conditions are required to join 4 tables in SQL?
Options- A. 1
- B. 2
- C. 3
- D. 4 Discuss
- 2. What are the different types of SQL statements ? Discuss
- 3. In R-DBMS, the data is organized in the form of _____.
Options- A. Hierarchical structure
- B. Tabular structure
- C. Linked structure
- D. All of the above Discuss
- 4. Insert command falls in which sub-language of SQL ?
Options- A. DCL
- B. DQL
- C. DML
- D. DDL Discuss
- 5. Define Executive Plan in Database SQL ? Discuss
- 6. What is an Oracle index? Discuss
- 7. What is the default return value of a function?
Options- A. int
- B. char
- C. string
- D. None of the above Discuss
- 8. 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
- 9. MOV extension refers usually to what kind of files?
Options- A. Audio
- B. Movies or other Videos
- C. Images
- D. Documents Discuss
- 10. Explain Data Control Language Discuss
Oracle Certification problems
Search Results
Correct Answer: 3
Explanation:
To join 'n' tables 'n-1' conditions should be satisfied.
So to join 4 tables 3 conditions should be satisfied.
Correct Answer: SQL statements are broadly classified into three They are 1 DDL ? Data Definition Language DDL is used to define the structure that holds the data For example, Create, Alter, Drop and Truncate table 2 DML ? Data Manipulation Language DML is used for manipulation of the data itself Typical operations are Insert, Delete, Update and retrieving the data from the table The Select statement is considered as a limited version of the DML, since it can't change the data in the database But it can perform operations on data retrieved from the DBMS, before the results are returned to the calling function 3 DCL ? Data Control Language DCL is used to control the visibility of data like granting database access and set privileges to create tables, etc Example - Grant, Revoke access permission to the user to access data in the database
Correct Answer: Tabular structure
Explanation:
Data is organized in the form of row and columns, thus it is in tabular structure.
Correct Answer: DML
Correct Answer: Executive plan can be defined as: * SQL Server caches collected procedure or the plan of query execution and used thereafter by subsequent calls * An important feature in relation to performance enhancement * Data execution plan can be viewed textually or graphically
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: 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: 15 0 20
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: Data Control Language (DCL):-statements to take care of the security and authorization Examples: GRANT REVOKE
Comments
There are no comments.Programming
Copyright ©CuriousTab. All rights reserved.