139 + Mcqs in Oracle Page 1 McqOptions

1.	To obtain the structure of an Oracle table, the command to use is:
A.	STRUCTURE [TableName].
B.	DESCRIBE [TableName].
C.	DESCRIBE STRUCTURE [TableName].
D.	DESC TABLE [TableName].
Answer» C. DESCRIBE STRUCTURE [TableName].

Discussion

2.	A Database Language Concerned With The Definition Of The Whole Database Structure And Schema Is ________
A.	DCL
B.	DML
C.	DDL
D.	All of the Mentioned
Answer» D. All of the Mentioned

Discussion

3.	The Database Language That Allows You To Access Or Maintain Data In A Database
A.	DCL
B.	DML
C.	DDL
D.	All of the Mentioned
Answer» B. DML

Discussion

4.	DCL Provides Commands To Perform Actions Like _____________
A.	Change The Structure Of Tables
B.	Insert, Update Or Delete Records And Data Values
C.	Authorizing Access And Other Control Over Database
D.	None of the Mentioned
Answer» D. None of the Mentioned

Discussion

5.	Which of the following keyword is used with Data Control Language (DCL) statements?
A.	SELECT
B.	INSERT
C.	DELETE
D.	GRANT
Answer» E.

Discussion

6.	A transaction completes its execution is said to be
A.	Committed
B.	Aborted
C.	Rolled back
D.	Failed
Answer» B. Aborted

Discussion

7.	In an SQL statement, which of the following parts states the conditions for row selection?
A.	Where
B.	From
C.	Order By
D.	Group By
Answer» B. From

Discussion

8.	_________commands in SQL allow controlling access to data within database.
A.	Database
B.	Data
C.	Data Control
D.	All of the Mentioned
Answer» D. All of the Mentioned

Discussion

9.	TCL stands for:
A.	Transaction control languages
B.	Transaction command languages
C.	Transaction connect languages
D.	None of the Mentioned
Answer» B. Transaction command languages

Discussion

10.	DCL stands for :
A.	Data Control Language
B.	Data Console Language
C.	Data Console Level
D.	Data Control Level
Answer» B. Data Console Language

Discussion

11.	The three language components of a database management system (DBMS) like DDL, DCL, DML. Two different types of people (users and practitioners) are concerned with them. Which of them do users of a DBMS usually deal with?
A.	DDL
B.	DML
C.	DDL and DCL
D.	DCL and DML
Answer» C. DDL and DCL

Discussion

12.	A type of query that is placed within a WHERE or HAVING clause of another query is called
A.	Master query
B.	Sub query
C.	Super query
D.	Multi-query
Answer» C. Super query

Discussion

13.	A table that displays data redundancies yields ____________ anomalies.
A.	Update
B.	Insertion
C.	Deletion
D.	All of the Mentioned
Answer» E.

Discussion

14.	Stack is also called __________
A.	First In First Out (LIFO)
B.	Last In First Out (FIFO)
C.	First In Last Out (FILO)
D.	First Come First Served (FCFS)
Answer» D. First Come First Served (FCFS)

Discussion

15.	In SQL, which command is used to add new rows to a table?
A.	Alter Table
B.	Add row
C.	Insert
D.	Append
Answer» D. Append

Discussion

16.	TRUNCATE statement in SQL is a –
A.	DML statement
B.	DDL statement
C.	DCL statement
D.	TCL statement
Answer» C. DCL statement

Discussion

17.	Which of the following is not included in DML (Data Manipulation Language)
A.	INSERT
B.	UPDATE
C.	DELETE
D.	CREATE
Answer» E.

Discussion

18.	Which of the following is not a type of SQL statement?
A.	Data Manipulation Language (DML)
B.	Data Definition Language (DDL)
C.	Data Control Language (DCL)
D.	Data Communication Language (DCL)
Answer» E.

Discussion

19.	In SQL, which of the following is not a data Manipulation Language Commands?
A.	Delete
B.	Truncate
C.	Update
D.	Create
Answer» C. Update

Discussion

20.	The language used application programs to request data from the DBMS is referred to as __________
A.	DML
B.	DDL
C.	Query language
D.	All of the Mentioned
Answer» B. DDL

Discussion

21.	Which command allows the removal of all rows from a table but flushes a table more efficiently since no rollback information is retained:
A.	TRUNCATE command
B.	Create command
C.	Drop table command
D.	Alter table command
Answer» B. Create command

Discussion

22.	Which command is used for removing a table and all its data from the database:
A.	Create command
B.	Drop table command
C.	Alter table command
D.	All of the Mentioned
Answer» C. Alter table command

Discussion

23.	Which command defines its columns, integrity constraint in create table:
A.	Create command
B.	Drop table command
C.	Alter table command
D.	All of the Mentioned
Answer» B. Drop table command

Discussion

24.	SQL has how many main commands for DDL:
A.	1
B.	2
C.	3
D.	4
Answer» D. 4

