if you want to remove an article from website contact us from top.

    which of the following database object is used to store data

    Mohammed

    Guys, does anyone know the answer?

    get which of the following database object is used to store data from screen.

    [Solved] Which of the following database object does not physically e

    The correct option is (3) View Concept:- A view is a result set of a stored query on the data in which the database users can query just as they would in a d

    Home DBMS Query Language Relational Model

    Question

    Download Solution PDF

    Which of the following database object does not physically exist?

    This question was previously asked in

    Rajasthan Basic Computer Instructor 18 June 2022 Official Paper 2

    Download PDF Attempt Online

    View all Rajasthan Computer Teacher Papers >

    Base table Index View None of the above

    Answer (Detailed Solution Below)

    Option 3 : View

    Crack CTET + State TET + PRT + TGT + PGT with

    India's Super Teachers

    FREE

    Demo Classes Available*

    Explore Supercoaching For FREE

    Free Tests

    View all Free tests >

    FREE

    Programming Fundamentals Mock Test

    15.8 K Users

    10 Questions 10 Marks 12 Mins

    Start Now

    Detailed Solution

    Download Solution PDF

    The correct option is (3)

    View

    Concept:-

    A view is a result set of a stored query on the data in which the database users can query just as they would in a database collection.

    Key Points

    In SQL, a view is a virtual table based on the result-set of an SQL statement.

    A view contains rows and columns, just like a real table. The fields in a view are fields from one or more real tables in the database.

    Views are used for security purposes because they provide encapsulation of the name of the table.

    An index is a database structure that you can use to improve the performance of database activity. A database table can have one or more indexes associated with it.

    System base tables are the underlying tables that actually store the metadata for a specific database.

    A base table is any table in the database where you are positioned and working at a certain time, for example for retrieving or modifying its data.

    Download Solution PDF

    Share on Whatsapp

    Latest Rajasthan Computer Teacher Updates

    Last updated on Oct 12, 2022

    The RSMSSB has released the DV Schedule. The RSMSSB Computer Teacher DV will be conducted from 17th to 21st October 2022 and then from 27th October 2022 to 7th November 2022. Earlier, RSMSSB Computer Teacher Result and cut off was out. Candidates who have qualified the written exam will appear for the Document Verification round. The RSMSSB had announced 10157 vacancies for Basic Computer Teacher and Senior Computer Teacher posts. Candidates with a Graduate/ Post Graduate degree could apply for these posts.

    India’s #1 Learning Platform

    Start Complete Exam Preparation

    Daily Live MasterClasses

    Practice Question Bank

    Mock Tests & Quizzes

    Get Started for Free

    Download App

    Trusted by 3.4 Crore+ Students

    ‹‹ Previous Ques Next Ques ››

    More Relational Model Questions

    Q1. Which of the following database object does not physically exist?Q2. In relational database minimal super keys is known as -Q3. Consider the following statements regarding key - (I) A super key is an attribute or combination of attributes that uniquely identify records in an RDBMS table. (II) A candidate key is a subset of a super key. (III) All super keys are candidate keys but vice versa is not true.Q4. Which of the following is not a super key in a relational schema with attributes V, W, X, Y, Z and primary key VY?Q5. Key to represent the relationship between tables is calledQ6. In a relational database, a referential integrity constraint can be specified with the help of:Q7. The special field used to identify the specific records that cannot be duplicated is classified as a form ______.Q8. A field used to access a specific record is called:Q9. Which of the following do you need to consider when you make a table in SQL?

    More Query Language Questions

    Q1. Which of the following statement contains an error?Q2. If SQL command DELETE FROM EMPLOYEE; is executed on relation EMPLOYEE having 'n' tuple in it, ______ will be deleted from relation EMPLOYEE.Q3. In SQL ______ is an aggregate function.Q4. Which of the following database object does not physically exist?Q5. In tuple relational calculus P1 → P2 is equivalent to –Q6. Which of the operations constitute a basic set of operations for manipulating relational data?Q7. In relational database minimal super keys is known as -Q8. Match the following - List I List II (a) DDL (i) LOCK TABLE (b) DML (ii) COMMIT (c) TCL (iii) Natural Difference (d) Binary operation (iv) REVOKEQ9. Consider the following statements regarding key - (I) A super key is an attribute or combination of attributes that uniquely identify records in an RDBMS table. (II) A candidate key is a subset of a super key. (III) All super keys are candidate keys but vice versa is not true.Q10. Which of the following is valid pair of schema change statements in SQL?

    स्रोत : testbook.com

    Which of the following database objects holds data

    Which of the following database objects holds data? a) Forms b) Reports c) Queries d) Tables

    Which of the following database objects holds data

    Home / Green Board / Miscellaneous / Question

    kaabara saha 4 years ago

    Which of the following database objects holds data?

    A. Forms B. Reports C. Queries D. Tables

    Answer: Option D

    Join The Discussion

    Related User Ask Questions

    Which of the following is not a primary function of a Bank?

    A. Granting Loans

    B. Collecting Cheques/Drafts customers

    C. Facilitating import of goods

    D. Issuing Bank Drafts

    View Answer

    Though ULIPs (Unit Linked Insurance Plan) are considered to be a better investment vehicle it has failed to capture the imagination of the retail investors in India because of which of the following reasons?

    A. Regulatory jurisdictional fight between SEBI and IRDA

    B. They don’t offer better tax benefits

    C. They offer lesser returns compared to traditional insurance policies

    D. All of the above View Answer

    The Chameli Devi Jain Award is given for an outstanding woman ____?

    A. Scientist B. Reporter C. Player D. Teacher View Answer

    HDFC bank has been named among 50 most valuable banks in 2014. It has got 45th rank. Wells Fargo & Co. has got first rank in this list. This bank belongs to which country?

    A. UK B. France C. European Union D. USA View Answer

    View all User Ask Questions

    Read More: MCQ Type Questions and Answers

    Arithmetic Ability

    Competitive Reasoning

    Competitive English Data Interpretation General Knowledge History Geography Current Affairs Banking Awareness

    Computer Fundamentals

    Networking C Program Java Program SQL Database HTML CSS Javascript PHP Computer Science

    Electrical Engineering

    Mechanical Engineering

    Civil Engineering

    Chemical Engineering

    Commerce Management

    स्रोत : www.examveda.com

    Access 2013: Introduction to Objects

    In Access objects include tables, queries, forms, and reports. These objects in Access help keep your database usable.

    Tutorial

    Access 2013: Introduction to Objects

    Introduction

    Databases in Access are composed of four objects: tables, queries, forms, and reports. Together, these objects allow you to enter, store, analyze, and compile your data however you want.

    In this lesson, you will learn about each of the four objects and come to understand how they interact with each other to create a fully functional relational database.

    Tables

    By this point, you should already understand that a database is a collection of data organized into many connected lists. In Access, all data is stored in tables, which puts tables at the heart of any database.

    You might already know that tables are organized into vertical columns and horizontal rows.

    In Access, rows and columns are referred to as records and fields. A field is more than just a column; it’s a way of organizing information by the type of data it is. Every piece of information within a field is of the same type. For example, every entry in a field called First Name would be a name, and every entry in field called Street Address would be an address.

    Likewise, a record is more than just a row; it's a unit of information. Every cell in a given row is part of that row’s record.

    Notice how each record spans several fields. Even though the information in each record is organized into fields, it belongs with the other information in that record. See the number at the left of each row? It’s the ID number that identifies each record. The ID number for a record refers to every piece of information contained on that row.

    Tables are good for storing closely related information. Let's say you own a bakery and have a database that includes a table with your customers' names and information, like their phone numbers, home addresses, and email addresses. Because these pieces of information are all details on your customers, you’d include them all in the same table. Each customer would be represented by a unique record, and each type of information about these customers would be stored in its own field. If you decided to add any more information—say, a customer's birthday—you would simply create a new field within the same table.

    Forms, queries, and reports

    Although tables store all of your data, the other three objects—forms, queries, and reports—offer you ways to work with it. Each of these objects interacts with the records stored in your database's tables.

    Forms

    Forms are used for entering, modifying, and viewing records. You likely have had to fill out forms on many occasions, like when visiting a doctor's office, applying for a job, or registering for school. The reason forms are used so often is that they're an easy way to guide people toward entering data correctly. When you enter information into a form in Access, the data goes exactly where the database designer wants it to go: in one or more related tables.

    Forms make entering data easier. Working with extensive tables can be confusing, and when you have connected tables you might need to work with more than one at a time to enter a set of data. However, with forms it's possible to enter data into multiple tables at once, all in one place. Database designers can even set restrictions on individual form components to ensure all of the needed data is entered in the correct format. All in all, forms help keep data consistent and organized, which is essential for an accurate and powerful database.

    Queries

    Queries are a way of searching for and compiling data from one or more tables. Running a query is like asking a detailed question of your database. When you build a query in Access, you are defining specific search conditions to find exactly the data you want.

    Queries are far more powerful than the simple searches you might carry out within a table. While a search would be able to help you find the name of one customer at your business, you could run a query to find the name and phone number of every customer who's made a purchase within the past week. A well-designed query can give information you might not be able to find just by looking through the data in your tables.

    स्रोत : edu.gcfglobal.org

    Do you want to see answer or more ?
    Mohammed 6 day ago
    4

    Guys, does anyone know the answer?

    Click For Answer