Description : The different objects supported by MS_Access are tables, queries, ………… and reports. -Technology
Last Answer : The different objects supported by MS-Access are tables, queries, forms, and reports.
Description : What is the default extension of a MS_Access database? -Technology
Last Answer : The default extension of an MS-Access database is .accdb.
Description : Give five names of database templates used in MS_Access 2007. -Technology
Last Answer : Assets, Contacts, Events, Faculty and Issues.
Description : How will you create a blank database in MS_Access 2007? -Technology
Last Answer : Creating a Blank DatabaseTo create a new blank database, you need to perform the steps which are as follows:Step 1 Start Microsoft Access 2007, then Getting Started with Microsoft Office Access page will ... in the first empty cell in the Add New Field column as shown in the following figure:
Description : A text field is initially 40 characters long and one record has an entry in this field in MS_Access database. -Technology
Last Answer : Since the new field length is 20 characters long. So, this field will contain only left 20 characters including spaces and the remaining data will be discarded. Thus, the data from the right side of the field will be lost.
Description : When you open a database, the Ribbon appears on the left side of the MS_Access 2007 window. -Technology
Last Answer : False Because ribbon appears on the top of the window.
Description : Database is made up of all the following components except (a) tables (b) queries -Technology
Last Answer : (d) A database is made up of tables, queries, and forms.
Description : A database that contains tables linked by common fields is called a (a) Centralized database (b) Flat file database -Technology
Last Answer : (c) Relational database stores data in the form of tables which are linked by common fields.
Description : In a Bank’s database, there are two tables ‘Customer’ and ‘Transaction’ as shown below. -Technology
Last Answer : (i)Acc_No, Cust_Phone(ii)All the columns having capability to become Primary Key are known as Candidate Keys.(iii)Acc_No(iv)Trans_Id
Description : In a Bank’s database, there are two tables ‘Customer’ and ‘Transaction’ as shown below. Write a query to display customer’s name who has -Technology
Last Answer : (i) Select cust_name from customer c,transaction t where c.Acc_No=t.Acc_No and Transaction_Type= 'Debit';(ii)Select cust_name, t.* from customer c, transaction t where c.Acc_No=t.Acc_No;(iii) ... total amount of all type of transactions, it will only display the total of credit transactions only.
Description : Give the names of five data types used in MS_Access. -Technology
Last Answer : Text, Memo, Date/Time, Yes/No and Currency.
Description : Is it necessary to define a field type for a field in MS_Access? -Technology
Last Answer : Yes, it is necessary to define a type of a field while entering data into a field.
Description : What is the use of AutoNumber type field used in MS_Access? -Technology
Last Answer : AutoNumber data type starts with a number for the first record and it automatically increases the number by a set of amount for each record.
Description : What are the views in which fields can be deleted in MS_Access? -Technology
Last Answer : Datasheet View and Design View.
Description : Explain MS_Access Ribbon. -Technology
Last Answer : The Ribbon contains a series of command tabs. In MS-Access 2007, the main command tabs are as follows: Home Create External Data Database Tools DatasheetCommand TabCommon Things You ... columns of the table.Set the data type and formatting.Create table relationships and object dependencies.
Description : Define primary key. How do you set it in MS_Access? -Technology
Last Answer : Primary key is the key which is used to uniquely identify the records into the table. To set the primary key you have to follow the steps given below:Step 1 Select the field that you want ... 2 Click Primary Key button from the Design tab.orRight click on the selected field and select Primary Key.
Description : Which of the following is not a part of a table structure in MS_Access? (a) Field Name (b) Field Type -Technology
Last Answer : (d) From the given options Field Name, Field Type Primary Key are the part of a table.
Description : Identify the columns out of the given three, which should not be present in each of the following tables: -Technology
Last Answer : (i) DateofBirth(ii) Admno(iii) Phonenumber
Description : A cell entry can be edited either in the cell or in the formula bar. -Technology
Last Answer : True There are two ways to edit the data which has entered in the cell, i.e. in the cell or in the formula bar.
Description : A report allows you to represent data retrieved from one or more tables so that, it can be analysed and printed if required. -Technology
Last Answer : True When you want to print those records which are fetched from your database then, reports are more useful for this purpose.
Description : Which of the following is used to specify the beginning of a table’s row? (a) -Technology
Last Answer : (b) tag indicates the beginning of a table’s row.
Description : Which tag is used to add columns in the tables? (a) (b) -Technology
Last Answer : (b) is used to add columns in the tables.
Description : Which tags divide HTML tables in multiple section? -Technology
Last Answer : , and
Description : Define cell padding and cell spacing with respect to tables in HTML. -Technology
Last Answer : CELLSPACING controls the space between table cells and CELLPADDING sets the amount of space between the contents of the cell and the cell wall.
Description : With reference to the above given tables, write commands in SQL for (i) and (ii) and output for (iii) below: -Technology
Last Answer : (i) select TName, Passenger from Train T, Reservation R where T.TrainId=R.TrainId;(ii) select T.* from Train T, Reservation R where T.TrainId!=R.TrainId;(iii)TrainIdTNameSourceDestination3424Lucknow MailLucknowNew Delhi5400Century ExpressNew DelhiKanpur
Description : How many rows and column will be there in the Cartesian product of the above given tables. Also mention the degree and cardinality -Technology
Last Answer : Cartesian Product:Number of Rows: 20Number of Columns: 9Degree: 9Cardinality: 20
Description : Consider the following tables PATIENT and TEST and answer the questions that follow : -Technology
Last Answer : Primary key in PATIENT and TEST tables are PCODE and TESTID respectively. Because primary key of a relational table uniquely identifies each record.Foreign key in PATIENT table is TESTID whose value is derived from the primary key (TESTID) of another table (TEST).
Description : Consider the tables given below. Salesperson -Technology
Last Answer : (i) Primary, Foreign(ii) Salespersons cannot be set as the primary key in the table Orders because table Orders has already primary key and one table cannot have more than one primary key column.
Description : How are relationship between tables expressed in a relational database?
Last Answer : Tables are the basic building blocks of a relationaldatabase.
Description : Is it true or false that a relational database typically consists of related two dimensional tables?
Last Answer : Need answer
Description : What is the difference between tables and form database objects?
Last Answer : Database table objects store data. Form objects used byapplications provide a visually pleasing or sensible way ofaccessing or updating data contained in the database tables. Thismeans that the form object is a display specification.
Description : What are two virtual tables available during database trigger execution ?
Last Answer : The table columns are referred as OLD.column_name and NEW.column_name. For triggers related to INSERT only NEW.column_name values only available. For triggers related to UPDATE only OLD. ... values only available. For triggers related to DELETE only OLD.column_name values only available.
Description : What are the dictionary tables used to monitor a database space?
Last Answer : DBA_FREE_SPACE DBA_SEGMENTS DBA_DATA_FILES.
Description : What are the dictionary tables used to monitor a database spaces ?
Description : Upper CASE tools are used to create diagrams and generate code for database tables system functionality during the design phase.
Last Answer : Ans: False
Description : A relational database management (RDBM) package manages datain morethan one file at once. How does itorganizethese file? As A. tables B. relations C. tuple D. both (a)and (b) E. None of the above
Last Answer : both (a)and (b)
Description : Which of the following is included in the database collection: a) Schemes, Tables, Queries b) Queries, Report, Views and other Objects c) Both of Above d) None of These
Last Answer : c) Both of Above
Description : A database is typically composed of one or more: a) Columns b) Files c) Rows d) Tables e) None of These
Last Answer : d) Tables
Description : Which of the following describes a relational database? 1) It provides a relationship between integers 2) It consists of separate tables or related data 3) It retrieves data related to its queries 4) It provides a relationship between floats
Last Answer : 2) It consists of separate tables or related data
Description : Distance vector routing algorithm is a dynamic routing algorithm. The routing tables in distance vector routing algorithm are updated ........... (1) automatically (2) by server (3) by exchanging information with neighbour nodes. (4) with back up database
Last Answer : Answer: 3
Description : What is part of a database that holds only one type of information? -Technology
Last Answer : Field. Record. is the answer
Description : A software that searches through a database of Web pages for particular information is known as (a) domain -Technology
Last Answer : (d) Search engine searches a software through a database of Web pages for particular information.
Description : Give any one use of database. -Technology
Last Answer : A database is used to store logically related information in the table.
Description : Explain Database Management. What are the features of DBMS? -Technology
Last Answer : It refers to the software that is responsible for storing, maintaining and utilising a database. It enables a user to define, create and maintain the database and provide controlled access on it. A ... Data security e.g. MS-Access, Corel Paradox, Lotus Approach, MySQL, OpenOffice.org Base etc.
Description : What is database? Give example. -Technology
Last Answer : A collection of related information organized as tables is known as the database, e.g. INGRES, MySQL etc.
Description : Write the relationship between a database and a table. -Technology
Last Answer : A database contains multiple tables whereas, a table cannot exist outside a database.
Description : Write any two advantages of using database. -Technology
Last Answer : 1. Can ensure data security.2. Reduces the data redundancy.
Description : What is field in database? Give an example. -Technology
Last Answer : A field is an area, reserved for a specific piece of data. It is also known as an attribute, e.g. Customer_Name.
Description : Give any two disadvantages of the database. -Technology
Last Answer : 1. High complexity2. Database failure
Description : Write any two uses of database management system. -Technology
Last Answer : 1. DBMS is used to store data at a centralized location.2. It is used to minimize data redundancy and data inconsistency.