Question # 1

Browser based forms are developed in the following tools EXCEPT

Choose an answer

HTML

Scripting language

Front Page

Web-based Forms

Which of the following enforces a relation into 1st normal form?

Choose an answer

The domain of attribute must include only atomic values

Every non-key attribute is fully functionally dependent on primary key

non-key attribute is non-transitively dependent on primary key.

Every non-key attribute is partially dependent on super key

Suppose there are 4 fields in a table named CUST (customer_id, first_name, last_name, phone). Which of the following gives all the information of the customers in the table whose last name is ALI?

Choose an answer

SELECT * FROM CUST WHERE last_name='ALI';

SELECT * FROM CUST WHERE last_name=ALI;

SELECT * FROM CUSTOMER WHERE name=ALI;

SELECT * FROM CUSTOMER WHERE last_name=ALI;

Which of the following is NOT a component of a DFD? Select correct option:

Choose an answer

Dataflow

Datastore

External entities

Relationship between external entities

Who is responsible for authorizing access to the database, for coordinating and monitoring its use? Select correct option:

Choose an answer

Database Designer

Database Administrator

End User

Application Programmer

The ER- data model is an example of:

Choose an answer

Physical database

Logical database

Relational database

Conceptual database

Which of the following is NOT a component of a DFD?

Choose an answer

Dataflow

Datastore

External entities

Relationship between external entities

Materialized views and Indexes are NOT similar by the following way(s).

Choose an answer

hey consume storage space

They must be refreshed when the data in their master tables changes

They can be accessed directly using a SELECT statement

All of the Given

Consider a transaction which includes following operations Z= Z + 10 Write Z ... Suppose that the value of Z after addition and the execution of this operation is 17. Now against the write operation the entry made in the log file will be What does Z reflects in the above entry?

Choose an answer

Object being updated

Identity of the transaction

Object value

Identity of the next transaction to be executed

Which of the following gives all the fields from employee table named as EMP?

Choose an answer

SELECT * from EMP;

SELECT emp* from EMP'

SELECT emp_id where EMP;

SELECT * where EMP;

Which of the following are the general activities, which are performed during the development of application programs?

Choose an answer

Data input programs

Editing

Display

All of given

More Classes

Other Links

CS-403 Final Term Exams Preparation Virtual University MCQs With Answers

Choose an answer

Choose an answer

Choose an answer

Choose an answer

Choose an answer

Choose an answer

Choose an answer

Choose an answer

Choose an answer

Choose an answer

Choose an answer