answersLogoWhite

0

📱

Database Programming

Databases are collections of tables that maintain and display information, often collaboratively; this information can be used for interaction with an application or gaining general knowledge. Questions about database engines and modifying or using them belong in this category.

8,803 Questions

What are the applications of DBMS?

Data base system applications:

1.Universities: For student information, course details, and grades.

2.Airlines: For reservations and schedule information.

3.Credit card transactions: For purchase on credit cards and generations of monthly statements.

4.Human resources: For information about employees, salaries, payroll taxes, benefits and for generations of paychecks.

5.Banking: For customer information, accounts, and banking transactions.

What is overlapping key DBMS?

Overlapping Key is a type of candidate key which occurs in BCNF (Boyce –Codd Normal Form).In the difference between 3NF and BCNF Example : A 3NF table which does not have multiple overlapping candidate keys is guaranteed to be in BCNF. Depending on what its functional dependencies are, a 3NF table with two or more overlapping candidate keys may or may not be in BCNF.

What is the difference between a logical view and a physical view of data?

The logical view presents data as they would be perceived by end users or business specialists, whereas the physical view shows how data are actually organized and structured on physical storage media.

What is schema and sub-schema?

The schema is the physical arrangement of the data as it appears in the DBMS. The subschema is the logical view of the data as it appears to the application program.

How to store fingerprints in a database?

There are a number of ways you can store fingerprints in a database. You can for example scan them and save them as individual files.

Who is the author of oracle?

Oracle is a product from Oracle corporation. www.oracle.com

Fuzzy logic previous papers please?

fuzzy logic papers fuzzy logic papers fuzzy logic papers

What are six types of basic elements in a database known as?

do u meen like fields if so then

fields

records

tables...

um i dnt know the rest soz :)

What are the major misconceptions regarding management information system?

According to Malik and Gupta (2005), the concept of management information systems is not clearly understood by many developers(viz. programmers and systems analysts) as well as end users, namely, managers, of these very systems. There are many misconceptions about a management information system. These are the following:

  • Any computer-based information system is an MIS.
  • Any reposting system is an MIS.
  • MIS is a philosophy and not any specific entity.
  • MIS is a management technique
  • MIS is a bunch of technologies.
  • MIS is an implementation of organizational systems and procedures. MIS is a course on file structures.

Six major types of Information system?

Decision Support System (DSS)

Management Information System (MIS)

Expert Information System (EIS)

Knowledge Management System (KMS)

Transaction Processing System (TPS)

Office Automation System (OAS)

Human Resource Management System (HRMS)

What is specific application software?

A specific application software is also referred to as specific purpose application software. It is designed for a particular task and tailored to the specific needs of the user.

What is software security?

Security software provides protection for your computer, mobile gadgets, networks, or any computing-enabled devices. The most efficient and effective ones are the cloud-based security software because they provide real-time protection and don't clog your space and cause device slowdowns. It can come as antivirus software, encryption software, firewall software, and spyware removal software. Security software can manage access control, give real-time data protection and network or internet-based intrusions, and defends against other system-level security risks. Most are offered for free, providing robust protection at no cost, but definitely promises to provide more features when you upgrade to a premium account.

A premium example of reliable security software is Bitdefender Antivirus Plus. It keeps your financial and personal information protected against all cyberthreats and prevents your devices from being compromised. It has a highly-rated performance compared to other antivirus brands. It keeps your computer in optimum performance while working on the double to secure your data from ransomware and other malware attacks. It scans and safeguards your network connections as well to add another layer of protection. This is why it is one of the most popular, go-to brand in cybersecurity.

In a database what is an entity?

WhatIs.com Definitions Database A database is a collection of information that is organized so that it can easily be accessed, managed, and updated. In one view, databases can be classified according to types of content: bibliographic, full-text, numeric, and images. Entity In general, an entity (pronounced N-tih-tee ) is an existing or real thing. The word root is from the Latin, ens , or being, and makes a distinction between a thing's existence and its qualities. An entity exists and that's all it needs to do to be an entity. The fact that something exists also seems to connote separateness from other existences or entities. In programming, engineering, and probably many other contexts, the word is used to identify units, whether concrete things or abstract ideas, that have no ready name or label. In blackboard discussions, one can draw something as yet unnamed and refer to that drawing as the representation of an "entity." (If the entity being discussed later gets ascribed qualities and a name, reference to it as an "entity" may no longer be useful.)

