IndiaBIX

Online Database Test - Database Test - Random

Instruction:
  • This is a FREE online test. Beware of scammers who ask for money to attend this test.
  • Total number of questions: 20.
  • Time allotted: 30 minutes.
  • Each question carries 1 mark; there are no negative marks.
  • DO NOT refresh the page.
  • All the best!

Marks : 2/20

Total number of questions
20
Number of answered questions
0
Number of unanswered questions
20
Test Review : View answers and explanation for this test.
1.
SQL provides five built-in functions: COUNT, SUM, AVG, MAX, MIN.
True
False
Your Answer: Option
(Not Answered)
Correct Answer: Option
Discuss about this problem : Discuss in Forum
Learn more problems on : Introduction to SQL
2.
Normalization ________ data duplication.
eliminates
reduces
increases
maximizes
Your Answer: Option
(Not Answered)
Correct Answer: Option
Discuss about this problem : Discuss in Forum
Learn more problems on : Database Design Using Normalization
3.
Which of the following indicates the maximum number of entities that can be involved in a relationship?
Minimum cardinality
Maximum cardinality
ERD
Greater Entity Count (GEC)
Your Answer: Option
(Not Answered)
Correct Answer: Option
Discuss about this problem : Discuss in Forum
Learn more problems on : Data Modeling with ER Model
4.
1:1, 1:N and N:M relationships are also known as HAS-A relationships.
True
False
Your Answer: Option
(Not Answered)
Correct Answer: Option
Discuss about this problem : Discuss in Forum
Learn more problems on : Data Modeling with ER Model
5.
Which of the following columns is(are) are required in a table?
A foreign key
An alternate key
A primary key
A surrogate key.
Your Answer: Option
(Not Answered)
Correct Answer: Option
Discuss about this problem : Discuss in Forum
Learn more problems on : Data Models into Database Designs
6.
An ideal primary key is short, numeric and seldom changing.
True
False
Your Answer: Option
(Not Answered)
Correct Answer: Option
Discuss about this problem : Discuss in Forum
Learn more problems on : Data Models into Database Designs
7.
A reason for using an SQL view to hide columns is:
to simplify a result only.
to prevent the display of sensitive data only.
to accomplish both of the above.
None of the above are reasons for using an SQL view.
Your Answer: Option
(Not Answered)
Correct Answer: Option
Discuss about this problem : Discuss in Forum
Learn more problems on : SQL for Database Construction
8.
The SQL-92 command to change a table name is RENAME TABLE.
True
False
Your Answer: Option
(Not Answered)
Correct Answer: Option
Discuss about this problem : Discuss in Forum
Learn more problems on : Database Redesign
9.
Dependency graphs are diagrams that consist of nodes and arcs that show the dependencies of a database.
True
False
Your Answer: Option
(Not Answered)
Correct Answer: Option
Discuss about this problem : Discuss in Forum
Learn more problems on : Database Redesign
10.
In creating a procedure, you may get a message if you have compile errors. Which of the following is true?
The line numbers reported match the line numbers you see in your text editor.
SQL*Plus will automatically show the errors to you.
To see the errors, enter SHOW ERRORS in SQL*Plus.
If there are no syntax errors, you will receive the message "NO ERRORS."
Your Answer: Option
(Not Answered)
Correct Answer: Option
Discuss about this problem : Discuss in Forum
Learn more problems on : Managing Databases with Oracle
11.
An SQL Server reserved word must be placed in brackets. If the word is not in brackets, SQL Server will try to interpret it as the name of one of its special words.
True
False
Your Answer: Option
(Not Answered)
Correct Answer: Option
Discuss about this problem : Discuss in Forum
Learn more problems on : SQL Server 2000
12.
The ODBC core API consists of which of the following functions?
Commit or rollback transactions only
Connect to data sources with driver-specific information only
Connect to data sources only
Both 1 and 3 above are in the OBDC core API.
Your Answer: Option
(Not Answered)
Correct Answer: Option
Discuss about this problem : Discuss in Forum
Learn more problems on : ODBC, OLE DB, ADO, and ASP
13.
Which of the following statements is not true about XML Schemas:
They are used to define the content and structure of data.
They define a set of symbols and the relationships of those symbols.
They are themselves XML documents.
They have their own syntax.
Your Answer: Option
(Not Answered)
Correct Answer: Option
Discuss about this problem : Discuss in Forum
Learn more problems on : XML and ADO.NET
14.
The XSLT processor copies the elements of the stylesheet until it finds a command in the format:
SELECT ... FROM ... WHERE.
{item, action}.
{for-each select}.
<HTML>...<\HTML>.
Your Answer: Option
(Not Answered)
Correct Answer: Option
Discuss about this problem : Discuss in Forum
Learn more problems on : XML and ADO.NET
15.
The systems development life cycle cannot be used with database implementation.
True
False
Your Answer: Option
(Not Answered)
Correct Answer: Option
Discuss about this problem : Discuss in Forum
Learn more problems on : The Database Development Process
16.
It is appropriate to use a supertype/subtype relationship when there are attributes that apply to some of the instances of an entity type.
True
False
Your Answer: Option
(Not Answered)
Correct Answer: Option
Discuss about this problem : Discuss in Forum
Learn more problems on : ER Model and Business Rules
17.
Which of the following is true concerning triggers?
You do not create them with SQL.
They execute against only some applications that access a database.
They have an event, condition, and action.
They cannot cascade (cause another trigger to fire).
Your Answer: Option
(Not Answered)
Correct Answer: Option
Discuss about this problem : Discuss in Forum
Learn more problems on : Advanced SQL
18.
An intranet provides which of the following?
Connectivity to all customers
Connectivity to selected customers
Connectivity to no customers
Connectivity to all of the above
Your Answer: Option
(Not Answered)
Correct Answer: Option
Discuss about this problem : Discuss in Forum
Learn more problems on : The Internet Database Environment
19.
A semijoin is which of the following?
Only the joining attributes are sent from one site to another and then all of the rows are returned.
All of the attributes are sent from one site to another and then only the required rows are returned.
Only the joining attributes are sent from one site to another and then only the required rows are returned.
All of the attributes are sent from one site to another and then only the required rows are returned.
Your Answer: Option
(Not Answered)
Correct Answer: Option
Discuss about this problem : Discuss in Forum
Learn more problems on : Distributed Databases
20.
You may specify an object identifier with only one unique tag name.
True
False
Your Answer: Option
(Not Answered)
Correct Answer: Option
Discuss about this problem : Discuss in Forum
Learn more problems on : Object-Oriented Database
*** END OF THE TEST ***
Time Left: 00:29:56
Post your test result / feedback here:

Quick links
Quantitative Aptitude
Verbal (English)
Reasoning
Programming
Interview
Placement Papers