Database MCQ Number 00883

Database MCQ Set 1

1. Which of the following is not a process of generating a good relational schema?
a) Converting ER diagrams to relational schema
b) Decomposing the relational schema while satisfying functional dependencies
c) Joining multiple relations together to form a single relation containing all the attributes
d) A design of relations which is then tested and modified to satisfy given normal forms

2. What is unique role assumption?
a) The attribute name has a unique meaning in the database
b) The attributes are all unique
c) No two tuples have even a single same value in a relation
d) None of the mentioned

3. The process of making a normalized schema unnormalized is called as ___
a) Unnormalization
b) Denormalization
c) Renormalization
d) Annormalization

4. State true or false: Crosstabs are not desirable in a database design
a) True
b) False

5. The data that have a time interval associated with them during which they are valid are called as ________
a) Timed data
b) Temporal data
c) Model data
d) Clocked data

6. The value of the data at a particular time is called as?
a) Instance
b) Picture
c) Snapshot
d) None of the mentioned

7. Functional dependencies that have a time associated with them during which they are valid are called as________
a) Timed functional dependencies
b) Clocked functional dependencies
c) Temporal functional dependencies
d) Modeled functional dependencies

8. State true or false: Overlapping time intervals cannot be prevented
a) True
b) False

9. Which of the following is the time of temporal data that record when a fact was recorded in a database?
a) Transaction time
b) Valid time
c) Enter time
d) Exit time

10. To specify the foreign keys in relations referencing temporal data we need to specify _______
a) The time interval
b) The Boolean value for the working
c) The integer corresponding to the relation number
d) None of the mentioned

Database MCQ Set 2

Q1) Create a Bank Database schema with the following relations and select an appropriate primary key.
account(account_number, branch_name, balance)
branch (branch_name, branch_city, assets)
customer (customer_name customer_street, customer_city)
loan (loan_number, branch_name, amount)
depositor((customer_name, account_number)
borrower(customer_name, loan_number)

NOTE: Please insert the following data into the database for the execution of further queries.

insert into customer values (‘Jones’, ‘Main’, ‘Harrison’);
insert into customer values (‘Smith’, ‘Main’, ‘Rye’);
insert into customer values (‘Hayes’, ‘Main’, ‘Harrison’);
insert into customer values (‘Curry’, ‘North’, ‘Rye’);
insert into customer values (‘Lindsay’, ‘Park’, ‘Pittsfield’);
insert into customer values (‘Turner’, ‘Putnam’, ‘Stamford’);
insert into customer values (‘Williams’, ‘Nassau’, ‘Princeton’);
insert into customer values (‘Adams’, ‘Spring’, ‘Pittsfield’);
insert into customer values (‘Johnson’, ‘Alma’, ‘Palo Alto’);
insert into customer values (‘Glenn’, ‘Sand Hill’, ‘Woodside’);
insert into customer values (‘Brooks’, ‘Senator’, ‘Brooklyn’);
insert into customer values (‘Green’, ‘Walnut’, ‘Stamford’);
insert into customer values (‘Jackson’, ‘University’, ‘Salt Lake’);
insert into customer values (‘Majeris’, ‘First’, ‘Rye’);
insert into customer values (‘McBride’, ‘Safety’, ‘Rye’);

insert into branch values (‘Downtown’, ‘Brooklyn’, 900000);
insert into branch values (‘Redwood’, ‘Palo Alto’, 2100000);
insert into branch values (‘Perryridge’, ‘Horseneck’, 1700000);
insert into branch values (‘Mianus’, ‘Horseneck’, 400200);
insert into branch values (‘Round Hill’, ‘Horseneck’, 8000000);
insert into branch values (‘Pownal’, ‘Bennington’, 400000);
insert into branch values (‘North Town’, ‘Rye’, 3700000);
insert into branch values (‘Brighton’, ‘Brooklyn’, 7000000);
insert into branch values (‘Central’, ‘Rye’, 400280);

insert into account values (‘A-101’, ‘Downtown’, 500);
insert into account values (‘A-215’, ‘Mianus’, 700);
insert into account values (‘A-102’, ‘Perryridge’, 400);
insert into account values (‘A-305’, ‘Round Hill’, 350);
insert into account values (‘A-201’, ‘Perryridge’, 900);
insert into account values (‘A-222’, ‘Redwood’, 700);
insert into account values (‘A-217’, ‘Brighton’, 750);
insert into account values (‘A-333’, ‘Central’, 850);
insert into account values (‘A-444’, ‘North Town’, 625);

insert into depositor values (‘Johnson’,’A-101′);
insert into depositor values (‘Smith’, ‘A-215’);
insert into depositor values (‘Hayes’, ‘A-102’);
insert into depositor values (‘Hayes’, ‘A-101’);
insert into depositor values (‘Turner’, ‘A-305’);
insert into depositor values (‘Johnson’,’A-201′);
insert into depositor values (‘Jones’, ‘A-217’);
insert into depositor values (‘Lindsay’,’A-222′);
insert into depositor values (‘Majeris’,’A-333′);
insert into depositor values (‘Smith’, ‘A-444’);

insert into loan values (‘L-17’, ‘Downtown’, 1000);
insert into loan values (‘L-23’, ‘Redwood’, 2000);
insert into loan values (‘L-15’, ‘Perryridge’, 1500);
insert into loan values (‘L-14’, ‘Downtown’, 1500);
insert into loan values (‘L-93’, ‘Mianus’, 500);
insert into loan values (‘L-11’, ‘Round Hill’, 900);
insert into loan values (‘L-16’, ‘Perryridge’, 1300);
insert into loan values (‘L-20’, ‘North Town’, 7500);
insert into loan values (‘L-21’, ‘Central’, 570);

insert into borrower values (‘Jones’, ‘L-17’);
insert into borrower values (‘Smith’, ‘L-23’);
insert into borrower values (‘Hayes’, ‘L-15’);
insert into borrower values (‘Jackson’, ‘L-14’);
insert into borrower values (‘Curry’, ‘L-93’);
insert into borrower values (‘Smith’, ‘L-11’);
insert into borrower values (‘Williams’,’L-17′);
insert into borrower values (‘Adams’, ‘L-16’);
insert into borrower values (‘McBride’, ‘L-20’);
insert into borrower values (‘Smith’, ‘L-21’);

Database MCQ Set 3

1. Which of the following is not a system database ?
a) Northwind
b) Master
c) Tempdb
d) All of the mentioned

