PrimeGyan
Home
O Level
M1-R5
M2-R5
M3-R5
M4-R5
CCC
Programming
Online Test
Hindi
Home
Online-test
Test
Database-technologies-set-3
18
Database Technologies Set 3
Databases Technologies Set 1
Database Technologies Set 2
Database Technologies Set 3
Database Technologies Set 3
1.
Course(course_id,sec_id,semester)Here the course_id,sec_id and semester are __________ and course is a _________
Relations, Attribute
Attributes, Relation
Tuple, Relation
Tuple, Attributes
2.
Maria DB is founded in the year of
2007
2009
2011
2013
3.
Is JSON Case sensitive ?
Yes
No
4.
A table must have _____ ?
Primary key
Composite key
Secondary key
Sort key
5.
In E-R model the details of the entities are hidden from the user. This process is called _____?
Generalization
Abstraction
Specialization
None of these
6.
An entity in A is associated with at most one entity in B, and an entity in B is associated with at most one entity in A. This is called as _____?
One-to-many
One-to-one
Many-to-one
Many-to-many
7.
Not applicable condition can be represented in relation entry as
NA
0
NULL
Blank Space
8.
What are the different types of clauses used in MariaDB?
MariaDB Where Clause
MariaDB Like Clause
Both A and B
None
9.
Which one of the following is a procedural language?
Tuple relational calculus
Relational algebra
Domain relational calculus
Query language
10.
The degree of a relationship refers to the:
Number of entities
Maximum cardinality
Minimum cardinality
Number of attributes in the identifiers
11.
In an E-R diagram an entity set is represent by a
rectangle
ellipse
diamond box
circle
12.
NoSQL databases is used mainly for handling large volumes of ______________ data.
unstructured
structured
semi-structured
all of the mentioned
13.
A two-dimensional table of data is called a _____?
Group
Set
Declaration
Relation
14.
A relation is analogous to a _____?
Field
File
Row
Record
15.
A domain is atomic if elements of the domain are considered to be ____________ units.
Divisible
Different
Indivisbile
Constant
16.
SELECT * FROM employee What type of statement is this?
DDL
DML
View
Integrity Constraint
17.
An example of a multi-valued attribute might be ______?
Student_Address
College_Degree
Student_GPA
ID_Number
18.
Relationships among entities of a single class are called _____________.
IS-A relationships
Recursive relationships
HAS-A relationships
None
19.
Which refers to connecting entities of different types when identifiers are different?
HAS-A relationships
IS-A relationships
Binary relationship
None
20.
In an E-R diagram a ellipse represents Attribute.
Weak entity
Relationship
Attribute
Entity class
21.
Entity is a _________.
Object of relation
Thing in real world
Present working model
Model of relation
22.
What is the interactive shell for MongoDB called?
mongo
mongodb
dbmong
none of the mentioned
23.
An entity type whose existence depends on another entity type is called _________ entity?
Strong
Weak
Dependent
Variant
24.
Which is not included in the definition of an entity?
Person
Object
Concept
Action
25.
If a university sets up a web-based information system that faculty could access to record student grades and to advise students, that would be an example of a/an
CRM
Intranet
ERP
None of the above
Submitting..
Welcome To PrimeGyan
Start test
Download