Sawaal
  • Home/
  • Searching for DBMS

 Searching for "DBMS"

Q:

Which of these is not a database management system (DBMS)?

A) Sybase B) SAP HANA
C) MySQL D) Cosmos
 
Answer & Explanation Answer: D) Cosmos

Explanation:
Report Error

View Answer Report Error Discuss

Filed Under: Computer
Exam Prep: Bank Exams

Q:

A DBMS query language is designed to

A) Specify the structure of a database B) Support in the development of complex applications software
C) Support end users who use English-like commands D) All of the above
 
Answer & Explanation Answer: D) All of the above

Explanation:
Report Error

View Answer Report Error Discuss

Filed Under: SQL
Job Role: Analyst , Database Administration , IT Trainer

Q:

Candidate Key in DBMS?

Answer

A candidate key is a column, or set of columns, in a table that can uniquely identify any database record without referring to any other data. Each table may have one or more candidate keys, but one candidate key is unique, and it is called the primary key.

Report Error

View answer Workspace Report Error Discuss

Subject: Oracle Certification
Job Role: Analyst , Database Administration , IT Trainer , Software Architect

Q:

Foreign key in DBMS is

Answer

Foreign keys are the columns of a table that points to the primary key of another table. They act as a cross-reference between tables.


 


In detail : A Foreign key is a field (or collection of fields) in one table that uniquely identifies a row of another table or the same table. In simpler words, the foreign key is defined in a second table, but it refers to the primary key or a unique key in the first table.

Report Error

View answer Workspace Report Error Discuss

Subject: Oracle Certification
Job Role: Analyst , Database Administration , IT Trainer , Project Manager

Q:

A Transparent DBMS

A) Keep its logical structure hidden from users B) Can access control
C) Keeps its physical structure hidden from users D) Can not hide sensitive information from users
 
Answer & Explanation Answer: C) Keeps its physical structure hidden from users

Explanation:

DBMS :: Database Managemet System.

A DBMS which keeps its physical structure hidden from the user is known as a transparent DBMS.

Report Error

View Answer Report Error Discuss

Filed Under: Oracle Certification
Job Role: Analyst , Database Administration , IT Trainer , Network Engineer , Project Manager , Software Architect

Q:

What is Primary Key in DBMS?

Answer

A primary key is a special relational database table column or combination of columns designated to uniquely identify all table records. That is, A primary key is a column or set of columns in a table that uniquely identifies tuples (rows) in that table.


A primary key, also called a Primary Keyword.



Main Features Primary key are ::


It must contain a unique value for each row of data.


It cannot contain null values.

Report Error

View answer Workspace Report Error Discuss

Subject: Oracle Certification
Job Role: Database Administration , IT Trainer , Software Architect

Q:

In R-DBMS, the data is organized in the form of _____.

A) Hierarchical structure B) Tabular structure
C) Linked structure D) All of the above
 
Answer & Explanation Answer: B) Tabular structure

Explanation:

Data is organized in the form of row and columns, thus it is in tabular structure.

Report Error

View Answer Report Error Discuss

Filed Under: Oracle Certification

Q:

What is RDBMS? Explain its features.

Answer

RDBMS is a database management system based on relational model defined by E.F.Codd. Data is stored in the form of rows and columns. The relations among tables are also stored in the form of the table.

Features:
- Provides data to be stored in tables
- Persists data in the form of rows and columns
- Provides facility primary key, to uniquely identify the rows
- Creates indexes for quicker data retrieval
- Provides a virtual table creation in which sensitive data can be stored and simplified query can be applied.(views)
- Sharing a common column in two or more tables(primary key and foreign key)
- Provides multi user accessibility that can be controlled by individual users

Report Error

View answer Workspace Report Error Discuss

Subject: Oracle