DBMS Quiz FyCyber 14/11/23

Who is responsible for authorizing access to the database, coordinating and monitoring its use

• Database programmer

• System Analyst

• Specialised User

• DBA

Collection of information stored in a database at a particular moment is

• view

• schema

• instance

• none of the above

A function that has no partial functional dependencies is in _______ form

• 3NF

• 2NF

• 4NF

• BCNF

Which command is used to remove all rows from a table ?

• Delete

• Remove

• Truncate

• Both A and B

The statement in SQL which allows to change the definition of a table is

• Alter

• Update

• Create

• Select

Which of the following statements contains an error?

• Select * from emp where empid = 10003;

• Select empid from emp where empid=10006;

• Select empid from emp;

• Select empid where empid=1009 and lastname = 'GELLER';

CREATE TABLE employee (name VARCHAR, id INTEGER)

What type of statement is this?

• DML

• DDL

• View

• Integrity Constraint

In SQL, which command is used to SELECT only one copy of each set of duplicable rows

• Select DISTINCT

• Select UNIQUE

• Select DIFFERENT

• All of the above

How do we select all rows for the "Designer" table?

• Select * from Designer

• Select [All] from Designer

• Select Designer*

• Select from Designer

........... in DBMS is the simplest architecture of Database in which the client, server, and Database all reside on the same machine.

• 1 Tier architecture

• 2 Tier architecture

• 3 Tier architecture

• n Tier architecture