Which is adatabase software?
- Dbase (SSC CHSL 21 March 1st Shift 2023)
is an object model language standard.
OQL (SSC CHSL 201 7)
performs tasks such as inserting, updating or
deleting data occurrences
Data Manipulation Language (SSC CHSL 2017)
allowssearching for information and computing
derived information. Query language (SSC CHSL 2017)
defines data types and the relationships among
them. - Data Definition Language (SSC CHSL 2017)
is a language for the specification of procedures
for the retrieval (and sometimes also modification) of
information from a database.
- Query Language (SSC JE 2017)
In IT, means that the data available in the database is both
accurate and consistent - Data Integrity (SSC CGL 2016)
Data in database set a particular point of time is called as
- Application (SSC CGL 2016)
The property that uniquely identifies the rows of a table is
called what key? - Primary(SSC MTS 2013)
The is a simple query language used for assessing
handling and managing data in arelation database.
- SQL (RRB NTPC 2021)
A
collection of interrelated files and a set of programs that
allow users to access and modify these files is known as.
-Database Management System (RRB NTPC 2021)
Acandidate key that is not the primary key is a/an.
-Alternate Key (UPPCL ARO 2018)
Set of one or more attributes that can uniquely identify
tuples within a relation is called
- Primary Key (UPPCL APS 2018)
Whichspecify how many instances of an entity related to
one instance of another entity?
- Cardinality (UPP Computer Operator 2018)
In RDBMS data is stored in
- Tables (UPP Computer Operator 2018)
Columns of a relation are generally referred to as
-Attributes (UPPCL ARO 2018)
What is the collection of interrelated data and a set of
programs to access those data? - Database Management
System (UPP Computer Operator 2018)
constitute the basic set of operations for a
relational database. - Relational Algebra (UPPCL, ARO 2018)
In a Relational Data Model, which option describes how.
the data can be manipulated for querying?
Operations (UPP Computer Operator 2018)
are usedto speed up searching.
- Indices (UPPCL APS 2018)
The number of rows in a relation (table) is called of
the relation. -Cardinality (UPPCL APS 2018)
The process of reducing data is redundancy in a relational
database is called
- Normalization (UPPCL APS 2018)
A is the primary unit of physical storage for data in
a database - Table (UPPCL APS 2018)
The row of the table is known as
- Record (UPPCL RO/ARO2014)
What is a'tuple'?
- It corresponds to a row in the table (NVS PGT 2019)
Which creates a drop down list to select values in MS
Access -Look up Wizard (Rajasthan Rajasthan Information
Assistant Exam 2013)
Audit Tral is -Recorded History of actions done on File
(Rajasthan Information tics Assistant Exam 2013)
Themaximum character length of Field Name in MS Access
2007 is
-64 (Rajasthan InformationAssistant Exam 2013)
What to do toenter password in MS Access database- Tools
-Security Set Database Password (Rajasthan Information
Assistant Exam 2008)
Microsoft Access -00DBMS (Rajasthan Information
Assistant Exam 2013)
Which objectsare used tocreate Form in MS Access -Tables
andQueries (Rajasthan Information Assistant-2008)
Data base structure at create a fag Data base Language
- DDL (Rajasthan Information Assistant-2013)
Columns in Microsoft Access tables are called
-Fields (Rajasthan Information Assistant Exam 2011)
If a computer provides database facility to another then it
is known as -Database Server
(Rajasthan Patwari Preliminary
Exam 13February, 2016)
Example of data is - Name of Students, Roll Number,
Account Number (Rajasthan Grade (Biology) 23 july, 2016)
How much memory size is required to store
type data in MS Access
currency data
-8Bytes (Rajasthan Junior Instructor 2019)
.... is used to develop the backend of the
application
Database (Rajasthan LDC Exam- 16 September, 2018)
With which extension do you save the database in
Access
- mdb (Rajasthan Information Assistant Exam 12
May, 2018)
Which of the following is not a recovery technique - Two
Phase Commit (Rajasthan Information Assistant Exam 12
May, 2018 )
Which is not a data type in Microsoft Access - Picture/Graphic
(Rajasthan Information Assistant Exam 2008)
V.B. What is control in
-Objects (Rajasthan Information Assistant Exam 2008)
In DBMS you can - Create File, Delete File, Retrieve File
(Rajasthan Information Assistant-2008)
The statement which is automatically issued due to any
modification in the database is called- Triggers (Rajasthan
Information Assistant Exam 12 May 2018)
The full name of ODBC is - Open
Data Base Connectivity
(Rajasthan BasicComputer Instructor - 18 June, 2022)
There is an aggregate function in SQL
-AVG (Rajasthan Basic
Computer Instructor-18 June, 2022)
What is used to maintain physical view of RDBMS -
Trigger
(RajasthanInformation Assistant Exam 12 May, 2018)
What is the full form of DDE- Dynamic Data Exchange
(Rajasthan Information Assistant Exam 12 May, 2018)
Field in a database is a
- Range of Information (MPPSC 2008)
provides the facility to reduce all the problems
related to essential data, inconsistencies, dependencies
and unauthorized access. - DBMS (IBPS2012)
Acomputer checks the username and password for
before use. - Database (SBIClerk 2011)
Database stores information in
-Rows and Columns (SBIPO 2011)
The smnallest unit of information about a record in a
database is called - Field (SBI PO 2010)
2012)
Agroup of related records is called- database (RBI
Oracle is - Data Software (Utt PCS 2002)