What is called the user has identified via a username and password in DBMS?

1. Authentication
2. Authorization
3. Accounting
4. Auditing

Ans: a

Which key is an attribute of a table that matches a primary key attribute in another table to create a relationship?

1. Candidate
2. Primary
3. Foreign
4. National

Ans: c

With SQL, how do you select all the records from a table named "NEB" where the value of the column "department" is "CDC"?

1. select * from NEB where department is exactly CDC;
2. select * from NEB where department is equal to CDC;
3. select * from NEB where department = 'CDC';
4. select * from NEB where department is not in CDC;

Ans: c

Which statement is used to delete a table in SQL?

1. REMOVE
2. DROP
3. Alter
4. Rename

Ans: b

Which function is used to connect to mySQL database?

1. mySqLi_open()
2. mySqLi_connect()
3. var mySqLi_query()
4. $mySqLi_con()

Ans: b

Which of the following is DML statement?

1. Create
2. Select
3. Create view Alter
4. Drop

Ans: b

Which one of the following given statement is correct?

1. Select * from enp where eopid=103;
2. Select from enp where eopid = 103;
3. Select eopid where enp = 103 from emp;
4. Select eopid where eopid = 103 and table = emp;

Ans: a

Which database system normally offers better performance for geographically dispersed users?

1. Centralized database system
2. Distributed database system
3. NoSQL database system
4. Relational database system

Ans: b

Which of the following uniquely identifies each record in the table?

1. Fields
2. Record
3. Row
4. Primary key

Ans: d

A field that is used to uniquely define a particular record in a table is called:

1. Primary key
2. Entity
3. Relationship
4. Constraints

Ans: a

Which of the following SQL statement is used to DELETE row from a database table?

1. DELETE
2. REMOVE
3. DROP
4. CLEAR

Ans: a

Which SQL keyword is used to retrieve data from a table?

1. SELECT
2. FROM
3. WHERE
4. JOIN

Ans: a

Which function is used to connect to MySql database?

1. mysqli_connect()
2. mysqli_query()
3. mysqli_Open()
4. $mysqli_con()

Ans: a

Which SQL statement will show the names and heights of all basketball players taller than 6 feet?

1. SELECT name FROM Player WHERE height >6;
2. SELECT name FROM Player WHERE height >=6;
3. SELECT name, height FROM Player WHERE height >6;
4. SELECT name, height FROM Player WHERE height <6;

Ans: c

Which of the following principle apply to 2NF?

1. A table must have primary key
2. All non-key attributes must be dependent on the primary key
3. All attributes must be atomic
4. A table must have at least more than two attributes

Ans: b