2. Point out the correct statement :
a) By default, tempdb autogrows as needed while SQL Server is running
b) By default, master autogrows as needed while SQL Server is running
c) By default, pubs autogrows as needed while SQL Server is running
d) By default, msdb autogrows as needed while SQL Server is running

3. Which of the following holds temporary data ?
a) Northwind
b) Master
c) Tempdb
d) Msdb

4. Which is the most important system database ?
a) Northwind
b) Master
c) Tempdb
d) All of the mentioned

5. Point out the wrong statement related to master database :
a) They are used to provide details of an backup plans
b) master records the information for SQL Server temporarily
c) master records the initialization information for SQL Server
d) None of the mentioned

6. Which database is used as template for all databases ?
a) Northwind
b) Master
c) Tempdb
d) Model

7. Which of the following database is used by SQL Server Agent ?
a) Pubs
b) Msdb
c) Tempdb
d) Model

8. How many types of system databases are present in SQL Server 2008?
a) 3
b) 4
c) 5
d) 6

9. Which of the following system database occupies more space and memory ?
a) Master
b) Msdb
c) Tempdb
d) Model

10. The ___ database stores basic configuration information for the server.
a) Master
b) Msdb
c) Tempdb
d) Model

Database MCQ Set 4

1. Which one of the following statements should be used to include a file?
a) #include ‘filename’;
b) include ‘filename’;
c) @include ‘filename’;
d) #include ;

2. Which one of the following methods is responsible for sending the query to the database?
a) query()
b) send_query()
c) sendquery()
d) query_send()

class mysqli
{
	mixed query(string query [, int resultmode])
}

3. Which one of the following methods recuperates any memory consumed by a result set?
a) destroy()
b) remover()
c) alloc()
d) free()

4. Which of the methods are used to manage result sets using both associative and indexed arrays?
a) get_array() and get_row()
b) get_array() and get_column()
c) fetch_array() and fetch_row()
d) fetch_array() and fetch_column()

calss mysqli_result
{
	mixed fetch_array ([int resulttype])
}
 
calss mysqli_result
{
	mixed fetch_row()
}

5. Which one of the following method is used to retrieve the number of rows affected by an INSERT, UPDATE, or DELETE query?
a) num_rows()
b) affected_rows()
c) changed_rows()
d) new_rows()

6. Which version of MySQL introduced the prepared statements?
a) MySQL 4.0
b) MySQL 4.1
c) MySQL 4.2
d) MySQL 4.3

7. Which of the following methods is used to execute the statement after the parameters have been bound?
a) bind_param()
b) bind_result()
c) bound_param()
d) bound_result()

8. Which one of the following methods is used to recuperating prepared statements resources?
a) end()
b) finish()
c) final()
d) close()

9. Which method retrieves each row from the prepared statement result and assigns the fields to the bound results?
a) get_row()
b) fetch_row()
c) fetch()
d) row()

10. Which method rolls back the present transaction?
a) commit()
b) undo()
c) back()
d) rollback()

class mysqli
{
boolean rollback()
}

Database MCQ Set 5

1. Which one of the following databases has PHP supported almost since the beginning?
a) Oracle Database
b) SQL
c) SQL+
d) MySQL

2. The updated MySQL extension released with PHP 5 is typically referred to as..
a) MySQL
b) mysql
c) mysqli
d) mysqly

3. Which one of the following lines need to be uncommented or added in the php.ini file so as to enable mysqli extension?
a) extension=php_mysqli.dll
b) extension=mysql.dll
c) extension=php_mysqli.dl
d) extension=mysqli.dl

4. In which version of PHP was MySQL Native Driver(also known as mysqlnd) introduced?
a) PHP 5.0
b) PHP 5.1
c) PHP 5.2
d) PHP 5.3

5. Which one of the following statements is used to create a table?
a) CREATE TABLE table_name (column_name column_type);
b) CREATE table_name (column_type column_name);
c) CREATE table_name (column_name column_type);
d) CREATE TABLE table_name (column_type column_name);

6. Which one of the following statements instantiates the mysqli class?
a) mysqli = new mysqli()
b) $mysqli = new mysqli()
c) $mysqli->new.mysqli()
d) mysqli->new.mysqli()

7.Which one of the following statements can be used to select the database?
a) $mysqli=select_db(‘databasename’);
b) mysqli=select_db(‘databasename’);
c) mysqli->select_db(‘databasename’);
d) $mysqli->select_db(‘databasename’);

8. Which one of the following methods can be used to diagnose and display information about a MySQL connection error?
a) connect_errno()
b) connect_error()
c) mysqli_connect_errno()
d) mysqli_connect_error()

9. Which method returns the error code generated from the execution of the last MySQL function?
a) errno()
b) errnumber()
c) errorno()
d) errornumber()

10. If there is no error, then what will the error() method return?
a) TRUE
b) FALSE
c) Empty String
d) 0

DistPub Team

Distance Publisher (DistPub.com) provide project writing help from year 2007 and provide writing and editing help to hundreds student every year.

• Website
• Twitter
• Facebook