Database Systems - CSE Questions and Answers

Whatsapp
Facebook
Copy
Copy Text
Copy
Copy URL

In SQL, which of the following is not a data definition language commands?

RENAME

REVOKE

GRANT

UPDATE

None of the above

Whatsapp
Facebook
Copy
Copy Text
Copy
Copy URL

Subschema can be used to

create very different, personalized views of the same data

present information in different formats

hide sensitive information by omitting fields from the sub¬schema's description

All of the above

None of the above

Whatsapp
Facebook
Copy
Copy Text
Copy
Copy URL

Database management systems are intended to:

eliminate data redundancy

establish relationships among records in different files

manage file access

maintain data integrity

All of the above

Whatsapp
Facebook
Copy
Copy Text
Copy
Copy URL

In SQL, which command(s) is(are) used to issue multiple CREATE TABLE, CREATE VIEW, and GRANT statements in a single transaction?

CREATE PACKAGE

CREATE SCHEMA

CREATE CLUSTER

All of the above

None of the above ;