Discussion

25.	___________ defines rules regarding the values allowed in columns and is the standard mechanism for enforcing database integrity.
A.	Column
B.	Constraint
C.	Index
D.	Trigger
Answer» C. Index

Discussion

26.	________clause is an additional filter that is applied to the result.
A.	Select
B.	Group-by
C.	Having
D.	Order by
Answer» D. Order by

Discussion

27.	In SQL, which command(s) is(are) used to change a table’s storage characteristics?
A.	ALTER TABLE
B.	MODIFY TABLE
C.	CHANGE TABLE
D.	All of the Mentioned
Answer» B. MODIFY TABLE

Discussion

28.	Which of the following is/are the DDL statements?
A.	Create
B.	Drop
C.	Alter
D.	All of the Mentioned
Answer» E.

Discussion

29.	Let the statement : SELECT column1 FROM myTable; return 10 rows. The statement : SELECT ALL column1 FROM myTable; will return
A.	less than 10 rows
B.	more than 10 rows
C.	exactly 10 rows
D.	none of the Mentioned
Answer» D. none of the Mentioned

Discussion

30.	Which of the following is illegal?
A.	SELECT SYSDATE – SYSDATE FROM DUAL;
B.	SELECT SYSDATE – (SYSDATE – 2) FROM DUAL;
C.	SELECT SYSDATE – (SYSDATE + 2) FROM DUAL;
D.	None of the Mentioned
Answer» E.

Discussion

31.	Find the temperature in increasing order of all cities
A.	SELECT city FROM weather ORDER BY temperature;
B.	SELECT city, temperature FROM weather;
C.	SELECT city, temperature FROM weather ORDER BY temperature;
D.	SELECT city, temperature FROM weather ORDER BY city;
Answer» D. SELECT city, temperature FROM weather ORDER BY city;

Discussion

32.	The SQL statement SELECT SUBSTR(‘123456789’, INSTR(‘abcabcabc’, ‘b’), 4) FROM DUAL;
A.	6789
B.	2345
C.	1234
D.	456789
Answer» C. 1234

Discussion

33.	Which of the SQL statements is correct?
A.	SELECT Username AND Password FROM Users
B.	SELECT Username, Password FROM Users
C.	SELECT Username, Password WHERE Username = ‘user1’
D.	None of the Mentioned
Answer» C. SELECT Username, Password WHERE Username = ‘user1’

Discussion

34.	A command that lets you change one or more fields in a record is
A.	Insert
B.	Modify
C.	Look-up
D.	All of the Mentioned
Answer» C. Look-up

Discussion

35.	In SQL, which command is used to SELECT only one copy of each set of duplicable rows
A.	SELECT DISTINCT
B.	SELECT UNIQUE
C.	SELECT DIFFERENT
D.	All of the Mentioned
Answer» B. SELECT UNIQUE

Discussion

36.	Which is the subset of SQL commands used to manipulate Oracle Database structures, including tables?
A.	Data Definition Language(DDL)
B.	Data Manipulation Language(DML)
C.	DDL and DML
D.	None of the Mentioned
Answer» B. Data Manipulation Language(DML)

Discussion

37.	What is the full form of SQL?
A.	Structured Query Language
B.	Structured Query List
C.	Simple Query Language
D.	None of the Mentioned
Answer» B. Structured Query List

Discussion

38.	An n-array relationship is drawn using which symbol:
A.	A diamond
B.	A line with arrows showing direction
C.	A line without arrows showing direction
D.	A rectangle
Answer» B. A line with arrows showing direction

Discussion

39.	An aggregation association is drawn using which symbol:
A.	a line which loops back onto the same table
B.	small closed diamond at the end of a line connecting two tables
C.	small open diamond at the end of a line connecting two tables
D.	small triangle at the end of a line connecting the aggregated item and multiple component items
Answer» D. small triangle at the end of a line connecting the aggregated item and multiple component items

Discussion

40.	The relational model is based on the concept that data is organized and stored in two-dimensional tables called _____________
A.	Fields
B.	Records
C.	Relations
D.	Keys
Answer» C. Relations

Discussion

41.	Identify the criteria for designing database from the point of view of user
A.	No redundancy
B.	No inapplicable attributes
C.	Uniformity in naming & definitions of the data items
D.	All of the Mentioned
Answer» E.

Discussion

42.	A ___________ normal form normalization will be needed where all attributes in a relation tuple are not functionally dependent only on the key attribute.
A.	First
B.	Second
C.	Third
D.	Fourth
Answer» D. Fourth

Discussion

43.	Which of the following is record based logical model?
A.	Network Model
B.	Object oriented model
C.	E-R Model
D.	None of the Mentioned
Answer» B. Object oriented model

Discussion

44.	E-R model uses this symbol to represent weak entity set ?
A.	Dotted rectangle
B.	Diamond
C.	Doubly outlined rectangle
D.	None of the Mentioned
Answer» D. None of the Mentioned

