Are you guys looking for computer science MCQ Questions with Answers PDF Free Download as per computer science new exam pattern? You came to the right page. This may assist you to understand and check your knowledge about the Subjects. Students also can take a free test of the Multiple Choice Questions of computer science. Each question has four options followed by the right answer. These computer science MCQ Questions are selected supported by the newest exam pattern.
Q1. Which of the following in not a function of DBA?
(A) Network Maintenance
(B) Routine Maintenance
(C) Schema Definition
(D) Authorization for data access
Answer:(A) Network Maintenance
Q2. What name is given to the collection of facts, items of information or data which are related in some way?
(A) Database
(B) Directory information
(C) Information tree
(D) Information provider
Answer:(A) Database
Q3. Which of the following is not characteristic of a relational database model?
(A) Tables
(B) Treelike structure
(C) Complex logical relationships
(D) Records
Answer: (B) Treelike structure
Q4. Data integrity control
(A) Is used to set upper and lower limits on numeric data
(B) Requires the use of passwords to prohibit unauthorized access to the file
(C) Has the data dictionary keep the date and time of last access last back-up, and most recent modification for all files
(D) None of the above
Answer: (C) Has the data dictionary keep the date and time of last access last back-up, and most recent modification for all files
Q5. In SQL, which command is used to add new rows to a table?
(A) ALTER TABLE
(B) ADD ROW
(C) INSERT
(D) APPEND
Answer: (C) INSERT
Q6. Which of the following is not Modification of the Database?
(A) Deletion
(B) Insertion
(C) Sorting
(D) Updating
Answer: (C) Sorting
Q7. A database management system
(A) Allows simultaneous access to multiple files
(B) Can do more than a record management system
(C) Is a collection of programs for managing data in a single file
(D) None of the above
Answer:(D) None of the above
Q8. A Database Management System (DBMS) is
(A) Collection of interrelated data
(B) Collection of programs to access data
(C) Collection of data describing one particular enterprise
(D) All of the above
Answer: (A) Collection of interrelated data
Q9. Embedded pointer provide
(A) A secondary access path
(B) A physical record key
(C) An inverted index
(D) All of the above
Answer:(A) A secondary access path
Q10. Which command is used to remove an index from the database in SQL?
(A) DELETE INDEX
(B) DROP INDEX
(C) REMOVE INDEX
(D) ROLL BACK INDEX
Answer: (B) DROP INDEX
Q11. A command to remove a relation from an SQL database
(A) Delete table < table name>
(B) Drop table <table name> (C) Erase table <table name> (D) Alter table <table name>
Answer: (B) Drop table