Sql Plus Questions
This document was uploaded by user and they confirmed that they have the permission to share it. If you are author or own the copyright of this book, please report to us by using this DMCA report form. Report DMCA
Overview
Download & View Sql Plus Questions as PDF for free.
More details
- Words: 390
- Pages: 3
1
ORACLE QUESTIONS & ANSWERS Questions What is a Database ?
What is a Database system ?
Answers A Database can be one of the two definitions: •
A set of dictionary tables and user tables that are treated as a unit.
•
One or more operating system files in which ORACLE stores the tables,views,and other objects:also, the set of database objects used by a given application.
•
A database is a collection of interrelated data that are to be stored in a single location. It enables sharing of data among various users as and when required.
A Database system is a combination of an Instance and a Database. If the instance is started and connected to an open database, then the database is available for access by the users. A DBMS is a software system with capabilities to organise, manipulate and manage the data. Note:A DBMS must be able to reliably manage a large amount of data in a multi-user environment so that many users can concurrently access the same data.
What is an RDBMS ?
What are the differnt Database models ? What is SQL ?
What are the benefits of SQL ?
A DBMS must also be secure from unauthorised access and provides eficient solutions for failure recovery. A relational database Mangement System (RDBMS) is a computer program for general purpose data storage and retrieval that organizes data into tables consisting of one or more units of information (rows), each containing the same set of data items (columns). ORACLE is a relational database management system. • Hierarchial. • Networking. • Relational. • S.Q.L - Structured Query Language.SQL is the ANSI industry standard language, used to manipulate information in a relational database and used in ORACLE and IBM DB2 relational database management systems. SQL is formally pronounced “sequel”, although common usage also pronounces it “S.Q.L.” • SQL is a set of commands that all programmers must use to access data within the tables of Database. 1. It is flexible, Powerful and easy to learn. 2. It is a non-procedural language. It a] Processes set of records rather than just one at a time and b] Provides automatic navigation to the data. 3. It provides commands for a variety of tasks including : a] Querying data b] Creating,Updating and Replacing objects and Inserting, Updating and Deleting rows. 2
3
ORACLE QUESTIONS & ANSWERS Questions What is a Database ?
What is a Database system ?
Answers A Database can be one of the two definitions: •
A set of dictionary tables and user tables that are treated as a unit.
•
One or more operating system files in which ORACLE stores the tables,views,and other objects:also, the set of database objects used by a given application.
•
A database is a collection of interrelated data that are to be stored in a single location. It enables sharing of data among various users as and when required.
A Database system is a combination of an Instance and a Database. If the instance is started and connected to an open database, then the database is available for access by the users. A DBMS is a software system with capabilities to organise, manipulate and manage the data. Note:A DBMS must be able to reliably manage a large amount of data in a multi-user environment so that many users can concurrently access the same data.
What is an RDBMS ?
What are the differnt Database models ? What is SQL ?
What are the benefits of SQL ?
A DBMS must also be secure from unauthorised access and provides eficient solutions for failure recovery. A relational database Mangement System (RDBMS) is a computer program for general purpose data storage and retrieval that organizes data into tables consisting of one or more units of information (rows), each containing the same set of data items (columns). ORACLE is a relational database management system. • Hierarchial. • Networking. • Relational. • S.Q.L - Structured Query Language.SQL is the ANSI industry standard language, used to manipulate information in a relational database and used in ORACLE and IBM DB2 relational database management systems. SQL is formally pronounced “sequel”, although common usage also pronounces it “S.Q.L.” • SQL is a set of commands that all programmers must use to access data within the tables of Database. 1. It is flexible, Powerful and easy to learn. 2. It is a non-procedural language. It a] Processes set of records rather than just one at a time and b] Provides automatic navigation to the data. 3. It provides commands for a variety of tasks including : a] Querying data b] Creating,Updating and Replacing objects and Inserting, Updating and Deleting rows. 2
3
Related Documents
Sql Plus Questions
November 2019 20
Sql-plus
October 2019 24
Sql Plus
November 2019 29
Sql And Sql Plus Basics
November 2019 26
Sql Questions
November 2019 5