Discussion

45.	The relational model feature is that there
A.	is no need for primary key data
B.	is much more data independence than some other database models
C.	are explicit relationships among records
D.	are tables with many dimensions
Answer» C. are explicit relationships among records

Discussion

46.	A relational database developer refers to a record as
A.	A criteria
B.	A relation
C.	A tuple
D.	An attribute
Answer» D. An attribute

Discussion

47.	In an E-R diagram an entity set is represent by a
A.	Rectangle
B.	Ellipse
C.	Diamond box
D.	Circle
Answer» B. Ellipse

Discussion

48.	In a database, a foreign key is ?
A.	A data element/attribute within a data field of a data record that is not unique, and cannot be used to distinguish one data record in a database from another data record within a database table
B.	A data element/attribute within a data field of a data record within a database table that is a secondary key in another database table
C.	A data element/attribute within a data field of a data record within a database table that is a primary key in another database table
D.	A data element/attribute within a data field of a data record that enables a database to uniquely distinguish one data record in a database from another data record within a database table
Answer» D. A data element/attribute within a data field of a data record that enables a database to uniquely distinguish one data record in a database from another data record within a database table

Discussion

49.	Which of the following statements is not correct?
A.	The primary key must be unique for a given table
B.	Specifying a zero (0) for the lower bound for the association multiplicity on a class diagram indicates that the item is required
C.	Specifying a one (1) for the lower bound for the association multiplicity on a class diagram indicates that the item is required
D.	Most databases allow multiple records that are identical
Answer» C. Specifying a one (1) for the lower bound for the association multiplicity on a class diagram indicates that the item is required

Discussion

50.	A Foreign key is combined with a foreign key creates
A.	Parent child relationship between the tables that connect them
B.	Many-Many relationship between the tables that connect them
C.	Network model between the tables that connect them
D.	None of the Mentioned
Answer» B. Many-Many relationship between the tables that connect them

Discussion

Explore topic-wise MCQs in Technical Programming.

To obtain the structure of an Oracle table, the command to use is:

A Database Language Concerned With The Definition Of The Whole Database Structure And Schema Is ________

The Database Language That Allows You To Access Or Maintain Data In A Database

DCL Provides Commands To Perform Actions Like _____________

Which of the following keyword is used with Data Control Language (DCL) statements?

A transaction completes its execution is said to be

In an SQL statement, which of the following parts states the conditions for row selection?

_________commands in SQL allow controlling access to data within database.

TCL stands for:

DCL stands for :

The three language components of a database management system (DBMS) like DDL, DCL, DML. Two different types of people (users and practitioners) are concerned with them. Which of them do users of a DBMS usually deal with?

A type of query that is placed within a WHERE or HAVING clause of another query is called

A table that displays data redundancies yields ____________ anomalies.

Stack is also called __________

In SQL, which command is used to add new rows to a table?

TRUNCATE statement in SQL is a –

Which of the following is not included in DML (Data Manipulation Language)

Which of the following is not a type of SQL statement?

In SQL, which of the following is not a data Manipulation Language Commands?

The language used application programs to request data from the DBMS is referred to as __________

Which command allows the removal of all rows from a table but flushes a table more efficiently since no rollback information is retained:

Which command is used for removing a table and all its data from the database:

Which command defines its columns, integrity constraint in create table:

SQL has how many main commands for DDL:

___________ defines rules regarding the values allowed in columns and is the standard mechanism for enforcing database integrity.

________clause is an additional filter that is applied to the result.

In SQL, which command(s) is(are) used to change a table’s storage characteristics?

Which of the following is/are the DDL statements?

Let the statement : SELECT column1 FROM myTable; return 10 rows. The statement : SELECT ALL column1 FROM myTable; will return

Which of the following is illegal?

Find the temperature in increasing order of all cities

The SQL statement SELECT SUBSTR(‘123456789’, INSTR(‘abcabcabc’, ‘b’), 4) FROM DUAL;

Which of the SQL statements is correct?

A command that lets you change one or more fields in a record is

In SQL, which command is used to SELECT only one copy of each set of duplicable rows

Which is the subset of SQL commands used to manipulate Oracle Database structures, including tables?

What is the full form of SQL?

An n-array relationship is drawn using which symbol:

An aggregation association is drawn using which symbol:

The relational model is based on the concept that data is organized and stored in two-dimensional tables called _____________

Identify the criteria for designing database from the point of view of user

A ___________ normal form normalization will be needed where all attributes in a relation tuple are not functionally dependent only on the key attribute.

Which of the following is record based logical model?

E-R model uses this symbol to represent weak entity set ?

The relational model feature is that there

A relational database developer refers to a record as

In an E-R diagram an entity set is represent by a

In a database, a foreign key is ?

Which of the following statements is not correct?

A Foreign key is combined with a foreign key creates