Questions tagged [dbms]

Question 1

I have moved into a DBA role where I now manage multiple types of DBs. I used to manage only MS SQL and MySQL, but now I am managing MS SQL, Azure SQL, MySQL, MariaDB and PostgreSQL. I am currently ...

Question 2

Suppose I have this database CREATE TABLE Students ( StudentID INT PRIMARY KEY, Name VARCHAR(255) NOT NULL, Roll INT NOT NULL, CustomID INT UNIQUE ); INSERT INTO Students (StudentID, ...

Question 3

In teradata sql I get an error when I use sel * from table where sk = null However if I include this in a stored procedure and pass a null value in the parameter I don't. replace procedure(In name ...

Question 4

In DBMSes like MySQL, MariaDB, PostgreSQL and MongoDB, data is saved as BSON, JSON or JSONB for JSON columns or document. All of these data types use space for key names in JSON. Does internal data on ...

Question 5

I am a java full stack developer who want to write oracle sql queries to simplify writing is there any mysql workbench like similar gui tool for oracle by oracle or any other please sugest

Question 6

I am creating an double entry accounting software where I have ledger table along with other tables. My cash account ledger table for is similar to following: ledger_id ledger_name ledger_trnx_ammount ...

Question 7

In a DBMS like MySQL, are the underlying files that contain the data encrypted since we want to have role and user based control? If they are encrypted, what encryption keys and algorithms are used? ...

Question 8

Here, Read_item(B); and B;=B+temp; have written parallelly. what happen here? What is the problem associated with the above transaction schedule?

Question 9

Currently I am working on a project of a management software. This software is currently in built with an old technology (Codeigniter-PHP). My job is to convert this software to latest technology (...

Question 10

I'm comparing the advantages and disadvantages of File system (journaling and COW) and Database (SQL and Non-SQL). Not only from the developer's point of view, I also want to know further what are the ...

Question 11

In following table how to print the student number when age occur two or more times, The result should be only column Sno i.e. Result Sno Reason 1 because 18 occur two times 2 because 20 occur three ...

Question 12

I want to make an ER diagram for scientific research papers, one of the constraints is that a paper shouldn't cite itself. I'm not very sure how to achieve this, as this question points out, the ER ...

Question 13

I am trying to get a better understanding of an answer by @GarethD in https://stackoverflow.com/questions/24188350/incorrect-syntax-near-keyword-option-in-cte-statement?rq=1#answer-24188586 . In that ...

Question 14

Given two relations R(A,B) with r tuples, S(B,C) with s tuples (r>0, s>0), find the min and max number of tuples in this relation: R U πA,B ( R⋈S ) Given options are: -min:r, max:r+s -min:0, ...

Question 15

I can't differentiate DBMS, database server and database client. Mysql, for instance, has Mysql shell, Mysql workbench, etc. If Mysql is a DBMS, then are Mysql shell and Mysql workbench both database ...

Stack Exchange Network

Questions tagged [dbms]

DBMS for multiple DB Enviroment Management

Column information from View

Where sk = null clause gives an error when used in a query but not in a stored procedure in teradata

Should i care about field names in JSON datatypes?

MYSQL workbench like gui tool for oracle 10 g or more

Update Ledger Table In double entry accounting when there are millions of entries

How does MySQL maintain confidentiality of files?

Problem associated with transaction schedule

Should I use many database in one application?

Maintenance : File system vs Database

Print all the row with two or more element in the column

Entity relation with itself

Are SQL views anything more than saved text?

FInd minimum and maximum number of tuples in R U πA,B ( R⋈S )

Is Mysql a database management system(DBMS) or a database server?

Hot Network Questions