Oracle Certification problems
- 1. What are the different types of SQL statements ? Also asked in: Database Administrator
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
- 2. How many joining conditions are required to join 4 tables in SQL?
Options- A. 1
- B. 2
- C. 3
- D. 4 Also asked in: Analyst, Database Administrator, IT Trainer
Correct Answer: 3
Explanation:
To join 'n' tables 'n-1' conditions should be satisfied.
So to join 4 tables 3 conditions should be satisfied.
- 3. What command would you use to create a backup control file? Also asked in: Database Administrator
Correct Answer: Alter database backup control file to trace
- 4. What is an Oracle index? Also asked in: Database Administrator
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
- 5. What is the default return value of a function?
Options- A. int
- B. char
- C. string
- D. None of the above Also asked in: Database Administrator
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.
- 6. 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 Also asked in: Analyst, IT Trainer, Project Manager, Software Architect
Correct Answer: 15 0 20
- 7. MOV extension refers usually to what kind of files?
Options- A. Audio
- B. Movies or other Videos
- C. Images
- D. Documents Also asked in: AIEEE, Bank Exams, Database Administrator, Bank Clerk, Analyst, IT Trainer
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.
- 8. Explain Data Control Language Also asked in: Database Administrator
Correct Answer: Data Control Language (DCL):-statements to take care of the security and authorization Examples: GRANT REVOKE
- 9. 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 Also asked in: Database Administrator
Correct Answer: Primary key
Explanation:
Primary key helps us to identify a row uniquely in a relation
- 10. What is the difference between oracle,sql and sql server? Also asked in: Database Administrator
Correct Answer: Oracle is based on RDBMS SQL is Structured Query Language SQL Server is another tool for RDBMS provided by MicroSoft
Programming
Copyright ©CuriousTab. All rights reserved.