Tuesday, October 23, 2007
Sunday, October 7, 2007
COMPUTER SCIENCE QUESTIONS AND ANSWERS PART – II
============ WINDOWS ==========
1
Windows NT uses ____ multitasking scheme
2
The NTFS file system supports file names up to ___ characters
3
Is it possible to change FAT partition to NTFS partition without moving all of the files and
directories?
4
Password is case-sensitive. Is username case-sensitive?
5
Ctrl+Alt+Delete is used to initiate
6
A Program group can have a maximum of ___ program items
7
Is this true? "The application represented by a program item is unaffected when you delete
its program item in Windows."
8
____ provides an interface to the applications you use with NT workstation
9
File Manager has directory tree pane and directory list pane. Is it possible to display only
the directory list pane?
10
In the directory tree of File Manager, how to see all levels beneath the current directory?
11
The file names can be upto ___ characters in length
12
Is it possible to format a fixed drive using File Manager?
13
In the File Manager, to select a contiguous range of files
14
The default priority for a printer is
15
It is possible to define a single printer that prints to multiple print devices. But is it possible
to define multiple printers that print to the same print device?
16
Can a user be a member of more than one group?
17
Can a group name be the same as the username of the workstation?
18
Is it possible to have more than one command prompt window at a time?
19
The command symbol means
20
A process can have a priority value from
21
Is it possible to specify that foreground and background processes have the same priority
level?
22
The device startup type Automatic is started everytime
23
Registry is a
24
Sharing and Stopping sharing is designated in
25
Is it possible to extend a Volume set?
26
Is the data written across the disks in a Stripe set?
27
The CONVERT.EXE utility is used to
28
The command line utility used to compress files is
29
What do we call the connections between a protocol and the network boards and drivers?
30
Is it possible to deploy multiple protocols on a concurrent basis?
1
Windows NT is a
2
Windows NT supports ____ file system
3
How many Remote Access Service sessions are possible in Windows NT Workstation?
4
Which of the following protocols is built into Windows NT ?
5
How many concurrent client connections are allowed in a Windows NT Workstation?
6
Windows NT doesn't support
7
Windows NT Workstation has ___ symmetric multiprocessors
8
Is Scalability supported in Windows NT?
9
Macintosh Services are available in
10
Logon Validation and Customization are in
11
Disk Fault Tolerance is available in
12
The minimum length of Username is
13
The minimum length of Password is
14
Windows NT Workstation requires a minimum of ___ MB RAM, for x86-based systems
15
The NTFS file system supports file names up to ___ characters
16
Does NTFS use automatic recovery?
17
Windows NT Workstation requires a minimum of ___ MB free space for x86-based
systems
18
Is the number of file systems on a system indicate the number of operating systems in use?
19
Is it possible to change FAT partition to NTFS partition without moving all of the files and
directories?
20
Is Windows NT compatible with third-party file systems?
21
Is Windows NT compatible with third-party disk compression utilities?
22
The maximum number of Common program groups allowed in Windows NT Program
manager is
23
The maximum number of Personal program groups allowed in Windows NT Program
manager is
24
A Program group can have a maximum of ___ program items
25
Can a Program item caption have symbols?
26
What is the maximum length of the Program item caption?
27
Can a Program item caption have spaces?
28
Is this true? "The application represented by a program item is unaffected when you delete
its program item in Windows."
1
Password is case-sensitive. Is username case-sensitive?
2
Ctrl+Alt+Delete is used to initiate
3
____ provides an interface to the applications you use with NT workstation
4
File Manager has directory tree pane and directory list pane. Is it possible to display only
the directory list pane?
5
In the directory tree of File Manager, how do you see all levels beneath the current
directory?
6
In the directory tree of File Manager, how do you see all directories on the drive?
7
Which of the following features is NOT supported in File Manager?
8
The file names can be upto ___ characters in length
9
Is it possible to control the font used to display the text that appears in the directory tree
and directory list?
10
Is it possible to format a fixed drive using File Manager?
11
In the File Manager, how do you select a contiguous range of files?
12
In the File Manager, how do you select a noncontiguous range of files?
13
In the File Manager, how do you select all the contents of a directory?
14
The maximum characters in a Username is
15
User name can have
16
A password can have a maximum of ___ characters
17
Is it possible to make the user unable to change password?
18
Is this true? "It is possible to rename a user account."
19
Is it possible to have more than one command prompt window at a time?
20
Is it possible to change the cursor size of the Command Prompt window?
21
What does the command symbol mean?
22
Which is NOT a valid command symbol?
23
In the following command, dir /w slash(/) is a
24
Which is the correct help command?
25
Is the memory management done by Virtual Memory Manager?
1
In the Print Manager, printer name can be up to ___ characters in length
2
Is space allowed in Printer name?
3
Which is NOT a valid printer permission?
4
The default printer permission for Everyone is
5
____ is used to audit printer usage
6
Printer Priority number 1 indicates
7
Printer Priority number ranges from
8
The default priority for a printer is
9
It is possible to define a single printer that prints to multiple print devices. But is it possible
to define multiple printers that print to the same print device?
10
____ is used to administer computer security
11
Which of the following is a built-in account?
12
Can a user be a member of more than one groups?
13
Is this true? "You cannot rename a built-in group."
14
Can a group name be same as an username of the workstation?
15
How many Remote Access Service sessions are possible in Windows NT Server?
16
How many concurrent client connections are allowed in Windows NT Server?
17
Is POSIX.1 applications supported in Windows NT ?
18
Windows NT Server has ___ symmetric multiprocessors.
19
Windows NT Workstation requires a minimum of ___ MB RAM, for RISC-based
systems.
20
Windows NT Workstation requires a minimum of ___ MB free space for RISC-based
systems.
21
What task(s) can logon scripts be used to perform?
22
Is a logon script a must for Windows NT Workstation?
23
Is it possible to deploy multiple protocols on a concurrent basis?
24
Is it possible to run native Windows NT networking services over IPX and run native
TCP/IP services over TCP/IP?
25
Is it possible to run native NetWare services over IPX and run native Windows NT
networking services over TCP/IP?
1
A process can have a priority value from
2
The standard priority value of a process is
3
Is it possible to specify that foreground and background processes have the same priority
level?
4
The type of environment variable that Windows NT uses is
5
Is this true? "The important system functions that are run as background tasks are known as
services."
6
The device startup type Automatic is started every time
7
Registry is a
8
Events raised due to unsuccessful attempts to log on to the system are recorded in
9
The shared directory in Windows NT workstation is usually
10
Sharing and Stopping sharing is designated in
11
Is this true? "A volume set can be one partition or a collection of partitions."
12
The maximum number of hard disks that can be gathered for a Volume set is
13
Must the Volume set is be formatted before use?
14
Is it possible to extend a Volume set?
15
Is this true? "In a Volume set, the data is written across the disks."
16
A Stripe set
17
Is the data written across the disks in a Stripe set?
18
Can Windows NT read (or write to) DoubleSpace drives?
19
Is this true? "Generally, Windows NT doesn't support any compression scheme that
requires a driver in the CONFIG.SYS file."
20
Which of the following Compression schemes do not have problem in NT?
21
Windows NT's file compression features are available in ___ formatted drives
22
The CONVERT.EXE utility is used to
23
File Compression and Decompression feature is available in
24
Uncompression for a compressed file is
25
Choose the wrong statement in the following related to Compression
26
The command line utility used to compress files is
27
What do we call the connections between a protocol and the network boards and drivers?
28
Which of the following is INCORREECT about Protocols?
29
The command ____ is used to establish Network Drive connection
1 VMM
2
WFW
3
SMB
4
NBF
5
DLC
6
UDP
7
BIOS
8
PCL
9
FTP
10
IPX
11
SPX
12
TCP/IP
13
SNMP
14
NetBIOS
15
NetBEUI
16
NIS
17
DNS
18
DHCP
19
RAS
20
CSNW
21
MDI
22
BRI
23
PRI
24
PAD
25
WINS
1
Windows NT uses ____ multitasking scheme
2
The NTFS file system supports file names up to ___ characters
3
Is it possible to change FAT partition to NTFS partition without moving all of the files and
directories?
4
Password is case-sensitive. Is username case-sensitive?
5
Ctrl+Alt+Delete is used to initiate
6
A Program group can have a maximum of ___ program items
7
Is this true? "The application represented by a program item is unaffected when you delete
its program item in Windows."
8
____ provides an interface to the applications you use with NT workstation
9
File Manager has directory tree pane and directory list pane. Is it possible to display only
the directory list pane?
10
In the directory tree of File Manager, how to see all levels beneath the current directory?
11
The file names can be upto ___ characters in length
12
Is it possible to format a fixed drive using File Manager?
13
In the File Manager, to select a contiguous range of files
14
The default priority for a printer is
15
It is possible to define a single printer that prints to multiple print devices. But is it possible
to define multiple printers that print to the same print device?
16
Can a user be a member of more than one group?
17
Can a group name be the same as the username of the workstation?
18
Is it possible to have more than one command prompt window at a time?
19
The command symbol means
20
A process can have a priority value from
21
Is it possible to specify that foreground and background processes have the same priority
level?
22
The device startup type Automatic is started everytime
23
Registry is a
24
Sharing and Stopping sharing is designated in
25
Is it possible to extend a Volume set?
26
Is the data written across the disks in a Stripe set?
27
The CONVERT.EXE utility is used to
28
The command line utility used to compress files is
29
What do we call the connections between a protocol and the network boards and drivers?
30
Is it possible to deploy multiple protocols on a concurrent basis?
1
Windows NT is a
2
Windows NT supports ____ file system
3
How many Remote Access Service sessions are possible in Windows NT Workstation?
4
Which of the following protocols is built into Windows NT ?
5
How many concurrent client connections are allowed in a Windows NT Workstation?
6
Windows NT doesn't support
7
Windows NT Workstation has ___ symmetric multiprocessors
8
Is Scalability supported in Windows NT?
9
Macintosh Services are available in
10
Logon Validation and Customization are in
11
Disk Fault Tolerance is available in
12
The minimum length of Username is
13
The minimum length of Password is
14
Windows NT Workstation requires a minimum of ___ MB RAM, for x86-based systems
15
The NTFS file system supports file names up to ___ characters
16
Does NTFS use automatic recovery?
17
Windows NT Workstation requires a minimum of ___ MB free space for x86-based
systems
18
Is the number of file systems on a system indicate the number of operating systems in use?
19
Is it possible to change FAT partition to NTFS partition without moving all of the files and
directories?
20
Is Windows NT compatible with third-party file systems?
21
Is Windows NT compatible with third-party disk compression utilities?
22
The maximum number of Common program groups allowed in Windows NT Program
manager is
23
The maximum number of Personal program groups allowed in Windows NT Program
manager is
24
A Program group can have a maximum of ___ program items
25
Can a Program item caption have symbols?
26
What is the maximum length of the Program item caption?
27
Can a Program item caption have spaces?
28
Is this true? "The application represented by a program item is unaffected when you delete
its program item in Windows."
1
Password is case-sensitive. Is username case-sensitive?
2
Ctrl+Alt+Delete is used to initiate
3
____ provides an interface to the applications you use with NT workstation
4
File Manager has directory tree pane and directory list pane. Is it possible to display only
the directory list pane?
5
In the directory tree of File Manager, how do you see all levels beneath the current
directory?
6
In the directory tree of File Manager, how do you see all directories on the drive?
7
Which of the following features is NOT supported in File Manager?
8
The file names can be upto ___ characters in length
9
Is it possible to control the font used to display the text that appears in the directory tree
and directory list?
10
Is it possible to format a fixed drive using File Manager?
11
In the File Manager, how do you select a contiguous range of files?
12
In the File Manager, how do you select a noncontiguous range of files?
13
In the File Manager, how do you select all the contents of a directory?
14
The maximum characters in a Username is
15
User name can have
16
A password can have a maximum of ___ characters
17
Is it possible to make the user unable to change password?
18
Is this true? "It is possible to rename a user account."
19
Is it possible to have more than one command prompt window at a time?
20
Is it possible to change the cursor size of the Command Prompt window?
21
What does the command symbol mean?
22
Which is NOT a valid command symbol?
23
In the following command, dir /w slash(/) is a
24
Which is the correct help command?
25
Is the memory management done by Virtual Memory Manager?
1
In the Print Manager, printer name can be up to ___ characters in length
2
Is space allowed in Printer name?
3
Which is NOT a valid printer permission?
4
The default printer permission for Everyone is
5
____ is used to audit printer usage
6
Printer Priority number 1 indicates
7
Printer Priority number ranges from
8
The default priority for a printer is
9
It is possible to define a single printer that prints to multiple print devices. But is it possible
to define multiple printers that print to the same print device?
10
____ is used to administer computer security
11
Which of the following is a built-in account?
12
Can a user be a member of more than one groups?
13
Is this true? "You cannot rename a built-in group."
14
Can a group name be same as an username of the workstation?
15
How many Remote Access Service sessions are possible in Windows NT Server?
16
How many concurrent client connections are allowed in Windows NT Server?
17
Is POSIX.1 applications supported in Windows NT ?
18
Windows NT Server has ___ symmetric multiprocessors.
19
Windows NT Workstation requires a minimum of ___ MB RAM, for RISC-based
systems.
20
Windows NT Workstation requires a minimum of ___ MB free space for RISC-based
systems.
21
What task(s) can logon scripts be used to perform?
22
Is a logon script a must for Windows NT Workstation?
23
Is it possible to deploy multiple protocols on a concurrent basis?
24
Is it possible to run native Windows NT networking services over IPX and run native
TCP/IP services over TCP/IP?
25
Is it possible to run native NetWare services over IPX and run native Windows NT
networking services over TCP/IP?
1
A process can have a priority value from
2
The standard priority value of a process is
3
Is it possible to specify that foreground and background processes have the same priority
level?
4
The type of environment variable that Windows NT uses is
5
Is this true? "The important system functions that are run as background tasks are known as
services."
6
The device startup type Automatic is started every time
7
Registry is a
8
Events raised due to unsuccessful attempts to log on to the system are recorded in
9
The shared directory in Windows NT workstation is usually
10
Sharing and Stopping sharing is designated in
11
Is this true? "A volume set can be one partition or a collection of partitions."
12
The maximum number of hard disks that can be gathered for a Volume set is
13
Must the Volume set is be formatted before use?
14
Is it possible to extend a Volume set?
15
Is this true? "In a Volume set, the data is written across the disks."
16
A Stripe set
17
Is the data written across the disks in a Stripe set?
18
Can Windows NT read (or write to) DoubleSpace drives?
19
Is this true? "Generally, Windows NT doesn't support any compression scheme that
requires a driver in the CONFIG.SYS file."
20
Which of the following Compression schemes do not have problem in NT?
21
Windows NT's file compression features are available in ___ formatted drives
22
The CONVERT.EXE utility is used to
23
File Compression and Decompression feature is available in
24
Uncompression for a compressed file is
25
Choose the wrong statement in the following related to Compression
26
The command line utility used to compress files is
27
What do we call the connections between a protocol and the network boards and drivers?
28
Which of the following is INCORREECT about Protocols?
29
The command ____ is used to establish Network Drive connection
1 VMM
2
WFW
3
SMB
4
NBF
5
DLC
6
UDP
7
BIOS
8
PCL
9
FTP
10
IPX
11
SPX
12
TCP/IP
13
SNMP
14
NetBIOS
15
NetBEUI
16
NIS
17
DNS
18
DHCP
19
RAS
20
CSNW
21
MDI
22
BRI
23
PRI
24
PAD
25
WINS
COMPUTER SCIENCE QUESTIONS AND ANSWERS PART-I
************ oracle ******************
1
A collection of related but physically independent databases is called as
2
______ data type stores floating point.
3
Which is NOT correct in the following for a View?
4
Is the Domain integrity to be inforced manually by the developer or administrator?
5
________ lock prevents other locks of any type on the same data.
6
When concurrent queries contend for the same resource, how are they handled in Oracle7?
7
A ______ is a collection of related privileges that an administrator can grant collectively to
database users.
8
A logical collection of related tables and views is called as
9
________ is used for database recovery.
10
________ middleware requires both client and server remain active during conversation.
11
Which process is responsible for cleaning up after a front-end server process abnormally
dies?
12
_________ is used to undo the changes made by current transaction.
13
SELECT SQR(25) FROM dual; will this return square root of 25 ?
14
In a PL/SQL, exceptions are handled by
15
_________ is used to create user-defined datatypes.
16
Procedures returns
17
An IN parameter in a Procedure
18
Which of the following is NOT a valid SQL*Loader command-line option?
19
Can a database name have $ sign?
20
_________ tool is used to generate the necessary network configuration files.
21
Is the Operating System Authentication same as Password Authentication?
22
Choose the one that fits best for a segment.
23
Which is NOT an extent storage parameter?
24
Is this true? "Row chaining improves disk I/O performance."
25
Can rollback segments be offline?
26
Which is NOT related to memory cache?
27
Shared pool is made of
28
SGA is
29
Is it possible to change the database block size, after creating the database?
30
A trigger body can contain any
31
A hint is represented by
32
Can a single SQL comment have more than one hint?
1
Client/Server computing model is also called as
2
A file server system has which of the following limitations for multiuser applications?
3
Database servers concentrate on
4
Validating data entry is done by
5
The Oracle7 database server is based on
6
A collection of related but physically independent databases is called as
7
Data integrity means
8
Is this true? "Integrity constraints automatically prohibit invalid data from existing."
9
Comments in a SQL statement begin with the character(s)
10
An Oracle7 database's logical structure is
11
Is this true? "Pre-relational database systems require users to program applications to
access data by using complicated physical addressing mechanisms."
12
Which of the following data types are NOT supported by Oracle7?
13
______ data type stores floating point.
14
______ data type stores binary strings.
15
Which is NOT correct in the following for a table space?
16
Is this correct? "Oracle7 uses the SYSTEM tablespace to hold the data dictionary."
17
Is this correct? 'Oracle7 does not allow administrators to back up a database at the
tablespace level'
18
Which is NOT correct in the following for a View?
19
View CANNOT be used to
20
A value in a column is a member of the column's domain, or legal set of values. This is
ensured by
21
_______ ensures "every row in a table must be unique."
22
Which is NOT valid for a Primary Key?
23
_______ ensures "the values in one column or set of columns refer to or must match the
values in a related column or set of columns."
24
Which of the following terms are used in Referential Integrity?
25
Is the Domain integrity to be inforced manually by the developer or administrator?
1
A stored procedure is
2
In Oracle SQL statements ______ is used as a statement terminator.
3
Is this true? "Every Oracle SQL statement must be terminated by the Statement
terminator."
4
Is "Trigger" a stored procedure?
5
Does Oracle7 has automatic concurrency control system?
6
When two operations contending for the same data, _______ occurs.
7
When concurrent transactions contend for the same resource, how are they handled in
Oracle7?
8
To maximize concurrency by minimizing data conflicts, Oracle7 uses
9
________ lock allows other transactions to acquire share locks on the same data.
10
________ lock prevents other locks of any type on the same data.
11
When concurrent queries contend for the same resource, how are they handled in Oracle7?
12
Is overriding of default locking mechanisms allowed in Oracle7?
13
________ are the key components that deliver multi-versioning.
14
Oracle7 maintains database security using
15
________ privilege gives a user the right to perform an operation on a database-wide
basis.
16
A ______ is a collection of related privileges that an administrator can grant collectively to
database users.
17
A logical collection of related tables and views is called as
18
________ is used for database recovery.
19
Is this correct? "A client application in a client/server system includes data management
component."
20
Which is NOT a query / reporting tool ?
21
An OCI program can control which of the following steps of SQL statement processing?
22
________ allows third-party CASE tools to work in an Oracle CASE development
environment.
23
Is this correct? "Vertical Client Applications are pre-built applications that work right out of
the box."
24
Is it a must that client and server use the same protocol to communicate with each other?
25
________ is Oracle's own middleware product.
26
________ middleware requires both client and server remain active during conversation.
1
________ writes data blocks that transactions modify in memory to the appropriate data
files.
2
Does DBWR writes to disk immediately?
3
Which of the following process is responsible for cleaning up after a front-end server
process abnormally dies?
4
Which is NOT a DML command?
5
Which is NOT a DCL command?
6
Is it valid? SELECT id, lname, fname FROM candidate WHERE id NOT IN (SELECT
candidateid FROM tests)
7
_________ is used to undo the changes made by current transaction.
8
SELECT SQR(25) FROM dual; will this return square root of 25?
9
Is SQL a nonprocedural language?
10
In a PL/SQL, exceptions are handled by
11
_________ is used to create user-defined datatypes.
12
_________ flow control statement is NOT supported by Oracle's PL/SQL
13
Oracle's PL/SQL raises ________ exception when it encounters divide by zero
14
Is this true? "Unhandled exceptions in a PL/SQL block are rolled back to the calling
environment."
15
Procedures returns
16
An IN parameter in a Procedure
17
Choose the one that best fits for a database trigger condition.
18
Is this correct? "Oracle7 fires a statement trigger's body once for every row the triggering
statement touches."
19
Which of the following is NOT a valid SQL*Loader control file option?
20
Which of the following is NOT a valid SQL*Loader command-line option?
21
SQL*Loader can load data into a database using
23
Can a database name have $ sign?
24
Which is NOT allowed in the following for a DB_NAME?
25
Is there a way to make a tablespace offline temporarily?
26
Which of the following types of configurations are available with Oracle7 ?
27
_________ tool is used to generate the necessary network configuration files.
1
Is this true? "Oracle7 dynamically adjusts the number of shared servers based on the
system load."
2
Is the Operating System Authentication same as Password Authentication?
3
Oracle7 database user can change his password by using the SQL command
4
Choose the one that fits best for a segment.
5
An extent is
6
Which is NOT an extent storage parameter?
7
Is this true? "Row chaining improves disk I/O performance."
8
_________ is used to control transaction access to data blocks.
9
Can rollback segments be stored in any tablespace of a database?
10
Can rollback segments be offline?
11
Which is NOT related to memory cache?
12
Oracle7 supports _______ cache.
13
Shared pool is made of
14
SGA is
15
Is it possible to change the database block size, after creating the database?
16
Is Database alerters same as Database triggers?
17
Oracle CDE tool set consists of
18
Oracle Forms has
19
Does Oracle Forms supports applications in bitmapped GUIs ?
20
A hint is represented by
21
Can a single SQL comment have more than one hint?
22
Oracle7 PL/SQL programs can include any
23
Oracle7 stores the compiler version of trigger in
24
A trigger's triggering statement is
25
A trigger body can contain any
1
A collection of related but physically independent databases is called as
2
______ data type stores floating point.
3
Which is NOT correct in the following for a View?
4
Is the Domain integrity to be inforced manually by the developer or administrator?
5
________ lock prevents other locks of any type on the same data.
6
When concurrent queries contend for the same resource, how are they handled in Oracle7?
7
A ______ is a collection of related privileges that an administrator can grant collectively to
database users.
8
A logical collection of related tables and views is called as
9
________ is used for database recovery.
10
________ middleware requires both client and server remain active during conversation.
11
Which process is responsible for cleaning up after a front-end server process abnormally
dies?
12
_________ is used to undo the changes made by current transaction.
13
SELECT SQR(25) FROM dual; will this return square root of 25 ?
14
In a PL/SQL, exceptions are handled by
15
_________ is used to create user-defined datatypes.
16
Procedures returns
17
An IN parameter in a Procedure
18
Which of the following is NOT a valid SQL*Loader command-line option?
19
Can a database name have $ sign?
20
_________ tool is used to generate the necessary network configuration files.
21
Is the Operating System Authentication same as Password Authentication?
22
Choose the one that fits best for a segment.
23
Which is NOT an extent storage parameter?
24
Is this true? "Row chaining improves disk I/O performance."
25
Can rollback segments be offline?
26
Which is NOT related to memory cache?
27
Shared pool is made of
28
SGA is
29
Is it possible to change the database block size, after creating the database?
30
A trigger body can contain any
31
A hint is represented by
32
Can a single SQL comment have more than one hint?
1
Client/Server computing model is also called as
2
A file server system has which of the following limitations for multiuser applications?
3
Database servers concentrate on
4
Validating data entry is done by
5
The Oracle7 database server is based on
6
A collection of related but physically independent databases is called as
7
Data integrity means
8
Is this true? "Integrity constraints automatically prohibit invalid data from existing."
9
Comments in a SQL statement begin with the character(s)
10
An Oracle7 database's logical structure is
11
Is this true? "Pre-relational database systems require users to program applications to
access data by using complicated physical addressing mechanisms."
12
Which of the following data types are NOT supported by Oracle7?
13
______ data type stores floating point.
14
______ data type stores binary strings.
15
Which is NOT correct in the following for a table space?
16
Is this correct? "Oracle7 uses the SYSTEM tablespace to hold the data dictionary."
17
Is this correct? 'Oracle7 does not allow administrators to back up a database at the
tablespace level'
18
Which is NOT correct in the following for a View?
19
View CANNOT be used to
20
A value in a column is a member of the column's domain, or legal set of values. This is
ensured by
21
_______ ensures "every row in a table must be unique."
22
Which is NOT valid for a Primary Key?
23
_______ ensures "the values in one column or set of columns refer to or must match the
values in a related column or set of columns."
24
Which of the following terms are used in Referential Integrity?
25
Is the Domain integrity to be inforced manually by the developer or administrator?
1
A stored procedure is
2
In Oracle SQL statements ______ is used as a statement terminator.
3
Is this true? "Every Oracle SQL statement must be terminated by the Statement
terminator."
4
Is "Trigger" a stored procedure?
5
Does Oracle7 has automatic concurrency control system?
6
When two operations contending for the same data, _______ occurs.
7
When concurrent transactions contend for the same resource, how are they handled in
Oracle7?
8
To maximize concurrency by minimizing data conflicts, Oracle7 uses
9
________ lock allows other transactions to acquire share locks on the same data.
10
________ lock prevents other locks of any type on the same data.
11
When concurrent queries contend for the same resource, how are they handled in Oracle7?
12
Is overriding of default locking mechanisms allowed in Oracle7?
13
________ are the key components that deliver multi-versioning.
14
Oracle7 maintains database security using
15
________ privilege gives a user the right to perform an operation on a database-wide
basis.
16
A ______ is a collection of related privileges that an administrator can grant collectively to
database users.
17
A logical collection of related tables and views is called as
18
________ is used for database recovery.
19
Is this correct? "A client application in a client/server system includes data management
component."
20
Which is NOT a query / reporting tool ?
21
An OCI program can control which of the following steps of SQL statement processing?
22
________ allows third-party CASE tools to work in an Oracle CASE development
environment.
23
Is this correct? "Vertical Client Applications are pre-built applications that work right out of
the box."
24
Is it a must that client and server use the same protocol to communicate with each other?
25
________ is Oracle's own middleware product.
26
________ middleware requires both client and server remain active during conversation.
1
________ writes data blocks that transactions modify in memory to the appropriate data
files.
2
Does DBWR writes to disk immediately?
3
Which of the following process is responsible for cleaning up after a front-end server
process abnormally dies?
4
Which is NOT a DML command?
5
Which is NOT a DCL command?
6
Is it valid? SELECT id, lname, fname FROM candidate WHERE id NOT IN (SELECT
candidateid FROM tests)
7
_________ is used to undo the changes made by current transaction.
8
SELECT SQR(25) FROM dual; will this return square root of 25?
9
Is SQL a nonprocedural language?
10
In a PL/SQL, exceptions are handled by
11
_________ is used to create user-defined datatypes.
12
_________ flow control statement is NOT supported by Oracle's PL/SQL
13
Oracle's PL/SQL raises ________ exception when it encounters divide by zero
14
Is this true? "Unhandled exceptions in a PL/SQL block are rolled back to the calling
environment."
15
Procedures returns
16
An IN parameter in a Procedure
17
Choose the one that best fits for a database trigger condition.
18
Is this correct? "Oracle7 fires a statement trigger's body once for every row the triggering
statement touches."
19
Which of the following is NOT a valid SQL*Loader control file option?
20
Which of the following is NOT a valid SQL*Loader command-line option?
21
SQL*Loader can load data into a database using
23
Can a database name have $ sign?
24
Which is NOT allowed in the following for a DB_NAME?
25
Is there a way to make a tablespace offline temporarily?
26
Which of the following types of configurations are available with Oracle7 ?
27
_________ tool is used to generate the necessary network configuration files.
1
Is this true? "Oracle7 dynamically adjusts the number of shared servers based on the
system load."
2
Is the Operating System Authentication same as Password Authentication?
3
Oracle7 database user can change his password by using the SQL command
4
Choose the one that fits best for a segment.
5
An extent is
6
Which is NOT an extent storage parameter?
7
Is this true? "Row chaining improves disk I/O performance."
8
_________ is used to control transaction access to data blocks.
9
Can rollback segments be stored in any tablespace of a database?
10
Can rollback segments be offline?
11
Which is NOT related to memory cache?
12
Oracle7 supports _______ cache.
13
Shared pool is made of
14
SGA is
15
Is it possible to change the database block size, after creating the database?
16
Is Database alerters same as Database triggers?
17
Oracle CDE tool set consists of
18
Oracle Forms has
19
Does Oracle Forms supports applications in bitmapped GUIs ?
20
A hint is represented by
21
Can a single SQL comment have more than one hint?
22
Oracle7 PL/SQL programs can include any
23
Oracle7 stores the compiler version of trigger in
24
A trigger's triggering statement is
25
A trigger body can contain any
Subscribe to:
Posts (Atom)