Discussion
Home ‣ Certification ‣ Oracle Certification Comments
- Question
How many joining conditions are required to join 4 tables in SQL?
Options- A. 1
- B. 2
- C. 3
- D. 4
- Correct Answer
- 3
ExplanationTo join 'n' tables 'n-1' conditions should be satisfied.
So to join 4 tables 3 conditions should be satisfied.
- 1. What are the different types of SQL statements ? Discuss
- 2. 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
- 3. Insert command falls in which sub-language of SQL ?
Options- A. DCL
- B. DQL
- C. DML
- D. DDL Discuss
- 4. Define Executive Plan in Database SQL ? Discuss
- 5. In the following pieces of code, B and D will compile without any error. True or false ? A: StringBuffer sb1 = "abcd"; B: Boolean b = new Boolean("abcd"); C: byte b = 255; D: int x = 0x1234; E: float fl = 1.2;
Options- A. TRUE
- B. FALSE Discuss
- 6. What command would you use to create a backup control file? Discuss
- 7. What is an Oracle index? Discuss
- 8. What is the default return value of a function?
Options- A. int
- B. char
- C. string
- D. None of the above Discuss
- 9. 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
- 10. MOV extension refers usually to what kind of files?
Options- A. Audio
- B. Movies or other Videos
- C. Images
- D. Documents Discuss
Oracle Certification problems
Search Results
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: TRUE
Explanation:
The code segments B and D will compile without any error. A is not a valid way to construct a StringBuffer, you need to create a StringBuffer object using "new". B is a valid construction of a Boolean (any string other than "true" or "false" to the Boolean constructor will result in a Boolean with a value of "false"). C will fail to compile because the valid range for a byte is -128 to +127 (i.e., 8 bits, signed). D is correct, 0x1234 is the hexadecimal representation in java. E fails to compile because the compiler interprets 1.2 as a double being assigned to a float (down-casting), which is not valid. You either need an explicit cast, as in "(float)1.2" or "1.2f", to indicate a float.
Correct Answer: Alter database backup control file to trace
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.
Comments
There are no comments.Programming
Copyright ©CuriousTab. All rights reserved.