Why is it important to verify the backup process for critical software and databases?

You'd want to verify a backup in order to be sure that you can actually restore backed-up data when you need it.

What is the purpose of filters in a database?

Filters in database reduce down the records you see, by finding ones that meet certain criteria. So if you had a list of people and their date of birth you could impose a filter to just show ones born after a certain date. If you had a list of companies and their profits or losses you could use a filter to show just the ones that made a profit. If you had a list of products you could show ones that were of a particular category. Filtering does not delete records, it just shows ones that meet certain criteria. The filters can be turned off so you see all the records again.

Basic commands in oracle?

See the list of Commands in Oracle

ANALYZE

AUDIT

CALL

CREATE CLUSTER

ALTER CLUSTER

DROP CLUSTER

COMMENT

COMMIT

CONNECT

CONSTRAINT

CREATE CONTEXT

DROP CONTEXT

CREATE CONTROLFILE

CREATE DATABASE

ALTER DATABASE

DELETE

DESCRIBE

CREATE DIMENSION

ALTER DIMENSION

DROP DIMENSION

CREATE DIRECTORY

DROP DIRECTORY

EXEC

EXECUTE IMMEDIATE

EXPLAIN PLAN

CREATE FUNCTION

ALTER FUNCTION

DROP FUNCTION

GRANT

CREATE INDEX

ALTER INDEX

DROP INDEX

CREATE INDEXTYPE

DROP INDEXTYPE

INSERT

INTERSECT

CREATE JAVA

ALTER JAVA

DROP JAVA

CREATE LIBRARY

DROP LIBRARY

CREATE DATABASE LINK

DROP DATABASE LINK

LOCK TABLE

CREATE MATERIALIZED VIEW

ALTER MATERIALIZED VIEW

DROP MATERIALIZED VIEW

CREATE MATERIALIZED VIEW LOG

ALTER MATERIALIZED VIEW LOG

DROP MATERIALIZED VIEW LOG

MINUS

NOAUDIT

CREATE OUTLINE

ALTER OUTLINE

DROP OUTLINE

CREATE PACKAGE/BODY

ALTER PACKAGE

DROP PACKAGE

CREATE PFILE

CREATE PROCEDURE

ALTER PROCEDURE

DROP PROCEDURE

CREATE PROFILE

ALTER PROFILE

DROP PROFILE

RECOVER

RENAME

ALTER RESOURCE COST

REVOKE

RMAN

CREATE ROLE

SET ROLE

ALTER ROLE

DROP ROLE

ROLLBACK

CREATE ROLLBACK SEGMENT

ALTER ROLLBACK SEGMENT

DROP ROLLBACK SEGMENT

SAVEPOINT

CREATE SCHEMA

SELECT

CREATE SEQUENCE

ALTER SEQUENCE

DROP SEQUENCE

ALTER SESSION

SHUTDOWN

SNAPSHOT

CREATE SPFILE

STARTUP

ASSOCIATE STATISTICS

DISASSOCIATE STATISTICS

CREATE SYNONYM

DROP SYNONYM

ALTER SYSTEM

CREATE TABLE

ALTER TABLE

DROP TABLE

CREATE TABLESPACE

ALTER TABLESPACE

DROP TABLESPACE

CREATE TEMPORARY TABLESPACE

SET TRANSACTION

CREATE TRIGGER

ALTER TRIGGER

DROP TRIGGER

TRUNCATE

UPDATE

UNION

CREATE USER

ALTER USER

DROP USER

CREATE VIEW

ALTER VIEW

DROP VIEW

WHERE

Can Oracle and IIS co-habit on one Server?

To my knowledge, yes.

You didn't ask if it would be a good idea. If you had, I would say maybe not.

The Oracle database includes its own web server, which possibly could conflict with the IIS web server (which is what IIS is).

What does a Hierarchical database do?

A hierarchical model is a database model which represents the database in a tree diagram. It thus helps the user to work with(i.e., use, modify, extract etc.) the database without even bothering about the complicated algorithms or flow chart used by the system to deal with the database.

What Different tables available in NTDS database?

i) Schema table

Ii) Link Table

iii) Data table

iv)Configuration Table