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
Support mcqgeeks.com by disabling your adblocker.
Please disable the adBlock and continue. Thank you.