Oracle and SQL
Description: Oracle and SQL | |
Number of Questions: 15 | |
Created by: Sanjiv Memon | |
Tags: Oracle and SQL Oracle Database |
Which of the following is the first step for using explicitly defined cursors within PL/SQL?
Which of the following methods in Oracle is a default method that allows a calling program to create new objects of that type?
Which of the following logical storage structures in Oracle is a contiguous group of blocks allocated for use as a part of table, index and so forth?
Which of the following schemas in distributed databases consists of fragments that are a part of logical portions of the global relation and that are physically dispersed at different sites of the network?
Which of the following layers in distributed query processing decomposes the distributed calculus query into an algebraic query on global relations?
Which of the following fragmentations in distributed database requires knowledge of the logical properties of the data and the statistical properties of the data such as the number of references of applications to the fragments?
Which of the following in Oracle architecture is a database management system that is able to store, manage and manipulate data?
Which of the following features of distributed database allows application developers and administrators to hide the physical location of database objects from applications and users?
Which of the following memory components of System Global Area (SGA) consists of an area in the memory that holds all the blocks read in from disk for query or modification?
Which of the following languages in SQL is involved in retrieval of data, insertion of new data and deletion or modification of existing data?
Which of the following exceptions is raised in PL/SQL when a select statement returns zero rows?
Which of the following in SQL represents the set of all permissible values for that particular column?
Which of the following is the first step in starting database in Oracle?
Which of the following files in Oracle is used to hold the names of privileged users who have been granted the SYSDBA and SYSOPER roles?
Which of the following loops does not exist in PL/SQL?