Q1541
Easy
The object of access that stores the data is known as______
note!Answer: B) Table
Tables are the objects in Access that actually store data.
Computer & IT
कम्प्युटर
Subjects
Computer Fundamental
कम्प्युटरको आधारभूत ज्ञान Hardware, memory, generations, number systems 723 questionsComputer Networking
कम्प्युटर नेटवर्किङ Networks, internet, protocols 216 questionsOperating System
अपरेटिङ सिस्टम Windows, Linux, files and processes 248 questionsWord Processing
वर्ड प्रोसेसिङ MS Word and documents 588 questionsElectronic Spreadsheet
इलेक्ट्रोनिक स्प्रेडसिट MS Excel, formulas, charts 416 questionsPresentation System
प्रस्तुतीकरण प्रणाली MS PowerPoint and slides 116 questionsDatabase System
डाटाबेस प्रणाली DBMS, SQL, MS Access 347 questionsWebpage Designing
वेबपेज डिजाइन HTML, CSS and the web 142 questionsAll questions
Showing 1541–1560 of 2,796 · Mix the order
Q1542
Easy
______ uniquely identifies any field.
note!Answer: C) Primary key
A primary key uniquely identifies each record in a table.
Q1543
Easy
The extension of database file in Access is______
note!Answer: B) .MDB
Access database files traditionally use the .mdb extension (newer versions use .accdb).
Q1544
Easy
The maximum text field size in Access______
note!Answer: D) 255
The maximum field size for a Text field in MS Access is 255 characters.
Q1545
Easy
Which of the following is the database software?
note!Answer: B) MS ACCESS
MS Access is a database management system; the others are an operating system, word processor and spreadsheet.
Q1546
Medium
Storage size of date/time data type is______
note!Answer: A) 8 byte
In MS Access, the Date/Time data type uses 8 bytes of storage.
Q1547
Easy
A column in Access table is______
note!Answer: A) Field
A column in a table is called a field, while a row is a record.
Q1548
Easy
It uniquely identifies a record
note!Answer: B) Primary key
A primary key uniquely identifies each record in a table.
Q1549
Easy
The type of key or field that can not hold duplicate data
note!Answer: A) Primary key
A primary key must contain unique values and cannot contain duplicates.
Q1550
Medium
The field size of YES/NO data type is______
note!Answer: A) 1 bit
The Yes/No data type in Access uses a field size of 1 bit.
Q1551
Easy
What is the function of relationship?
note!Answer: A) Relate multiple tables
A relationship links two or more tables based on common fields.
Q1552
Medium
Which of the following data type does not exist in access?
note!Answer: B) Picture
Access has no Picture data type; images are stored using the OLE Object or Attachment types.
Q1553
Easy
Which one is unique field?
note!Answer: A) Primary key
A primary key field holds unique values for each record.
Q1554
Easy
What is the full form of E-R diagram?
note!Answer: B) Entity relational diagram
E-R stands for Entity-Relationship, a diagram that models entities and their relationships.
Q1555
Easy
What function does form?
note!Answer: D) All of the above
Forms let users add, delete and modify records in a table.
Q1556
Easy
Table is a ______
note!Answer: A) Row and column
A table is organised into rows and columns, which hold the records and fields of data.
Q1557
Easy
Which is the database application?
note!Answer: B) Access
Microsoft Access is a database application. Excel and spreadsheets are not database applications.
Q1558
Easy
Which is the database program?
note!Answer: A) Oracle
Oracle is a relational database management program. Word is a word processor and Excel is a spreadsheet.
Q1559
Easy
Restrict to database file use to another user we protect in
note!Answer: A) Exclusive mode
Opening a database in exclusive mode prevents other users from accessing the file at the same time.
Q1560
Easy
Which object extracts the subset of data?
note!Answer: C) Query
A query selects and extracts a subset of data from one or more tables based on criteria.