Try the CS-403 Final Term Exams Preparation Virtual University.
Total Questions10
Time Allowed10
Ch. # | Test Name | MCQs Available | PDF File | Answers Mode | Launch Test |
---|---|---|---|---|---|
1 | CS-403 Final Term Exams Preparation Virtual University | 184 | Download PDF | MCQ Answers | Launch Test |
Here you can prepare cs-403 Test. Click the button for cs-403 100% free full practice test.
Sr. # | Questions | Answers Choice |
---|---|---|
1 | Which of the following is not true about input forms? | Provide an easy, effective, efficient way to enter data into a table Especially useful when the person entering the data is not familiar with the inner workings Provide different controls to add data into the tables One input forms can populate one table at a time |
2 | Which of the following is true about application programs? | develop before the database design Tools selection is made after the development database meant to perform different operations by the user must to design before the designing and developing database |
3 | Which of the following functions are NOT performed by a database administrator? | Planning, designing and implementing database systems Establishing standards and procedures for database systems Communicating with database users Allocation of storage locations and data structures |
4 | Which of the following statements are Data Definition Language command? | INSERT UPDATE GRANT TRUNCATE |
5 | 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? | 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; |
6 | Which of the following statements creates a database named COMPANY. | CREATE DATABASE company CREATE DB company ADD DATABASE copmany CREATE company DATABASE |
7 | Which one is true regarding relation? | Every attribute value Non atomic Attribute in table may not have unique name table order of the column is relevant the order of the rows is irrelevant |
8 | Which of the following is not true about De-normalization? | It is the process of attempting to optimize the performance of a database De-normalization is a technique to move from lower to higher normal forms of database modeling It enhances the performance of DB In de-normalization it is required to add redundant data. |
9 | A superkey that does not contain a subset of attributes that is itself a superkey is called a ____. | candidate key primary key superkey secondary key |
10 | Incase of Context-level Diagram, the system is represented by<div>Select correct option:</div> | One process atleast Two processes atleast One process only Any number of processes |