Q.1
In existing table, ALTER TABLE statement is used to
  • Add columns
  • Add constraints
  • Delete columns
  • Delete constrains
  • All the above
Q.2
The term "ODBC" stands for_____
  • Oral database connectivity
  • Oracle database connectivity
  • Open database connectivity
  • Object database connectivity
Q.3
How can you change “Hansen” into “Nilsen” in the “LastName” column in the Persons table?
  • UPDATE Persons SET LastName=’Hansen’ INTO LastName=’Nilsen’
  • MODIFY Persons SET LastName=’Nilsen’ WHERE LastName=’Hansen’
  • MODIFY Persons SET LastName=’Hansen’ INTO LastName=’Nilsen’
  • UPDATE Persons SET LastName=’Nilsen’ WHERE LastName=’Hansen’
Q.4
Which of the following is not a DBMS despite having database capabilities:
  • Microsoft Excel or similar spreadsheets
  • Oracle
  • MySQL
  • Microsoft Access or similar
Q.5
In the relation model, the relation are generally termed as ________
  • Tuples
  • Attributes
  • Rows
  • Tables
Q.6
An attribute A of datatype varchar(has the value “Avi” . The attribute B of datatype char(has value ”Reed” .Here attribute A has ____ spaces and attribute B has ____ spaces .(i.e the total number of utilized space by A,B)
  • 3,20
  • 20,4
  • 3,4
  • 20,20
Q.7
What is missing in this code? SELECT * FROM WHERE genre = ‘action’ ORDER BY year ASC;
  • Missing an AND
  • Table name
  • Capitalize action
  • None of these
Q.8
SELECT * FROM employeeWhat type of statement is this?
  • integrity constraint
  • ddl
  • dml
  • view
Q.9
The database management system can be considered as the collection of ______ that enables us to create and maintain the database.
  • Translators
  • Programs
  • Keys
  • Language activity
Q.10
What is returned by SUBSTR(‘TUTORIALS POINT’,9)
  • TUTORIAL
  • POINT
  • TUTORIALS
  • UTORIALS
Q.11
Concurrent access by multiple users is not possible by using DBMS
  • true
  • false
Q.12
CREATE TABLE employee (name VARCHAR, id INTEGER)What type of statement is this?
  • view
  • ddl
  • dml
  • tcl
Q.13
Which of the following refers to the number of attributes in a relation?
  • Degree
  • Row
  • Column
  • All of the above
Q.14
A view of database that appears to an application program is known as
  • schema
  • subschema
  • virtual table
  • none of the above
Q.15
Every Boyee-Codd normal form is in
  • 1NF
  • 2Nf
  • 3NF
  • all the above
Q.16
Which command is used to remove all rows from a table ?
  • Delete
  • Remove
  • Truncate
  • Both [A] and [B]
Q.17
A DBMS query language is designed to
  • Support end users who use English-like commands.
  • Support in the development of complex applications software.
  • Specify the structure of a database.
  • all of the above
Q.18
The architecture of a database can be viewed as the ________
  • a) One level
  • b) Two-level
  • c) Three-level
  • d) Four level
Q.19
How will a data analyst retrieve a list of all employees' first_name, last_name and hire_date from the employees table?
  • select first_name,last_name,hire_date, from employee;
  • select first_name,last_name and hire_date from employees;
  • Select first_name,last_name& hire_date from employees;
  • select first_name,last_name,hire_date from employees;
Q.20
Which of the following is used in the application programs to request data from the database management system?
  • a) Data Manipulation language
  • b) Data Definition Language
  • c) Data Control Language
  • d) All of the above
0 h : 0 m : 1 s