Databases Technologies Set 1

1. What are the different types of relationships in RDBMS?

One to Many

One to One

One to Multiple

A & B

2. DBMS provides the following feature:

Authorized access

Protect data from a system crash

Safety of the information stored

All of the above

3. The overall description of a database is called______.

Data manipulation

Data Updation

Data integrity

Database schema

4. A view of database that appears to an application program is known as:

Subschema

Schema

Virtual table

None of the above

5. The following are components of a database except ________.

User data

Metadata

Reports

Indexes

6. Minimal Superkeys is called

Domain keys

Attribute keys

Candidate keys

Schema keys

7. How many types of keys in Database Design?

Foreign key

Primary key

Candidate key

All of the Above

8. Row is synonymous with the term: a. b. c. d.

Record

Relation

tuple

A & C

9. How many types of aggregate functions in MariaDB?

10. Maria DB is founded in the year of 2009.

True

False

11. Maria DB is a Open Source Project and New replacement of MySql.

True

False

12. Maria DB is written in

C++

Perl

All of the above

13. DOUBLE also known as?

Real

Double Precision

Both A and B

Nor A and Nor B

14. We can disconnect from MariaDB through?

exit

break

push

terminate

15. NoSQL databases (not only SQL) are non-tabular databases and store data differently than relational tables.

True

False

16. What are the different types of clauses used in MariaDB?

MariaDB Like Clause

MariaDB Where Clause

Both A and B

None of the above

17. What are the types of JOIN in MariaDB?

Inner Join and Outer Join

Left Join and Right Join

Both a and b

None of the above

18. Which of the following is a NoSQL Database Type?

SQL

Document databases

JSON

All of the mentioned

19. MariaDB is a community-developed branch of the OpenSolaris database, which uses the Maria engine by default.

True

False

20. DDBMS is designed for heterogeneous database platforms.

True

False

21. The database schema is written in Data Control Language.

True

False

22. In MariaDB, the SELECT statement can be used with_________ statement.

Union

Deadlock

Isolation

Schema

23. Which one of the following attributes can be taken as a primary key?

Department

Street

Name

24. Which one of these is not a RDBMS?

MS Access

Drupal

Oracle

MySQL

25. Which of the below statements are not true?

DBMS creates each table in a file.

RDBMS is an operating system

RDBMS requires seperate hardware.

RDBMS. Oracle MS SQL Server MySQL are different database systems

Databases Technologies Set 1

Databases Technologies Set 1

1. What are the different types of relationships in RDBMS?

2. DBMS provides the following feature:

3. The overall description of a database is called______.

4. A view of database that appears to an application program is known as:

5. The following are components of a database except ________.

6. Minimal Superkeys is called

7. How many types of keys in Database Design?

8. Row is synonymous with the term: a. b. c. d.

9. How many types of aggregate functions in MariaDB?

10. Maria DB is founded in the year of 2009.

11. Maria DB is a Open Source Project and New replacement of MySql.

12. Maria DB is written in

13. DOUBLE also known as?

14. We can disconnect from MariaDB through?

15. NoSQL databases (not only SQL) are non-tabular databases and store data differently than relational tables.

16. What are the different types of clauses used in MariaDB?

17. What are the types of JOIN in MariaDB?

18. Which of the following is a NoSQL Database Type?

19. MariaDB is a community-developed branch of the OpenSolaris database, which uses the Maria engine by default.

20. DDBMS is designed for heterogeneous database platforms.

21. The database schema is written in Data Control Language.

22. In MariaDB, the SELECT statement can be used with_________ statement.

23. Which one of the following attributes can be taken as a primary key?

24. Which one of these is not a RDBMS?

25. Which of the below statements are not true?

Welcome To PrimeGyan